Thread: Socket error instead of Access denied
Recently I started to move from MySQL to PostgreSQL.
When I had it set up on windows, I enabled ssl and everything worked like a charm.
My pg_hba.conf looks like this:
hostssl ticketsystem ticketsystem127.0.0.1/32md5
hostsslfaq faq 127.0.0.1/32 md5
hostssl allpostgres::1/128 md5
hostssl ticketsystemticketsystem::1/128md5
hostssl faq faq ::1/128 md5
Sorry about that, submitted it to early.
Here goes again:
Recently I started to move from MySQL to PostgreSQL.
When I had it set up on windows, I enabled ssl and everything worked like a charm.
My pg_hba.conf looks like this:
hostssl all postgres 127.0.0.1/32 md5
hostssl ticketsystem ticketsystem 127.0.0.1/32 md5
hostssl faq faq 127.0.0.1/32 md5
hostssl all postgres ::1/128 md5
hostssl ticketsystem ticketsystem ::1/128 md5
hostssl faq faq ::1/128 md5
If I access the database to which the user has access, no problem, If I use the user faq to connecto to ticketsystem I'd exect an access denied of some sort, instead I get:
could not receive data from server: Unknown socket error (0x00000002/2)
Previous connection kept
Is this due to the SSL connection, or is it related to some other error
And is it 'fixable'
I already searched the mailing list and google, but to no avail.
Thanks in advance
Serge Fonville
One thing I forgot.
The errors occur when I use psql.exe with the -U paramter
---------- Forwarded message ----------
From: Serge Fonville <serge.fonville@gmail.com>
Date: Fri, Oct 10, 2008 at 3:00 PM
Subject: Fwd: Socket error instead of Access denied
To: pgsql-general <pgsql-general@postgresql.org>
From: Serge Fonville <serge.fonville@gmail.com>
Date: Fri, Oct 10, 2008 at 3:00 PM
Subject: Fwd: Socket error instead of Access denied
To: pgsql-general <pgsql-general@postgresql.org>
Sorry about that, submitted it to early.
Here goes again:
Recently I started to move from MySQL to PostgreSQL.
When I had it set up on windows, I enabled ssl and everything worked like a charm.
My pg_hba.conf looks like this:
hostssl all postgres 127.0.0.1/32 md5
hostssl ticketsystem ticketsystem 127.0.0.1/32 md5
hostssl faq faq 127.0.0.1/32 md5
hostssl all postgres ::1/128 md5
hostssl ticketsystem ticketsystem ::1/128 md5
hostssl faq faq ::1/128 md5
If I access the database to which the user has access, no problem, If I use the user faq to connecto to ticketsystem I'd exect an access denied of some sort, instead I get:
could not receive data from server: Unknown socket error (0x00000002/2)
Previous connection kept
Is this due to the SSL connection, or is it related to some other error
And is it 'fixable'
I already searched the mailing list and google, but to no avail.
Thanks in advance
Serge Fonville