Hello everybody, I'm using OpenCA with PostgreSQL and it works excellent. Today I started making some tests using OpenCA and MySQL, but I can make it work :-(
Software I have: Fedora Core 1 mysql-3.23.58-4 mysql-server-3.23.58-4 perl-Parse-Yapp-1.05-30 perl-libxml-perl-0.07-28 perl-5.8.1-92 perl-Filter-1.29-8 mod_perl-1.99_09-10 perl-DateManip-5.40-30 perl-HTML-Parser-3.26-18 perl-URI-1.21-7 perl-XML-Parser-2.31-16 perl-XML-Dumper-0.4-25 perl-libxml-enno-1.02-29 perl-DBD-MySQL-2.9003-4 perl-DBD-Pg-1.22-1 perl-HTML-Tagset-3.03-28 perl-libwww-perl-5.65-6 perl-XML-Encoding-1.01-23 perl-DBI-1.37-1 openca-0.9.1.8 My DBI.conf is like this: DEBUG 0 DB_Type "mysql" DB_Name "pki" DB_Host "localhost" DB_Port 3306 DB_User "openca" DB_Passwd "openca" Some data from the mysql database: select host, user, password from user; +-----------+--------+----------+ | host | user | password | +-----------+--------+----------+ | localhost | root | | | maquina24 | root | | | localhost | | | | maquina24 | | | | localhost | openca | openca | | localhost | apache | | +-----------+--------+----------+ 6 rows in set (0.00 sec) Here we can see user openca should connect to the database using host: localhost and password: openca select host, db, user from db; +-----------+---------+--------+ | host | db | user | +-----------+---------+--------+ | % | test | | | % | test\_% | | | localhost | pki | openca | | localhost | pki | root | +-----------+---------+--------+ 4 rows in set (0.01 sec) Error Message found when I try to enter to, fro example, http://localhost/ra/: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Apache/2.0.47 (Fedora) Server at localhost Port 80 When I change the DBI.conf for OpenCA to use no password: DEBUG 0 DB_Type "mysql" DB_Name "pki" DB_Host "localhost" DB_Port 3306 DB_User "openca" DB_Passwd "" The error message is different: Error 690 Configuration Error. Cannot initialize OpenCA::DBI class! The database returns errorcode 0. (Success (error 10070: Missing database parameters (type, name, user or passphrase). Does the passphrase be empty? (error 11111: Do not commit if the database or the module itself fails.))). What should I do?? Sorry for my newbie questions, Johnny ______________________________________________ Renovamos el Correo Yahoo!: �100 MB GRATIS! Nuevos servicios, m�s seguridad http://correo.yahoo.es ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
