Mike,
Type in 'ldconfig -r' on the command line, look for :
221:-lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10
If you don't try,
'ldconfig -m /usr/local/lib/mysql/libmysqlclient.so.10'
and try to compile DBD::mysql again.
On 05-Oct-01 ARCS \(Mike\) wrote:
> Hi,
>
> I am trying to install DBD::mysql on a FreeBSD system and cannot get it to
> install for the life of me. I've installed it with no problems on a ton of
> Linux systems with no problems. Any help would be greatly appreciated!
> Here's the output of all the commands I ran to install it:
>
> mysql3# gunzip Msql-Mysql-modules-1.2215.tar.gz
> mysql3# tar -xvf Msql-Mysql-modules-1.2215.tar
> Msql-Mysql-modules-1.2215/
> Msql-Mysql-modules-1.2215/dbd/
> Msql-Mysql-modules-1.2215/dbd/constants.h
> Msql-Mysql-modules-1.2215/dbd/dbd.xs.in
> Msql-Mysql-modules-1.2215/dbd/dbimon.in
> Msql-Mysql-modules-1.2215/dbd/Acknowledgements
> Msql-Mysql-modules-1.2215/dbd/myMsql.h
> Msql-Mysql-modules-1.2215/dbd/Changes
> Msql-Mysql-modules-1.2215/dbd/bindparam.h
> Msql-Mysql-modules-1.2215/dbd/dbd.pm.in
> Msql-Mysql-modules-1.2215/dbd/Makefile.PL.in
> Msql-Mysql-modules-1.2215/dbd/dbdimp.c
> Msql-Mysql-modules-1.2215/dbd/dbdimp.h
> Msql-Mysql-modules-1.2215/dbd/bundle.pm.in
> Msql-Mysql-modules-1.2215/lib/
> Msql-Mysql-modules-1.2215/lib/ExtUtils/
> Msql-Mysql-modules-1.2215/lib/ExtUtils/PerlPP.pm
> Msql-Mysql-modules-1.2215/lib/DBD/
> Msql-Mysql-modules-1.2215/lib/DBD/mSQL/
> Msql-Mysql-modules-1.2215/lib/DBD/mSQL/Install.pm
> Msql-Mysql-modules-1.2215/lib/DBD/mSQL1/
> Msql-Mysql-modules-1.2215/lib/DBD/mSQL1/Install.pm
> Msql-Mysql-modules-1.2215/lib/DBD/mysql/
> Msql-Mysql-modules-1.2215/lib/DBD/mysql/Install.pm
> Msql-Mysql-modules-1.2215/tests/
> Msql-Mysql-modules-1.2215/tests/ak-dbd.t
> Msql-Mysql-modules-1.2215/tests/mSQL1.dbtest
> Msql-Mysql-modules-1.2215/tests/CSV.mtest
> Msql-Mysql-modules-1.2215/tests/CSV.dbtest
> Msql-Mysql-modules-1.2215/tests/20createdrop.t
> Msql-Mysql-modules-1.2215/tests/dbdadmin.t
> Msql-Mysql-modules-1.2215/tests/50commit.t
> Msql-Mysql-modules-1.2215/tests/msql2.t
> Msql-Mysql-modules-1.2215/tests/mysql.dbtest
> Msql-Mysql-modules-1.2215/tests/50chopblanks.t
> Msql-Mysql-modules-1.2215/tests/00base.t
> Msql-Mysql-modules-1.2215/tests/40nulls.t
> Msql-Mysql-modules-1.2215/tests/msql1.t
> Msql-Mysql-modules-1.2215/tests/pNET.dbtest
> Msql-Mysql-modules-1.2215/tests/mysql2.t
> Msql-Mysql-modules-1.2215/tests/40bindparam.t
> Msql-Mysql-modules-1.2215/tests/10dsnlist.t
> Msql-Mysql-modules-1.2215/tests/mSQL.mtest
> Msql-Mysql-modules-1.2215/tests/mysql.t
> Msql-Mysql-modules-1.2215/tests/README
> Msql-Mysql-modules-1.2215/tests/60leaks.t
> Msql-Mysql-modules-1.2215/tests/mSQL1.mtest
> Msql-Mysql-modules-1.2215/tests/30insertfetch.t
> Msql-Mysql-modules-1.2215/tests/Adabas.mtest
> Msql-Mysql-modules-1.2215/tests/40blobs.t
> Msql-Mysql-modules-1.2215/tests/40numrows.t
> Msql-Mysql-modules-1.2215/tests/lib.pl
> Msql-Mysql-modules-1.2215/tests/pNET.mtest
> Msql-Mysql-modules-1.2215/tests/40listfields.t
> Msql-Mysql-modules-1.2215/tests/skeleton.test
> Msql-Mysql-modules-1.2215/tests/mysql.mtest
> Msql-Mysql-modules-1.2215/tests/mSQL.dbtest
> Msql-Mysql-modules-1.2215/tests/Adabas.dbtest
> Msql-Mysql-modules-1.2215/tests/akmisc.t
> Msql-Mysql-modules-1.2215/mSQL/
> Msql-Mysql-modules-1.2215/mSQL/lib/
> Msql-Mysql-modules-1.2215/mSQL/lib/Bundle/
> Msql-Mysql-modules-1.2215/mSQL/lib/Bundle/DBD/
> Msql-Mysql-modules-1.2215/mSQL/lib/Bundle/DBD/mSQL.pm
> Msql-Mysql-modules-1.2215/mSQL/lib/DBD/
> Msql-Mysql-modules-1.2215/mSQL/lib/DBD/mSQL.pm
> Msql-Mysql-modules-1.2215/mSQL/lib/Msql.pm
> Msql-Mysql-modules-1.2215/mSQL/lib/Msql/
> Msql-Mysql-modules-1.2215/mSQL/lib/Msql/Statement.pm
> Msql-Mysql-modules-1.2215/nodbd/
> Msql-Mysql-modules-1.2215/nodbd/nodbd.pm.in
> Msql-Mysql-modules-1.2215/nodbd/pmsql.in
> Msql-Mysql-modules-1.2215/nodbd/statement.pm.in
> Msql-Mysql-modules-1.2215/nodbd/typemap
> Msql-Mysql-modules-1.2215/mysql/
> Msql-Mysql-modules-1.2215/mysql/lib/
> Msql-Mysql-modules-1.2215/mysql/lib/Mysql.pm
> Msql-Mysql-modules-1.2215/mysql/lib/Mysql/
> Msql-Mysql-modules-1.2215/mysql/lib/Mysql/Statement.pm
> Msql-Mysql-modules-1.2215/mysql/lib/DBD/
> Msql-Mysql-modules-1.2215/mysql/lib/DBD/mysql.pm
> Msql-Mysql-modules-1.2215/mysql/lib/Bundle/
> Msql-Mysql-modules-1.2215/mysql/lib/Bundle/DBD/
> Msql-Mysql-modules-1.2215/mysql/lib/Bundle/DBD/mysql.pm
> Msql-Mysql-modules-1.2215/Makefile.PL
> Msql-Mysql-modules-1.2215/MANIFEST
> Msql-Mysql-modules-1.2215/MANIFEST.SKIP
> Msql-Mysql-modules-1.2215/README
> Msql-Mysql-modules-1.2215/ChangeLog
> mysql3# cd Msql-Mysql-modules-1.2215
> mysql3# perl Makefile.PL
> Which drivers do you want to install?
>
> 1) MySQL only
> 2) mSQL only (either of mSQL 1 or mSQL 2)
> 3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
>
> 4) mSQL 1 and mSQL 2
> 5) MySQL, mSQL 1 and mSQL 2
>
> Enter the appropriate number: [3] 1
>
>
> Do you want to install the MysqlPerl emulation? You might keep your old
> Mysql module (to be distinguished from DBD::mysql!) if you are concerned
> about compatibility to existing applications! [n]
> Where is your MySQL installed? Please tell me the directory that
> contains the subdir 'include'. [/usr/local/mysql]
> Which database should I use for testing the MySQL drivers? [test]
> On which host is database test running (hostname, ip address
> or host:port) [localhost]
> User name for connecting to database test? [undef]
> Password for connecting to database test? [undef]
> Creating files for MySQL ....................
> Checking if your kit is complete...
> Looks good
> Note (probably harmless): No library found for -lgz
> Using DBI 1.20 installed in
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI
> Writing Makefile for DBD::mysql
> Writing Makefile for Msql-Mysql-modules
> mysql3# make
> mkdir blib
> mkdir blib/lib
> /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/libdata/perl/5.00503/mach -I/us
> r/libdata/perl/5.00503 -Ilib -MExtUtils::PerlPP -e ppp "dbd/dbimon.in"
> "dbimon" "lib/DBD/mysql/Install/Config.pm"
> /usr/local/bin/pod2text mysql/lib/DBD/mysql.pm >README
> mkdir blib/arch
> mkdir blib/arch/auto
> mkdir blib/arch/auto/Msql-Mysql-modules
> mkdir blib/lib/auto/Msql-Mysql-modules
> mkdir blib/man1
> mkdir ../blib/lib/DBD
> 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/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI -I/usr/lo
> cal/mysql/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.005/i386
> -freebsd/auto/DBI -I/usr/libdata/perl/5.00503/mach -DVERSION=\"2.0415\
> " -DXS_VERSION=\"2.0415\" -DPIC -fpic -I/usr/libdata/perl/5.00503/mach/CORE
> -DDBD_MYSQL dbdimp.c
> /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" <
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI/Driver.xst >
> mysql.xsi
> /usr/bin/perl -I/usr/libdata/perl/5.00503/mach -I/usr/libdata/perl/5.00503
> /usr/libdata/perl/5.00503/ExtUtils/xsubpp -object_capi -typemap
> /usr/libdata/perl/5.00503/ExtUtils/typemap mysql.xs >xstmp.c && mv xstmp.c
> mysql.c
> cc -c -I/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI -I/usr/lo
> cal/mysql/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.005/i386
> -freebsd/auto/DBI -I/usr/libdata/perl/5.00503/mach -DVERSION=\"2.0415\
> " -DXS_VERSION=\"2.0415\" -DPIC -fpic -I/usr/libdata/perl/5.00503/mach/CORE
> -DDBD_MYSQL mysql.c
> mkdir ../blib/arch/auto/DBD
> mkdir ../blib/arch/auto/DBD/mysql
> Running Mkbootstrap for DBD::mysql ()
> chmod 644 mysql.bs
> cc -o ../blib/arch/auto/DBD/mysql/mysql.so -Wl,-E -shared -lperl -lm
> dbdimp.o
> ysql.o -L/usr/local/mysql/lib/mysql -L/usr/local/mysql/lib/mysql -lmysqlcl
> ient -lm -lz
> 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
> mkdir ../blib/lib/auto/DBD
> mkdir ../blib/lib/auto/DBD/mysql
> mkdir ../blib/man3
> Manifying ../blib/man3/DBD::mysql.3
> Manifying ../blib/man3/Bundle::DBD::mysql.3
> Manifying ../blib/man3/Mysql.3
> mkdir blib/script
> cp dbimon blib/script/dbimon
> /usr/bin/perl -I/usr/libdata/perl/5.00503/mach -I/usr/libdata/perl/5.00503 -
> MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon
> Manifying blib/man1/dbimon.1
> mysql3# make test
> PERL_DL_NONLAZY=1
> /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/libdata/perl/5.00503/mach
> -I/usr/libdata/perl/5.00503 -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: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/00base.t line 38
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 4-5
> Failed 2/5 tests, 60.00% okay
> t/10dsnlist.........install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/10dsnlist.t line 45
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-3
> Failed 3/3 tests, 0.00% okay
> t/20createdrop......install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/20createdrop.t line 47
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-5
> Failed 5/5 tests, 0.00% okay
> t/30insertfetch.....install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/30insertfetch.t line 48
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-11
> Failed 11/11 tests, 0.00% okay
> t/40bindparam.......install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 3) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/40bindparam.t line 64
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-28
> Failed 28/28 tests, 0.00% okay
> t/40blobs...........install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/40blobs.t line 68
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-11
> Failed 11/11 tests, 0.00% okay
> t/40listfields......install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/40listfields.t line 57
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-16
> Failed 16/16 tests, 0.00% okay
> t/40nulls...........install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/40nulls.t line 50
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-11
> Failed 11/11 tests, 0.00% okay
> t/40numrows.........install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/40numrows.t line 59
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-25
> Failed 25/25 tests, 0.00% okay
> t/50chopblanks......install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/50chopblanks.t line 57
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-35
> Failed 35/35 tests, 0.00% okay
> t/50commit..........install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/50commit.t line 64
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-16
> Failed 16/16 tests, 0.00% okay
> t/60leaks...........skipping test on this platform
> t/ak-dbd............install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/ak-dbd.t line 59
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-90
> Failed 90/90 tests, 0.00% okay
> t/dbdadmin..........install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object
> "libmysqlclient.so.10" not found at /usr/libdata/perl/5.00503/DynaLoader.pm
> line 169.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> at t/dbdadmin.t line 60
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 1-20
> Failed 20/20 tests, 0.00% okay
> Failed Test Status 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. 255 65280 5 5 100.00% 1-5
> t/30insertfetch 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. 255 65280 16 16 100.00% 1-16
> t/40nulls.t 255 65280 11 11 100.00% 1-11
> t/40numrows.t 255 65280 25 25 100.00% 1-25
> t/50chopblanks. 255 65280 35 35 100.00% 1-35
> t/50commit.t 255 65280 16 16 100.00% 1-16
> t/ak-dbd.t 255 65280 90 90 100.00% 1-90
> t/dbdadmin.t 255 65280 20 20 100.00% 1-20
> 1 test skipped.
> Failed 13/14 test scripts, 7.14% okay. 273/276 subtests failed, 1.09% okay.
> *** Error code 2
>
> Stop in /usr/local/www/install/Msql-Mysql-modules-1.2215/mysql.
> *** Error code 1
>
> Stop in /usr/local/www/install/Msql-Mysql-modules-1.2215.
> mysql3# make install
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.bs
> Files found in blib/arch --> Installing files in blib/lib into architecture
> dependend library tree!
> Installing /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/DBD/mysql.pm
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Bundle/DBD/mysql.pm
> Installing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql/Statement.pm
> Installing /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm
> Installing /usr/local/man/man1/dbimon.1
> Installing /usr/local/lib/perl5/5.00503/man/man3/DBD::mysql.3
> Installing /usr/local/lib/perl5/5.00503/man/man3/Bundle::DBD::mysql.3
> Installing /usr/local/lib/perl5/5.00503/man/man3/Mysql.3
> Installing /usr/bin/dbimon
> Writing
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/Msql-Mysql-modules/.p
> acklist
> Appending installation info to /usr/libdata/perl/5.00503/mach/perllocal.pod
>
> Have a nice day ...
>
> Sincerely,
>
> Mike Cherichetti, CTO
> Advanced Resource Computing Services
> Phone (256)828-8921
> ___________________________________________
>
> Internet Advertising Delivery Solutions
> www.advertpro.com
> ___________________________________________
>
> Web Design, Hosting, Promotion
> www.arc-s.com
> ___________________________________________
>
----------------------------------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 08-Oct-01
Time: 06:52:48
----------------------------------
