Hello,
I'm having trouble installing the msql-mysql perl drivers. I'm running
Red Hat Linux 6.1. I compiled the mysql-3.22.27 sources (to get the .h
files) and got as far as running make install. It put mysqld in
/usr/local/libexec/ instead of /usr/sbin, but all the client code
appears to have been copied to /usr/local/bin.
The problem I have with the perl modules is this:
[root@nefertiti Msql-Mysql-modules-1.2210]# perl Makefile.PL
Which drivers do you want to install?
1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2
Enter the appropriate number: [3] 1
Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [y]
Using DBI 1.13 installed in
/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules
[root@nefertiti Msql-Mysql-modules-1.2210]# make
make[1]: Entering directory
`/root/.cpan/build/Msql-Mysql-modules-1.2210/mysql'
cc -c -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI
-I/usr/src/redhat/SOURCES/mysql-
3.22.27/include -I../dbd
-I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI -I/usr/lib/pe
rl5/5.00503/i386-linux -Dbool=char -DHAS_BOOL -I/usr/local/include
-O2 -DVERSION=\"2.041
0\" -DXS_VERSION=\"2.0410\" -fpic
-I/usr/lib/perl5/5.00503/i386-linux/CORE -DDBD_MYSQL dbdi
mp.c
cc -c -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI
-I/usr/src/redhat/SOURCES/mysql-
3.22.27/include -I../dbd
-I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI -I/usr/lib/pe
rl5/5.00503/i386-linux -Dbool=char -DHAS_BOOL -I/usr/local/include
-O2 -DVERSION=\"2.041
0\" -DXS_VERSION=\"2.0410\" -fpic
-I/usr/lib/perl5/5.00503/i386-linux/CORE -DDBD_MYSQL mysq
l.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="/usr/src/redhat/SOURCES/mysql-3.22.27/lib:/lib:/usr/lib/gcc-lib/i386-redhat-li
nux/egcs-2.91.66" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared
-L/usr/local/lib dbdi
mp.o mysql.o -L/usr/src/redhat/SOURCES/mysql-3.22.27/lib
-L/usr/src/redhat/SOURCES/mysql
-3.22.27/lib -lmysqlclient -lm
-L/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66 -lgcc
chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs
Manifying ../blib/man3/DBD::mysql.3
Manifying ../blib/man3/Bundle::DBD::mysql.3
Manifying ../blib/man3/Mysql.3
make[1]: Leaving directory
`/root/.cpan/build/Msql-Mysql-modules-1.2210/mysql'
cp dbimon blib/script/dbimon
/usr/bin/perl -I/usr/lib/perl5/5.00503/i386-linux
-I/usr/lib/perl5/5.00503 -MExtUtils::Make
Maker -e "MY->fixin(shift)" blib/script/dbimon
Manifying blib/man1/dbimon.1
[root@nefertiti Msql-Mysql-modules-1.2210]# make test
make[1]: Entering directory
`/root/.cpan/build/Msql-Mysql-modules-1.2210/mysql'
make[1]: Leaving directory
`/root/.cpan/build/Msql-Mysql-modules-1.2210/mysql'
make[1]: Entering directory
`/root/.cpan/build/Msql-Mysql-modules-1.2210/mysql'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib
-I/usr/lib/perl5/5.00503/i386-
linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; ru
ntests @ARGV;' t/*.t
t/00base............install_driver(mysql) failed: Can't load
'../blib/arch/auto/DBD/mysql/m
ysql.so' for module DBD::mysql: libmysqlclient.so.6: cannot open shared
object file: No suc
h file or directory at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm
line 169.
at (eval 1) line 3
at t/00base.t line 38
dubious
Test returned status 255 (wstat 65280, 0xff00)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Test/Harnes
s.pm line 288.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory
`/root/.cpan/build/Msql-Mysql-modules-1.2210/mysql'
make: *** [test] Error 2
I read in the README that this means my linker doesn't include libgcc.a.
For the libgcc.a version I get the answer:
gcc --print-libgcc-file
/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/libgcc.a
Which is already being included in my LD_RUN_PATH above.
Help!! I need more detailed instructions for how to get the perl modules
to install. If I try to use perl -MCPAN -e shell, I just get the same
error.
Thanks,
Leila Schneberger