Thread: SSL error

SSL error

From
AI Rumman
Date:
I have created server.crt and server.key using the Postgresql documentation.

Followings are the commands:
-------------------------------------------
openssl req -new -text -out server.req

openssl rsa -in privkey.pem -out server.key
rm privkey.pem

openssl req -x509 -in server.req -text -key server.key -out server.crt

chmod og-rwx server.key
-------------------------------------------
Mdified

SSL=on at postgresql.conf and restarted the server.

But when I am trying to connect I get the following error:

 FATAL:  no pg_hba.conf entry for host "10.0.0.34", user "postgres", database "postgres", SSL off

Please tell me why I get this error.

Re: SSL error

From
Thom Brown
Date:
On 4 May 2010 11:50, AI Rumman <rummandba@gmail.com> wrote:
I have created server.crt and server.key using the Postgresql documentation.

Followings are the commands:
-------------------------------------------
openssl req -new -text -out server.req

openssl rsa -in privkey.pem -out server.key
rm privkey.pem

openssl req -x509 -in server.req -text -key server.key -out server.crt

chmod og-rwx server.key
-------------------------------------------
Mdified

SSL=on at postgresql.conf and restarted the server.

But when I am trying to connect I get the following error:

 FATAL:  no pg_hba.conf entry for host "10.0.0.34", user "postgres", database "postgres", SSL off

Please tell me why I get this error.


It appears you're not connecting securely and there's no access from your IP specified in pg_hba.conf.  You'll need to change that file and restart the service.

Thom

Re: SSL error

From
AI Rumman
Date:
I change the pg_hba.conf as below:

hostssl  all    all    10.0.0.34/32         md5

But still the same problem.

On Tue, May 4, 2010 at 5:03 PM, Thom Brown <thombrown@gmail.com> wrote:
On 4 May 2010 11:50, AI Rumman <rummandba@gmail.com> wrote:
I have created server.crt and server.key using the Postgresql documentation.

Followings are the commands:
-------------------------------------------
openssl req -new -text -out server.req

openssl rsa -in privkey.pem -out server.key
rm privkey.pem

openssl req -x509 -in server.req -text -key server.key -out server.crt

chmod og-rwx server.key
-------------------------------------------
Mdified

SSL=on at postgresql.conf and restarted the server.

But when I am trying to connect I get the following error:

 FATAL:  no pg_hba.conf entry for host "10.0.0.34", user "postgres", database "postgres", SSL off

Please tell me why I get this error.


It appears you're not connecting securely and there's no access from your IP specified in pg_hba.conf.  You'll need to change that file and restart the service.

Thom

Re: SSL error

From
Ray Stell
Date:
On Tue, May 04, 2010 at 05:12:16PM +0600, AI Rumman wrote:
> I change the pg_hba.conf as below:

and you restart or do a pg_ctl reload?