-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Sergei Vyshenski wrote: > 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); I changed the SET NAME '$charset' to SET NAME utf8 and all works as expected. > > 2. Restart OpenCA server. > > If this helps, I will explain what is happening. > Suspecting careless installation of MySQL. please do. I'm very curious. > > 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: > > > 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 > ================================================== >> >> - ------------------------------------------------------- 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 - -- ================================================== 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) iD8DBQFEda9kjGXbUSvc3AsRAs50AJ9rrhcUhz10Wqnbx7hYRIZOU96JKgCZAR1Y vK90vwqqSJPcvt2F7O7bqm8= =7ZPL -----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
