On Wed, Oct 22, 2008 at 12:07 AM, Massimiliano Pala <
[EMAIL PROTECTED]> wrote:
> Hi Ernest,
>
> I am going to post something, but I have nit much time now.. can you
> please forward me the structure of your database ? That is:
>
> SHOW TABLES;
mysql> SHOW TABLES;
+------------------+
| Tables_in_openca |
+------------------+
| ca_certificate |
| certificate |
| crl |
| crr |
| request |
+------------------+
5 rows in set (0.00 sec)
>
> and then for each table:
>
> SHOW COLUMNS FROM xxxx;
>
> in particular, can you send me the output of this:
>
> SHOW COLUMNS FROM ca_certificate;
> SHOW COLUMNS FROM certificate;
> SHOW COLUMNS FROM crl;
> SHOW COLUMNS FROM crr;
> SHOW COLUMNS FROM request;
>
mysql> SHOW COLUMNS FROM ca_certificate;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| ca_cert_key | varchar(255) | NO | 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.00 sec)
mysql> SHOW COLUMNS FROM certificate;
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| cert_key | bigint(20) | NO | 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> SHOW COLUMNS FROM crl;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| crl_key | varchar(255) | NO | 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.01 sec)
mysql> SHOW COLUMNS FROM crr;
+-------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| crr_key | bigint(20) | NO | 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> SHOW COLUMNS FROM request;
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| req_key | bigint(20) | NO | 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)
PS: i'll attach also mysqldump
-- MySQL dump 10.11
--
-- Host: localhost Database: openca
-- ------------------------------------------------------
-- Server version 5.0.45-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `ca_certificate`
--
CREATE TABLE `ca_certificate` (
`ca_cert_key` varchar(255) NOT NULL default '',
`format` text,
`data` text,
`dn` text,
`cn` text,
`email` text,
`status` text,
`public_key` text,
`notafter` bigint(20) default NULL,
PRIMARY KEY (`ca_cert_key`)
);
--
-- Table structure for table `certificate`
--
CREATE TABLE `certificate` (
`cert_key` bigint(20) NOT NULL default '0',
`format` text,
`data` text,
`dn` text,
`cn` text,
`email` text,
`status` text,
`role` text,
`public_key` text,
`notafter` bigint(20) default NULL,
`req_key` bigint(20) default NULL,
`loa` text,
PRIMARY KEY (`cert_key`)
);
--
-- Table structure for table `crl`
--
CREATE TABLE `crl` (
`crl_key` varchar(255) NOT NULL default '',
`status` text,
`format` text,
`data` text,
`last_update` text,
`next_update` text,
PRIMARY KEY (`crl_key`)
);
--
-- Table structure for table `crr`
--
CREATE TABLE `crr` (
`crr_key` bigint(20) NOT NULL default '0',
`cert_key` bigint(20) default NULL,
`submit_date` text,
`format` text,
`data` text,
`dn` text,
`cn` text,
`email` text,
`ra` text,
`rao` text,
`status` text,
`reason` text,
`loa` text,
PRIMARY KEY (`crr_key`)
);
--
-- Table structure for table `request`
--
CREATE TABLE `request` (
`req_key` bigint(20) NOT NULL default '0',
`format` text,
`data` text,
`dn` text,
`cn` text,
`email` text,
`ra` text,
`rao` text,
`status` text,
`role` text,
`public_key` text,
`scep_tid` text,
`loa` text,
PRIMARY KEY (`req_key`)
);
/*!40103 SET [EMAIL PROTECTED] */;
--
+421-2--6241-0360, +421-903--482-603
icq://28153343, skype://oernii-work, jabber://[EMAIL PROTECTED]
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
