Problems with Net::MySQL on OS X Server

I'm trying to port a web-based application from a Solaris 2.6 box to
Mac OS X Server 10.4.8.

The Solaris box was running perl 5.6.1 and MySQL 4.0.18, the OS X box
is running perl 5.6.2 and MySQL 4.0.18. Both are running Net::MySQL
0.009. The trouble is, the Solaris box will connect successfully to the
MySQL DB but the OS X box will not.

This is the code:

#!/usr/bin/perl -w
use Net::MySQL;

my $mysql = Net::MySQL->new(
database => 'mysql',
user => 'root',
password => '*'
);

# SLECT example
$mysql->query(q{SELECT * FROM user});
my $record_set = $mysql->create_record_iterator;
while (my $record = $record_set->each) {
printf "First column: %s Next column: %s\n",
$record->[0], $record->[1];
}
$mysql->close;

And this is the error it yields:

[root@csc-web2 admin]# perl test.pl
Access denied for user: '@localhost' to database '!' at test.pl line 5

I am pretty new to perl, so I'm not quite sure how to debug this. The
username and password are definitely correct, but the most troubling
thing is that the error message says that the perl file is trying to
connect to the database named '!', not the database named 'mysql'.
Anyone have any ideas on how I can debug this?

Thanks,


Chris

Re: Problems with Net::MySQL on OS X Server

chriswaltham@gmail.com wrote:

> I'm trying to port a web-based application from a Solaris 2.6 box to
> Mac OS X Server 10.4.8.
>
> The Solaris box was running perl 5.6.1 and MySQL 4.0.18, the OS X box
> is running perl 5.6.2 and MySQL 4.0.18. Both are running Net::MySQL
> 0.009. The trouble is, the Solaris box will connect successfully to the
> MySQL DB but the OS X box will not.
>

Huh? Mac OS 10.4 comes with Perl 5.8.6. Somebody downgraded it?

Tom Wyant

Re: Problems with Net::MySQL on OS X Server

harryfmudd [AT] comcast [DOT] net wrote:
> chriswaltham@gmail.com wrote:
>
> > I'm trying to port a web-based application from a Solaris 2.6 box to
> > Mac OS X Server 10.4.8.
> >
> > The Solaris box was running perl 5.6.1 and MySQL 4.0.18, the OS X box
> > is running perl 5.6.2 and MySQL 4.0.18. Both are running Net::MySQL
> > 0.009. The trouble is, the Solaris box will connect successfully to the
> > MySQL DB but the OS X box will not.
> >
>
> Huh? Mac OS 10.4 comes with Perl 5.8.6. Somebody downgraded it?
>
> Tom Wyant

I downgraded it... well, actually, I just compiled it and installed it
in /usr/local/perl/. Because I'm not the author of the original web
app, I want to try and replicate its environment as much as possible
when I'm porting it.

After I actually get it working, I'll try using perl-5.8.6 against it.
In the meantime, though, I am getting nowhere :-\ FWIW, I've installed
Net::MySQL under 5.8.6 and still haven't had any success.


Chris