I'm using the PurePerl driver, mysqlPP, but I can't connect.
I've been using this locally on my MySQL server box and this is my first attempt to
connect remotely.
I did add a user/host to the mysql.user table for the remote host I was connecting
from.
I also tried to turn on tracing, but the log is not being written out. ?????
Any ideas?
Thanks,
Greg
connecting
BEI::PFSdb::ctor self = BEI::PFSdb
BEI::PFSdb::ctor connecting to = DBI:mysqlPP:database=rt3;host=forthsol as user1
Uncaught exception from user code:
DBI connect('database=rt3;host=forthsol','user1',...) failed: (no error
string) at BEI/PFSdb.pm line 39
DBI::__ANON__('undef','undef') called at
/export/home/local/lib/perl5/site_perl/5.8.0/sun4-solaris-64int/DBI.pm line 643
DBI::connect('DBI','DBI:mysqlPP:database=rt3;host=forthsol','user1','password','HASH(0x117bec)')
called at BEI/PFSdb.pm line 39
BEI::PFSdb::new('BEI::PFSdb','DBI:mysqlPP:database=rt3;host=forthsol','user1','password')
called at pfsreport.pl line 42
main::main() called at pfsreport.pl line 53
(in cleanup) Can't call method "close" on an undefined value at
/export/home/glhering/lib/perl5/site_perl/5.8.0/DBD/mysqlPP.pm line 314.
$
(I changed the user/pass for this example)
Gregory L. Hering
4807 Bradford Drive
Huntsville, AL 35805
(256) 722-6420
> -----Original Message-----
> From: Stephan Harren [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 25, 2003 11:19 AM
> To: Hardy Merrill; Hering, Greg
> Cc: [EMAIL PROTECTED]
> Subject: Re: local DB only?
>
>
> > I always install all the mysql packages including the
> > mysql client package - can someone else confirm that
> > to install DBD::mysql you only need the mysql client?
>
> Should work, but a good alternative is to use DBD::mysqlPP,
> which is a pure
> Perl interface that doesn't need any MySQL libraries.
>
> Best regards,
>
> Stephan
> --
> Stephan Harren
> Manager Site Operations
> MFN-IS
> -------------------------------
> Phone +49 69 90554 153
> Fax +49 69 90554 111
> Cell +49 173 7011126
>
>