Postgres Pro
Downloads
Home   >   mailing lists

Socket error instead of Access denied - Mailing list pgsql-general

From Serge Fonville
Subject Socket error instead of Access denied
Date
Msg-id 680cbe0e0810100602r2b0d1bc7ma0b02f1744940d04@mail.gmail.com
Whole thread Raw
In response to Fwd: Socket error instead of Access denied  ("Serge Fonville" <serge.fonville@gmail.com>)
List pgsql-general
Tree view
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>


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

pgsql-general by date:

Previous
From: "Serge Fonville"
Date:
Subject: Fwd: Socket error instead of Access denied
Next
From: "Scott Marlowe"
Date:
Subject: Re: localhost (windows) performance