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
> >
> >
> >
> >
