You are viewing a plain text version of this content. The canonical link for it is here.
Posted to bugs@httpd.apache.org by bu...@apache.org on 2007/07/05 13:58:32 UTC
DO NOT REPLY [Bug 42732] - Authentication against database issue.
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