This would perhaps help:
diff -ruN OpenCA-0.9.2.5-orig/src/modules/openca-dbi/DBI.pm
OpenCA-0.9.2.5/src/modules/openca-dbi/DBI.pm
--- OpenCA-0.9.2.5-orig/src/modules/openca-dbi/DBI.pm 2005-08-09
14:01:01.000000000 +0000
+++ OpenCA-0.9.2.5/src/modules/openca-dbi/DBI.pm 2006-09-21
15:43:23.000000000 +0000
@@ -781,6 +781,7 @@
$self->debug ("connect: Setting characterset if the database
support it ...");
$charset =~ s/^[^\.]+\.//g;
+ $charset = 'UTF8' if ($charset =~ /UTF-8/i);
$self->doQuery (QUERY => "SET NAMES '$charset'");
$self->debug ("connect: Characterset fixed if possible");
}
Chris
Jeremy Rosen schrieb:
> Hi ListUsers,
>
> since I'd like to have support for special character in my certificates
> I wanted to switch my old CA/RA to the most recent version 0.9.3-rc1.
> I configured the sources --with-cert-chars=UTF8, and in my confix.xml I
> have
>
> <option>
> <name>default_charset</name>
> <value>utf8</value>
> </option>
> <option>
>
> and
>
> <name>cert_chars</name>
> <value>UTF8</value>
>
> I created my CA root certificate and that ran well. I continued to
> create a CSR for CAoperator, that worked well too, but when I want to
> look at the request (even directly) I see an empty screen and stderr.log
> says :
>
> DBD::mysql::st execute failed: Unknown character set: 'utf-8' at
> /usr/local/openca/modules/perl5/OpenCA/DBI.pm line 2544.
>
> several times.
>
> Conclusion: DBI.pm fails while executing the statement, so the statement
> must be wrong, and for any reason he's creating a statement for whatever
> and includes utf-8 instead of utf8. I cannot explain that behaviour nor
> did I find anything searching now.
>
> Can anybody help?
> Thx in advance
>
> Jeremy Rosen
> [EMAIL PROTECTED]
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Openca-Users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openca-users
>
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
