Mario, how about checking that your mysql database is created correctly ? Here's mine (don't worry about the table 'logged' its an extra we added).
David mysql> show tables; +---------------------+ | Tables_in_openca_db | +---------------------+ | ca_certificate | | certificate | | crl | | crr | | logged | | request | +---------------------+ 6 rows in set (0.00 sec) mysql> describe ca_certificate; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | ca_cert_key | varchar(255) | | PRI | | | | format | text | YES | | NULL | | | data | text | YES | | NULL | | | dn | text | YES | | NULL | | | cn | text | YES | | NULL | | | email | text | YES | | NULL | | | status | text | YES | | NULL | | | public_key | text | YES | | NULL | | | notafter | bigint(20) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ 9 rows in set (0.01 sec) mysql> describe certificate; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | cert_key | bigint(20) | | PRI | 0 | | | format | text | YES | | NULL | | | data | text | YES | | NULL | | | dn | text | YES | | NULL | | | cn | text | YES | | NULL | | | email | text | YES | | NULL | | | status | text | YES | | NULL | | | role | text | YES | | NULL | | | public_key | text | YES | | NULL | | | notafter | bigint(20) | YES | | NULL | | | req_key | bigint(20) | YES | | NULL | | | loa | text | YES | | NULL | | +------------+------------+------+-----+---------+-------+ 12 rows in set (0.00 sec) mysql> describe crl; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | crl_key | varchar(255) | | PRI | | | | status | text | YES | | NULL | | | format | text | YES | | NULL | | | data | text | YES | | NULL | | | last_update | text | YES | | NULL | | | next_update | text | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ 6 rows in set (0.00 sec) mysql> describe crr; +-------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------+------+-----+---------+-------+ | crr_key | bigint(20) | | PRI | 0 | | | cert_key | bigint(20) | YES | | NULL | | | submit_date | text | YES | | NULL | | | format | text | YES | | NULL | | | data | text | YES | | NULL | | | dn | text | YES | | NULL | | | cn | text | YES | | NULL | | | email | text | YES | | NULL | | | ra | text | YES | | NULL | | | rao | text | YES | | NULL | | | status | text | YES | | NULL | | | reason | text | YES | | NULL | | | loa | text | YES | | NULL | | +-------------+------------+------+-----+---------+-------+ 13 rows in set (0.00 sec) mysql> describe request; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | req_key | bigint(20) | | PRI | 0 | | | format | text | YES | | NULL | | | data | text | YES | | NULL | | | dn | text | YES | | NULL | | | cn | text | YES | | NULL | | | email | text | YES | | NULL | | | ra | text | YES | | NULL | | | rao | text | YES | | NULL | | | status | text | YES | | NULL | | | role | text | YES | | NULL | | | public_key | text | YES | | NULL | | | scep_tid | text | YES | | NULL | | | loa | text | YES | | NULL | | +------------+------------+------+-----+---------+-------+ 13 rows in set (0.00 sec) mysql> ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Openca-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openca-users
