Can't locate loadable object for module Mysql

[Charles Galpin <cg...@lighthouse-software.com>]

I'm getting this error from some code that is attempting to connect to
mysql via DBI. The same snippet of code works fine from the command. I did
not install any of the software, but given that this works form the
command line I tend to believe that mysql and the perl DBI module are
installed and working properly. this leaves the apache / mod_perl
configuration I guess?

I can give more specifics about the versions if need be, but it's a Red
Hat Linux 6.0 box with apache_1.3.11, mod_perl-1.19 and mysql-3.22.30

This is my first experience with mod_perl, so please be gentle :)
thanks
charles

The exact error
install_driver(mysql) failed: Can't locate
            loadable object for module Mysql in @INC
            (@INC contains: /usr/local/apache/lib
            /usr/local/lib/perl5/5.00503/i686-linux
            /usr/local/lib/perl5/5.00503
            /usr/local/lib/perl5/site_perl/5.005/i686-linux
            /usr/local/lib/perl5/site_perl/5.005 .
            /usr/local/apache/ /usr/local/apache/lib/perl)
            at (eval 27) line 3 Perhaps a module that
            DBD::mysql requires hasn't been fully
            installed at /usr/local/apache/lib/MP3/DB.pm
            line 29 


The command line stuff

#less test.pl
#!/usr/local/bin/perl -w

use strict;
use DBI;

my $dsn = 'DBI:mysql:MP3:host=myhost';
my $user = 'user';
my $password = 'pssst';
my $db  = DBI->connect($dsn, $user, $password, { RaiseError => 1 });

($db) ? print "db connection ok\n" : print "db connection bad\n";
$db->disconnect;

# ./test.pl
db connection ok

# perl -e 'print "@INC"'
/usr/local/lib/perl5/5.00503/i686-linux 
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/i686-linux
/usr/local/lib/perl5/site_perl/5.005 
.

Re: Can't locate loadable object for module Mysql

[Stas Bekman <sb...@iname.com>]

> I'm getting this error from some code that is attempting to connect to
> mysql via DBI. The same snippet of code works fine from the command. I did
> not install any of the software, but given that this works form the
> command line I tend to believe that mysql and the perl DBI module are
> installed and working properly. this leaves the apache / mod_perl
> configuration I guess?
> 
> I can give more specifics about the versions if need be, but it's a Red
> Hat Linux 6.0 box with apache_1.3.11, mod_perl-1.19 and mysql-3.22.30
> 
> This is my first experience with mod_perl, so please be gentle :)
> thanks
> charles
> 
> The exact error
> install_driver(mysql) failed: Can't locate
>             loadable object for module Mysql in @INC

http://perl.apache.org/guide/troubleshooting.html#Can_t_locate_loadable_object_for

>             (@INC contains: /usr/local/apache/lib
>             /usr/local/lib/perl5/5.00503/i686-linux
>             /usr/local/lib/perl5/5.00503
>             /usr/local/lib/perl5/site_perl/5.005/i686-linux
>             /usr/local/lib/perl5/site_perl/5.005 .
>             /usr/local/apache/ /usr/local/apache/lib/perl)
>             at (eval 27) line 3 Perhaps a module that
>             DBD::mysql requires hasn't been fully
>             installed at /usr/local/apache/lib/MP3/DB.pm
>             line 29 
> 
> 
> The command line stuff
> 
> #less test.pl
> #!/usr/local/bin/perl -w
> 
> use strict;
> use DBI;
> 
> my $dsn = 'DBI:mysql:MP3:host=myhost';
> my $user = 'user';
> my $password = 'pssst';
> my $db  = DBI->connect($dsn, $user, $password, { RaiseError => 1 });
> 
> ($db) ? print "db connection ok\n" : print "db connection bad\n";
> $db->disconnect;
> 
> # ./test.pl
> db connection ok
> 
> # perl -e 'print "@INC"'
> /usr/local/lib/perl5/5.00503/i686-linux 
> /usr/local/lib/perl5/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i686-linux
> /usr/local/lib/perl5/site_perl/5.005 
> .
> 
> 
> 



_______________________________________________________________________
Stas Bekman    mailto:sbekman@iname.com      http://www.stason.org/stas
Perl,CGI,Apache,Linux,Web,Java,PC     http://www.stason.org/stas/TULARC
perl.apache.org    modperl.sourcegarden.org   perlmonth.com    perl.org
single o-> + single o-+ = singlesheaven    http://www.singlesheaven.com