MySQL Forums
Forum List  »  Perl

Re: MySQL, Solaris 9 and DBD::mysql
Posted by: Yair Lapin
Date: January 18, 2005 04:57AM

Hi,

I'm again , I find something interesting may give a clue what is happening with DBD::mysql module installation in solaris 9.
I saw in my mysql librery /usr/local/mysql/lib/mysql 2 dynamics version, 10 and 12:

-rw-r--r-- 1 root bin 15448 Oct 31 10:08 libdbug.a
-rw-r--r-- 1 root bin 33496 Oct 31 10:09 libheap.a
-rw-r--r-- 1 root bin 13204 Oct 31 10:08 libmerge.a
-rw-r--r-- 1 root bin 286760 Oct 31 10:09 libmyisam.a
-rw-r--r-- 1 root bin 23184 Oct 31 10:09 libmyisammrg.a
-rw-r--r-- 1 root bin 328620 Oct 31 10:07 libmysqlclient.a
-rwxr-xr-x 1 root bin 1011 Oct 31 10:07 libmysqlclient.la
lrwxrwxrwx 1 root other 24 Jan 18 11:40 libmysqlclient.so -> libmysqlclient.so.12.0.0
lrwxrwxrwx 1 root other 24 Dec 29 15:27 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x 1 root bin 152664 Oct 31 2002 libmysqlclient.so.10.0.0
lrwxrwxrwx 1 root other 24 Dec 29 15:27 libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
-rwxr-xr-x 1 root bin 163820 Apr 9 2004 libmysqlclient.so.12.0.0
-rw-r--r-- 1 root bin 337396 Oct 31 10:07 libmysqlclient_r.a
-rwxr-xr-x 1 root bin 1055 Oct 31 10:07 libmysqlclient_r.la
-rw-r--r-- 1 root bin 121848 Oct 31 10:07 libmystrings.a
-rw-r--r-- 1 root bin 250028 Oct 31 10:08 libmysys.a
-rw-r--r-- 1 root bin 108332 Oct 31 10:08 libnisam.a
-rw-r--r-- 1 root bin 5288 Oct 31 10:09 libvio.a

the newest verion was linked to libmysqlclient.so , i changes it to old one version 10.
the compilation worked with almost same problems than before but the test fail due to a different variable mysql_ssl_set may be connected to the new features in 4.1 mysql versions. I understand they support ssl connection by default.

compilation
-------------------------------------------------
make: Warning: File `Makefile' has modification time 51 s in the future
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -B/usr/ccs/bin/ -c -I/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ -I/usr/local/mysql/include/mysql -DDBD_MYSQL_WITH_SSL -fno-strict-aliasing -pipe -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE" dbdimp.c
/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI//Driver.xst > mysql.xsi
/bin/perl /usr/local/lib/perl5/5.8.5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.5/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 196
Warning: duplicate function definition 'rows' detected in mysql.xs, line 294
gcc -B/usr/ccs/bin/ -c -I/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/ -I/usr/local/mysql/include/mysql -DDBD_MYSQL_WITH_SSL -fno-strict-aliasing -pipe -I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O -DVERSION=\"2.9004\" -DXS_VERSION=\"2.9004\" -fPIC "-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/local/lib:/usr/lib" /bin/perl myld gcc -B/usr/ccs/bin/ -G -L/usr/local/lib -L/opt/gnu/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/lib -R/usr/local/lib -R/usr/lib -L/usr/lib -R/usr/openwin/lib -L/usr/openwin/lib -L/usr/local/ssl/lib -R/usr/local/ssl/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
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/DBD::mysql::INSTALL.3
Manifying blib/man3/Mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
make: warning: Clock skew detected. Your build may be incomplete.

--------------------------------------------------------------------
TEST


t/dbdadmin.........install_driver(mysql) failed: Can't load '/fs/www/w2w7/share/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file /fs/www/w2w7/share/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_ssl_set: referenced symbol not found at /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/dbdadmin.t line 74
t/dbdadmin.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-21
Failed 21/21 tests, 0.00% okay
t/insertid.........install_driver(mysql) failed: Can't load '/fs/www/w2w7/share/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file /fs/www/w2w7/share/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_ssl_set: referenced symbol not found at /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/insertid.t line 13
t/insertid.........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/mysql............Can't load '/fs/www/w2w7/share/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file /fs/www/w2w7/share/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_ssl_set: referenced symbol not found at /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230.
at /fs/www/w2w7/share/DBD-mysql-2.9004/blib/lib/Mysql.pm line 13


I hope it says something for someone.

thanks!

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL, Solaris 9 and DBD::mysql
January 18, 2005 04:57AM
June 05, 2006 10:49AM
June 05, 2006 01:10PM
March 07, 2005 12:57PM
March 07, 2005 12:58PM
February 14, 2006 10:32AM
October 24, 2007 08:59AM
November 17, 2007 07:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.