Re: MySQL, Solaris 9 and DBD::mysql

[Yair Lapin]

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!