Search Postgresql Archives

Re: Problem with SSL: "could not accept SSL connection: EOF detected"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Pat Maddox <pat.maddox@xxxxxxxxx> writes:
> On Thu, Mar 5, 2009 at 10:34 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>> Odd.  Try strace'ing the failing psql session, and send us the last few
>> dozen lines of the output.

> http://pastie.org/private/y7cbpuamemxawmhh8hdna is the strace output

So the relevant info is

sendto(3, "\0\0\0*\0\3\0\0user\0enc\0database\0yachti"..., 42, 0, NULL, 0) = 42
rt_sigaction(SIGPIPE, {SIG_DFL}, {SIG_IGN}, 8) = 0
poll([{fd=3, events=POLLIN|POLLERR, revents=POLLIN}], 1, -1) = 1
recvfrom(3, "E\0\0\0\225SFATAL\0C28000\0Mno pg_hba.co"..., 16384, 0, NULL, NULL) = 150
write(2, "psql: ", 6psql: )                   = 6
close(3)                                = 0
exit_group(2)                           = ?

Which looks to me like the server is correctly returning a rejection
(I assume there's a "no pg_hba.conf entry..." error showing up in the
server log too?) and then libpq is somehow falling down at converting
that to a displayable message --- psql seems to be getting told
correctly that the connection failed, but it's getting an empty string
instead of the desired error message.

In short, you've got a broken libpq (or possibly a broken psql
executable) on that machine.  I'd try reinstalling the postgres stuff
before spending additional time on it.  If it still fails then it would
be time to inquire into configuration options and so forth used to build
the postgres code for that machine.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux