I am attempting to install a shareware library administration system
called koha which is written in perl. I have used cpan to install a
large number of perl modules, including DBI.
But when I try to connect to DBI I always get the message in the above
subject line.
I wrote a very simple perl script as a test, and always get the same
message:
--------------------------------------------------------------------------------
use DBI;
my $dsn="DBI:mysql:koha:localhost:3306";
my $user="kohaadmin";
my $pass="<whatever>";
$dbh = DBI->connect($dsn, $user, $pass) || die "Couldn't connect to database
! $DBI::errstr\n";
-----------------------------------------------------------------------------
I have tried all the obvious things:
1. Assured that DBI in installed, with all prerequisites (based on the
following site:
http://deps.cpantesters.org/?module=DBI;perl=latest)
2. Assured that my perl @INC include all the DBI stuff
3. Assured that I could connect to mysql from a command prompt, using
the same
username and password. After connecting, I am able to do all the
standard
database command (create table, drop table, insert, select) so I
know that the
account is valid and has the proper permissions.
Any other ideas?
Thanks,
Sanford Stein
CyberTools Inc.
--
Sanford Stein
Support Group at CyberTools for Libraries | 249 Ayer Road, Suite 302, Harvard
MA 01451 | 978.772.9200 x2 | Fax 888.899.0341
sanford.st...@cybertools.biz