Ok, I ran GRANT and I got the error
"Can't disable AUTOCOMMIT"
When I turn off autocommit then I can connect.
I did a perldoc on mysqlPP but didn't see anything about autocommit.
Greg
Gregory L. Hering
4807 Bradford Drive
Huntsville, AL 35805
(256) 722-6420
> -----Original Message-----
> From: Hering, Greg
> Sent: Friday, September 26, 2003 2:58 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: local DB only?
>
>
> 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-64in
> t/DBI.pm line 643
>
> DBI::connect('DBI','DBI:mysqlPP:database=rt3;host=forthsol','u
> ser1','password','HASH(0x117bec)') called at BEI/PFSdb.pm line 39
>
> BEI::PFSdb::new('BEI::PFSdb','DBI:mysqlPP:database=rt3;host=fo
> rthsol','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
> >
> >
>
