Bump! Am 07.12.2011 11:46, schrieb Steffen Waitz: > 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 >
------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users