Re: Unable To Establish Connections - Mailing list pgsql-admin

From Sam Stearns
Subject Re: Unable To Establish Connections
Date
Msg-id BANLkTinQcvvGp0HUUBJ1AEvpkVmuZ_JghQ@mail.gmail.com
Whole thread Raw
In response to Re: Unable To Establish Connections  (Tim <elatllat@gmail.com>)
Responses Re: Unable To Establish Connections  (Sam Stearns <samtstearns@gmail.com>)
List pgsql-admin
Thanks, Tim.

I've turned up logging some more.

On Wed, May 18, 2011 at 8:38 AM, Tim <elatllat@gmail.com> wrote:
> First google hit said this:
>
> "It seems (not sure) to occur when user retypes password fast.
> Maybe in this case ODBC driver gets old connection somehow from driver
> manager."
>
> also
> "It looks to me like the ODBC driver is failing to follow the protocol.
> It shouldn't respond with an 'X' if it doesn't have a password, just
> disconnect."
> I would start logging traffic so you have more to go on next time it
> happens.
>
> On Tue, May 17, 2011 at 6:52 PM, Sam Stearns <samtstearns@gmail.com> wrote:
>>
>> Anyone have any ideas on this?  We're an ISP.  I was thinking of the
>> possibility of a hack attempt.
>>
>> On Tue, May 17, 2011 at 6:52 PM, Sam Stearns <samtstearns@gmail.com>
>> wrote:
>> > Howdy,
>> >
>> > Environment:
>> >
>> > Postgres 8.2.3
>> > Solaris 10
>> >
>> > We were unable to make a remote postgres connection for ~2 hours this
>> > afternoon.  Receiving the following message in the postgres log every
>> > 30 seconds:
>> >
>> > LOG:  expected password response, got message type 88
>> >
>> > Connection limit is 300.  17 active connections at the time.  Bounced
>> > postgres successfully but the above error message was still being
>> > logged.  About 20 minutes later the error message stopped and
>> > connections started to re-establish.
>> >
>> > Any ideas?
>> >
>> > Thank you,
>> >
>> > Sam
>> >
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>

pgsql-admin by date:

Previous
From: Tim
Date:
Subject: Re: Unable To Establish Connections
Next
From: Silvio Brandani
Date:
Subject: server - odbc driver compatibility matrix