From: <bal...@vt...> - 2001-09-11 15:33:50
|
hello=20 Why the ca command listReq is using the listItem funcation of the DBI instead of using the searchItem of the DBI? I had no luck getting it to work whith listItems but it = does work with search Items. if there is any reason why I shuold not use it please tell me. I also included the debug output of the listItems. Starting to init a new OpenCA::DBI defining the class parameters = checking the configuration for enough data checking for the tools preparing the remote and local databases (vendor dependent) Oracle = detected for remoteDB remoteDB: dbi:Oracle:PKI2 Oracle detected for localDB localDB: dbi:Oracle:PKI2 try to get a consistent operationmode set standard and backup databases OpenCA::DBI should now complete ### new function call ### Entering function elements ### new function call ### Entering getStatus no status given using datatype: PENDING_REQUEST given mode is: "PENDING" legal status ### leaving function successful ### ### new function call ### Entering sub doConnect status: 0 errors: 0 connect never failed so using standard DSN STANDERD=3D dbi:Oracle:PKI2 Databasetype:Oracle try to connect YYYYY MMBBBBB function succeeded ### leaving function doConnect successfully ### ### new function call ### Entering sub doQuery query: select count(*) from request where status like ? bind_values: PENDING prepare statement statement nr.: 1 execute statement execute succeeded ### leaving function doQuery successfully ### state: $rv=3D elements comleted successful ### leaving function elements ### LLLLLLLLLLLLLLLLLLLLLLLL0 LLLLLLLLLLLLLLLL### new function call ### Entering function listItems ### new function call ### Entering getStatus no status given using datatype: PENDING_REQUEST given mode is: "PENDING" legal status ### leaving function successful ### KKKKKKKKKKK ### new function call ### Entering sub doConnect status: 0 errors: 0 connect never failed so using standard DSN STANDERD=3D dbi:Oracle:PKI2 Databasetype:Oracle try to connect function succeeded ### leaving function doConnect successfully ### ### new function call ### Entering sub doQuery query: select MIN (req_key) from request where (req_key > ? ) and = (status like ?) bind_values:=20 bind_values: PENDING prepare statement statement nr.: 1 execute statement execute succeeded ### leaving function doQuery successfully ### HHHHHHHH ARRAY(0x850ab28) HHHHHHHHHHHHHHHHH### new function call ### Entering sub getItem ### new function call ### Entering getStatus no status given using datatype: PENDING_REQUEST given mode is: "PENDING" legal status ### leaving function successful ### table: REQUEST status: PENDING serial:=20 listItem completed successful ### leaving function successfully ### =20 Pending Requests. Following you can find the request waiting for Certification. This list has been updated on Tue Sep 11 15:34:31 2001 = GMT. =20 No Extra = References Op. Serial Submit Name Submitted On =A9 1998-2001 by Massimiliano Pala and the = OpenCA Group. CA Manager - Version 0.7.11a =20 |