Hi, you might want to check that mysql is responding on localhost port 3306 by doing:
$ telnet localhost 3306 if it works, great. If it does not, you need to check the mysql config. If, instead you need to change the default configuration in openca, remember to change the .template files, not the .xml files as they get over-written when openca starts! Let me know if you managed to fix the issue. Cheers, Max On 07/08/2011 10:23 AM, Ben Tullis wrote:
Hi, I'm trying to create a new instance of an OpenCA version 1.1.1. I've installed it from source on Debian 5.0.8 My problem occurs when trying to start the openca service and initialize the MySQl database. I have put the correct parameters into PREFIX/openca/etc/config.xml and the PREFIX/openca/etc/database/DBI.conf file has been updated with the correct values, but these values aren't being used when the init script runs the following command: /usr/bin/perl /usr/local/openca/etc/openca/openca_start Here is the output from that command, when run as the webserver user. I have enabled DEBUG in /usr/local/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pmOpenCA::DBI->new: Starting to init a new OpenCA::DBI OpenCA::DBI->Entering set_error ... OpenCA::DBI->set_error: gettext is not defined OpenCA::DBI->set_error: errno and errval set OpenCA::DBI->new: checking for backend OpenCA::DBI->new: defining the class parameters OpenCA::DBI->new: rewrite table spaces if necessary (namespace) OpenCA::DBI->new: checking the configuration for enough data OpenCA::DBI->new: preparing the database (vendor dependent) OpenCA::DBI->new: mysql detected OpenCA::DBI->new: DB: dbi:mysql:database=openca;host=localhost;port=3306;mysql_ssl=0 OpenCA::DBI->new: OpenCA::DBI should now complete OpenCA::DBI->Entering set_error ... OpenCA::DBI->errno: gettext is defined OpenCA::DBI->errno: old errno 11111 is present OpenCA::DBI->errno: new errorcode is 11111 OpenCA::DBI->connect: connecting to database OpenCA::DBI->connect: try to connect DBI connect('database=openca;host=localhost;port=3306;mysql_ssl=0','openca',...) failed: Access denied for user 'openca'@'localhost' (using password: YES) at /usr/local/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 899 OpenCA::DBI->connect: connect failedIf I change the values in config.xml and regenerate the DBI.conf files, the values in the DBI connect() string do not change to match them. I have installed the new versions of User.pm and initServer mentioned here: http://wiki.openca.org/wiki/index.php/ERR_USER_UNKNOWN Can anyone shed any light on this problem? Many thanks, Ben ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users
-- http://member.acm.org/~openca/ Massimiliano Pala, Ph.D. Director, OpenCA Labs Professor, NYU Poly
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users
