Re: problem to install module DBD-mysql-3.0008

cédric,

It looks to me that your library path (to mysql's client library) is not 
correctly set. Are your mysql libaries installed per the location listed 
in the mysql_config line states?

Kind regards,

Patrick


cédric wrote:

>Hi ,
>
>I have problem to install DBD-mysql-3.0008 on my server :
>
>server : Sun Ultra60
>OS: solaris 8
>gcc : 3.3.2
>BDB :3.0008
>mysql : 5.0.24
>apache :2.0.55
>
># perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config
>I will use the following settings for compiling and testing:
>
>  cflags        (mysql_config) = -I/usr/local/mysql/include/mysql
>  embedded      (mysql_config) =
>  libs          (mysql_config) = -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/BerkeleyDB.4.2/lib
>-R/usr/local/BerkeleyDB.4.2/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lz
>-lposix4 -lgen -lsocket -lnsl -lm
>  mysql_config  (Users choice) = /usr/local/mysql/bin/mysql_config
>  nocatchstderr (default     ) = 0
>  nofoundrows   (default     ) = 0
>  ssl           (guessed     ) = 1
>  testdb        (default     ) = test
>  testhost      (default     ) =
>  testpassword  (default     ) =
>  testsocket    (default     ) =
>  testuser      (default     ) =
>
>To change these settings, see 'perl Makefile.PL --help' and
>'perldoc INSTALL'.
>
>Using DBI 1.53 (for perl 5.008005 on sun4-solaris) installed in
>/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBI/
>Writing Makefile for DBD::mysql
>
>
> make
>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
>-DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-strict-aliasing -pipe
>-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   
>-DVERSION=\"3.0008\"  -DXS_VERSION=\"3.0008\" -fPIC
>"-I/usr/local/lib/perl5/5.8.5/sun4-solaris/CORE"   dbdimp.c
>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
>-DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -fno-strict-aliasing -pipe
>-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   
>-DVERSION=\"3.0008\"  -DXS_VERSION=\"3.0008\" -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/mysql/lib/mysql:/usr/lib" /usr/local/bin/perl myld gcc
>-B/usr/ccs/bin/  -G -L/usr/local/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/BerkeleyDB.4.2/lib
>-R/usr/local/BerkeleyDB.4.2/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lz
>-lposix4 -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 test
>Compilation failed in require at (eval 3) line 3.
>Perhaps a required shared library or dll isn't installed where expected
> at t/texecute.t line 17
>t/texecute...........dubious
>        Test returned status 255 (wstat 65280, 0xff00)
>DIED. FAILED tests 1-9
>        Failed 9/9 tests, 0.00% okay
>Failed Test         Stat Wstat Total Fail  Failed  List of Failed
>-------------------------------------------------------------------------------
>t/00base.t           255 65280     5    4  80.00%  4-5
>t/10dsnlist.t        255 65280     9   18 200.00%  1-9
>t/20createdrop.t     255 65280     5   10 200.00%  1-5
>t/30insertfetch.t    255 65280    11   22 200.00%  1-11
>t/35limit.t          255 65280   113  226 200.00%  1-113
>t/35prepare.t        255 65280    30   60 200.00%  1-30
>t/40bindparam.t      255 65280    28   56 200.00%  1-28
>t/40bindparam2.t     255 65280    13   26 200.00%  1-13
>t/40blobs.t          255 65280    11   22 200.00%  1-11
>t/40listfields.t     255 65280    18   36 200.00%  1-18
>t/40nulls.t          255 65280    11   22 200.00%  1-11
>t/40numrows.t        255 65280    25   50 200.00%  1-25
>t/41bindparam.t      255 65280    11   22 200.00%  1-11
>t/41blobs_prepare.t  255 65280    24   48 200.00%  1-24
>t/42bindparam.t      255 65280    11   22 200.00%  1-11
>t/50chopblanks.t     255 65280    35   70 200.00%  1-35
>t/50commit.t         255 65280    30   60 200.00%  1-30
>t/dbdadmin.t         255 65280    21   42 200.00%  1-21
>t/insertid.t         255 65280    12   24 200.00%  1-12
>t/param_values.t     255 65280     8   16 200.00%  1-8
>t/prepare_noerror.t  255 65280    ??   ??       %  ??
>t/texecute.t         255 65280     9   18 200.00%  1-9
>1 test skipped.
>Failed 22/23 test scripts, 4.35% okay. 437/440 subtests failed, 0.68% okay.
>*** Error code 2
>make: Fatal error: Command failed for target `test_dynamic'
>
>Can you have an idea ?
>
>Thanks for your Help
>
>
>  
>


-- 
Patrick Galbraith, Senior Systems Engineer 
MySQL AB, www.mysql.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]