Hi @all, after migrating to OpenCA 1.1.1 and importing the data from a 0.9.2+ system I'm not able to create new a CSR in OpenCA 1.1.1.
These are my steps that I used to get the old data in the new system... 1. backuped the old data using the Node-Interface 2. droped the DB on the new system to be sure it is a clean one 3. created a new DB 4. intialized the DB 5. recovered the data via the Node-Interface 6. restored SSL-Files I went throgh these steps without any problems, so the first qestion is: Do I overlooked something? Due research on the code it turned out, that OpenCA is trying to find the highest rowid to get the next free CSR serial but in my case the highest rowid does not match the highest CSR serial. mysql> SELECT rowid, req_key from request ORDER BY rowid DESC; +-------+---------+ | rowid | req_key | +-------+---------+ | 820 | 209184 | | 819 | 203808 | | 818 | 196128 | mysql> SELECT rowid, req_key from request ORDER BY req_key DESC; +-------+---------+ | rowid | req_key | +-------+---------+ | 764 | 209952 | | 763 | 209696 | | 762 | 209440 | So the export-import.lib loops trough the directories of the unpacked tar file alphabetically and reads the first the approved and the deleted CSR. By insert time the rowid is generated by the DB coz it is auto_increment. For me the question is: How can i prevent this behavior. Many thanks Steffen ------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users
