current environment
solaris 8, perl5.8.8, gcc3.4.6, mysql5.0.
please see the error in red mark. please assist me is there any other
supporting files need to install?..
*andd141# perl Makefile.PL*
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'root'@'localhost' identified by
's3kr1 t';
You can also optionally set the user to run 'make test' with:
perl Makefile.pl --testuser=username
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/local/mysql/include/mysql
-L/usr/local/l ib
-R/usr/local/lib -L/usr/local/ssl/lib -R/usr/local/ssl/lib
-L/usr/openwin/lib
-R/usr/openwin/lib -I/usr/local/rrdtool-1.2.19/include
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/ openwin/lib
-R/usr/openwin/lib -L/usr/local/mysql/lib/mysql -lmysqlclient -lz
-l posix4 -lresolv -lgen
-lsocket -lnsl -lm -L/usr/local/ssl/lib -lssl -lcrypto
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 1
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (guessed ) = root
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.609 (for perl 5.008008 on sun4-solaris) installed in
/usr/local/lib/
perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/
Writing Makefile for DBD::mysql
*andd141# make*
gcc -c -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI
-I/usr/local/mysql/include/mysql -L/usr/local/lib -R/usr/local/lib
-L/usr/local/ssl/lib -R/usr/local/ssl/lib -L/usr/openwin/lib
-R/usr/openwin/lib -I/usr/local/rrdtool-1.2.19/include -DDBD_MYSQL_WITH_SSL
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"4.013\" -DXS_VERSION=\"4.013\" -fPIC
"-I/usr/local/lib/perl5/5.8.8/sun4-solaris/CORE" dbdimp.c
gcc -c -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI
-I/usr/local/mysql/include/mysql -L/usr/local/lib -R/usr/local/lib
-L/usr/local/ssl/lib -R/usr/local/ssl/lib -L/usr/openwin/lib
-R/usr/openwin/lib -I/usr/local/rrdtool-1.2.19/include -DDBD_MYSQL_WITH_SSL
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O -DVERSION=\"4.013\" -DXS_VERSION=\"4.013\" -fPIC
"-I/usr/local/lib/perl5/5.8.8/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/local/lib:/usr/lib:/usr/local/ssl/lib"
/usr/bin/perl myld gcc -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/openwin/lib -R/usr/openwin/lib
-L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lposix4 -lresolv -lgen
-lsocket -lnsl -lm -L/usr/local/ssl/lib -lssl -lcrypto \
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/Bundle::DBD::mysql.3
*andd141# make test*
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok 1/6
# Failed test 'use DBD::mysql;'
# in t/00base.t at line 21.
# Tried to use 'DBD::mysql'.
# Error: Can't load
'/data/dbi/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.15: open
failed: No such file or directory at
/usr/local/lib/perl5/5.8.8/sun4-solaris/DynaLoader.pm line 230.
# at (eval 6) line 2
# Compilation failed in require at (eval 6) line 2.
# BEGIN failed--compilation aborted at t/00base.t line 21.
t/00base....................NOK 2FAILED--Further testing stopped: Unable to
load DBD::mysql
make: *** [test_dynamic] Error 29
*andd141# make install*
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Writing
/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBD/mysql/.packlist
Appending installation info to
/usr/local/lib/perl5/5.8.8/sun4-solaris/perllocal.pod
after install i ran some scripts. that also failed
*script*
#!/bin/perl
use DBI;
my $dbh = DBI->connect("DBI:mysql database=db2;host=localhost", "joe",
"guessme", {'RaiseError' => 1});
my $rows = $dbh->do("INSERT INTO users (id, username, country) VALUES (4,
'jay', 'CZ')");
print "$rows row(s) affected\n";
*
error:
*bash-2.03$ ./hello.pl install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.8/Sun4-solaris/auto/DBD/mysql/mysql.so'
for module DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.15:
open failed: No such file or directory at
/usr/local/lib/perl5/5.8.8/sun4-solaris/DynaLoader.pm line 230. at (eval 3)
line 3 Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected at
./hello.pl line 5
please assist me to solve this..
thanks in advance..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
