Greetings, everyone!
I have the latest (minutes ago) snapshot of the 0.9.2 stable branch of
OpenCA.
I want to use OpenCA with MySQL 4.1.13 on my FreeBSD5.4.
SQL statements for database initialization looks like this:
~~~~
> ...
> create table ca_certificate (ca_cert_key VARCHAR (255) NOT NULL
> PRIMARY KEY, format TEXT, data TEXT, dn TEXT, cn TEXT, email TEXT,
> status TEXT, public_key TEXT, notafter BIGINT) TYPE=BDB;
> ...
~~~~
This statement fails
~~~~
> Error 10040
> General Error Error while initializing the database. Cannot create
> the table ca_certificate. (error 20016: EXECUTE_FAILED (error 11111:
> Do not commit if the database or the module itself fails.
> ...
~~~~
If I manually give a command
> create table ca_certificate (ca_cert_key VARCHAR (255) NOT NULL
> PRIMARY KEY, format TEXT, data TEXT, dn TEXT, cn TEXT, email TEXT,
> status TEXT, public_key TEXT, notafter BIGINT) TYPE=BDB;
in mysql console, i have an error message:
> MySQL:
> #1071 - Specified key was too long; max key length is 255 bytes
If I manually create table with the same fields via phpMyAdmin I get
almost the same statement NOT ending with "TYPE=BDB".
I change
CREATE_TABLE_OPTION => "TYPE=BDB",
to
CREATE_TABLE_OPTION => "",
in DBI.pm and restart ca server.
Now everything looks fine, the database is successfully initialized,
certificates are found in database without any problems.
Can anybody comment this? What happens in Debian? Is any particular
need in option "TYPE=BDB"?
--
Chernov S. [EMAIL PROTECTED]
icq 4205925
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
