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 [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|INVALID | ------- Additional Comments From [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
