SSL error
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.
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.reqopenssl rsa -in privkey.pem -out server.key
rm privkey.pemopenssl req -x509 -in server.req -text -key server.key -out server.crt
chmod og-rwx server.key
-------------------------------------------
MdifiedSSL=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 offPlease 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
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:
Show quoted text
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.reqopenssl rsa -in privkey.pem -out server.key
rm privkey.pemopenssl req -x509 -in server.req -text -key server.key -out server.crt
chmod og-rwx server.key
-------------------------------------------
MdifiedSSL=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 offPlease 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
