Hi,
I have a problem with the MySQL backend from OpenCA::DBI.
I currently use OpenCA 0.9.2.2 and have no compile errors or anything. I
installed all missing modules using cpan.
I made a little perl-script that demonstrates the error:
----- cut here -----
#!/usr/bin/perl -w
use strict;
use CGI;
use DBI;
use OpenCA::DBI;
use gettext;
my $cgi_obj = new CGI;
# New database connection, works fine
my $dbh = DBI->connect( 'dbi:mysql:openca', 'openca', '<pass>') ||
die "Cannot connect to MySQL server: $DBI::errstr\n";
# New OpenCA::DBI connection fails
my $db = new OpenCA::DBI (
DEBUG => "10",
DB_Type => "mysql",
DB_Name => "openca",
DB_User => "openca",
DB_Host => "127.0.0.1",
DB_Passwd => "<pass>"
) || die "Cannot initialize OpenCA::DBI\n";
# terminate database connect
$dbh->disconnect;
----- cut here -----
The output of the script is:
Use of uninitialized value in concatenation (.) or string at
/usr/lib/perl5/site_perl/5.6.1/Parse/RecDescent.pm line 2738.
Subroutine errno redefined at
/usr/lib/perl5/site_perl/5.6.1/i386-linux/OpenCA/OpenSSL.pm line 270.
DEBUG: OpenCA::DBI->new: checking for backend
DEBUG: OpenCA::DBI->Entering set_error ...
DEBUG: OpenCA::DBI->set_error: gettext is not defined
DEBUG: OpenCA::DBI->set_error: errno and errval set
Cannot initialize OpenCA::DBI
DEBUG: OpenCA::DBI->DESTROY: automatic commit by destructor DESTROY
DEBUG: OpenCA::DBI->commit: entering function
DEBUG: OpenCA::DBI->errno: returning local errorcode 10017
DEBUG: OpenCA::DBI->DESTROY: call finish on all statement handles to
avoid warnings by DBI
So, the connection via DBI native just works fine but with OpenCA::DBI
it fails.
I also tried to change DB_Host to "localhost" in the constructor of
OpenCA::DBI, but that didn't work either. Can anybody help me?
Thanks,
Georg
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
