Re: [Ejbca-develop] CADATA table

[Seonman K. <seo...@jp...>]

Please ignore this email.
I made a mistake when installing ejbca, especially in the configuration of
DataStore using MySql.
The type of "data" row should be "TEXT" type instead of varchar.


----- Original Message ----- 
From: "Seonman Kim" <seo...@jp...>
To: <ejb...@li...>
Sent: Tuesday, December 14, 2004 11:29 AM
Subject: [Ejbca-develop] CADATA table


> Hi,
>
> I am looking at the EJBCA code.
> I found a little buggy(?) setting for database. (Actually, I am not sure
it
> is buggy setting or intended one.)
> Seeing the table description of CADATA, I found the data row is not enough
> for saving the CA data. It is set as varchar(250).
>
> mysql> desc cadata;
> +------------+--------------+------+-----+---------+-------+
> | Field      | Type         | Null | Key | Default | Extra |
> +------------+--------------+------+-----+---------+-------+
> | cAId       | int(11)      |      | PRI | 0       |       |
> | name       | varchar(250) | YES  |     | NULL    |       |
> | subjectDN  | varchar(250) | YES  |     | NULL    |       |
> | status     | int(11)      |      |     | 0       |       |
> | expireTime | bigint(20)   |      |     | 0       |       |
> | data       | varchar(250) | YES  |     | NULL    |       |
> +------------+--------------+------+-----+---------+-------+
>
> Actually, seeing an entry of the "cadata" table, the data in the "data"
row
> was truncated like as below:
> | 1631242330 | TestCA1 | CN=TestCA1,O=Company,C=JP |      1 |
1418292283000
> | <?xml version="1.0" encoding="UTF-8"?>
> <java version="1.5.0" class="java.beans.XMLDecoder">
>  <object class="java.util.HashMap">
>   <void method="put">
>    <string>catype</string>
>    <int>1</int>
>   </void>
>   <void method="put">
>    <string>certif |
>
> Is it OK even in that case?
>
> I used EJBCA 3.0.4, JBOSS 3.2.6., and mysql 4.1.7.
>
> Regards,
> --
> Seonman
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Ejbca-develop mailing list
> Ejb...@li...
> https://lists.sourceforge.net/lists/listinfo/ejbca-develop