Skip site navigation (1) Skip section navigation (2)

Re: Reposnse from backend when wrong user/database request send

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: ishii(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Reposnse from backend when wrong user/database request send
Date: 2010-03-12 23:39:24
Message-ID: 20100313.083924.118740670.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
> Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
> >> Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
> >>> It seems between 8.4 and CVS HEAD backend responses 'E' packet
> >>> (error/fatal message) if a startup packet sent with wrong user and/or
> >>> database. Before backend responses 'R' packet first followd by 'E'
> >>> packet.
> 
> > I now understand that those behavior could be changed randomly release
> > to relase in unpredictable way.
> 
> I think the protocol specification is pretty explicit that you shouldn't
> be relying on specific sequences of events where it's not logically
> necessary that things happen in a particular order.  It's always been
> possible for a connection to be rejected before any 'R' is sent; we've
> only made a minor change in the set of error cases for which that's
> true.

No. I would say CVS HEAD's behavior that it returns 'E' first is ok if
it is given wrong database.

Problem is in 8.4 or before and HEAD returns Authentication ok
('R'+0x8+0x0) then 'E' if wrong user is given. How come backend says
"Great! authentication ok" then "Sorry your database is wrong so
authentican failed". FYI 8.4 or before always returns Authentication
ok then 'E' if user and/or database is wrong.

Maybe we should change "AuthenticationOK" to "AuthenticationMaybeOK"?:-)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2010-03-13 00:48:24
Subject: Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores
Previous:From: Tom LaneDate: 2010-03-12 23:19:59
Subject: Re: buildfarm logging versus embedded nulls

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group