DBD::mysql Installation Problem!

am 02.06.2004 20:37:10 von Zaihua Ji

Hi,

Versions:
gcc => 3.3.2
perl => 5.6.1
mysql => 4.1.1
DBD:mysql => 2.9003

I have installed mysql from source with the same compiler. the make
looked fine and make test failed. What dynamic lib I missed?

Thanks,

zj

eldora:DBD-mysql-2.9003% perl Makefile.PL
I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/opt/sfw/mysql/include/mysql
libs (mysql_config) =
-L/fs/tools/sparc.solaris-7/gcc-3.3.2/lib/gcc-lib/sparc-sun- solaris2.9/3.3.2
-lgcc -L/opt/sfw/mysql/lib/mysql -lmysqlclient -lz -lposix4 -lcrypt
-lgen -lsocket -lnsl -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.42 (for perl 5.006001 on sun4-solaris-64int) installed in
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI
Writing Makefile for DBD::mysql

eldora:DBD-mysql-2.9003% make
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cc -c -I/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI
-I/opt/sfw/mysql/include/mysql -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -xO3 -xdepend -DVERSION=\"2.9003\"
-DXS_VERSION=\"2.9003\" -KPIC
-I/usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE dbdimp.c
/bin/sh -c true
/bin/sh -c true
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI/Drive r.xst >
mysql.xsi
/usr/bin/perl -I/usr/perl5/5.6.1/lib/sun4-solaris-64int
-I/usr/perl5/5.6.1/lib /usr/perl5/5.6.1/lib/ExtUtils/xsubpp -typemap
/usr/perl5/5.6.1/lib/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 192
Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
cc -c -I/usr/perl5/site_perl/5.6.1/sun4-solaris-64int/auto/DBI
-I/opt/sfw/mysql/include/mysql -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -xO3 -xdepend -DVERSION=\"2.9003\"
-DXS_VERSION=\"2.9003\" -KPIC
-I/usr/perl5/5.6.1/lib/sun4-solaris-64int/CORE mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/fs/tools/sparc.solaris-7/gcc-3.3.2/lib/gcc-lib /sparc-sun-solaris2.9/3.3.2:/opt/sfw/mysql/lib/mysql:/lib"
/usr/bin/perl myld cc -G dbdimp.o mysql.o -o
blib/arch/auto/DBD/mysql/mysql.so
-L/fs/tools/sparc.solaris-7/gcc-3.3.2/lib/gcc-lib/sparc-sun- solaris2.9/3.3.2
-lgcc -L/opt/sfw/mysql/lib/mysql -lmysqlclient -lz -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::INSTALL.3
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/Bundle::DBD::mysql.3
Manifying blib/man3/Mysql.3

eldora:DBD-mysql-2.9003% make test
/bin/sh -c true
/bin/sh -c true
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/perl5/5.6.1/lib/sun4-solaris-64int -I/usr/perl5/5.6.1/lib -e 'use
Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base...........install_driver(mysql) failed: Can't load
'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1:
/usr/bin/perl: fatal: relocation error: file
/opt/sfw/mysql/lib/mysql/libmysqlclient.so.14: symbol __floatdisf:
referenced symbol not found at
/usr/perl5/5.6.1/lib/sun4-solaris-64int/DynaLoader.pm line 206.
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
t/00base...........dubious

Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql Installation Problem!

am 03.06.2004 08:35:51 von Jochen Wiedmann

On Mi, 2004-06-02 at 20:37, Zaihua Ji wrote:

> 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1:
> /usr/bin/perl: fatal: relocation error: file
> /opt/sfw/mysql/lib/mysql/libmysqlclient.so.14: symbol __floatdisf:
> referenced symbol not found at

This looks *very much* like a problem with mixed binaries. It is
definitely recommended to compile everything (MySQL, or at least the
MySQL client libraries, Perl, DBI, DBD::mysql) with the same compiler.

Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql Installation Problem!

am 03.06.2004 08:35:51 von Jochen Wiedmann

Re: DBD::mysql Installation Problem!

am 03.06.2004 22:24:00 von Zaihua Ji

--------------080301010309050701070407
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

I realized that I had mixed binaries after I sent out my email for help.
I have successfully recompiled both mysql and DBD::mysql. It works
perfect now.

Thanks,

zj

Jochen Wiedmann wrote:

>On Mi, 2004-06-02 at 20:37, Zaihua Ji wrote:
>
>
>
>>'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1:
>>/usr/bin/perl: fatal: relocation error: file
>>/opt/sfw/mysql/lib/mysql/libmysqlclient.so.14: symbol __floatdisf:
>>referenced symbol not found at
>>
>>
>
>This looks *very much* like a problem with mixed binaries. It is
>definitely recommended to compile everything (MySQL, or at least the
>MySQL client libraries, Perl, DBI, DBD::mysql) with the same compiler.
>
>
>Jochen
>
>
>
>

--------------080301010309050701070407--

Re: DBD::mysql Installation Problem!

am 03.06.2004 22:24:00 von Zaihua Ji