Hi David, thanks for your answer. The database structure looks like yours...but in the stderr.log from yesterday there was an entry: New errorcode is 11111, you have the same in your stderr.log, so this entry wouldn't be a real error?
Regards Mario > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag > von David Bannon > Gesendet: Dienstag, 31. Januar 2006 02:05 > An: [email protected] > Betreff: Re: [Openca-Users] No certificates are present > > 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 > ------------------------------------------------------- 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&kid3432&bid#0486&dat1642 _______________________________________________ Openca-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openca-users
