-----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
