| From: | "Serge Fonville" <serge(dot)fonville(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Fwd: Socket error instead of Access denied |
| Date: | 2008-10-10 13:00:30 |
| Message-ID: | 680cbe0e0810100600x23a93age17f6c3f3790e826@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Serge Fonville | 2008-10-10 13:02:52 | Socket error instead of Access denied |
| Previous Message | Tom Lane | 2008-10-10 12:58:42 | Re: flood in logs |