Thanks anyhow. I believe it is because the fact that the perl on my solaris was compiled by SUNPro cc and the mysql binary was compiled by gcc. There might not be a feasible work-around so far. I have spent half day research the way to solve it. P.S. I am not the sys admin, so I cannot do anything. such as compiled the perl again with gcc. And also I failed to compiled mysql with SUNPro cc. Really sad. Calvin
>>> Tim Bunce <[EMAIL PROTECTED]> 06/25/04 05:00am >>> Seems like there's a deeper problem. [EMAIL PROTECTED] is the place to discuss it (or there's mysql specific mailing list, see the docs). Tim. On Fri, Jun 25, 2004 at 12:25:38AM +0800, calvin huang [SAO] wrote: > Sad, I got the following error when I used the DBD::mysql. > > ld.so.1: /usr/bin/perl: fatal: relocation error: file > /a04_01/intranet/dept/saoit/perl_module/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.so: > symbol mysql_init: referenced symbol not found > Killed > > > >>> calvin huang [SAO]<[EMAIL PROTECTED]> 06/24/04 11:55pm >>> > > Thanks Tim, > > It seems working now though the make test still fails and have fatal error! > Wonder if it will work or not. Going to test soon! Thx anyhow > > Calvin > ------ --------------- > $ perl -MDBI -e 'DBI->installed_versions' > Perl : 5.008 (sun4-solaris) > OS : solaris (2.8) > DBI : 1.42 > DBD::mysql : 2.9003 > DBD::Sponge : 11.10 > DBD::SQLite : 0.31 > DBD::Proxy : install_driver(Proxy) failed: Can't locate RPC/PlClient..pm in > @INC > DBD::File : 0.30 > DBD::ExampleP : 11.12 > DBD::DBM : 0.01 > > ---Fatal error------ > t/insertid.........install_driver(mysql) failed: Can't load > '/a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/mysql/mysql..so' > for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: relocation error: file > /a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/mysql/mysql.so: > symbol mysql_real_escape_string: referenced symbol not found at > /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229. > 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 > '/a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/mysql/mysql.so' > for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: relocation error: file > /a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/arch/auto/DBD/mysql/mysql.so: > symbol mysql_real_escape_string: referenced symbol not found at > /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229. > at /a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/lib/Mysql..pm line > 13 > Compilation failed in require at > /a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/lib/Mysql.pm line 13. > Compilation failed in require at t/mysql.t line 34. > BEGIN failed--compilation aborted at t/mysql.t line 34. > t/mysql............dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 1-68 > Failed 68/68 tests, 0.00% okay > t/mysql2...........Had to create DBD::mysql::dr::imp_data_size unexpectedly at > /a04_01/intranet/dept/saoit/perl_module/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm > line 1061. > Use of uninitialized value in subroutine entry at > /a04_01/intranet/dept/saoit/perl_module/lib/perl5/site_perl/5.8.0/sun4-solaris/DBI.pm > line 1061. > Can't locate object method "connect" via package "Mysql" at > /a04_01/intranet/dept/saoit/.cpan/build/DBD-mysql-2.9003/blib/lib/Mysql.pm line 71. > t/mysql2...........dubious > Test returned status 255 (wstat 65280, 0xff00) > Failed Test Stat Wstat Total Fail Failed List of Failed > ------------------------------------------------------------------------------- > t/00base.t 255 65280 5 2 40.00% 4-5 > t/10dsnlist.t 255 65280 3 3 100.00% 1-3 > t/20createdrop.t 255 65280 5 5 100.00% 1-5 > t/30insertfetch.t 255 65280 11 11 100.00% 1-11 > t/40bindparam.t 255 65280 28 28 100.00% 1-28 > t/40blobs.t 255 65280 11 11 100.00% 1-11 > t/40listfields.t 255 65280 18 18 100.00% 1-18 > t/40nulls.t 255 65280 11 11 100.00% 1-11 > t/40numrows.t 255 65280 25 25 100.00% 1-25 > t/50chopblanks.t 255 65280 35 35 100.00% 1-35 > t/50commit.t 255 65280 30 30 100.00% 1-30 > t/ak-dbd.t 255 65280 90 90 100.00% 1-90 > t/akmisc.t 255 65280 351 351 100.00% 1-351 > t/dbdadmin.t 255 65280 21 21 100.00% 1-21 > t/insertid.t 255 65280 12 12 100.00% 1-12 > t/mysql.t 255 65280 68 68 100.00% 1-68 > t/mysql2.t 255 65280 ?? ?? % ?? > 1 test skipped. > Failed 17/18 test scripts, 5.56% okay. 721/724 subtests failed, 0.41% okay. > *** Error code 2 > make: Fatal error: Command failed for target `test_dynamic' > > > >>> Tim Bunce<[EMAIL PROTECTED]> 06/24/04 10:44pm >>> > Neither do I. Just do what I'd do... search the fields for references > to net_buffer_length and edit them to remove the reference... > > $ grep -r net_buffer_length . > ../mysql.xs: retsv = newSViv(net_buffer_length); > > Just changing net_buffer_length to 0 should be enough. > > Tim. > > On Thu, Jun 24, 2004 at 09:44:14PM +0800, calvin huang [SAO] wrote: > > Tim, > > > > Thanks so much for your prompt reply! but I dont know what is the relevant code to > > delete and which file need to be modified. Can you be more specific. Thanks so much > > > > Calvin > > > > >>> Tim Bunce<[EMAIL PROTECTED]> 06/24/04 06:34PM >>> > > I think there's a bug in the latest mysql client libs that made > > net_buffer_length disappear. Quickest fix would be to delete the > > relevant code from DBD::mysql (unless you really need it). > > > > Tim. > > > > On Thu, Jun 24, 2004 at 06:28:58AM -0000, PerlDiscuss - Perl Newsgroups and > > mailing lists wrote: > > > I have the same problem too. > > > > > > I use the binary tar file downloaded from mysql.com and place it in my > > > home direcotry of my account in Solaris 2.8.2 machince. > > > > > > mysql client is working and I try to compile DBD::mysql just like you. > > > make test return error message as yours. > > > > > > when I check the installed driver , it shows the following things! Hope > > > someone with experience can help: > > > > > > $ perl -MDBI -e 'DBI->installed_versions'; > > > Perl : 5.008 (sun4-solaris) > > > OS : solaris (2.8) > > > DBI : 1.42 > > > DBD::mysql : install_driver(mysql) failed: Can't load > > > '/a04_01/intranet/dept/saoit/perl_m > > > odule/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.so' for > > > module DBD::mysql: ld. > > > so.1: perl: fatal: relocation error: file > > > /a04_01/intranet/dept/saoit/perl_module/lib/perl5/site > > > _perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.so: symbol > > > net_buffer_length: referenced symbol no > > > t found at /usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229. > > > at (eval 12) line 3 > > > Compilation failed in require at (eval 12) line 3. > > > Perhaps a required shared library or dll isn't installed where expected > > > at -e line 1 > > > > > > DBD::Sponge : 11.10 > > > DBD::SQLite : 0.31 > > > DBD::Proxy : install_driver(Proxy) failed: Can't locate > > > RPC/PlClient.pm in @INC > > > DBD::File : 0.30 > > > DBD::ExampleP : 11.12 > > > DBD::DBM : 0.01 > > > > > > > > > > > > > >
