Ok, if you have OpenSSL-0.9.8, then try:
1. In the file OpenCA/DBI.pm after the line #783
(which is:
$charset =~ s/^[^\.]+\.//g;
)
add the following line:
$charset = 'UTF8' if ($charset =~ /UTF-8/i);
2. Restart OpenCA server.
If this helps, I will explain what is happening.
Suspecting careless installation of MySQL.
If you had OpenSSL-0.9.7, then let me know too, as
not reporting the wrong OpenSSL version would be a serious bug
in OpenCA.
Subredu Manuel wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I made some more digging (enabled trace for dbi in the openca perl
modules), and found this:
DBI 1.50-ithread default trace level set to 0x0/4 (pid 20701)
-> prepare for DBD::mysql::db (DBI::db=HASH(0x9fef204)~0xa0372ac
'SET NAMES 'utf-8'') thr#8166008
New DBI::st (for DBD::mysql::st, parent=DBI::db=HASH(0xa0372ac), id=)
dbih_setup_handle(DBI::st=HASH(0xa0374b0)=>DBI::st=HASH(0xa037588),
DBD::mysql::st, a0374bc, Null!)
dbih_make_com(DBI::db=HASH(0xa0372ac), a039780, DBD::mysql::st, 248,
0) thr#8166008
dbd_st_prepare calling count_params (counting params emulation)
<- prepare= DBI::st=HASH(0xa0374b0) at DBI.pm line 2530 via
/usr/lib/perl5/5.8.8/OpenCA/DBI.pm line 784
-> execute for DBD::mysql::st (DBI::st=HASH(0xa0374b0)~0xa037588)
thr#8166008
-> dbd_st_execute for 0a0375d0
- ---> parse_params with statement SET NAMES 'utf-8' num params 0
mysql_st_internal_execute
Unknown character set: 'utf-8' error 1115 recorded: Unknown character
set: 'utf-8'
As you can see, before doing anything with the database OpenCA try to
"SET NAMES utf-8" which is not valid.
Proof:
mysql> SET NAMES utf-8;
ERROR 1115 (42000): Unknown character set: 'utf'
mysql> SET NAMES utf8;
Query OK, 0 rows affected (0.00 sec)
So .. how do I change that ? :)
Subredu Manuel wrote:
Hi,
I just installed OpenCA-0.9.2.5 and install it on a OpenSuSE 10.1
machine. I have configured and started all the daemons and the
webserver, I initialized the CA, created the initial certificates.
After that I tried to generate a user certificate. All was ok, the
certificate is in the database, but when I try (as regular user) to
download the certificate, OpenCA fails and the log file contain the
following:
DBD::mysql::st execute failed: Unknown character set: 'utf-8' at
/usr/lib/perl5/5.8.8/OpenCA/DBI.pm line 2544.
Why ? I haven't been able to find the cause of all this. The modules
used by OpenCA are:
Module Version
OpenSSL 0.9.135.2.11
Tools 0.4.3
DB 0.9.115.2.8
Configuration 1.5.3
TRIStateCGI 1.5.5
REQ 0.9.61.2.1
X509 0.9.57
CRL 0.9.24.2.1
PKCS7 0.9.19.2.5
I have mysql 5.x with utf8 support enabled.
mysqldump openca | grep -i utf8
/*!40101 SET NAMES utf8 */;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Do you have any hints ? Any ideas ? I tried everything I knew but
nothing worked.
- -------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
- --
==================================================
inf. Manuel SUBREDU
Network Engineer at RoEduNet Iasi
Phone: +40 (232) 201007
+40 (742) 088067
Email: [EMAIL PROTECTED]
website: http://www.packages.ro
GPG key: http://www.packages.ro/diablo.gpg.txt
==================================================
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
iD8DBQFEdaEEjGXbUSvc3AsRAokEAJ99RDlM7FSK8fWVg2rLWdpIjZqH2QCfZHn8
ZNvM5yZ9ATGMh90vAF8I2xE=
=GuxC
-----END PGP SIGNATURE-----
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Openca-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openca-users
