Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Ray Stell
On Feb 23, 2013, at 11:05 PM, Maz Mohammadi wrote: FATAL: connection requires a valid client certificate. I use openssl to verify the chain, I think that would help you know what's going on: openssl verify -CAfile rootca.crt user.crt

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Adrian Klaver
On 02/23/2013 08:05 PM, Maz Mohammadi wrote: I still can’t access my SSL enabled server!!! Is root.crt supposed to be an exact copy of server.crt file which I use in my client’s keystore? I have another observation. As I start the coordinator node, I don’t see any file access to the

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Maz Mohammadi
: Sunday, February 24, 2013 4:37 PM To: Maz Mohammadi Cc: pgsql-j...@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] [JDBC] can't access through SSL On 02/23/2013 08:05 PM, Maz Mohammadi wrote: I still can't access my SSL enabled server!!! Is root.crt supposed to be an exact copy

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Adrian Klaver
On 02/24/2013 02:35 PM, Maz Mohammadi wrote: Correct! I'm new postgresql and I need to figure this out for a client. I installed a bunch packages on my Ubuntu linux and here I am. I've learned a lot. I have 2 datanodes, coordinator + gtm. Some general pointers on helping to figure this

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Maz Mohammadi
directory. -maz -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Sunday, February 24, 2013 8:08 PM To: Maz Mohammadi Cc: pgsql-j...@postgresql.org; pgsql-general@postgresql.org Subject: Re: [GENERAL] [JDBC] can't access through SSL On 02/24/2013 02:35 PM, Maz

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Adrian Klaver
On 02/24/2013 05:54 PM, Maz Mohammadi wrote: Hi Adrian, Thanks for sharing some pointers with me. You are right, it's not actually an JDBC driver issue. I posted it on jdbc, because I'm accessing it from a jdbc client, I thought there might be some security issues with the JDBC driver. 1)

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-24 Thread Michael Paquier
On Mon, Feb 25, 2013 at 10:07 AM, Adrian Klaver adrian.kla...@gmail.comwrote: 1) Postgres-XC != Postgres. It shares a code base but adds more moving parts. Along that line, you will need to be more specific about how you have setup Postgres-XC and exactly which part is failing? I for one do

Re: [GENERAL] [JDBC] can't access through SSL

2013-02-23 Thread Maz Mohammadi
I still can't access my SSL enabled server!!! Is root.crt supposed to be an exact copy of server.crt file which I use in my client's keystore? I have another observation. As I start the coordinator node, I don't see any file access to the server.key or server.crt file? Aren't these files