Hi, maybe I've messed up something again, after fixing the problem with literal \n -> LF conversion on imported SQL dumps, I am now facing a new problem.
After importing the SQL dump and restoring the var/ hierarchy, I can now display the certificates. However there is a new problem: if I issue a new CSR, the insertion into the database fails with the Error ENTRY_EXIST, resulting from the fact that the chosen CSR serial 288 is already existing in the DB. When digging through the logs, I found that some time before the system used a max() call to determine the highes already existing req_key: DEBUG: OpenCA::DBI->doQuery: entering function DEBUG: OpenCA::DBI->doQuery: query: select MAX(req_key) from pkiscop1.request DEBUG: OpenCA::DBI->doQuery: prepare statement DEBUG: OpenCA::DBI->doQuery: statement nr.: 3 DEBUG: OpenCA::DBI->doQuery: execute statement DEBUG: OpenCA::DBI->doQuery: execute succeeded (leaving function - 0E0) 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: 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=6176 DEBUG: OpenCA::DBI->getArguments: check: DATATYPE=REQUEST DEBUG: OpenCA::DBI->getArguments: check: MODE= DEBUG: OpenCA::DBI->getArguments: TABLE:REQUEST DEBUG: OpenCA::DBI->getArguments: MODE: So far, so good, but when actually inserting the new CSR, it chooses the very first CSR serial that is assigned to new CSRs (288): DEBUG: OpenCA::DBI->storeItem: table: REQUEST DEBUG: OpenCA::DBI->Entering set_error ... DEBUG: OpenCA::DBI->errno: gettext is defined DEBUG: OpenCA::DBI->errno: new errorcode is 0 DEBUG: OpenCA::DBI->storeItem_checkData: Entering storeItem_checkData DEBUG: OpenCA::DBI->storeItem_checkData: check for existence of item DEBUG: OpenCA::DBI->storeItem_checkData: doQuery: select * from pkiscop1.request where req_key=? 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->doQuery: entering function DEBUG: OpenCA::DBI->doQuery: query: select * from pkiscop1.request where req_key =? DEBUG: OpenCA::DBI->doQuery: bind_values: 288 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 - 0E0) 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->storeItem_checkData: illegal insert 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 10006 DEBUG: OpenCA::DBI->rollback: entering function DEBUG: OpenCA::DBI->errno: returning local errorcode 10006 DEBUG: OpenCA::OpenSSL->_stop_shell: try to stop shell Why does it select 288 and not the next free CSR serial above 6176? cheers, Martin ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
