michael, really sorry, i am still not able to locate the problem. i have added my sql query output here.
> > I still can only simulate your problem if I run two public interfaces > both with the same module_id. No, i have only one public interface, infact this is my test installation. I have installed all the modules in the same machine. But OpenCA version is RC release (0.9.1 RC7) not the offical one. > > 1. Do you have really high loads on your database? > No, not more than 200 certificates. > 2. I have a problem too because I don't understand how mysql can create > two rows with the same req_key (this is the CSR_SERIAL) but req_key is > the primary key!? This is an integrity problem of the database. > > If the CSR_SERIALs are equal then req_key must be equal too. Is this > correct in your db? If yes then does mysql report any integrity problems? > Here is my sql query output. ########################## mysql> select cert_key,status,req_key from certificate; +----------+---------+---------+ | cert_key | status | req_key | +----------+---------+---------+ | 66 | NULL | 288 | | 67 | VALID | 544 | | 68 | VALID | 800 | | 69 | NULL | 1056 | | 70 | NULL | 2080 | | 71 | NULL | 2336 | | 72 | REVOKED | 1312 | | 73 | NULL | 2592 | | 74 | REVOKED | 3104 | | 75 | VALID | 3616 | | 76 | REVOKED | 3360 | | 77 | VALID | 3872 | | 78 | REVOKED | 2848 | | 79 | VALID | 4128 | | 84 | VALID | 5408 | | 85 | REVOKED | 6944 | | 86 | NULL | 7200 | | 87 | VALID | 7456 | | 99 | VALID | 12032 | | 100 | VALID | 12576 | | 102 | NULL | 13088 | | 107 | VALID | 288 | | 108 | VALID | 800 | | 109 | VALID | 1312 | | 110 | VALID | 3104 | | 111 | VALID | 2592 | | 112 | VALID | 2848 | | 113 | VALID | 3360 | | 114 | VALID | 5152 | | 115 | VALID | 5408 | | 116 | VALID | 5664 | | 117 | VALID | 6944 | | 118 | VALID | 7456 | | 119 | VALID | 7712 | | 120 | VALID | 4896 | | 121 | VALID | 7968 | | 122 | VALID | 8224 | | 123 | VALID | 8480 | | 124 | VALID | 8736 | | 125 | VALID | 9760 | | 126 | VALID | 10016 | | 127 | VALID | 10784 | | 128 | VALID | 11296 | | 129 | VALID | 11552 | | 130 | VALID | 10528 | | 131 | VALID | 9504 | | 132 | VALID | 4640 | | 133 | VALID | 3616 | +----------+---------+---------+ 48 rows in set (0.01 sec) mysql> notee #################################### you can see for req_key 800, cert_key 68 and 108. similarly for req_key 3104. Does this happen only in the old release. Do you any glue of where i am doing wrong. Thanks in advance. -venki. ------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
