Hi Michael,
thank you very much for your reply.
On Mon, Jun 13, 2005 at 01:02:53PM +0200, Michael Bell wrote:
>
> This is a protection against SQL injection. We never put arguments
> directly into SQL queries - and if we did it then it is a bug. The $1 is
> a placeholder for the argument which is submitted seperately. Does the
> PostgreSQL result contain a real errormessage? Usually there is a
> detailed log of PostgreSQL if there is a query error.
>
> If you want more details from the database then please set the DEBUG
> switch in etc/database/DBI.conf to 1. After this var/log/stderr.log
> contains a lot of messages.
>
I had already set the debug flag and checked stderr.log, but havn't found
anything that point me to a solution.
In the meantime I installed a different DBD driver and got the same
error message.
Perhaps, there is something wrong with the PostgreSQL installation.
It is a little bit strange, that openca can write the records without
any problem.
So, I give it up and try it later again, because there are other
features waiting for beeing tested.
Thank you very much for your help.
here the content of stderr.log
--------------------------------------------------------------
DEBUG: OpenCA::DBI->getResultItem: format: PKCS#10
DEBUG: OpenCA::DBI->getResultItem: have all data
DEBUG: OpenCA::DBI->getResultItem: return item
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->listItems: added item 7200 to result
DEBUG: OpenCA::DBI->listItems: completed successful
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->getArguments: entering function
DEBUG: OpenCA::DBI->getArguments: check: DATATYPE=NEW_REQUEST
DEBUG: OpenCA::DBI->getArguments: TABLE:REQUEST
DEBUG: OpenCA::DBI->getArguments: MODE:
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->getArguments: attribute: KEY
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: STATUS
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: DN
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: CN
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: EMAIL
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: RA
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: OPERATOR
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: ROLE
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: PUBKEY
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: SCEP_TID
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: LOA
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->getStatus: Entering function
DEBUG: OpenCA::DBI->getStatus: no status given using datatype: NEW_REQUEST
DEBUG: OpenCA::DBI->getStatus: given mode is now: NEW
DEBUG: OpenCA::DBI->getStatus: legal status (leaving function)
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->getArguments: status: NEW
DEBUG: OpenCA::DBI->getArguments: completed successful
DEBUG: OpenCA::DBI->getNextItem: query: select MIN(req_key) from request where
(status like ?)
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->doQuery: entering function
DEBUG: OpenCA::DBI->doQuery: query: select MIN(req_key) from request where
(status like ?)
DEBUG: OpenCA::DBI->doQuery: bind_values: NEW
DEBUG: OpenCA::DBI->doQuery: prepare statement
DEBUG: OpenCA::DBI->doQuery: statement nr.: 5
DEBUG: OpenCA::DBI->doQuery: execute statement
DEBUG: OpenCA::DBI->doQuery: execute succeeded (leaving function - 1)
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->getNextItem: arg:
DEBUG: OpenCA::DBI->getNextItem: result: ARRAY(0x9899284)
DEBUG: OpenCA::DBI->getNextItem: result: 7200
DEBUG: OpenCA::DBI->getItem: Entering sub getItem
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->getArguments: entering function
DEBUG: OpenCA::DBI->getArguments: check: KEY=7200
DEBUG: OpenCA::DBI->getArguments: check: DATATYPE=REQUEST
DEBUG: OpenCA::DBI->getArguments: check: MODE=
DEBUG: OpenCA::DBI->getArguments: TABLE:REQUEST
DEBUG: OpenCA::DBI->getArguments: MODE:
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->getArguments: attribute: KEY
DEBUG: OpenCA::DBI->getArguments: value: 7200
DEBUG: OpenCA::DBI->getArguments: attribute: STATUS
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: DN
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: CN
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: EMAIL
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: RA
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: OPERATOR
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: ROLE
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: PUBKEY
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: SCEP_TID
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->getArguments: attribute: LOA
DEBUG: OpenCA::DBI->getArguments: value:
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->getStatus: Entering function
DEBUG: OpenCA::DBI->getStatus: no status given using datatype: REQUEST
DEBUG: OpenCA::DBI->getStatus: given mode is now:
DEBUG: OpenCA::DBI->getStatus: no status (leaving function)
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->getArguments: no STATUS present
DEBUG: OpenCA::DBI->getArguments: completed successful
DEBUG: OpenCA::DBI->getItem: data complete
DEBUG: OpenCA::DBI->getItem: query: select * from request where (req_key=?)
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->doQuery: entering function
DEBUG: OpenCA::DBI->doQuery: query: select * from request where (req_key=?)
DEBUG: OpenCA::DBI->doQuery: bind_values: 7200
DEBUG: OpenCA::DBI->doQuery: prepare statement
DEBUG: OpenCA::DBI->doQuery: statement nr.: 7
DEBUG: OpenCA::DBI->doQuery: execute statement
DEBUG: OpenCA::DBI->doQuery: execute succeeded (leaving function - 1)
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: old errno 11111 is present
DEBUG: OpenCA::DBI->errno: new errorcode is 11111
DEBUG: OpenCA::DBI->getItem: query completed
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->errno: gettext is defined
DEBUG: OpenCA::DBI->errno: new errorcode is 0
DEBUG: OpenCA::DBI->errno: returning local errorcode 20032
DEBUG: OpenCA::DBI->errno: returning local errorcode 20032
DEBUG: OpenCA::DBI->rollback: entering function
DEBUG: OpenCA::DBI->errno: returning local errorcode 20032
DEBUG: OpenCA::DBI->DESTROY: automatic commit by destructor DESTROY
DEBUG: OpenCA::DBI->commit: entering function
DEBUG: OpenCA::DBI->errno: returning local errorcode 20032
DEBUG: OpenCA::DBI->DESTROY: call finish on all statement handles to avoid
warnings by DBI
--------------------------------------------------------------------------------
Thank you ...
Niels Peuyn
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
