httpd-bugs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 42732] - Authentication against database issue.
Date Thu, 05 Jul 2007 11:58:32 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=42732>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=42732


laurent.faillie@st.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|INVALID                     |




------- Additional Comments From laurent.faillie@st.com  2007-07-05 04:58 -------
It's not a misconfiguration but really a bug : I did several tests and generated
some log on the database.

when the password is rejected, Apache did initiated the connection but the query
didn't run.

DEBUG:  bind <unnamed> to authn_dbd_1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3116/1/0, nestlvl: 1, children: <>
LOG:  execute authn_dbd_1: PREPARE authn_dbd_1 (varchar) AS select passwd from
test.comptes where id = $1
DETAIL:  parameters: $1 = 'Test'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3116/1/1, nestlvl: 1, children: <>

When the password is accepted, Apache initiate the connection and then a query
is issued on the database.

DEBUG:  bind <unnamed> to authn_dbd_1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3120/1/0, nestlvl: 1, children: <>
LOG:  execute authn_dbd_1: PREPARE authn_dbd_1 (varchar) AS select passwd from
test.comptes where id = $1
DETAIL:  parameters: $1 = 'Test'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3120/1/1, nestlvl: 1, children: <>
DEBUG:  bind <unnamed> to authn_dbd_1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3121/1/0, nestlvl: 1, children: <>
LOG:  execute authn_dbd_1: PREPARE authn_dbd_1 (varchar) AS select passwd from
test.comptes where id = $1
DETAIL:  parameters: $1 = 'Test'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3121/1/1, nestlvl: 1, children: <>
DEBUG:  bind <unnamed> to authn_dbd_1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3122/1/0, nestlvl: 1, children: <>
LOG:  execute authn_dbd_1: PREPARE authn_dbd_1 (varchar) AS select passwd from
test.comptes where id = $1
DETAIL:  parameters: $1 = 'Test'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3122/1/1, nestlvl: 1, children: <>
DEBUG:  bind <unnamed> to authn_dbd_1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3123/1/0, nestlvl: 1, children: <>
LOG:  execute authn_dbd_1: PREPARE authn_dbd_1 (varchar) AS select passwd from
test.comptes where id = $1
DETAIL:  parameters: $1 = 'Test'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3123/1/1, nestlvl: 1, children: <>
DEBUG:  bind <unnamed> to authn_dbd_1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3124/1/0, nestlvl: 1, children: <>
LOG:  execute authn_dbd_1: PREPARE authn_dbd_1 (varchar) AS select passwd from
test.comptes where id = $1
DETAIL:  parameters: $1 = 'Test'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3124/1/1, nestlvl: 1, children: <>
LOG:  connection received: host=[local]
DEBUG:  forked new backend, pid=18697 socket=7
LOG:  connection authorized: user=www database=www
DEBUG:  postgres child[18697]: starting with (
DEBUG:  	postgres
DEBUG:  	-v196608
DEBUG:  	-y
DEBUG:  	www
DEBUG:  )
DEBUG:  InitPostgres
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3125/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid:
3125/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid:
3126/1/0, nestlvl: 1, children: <>
LOG:  statement: SELECT *, TO_CHAR(expiration, 'YYYYMMDD') AS expiration FROM
hebergement.site WHERE id='Test';
DEBUG:  parse tree:
DETAIL:  {QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <>
	:resultRelation 0 :into <> :intoOptions <> :intoOnCommit 0 :intoTableSpaceName
...

According to PostgreSQL log, it seems the connection hasn't a "working" status
(expired ?), and this time, apache is doing several attempts, all failing and
finally create a new connection and do the query, successfully this time.

Best regards,

Laurent


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org


Mime
View raw message