RE: [Openca-Users] No certificates are present

[Mario C. <mar...@sa...>]

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=20

> -----Urspr=FCngliche Nachricht-----
> Von: ope...@li...=20
> [mailto:ope...@li...] Im Auftrag=20
> von David Bannon
> Gesendet: Dienstag, 31. Januar 2006 02:05
> An: ope...@li...
> Betreff: Re: [Openca-Users] No certificates are present
>=20
> 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).
>=20
> David
>=20
> mysql> show tables;
> +---------------------+
> | Tables_in_openca_db |
> +---------------------+
> | ca_certificate      |
> | certificate         |
> | crl                 |
> | crr                 |
> | logged              |
> | request             |
> +---------------------+
> 6 rows in set (0.00 sec)
>=20
> 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)
>=20
> 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)
>=20
> 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)
>=20
> 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)
>=20
> 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)
>=20
> mysql>
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep=20
> through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web. =20
> DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&
dat=3D121642
> _______________________________________________
> Openca-Users mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openca-users
>=20