Trying to install DBD::mysql into a perl installation in my home
directory. The MySQL server is installed on the same host, but it is
managed by the web-hoster (i.e. I have to link to their libs, and can't
upgrade MySQL). I have created a script (prep.sh) to run "perl
Makefile.PL" with the options I want.
I have read thru all the mailing lists and I can't find the same
problem in the past. In short, build is OK; but any tests beyond
00dsn.t fail with a Segmentation fault/violation.
Any suggestions welcome as I will try anything now. Thanks,
Doug
Script started on Tue Sep 3 21:48:10 2002
pine:~/src/Msql-Mysql-modules-1.2219$ cat prep.sh
#!/bin/sh
perl Makefile.PL \
--config \
--static \
--mysql-test-db=tvbarn \
--mysql-test-user=tvbarn \
--mysql-test-pass=XXXXX \
--mysql-test-host=pine.he.net \
--verbose
pine:~/src/Msql-Mysql-modules-1.2219$ sh prep.sh
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]
Using include/mysql/mysql.h in /usr/local.
Using lib/mysql/libmysqlclient.a in /usr/local.
Which database should I use for testing the MySQL drivers? [tvbarn]
On which host is database tvbarn running (hostname, ip address
or host:port) [pine.he.net]
User name for connecting to database tvbarn? [tvbarn]
Password for connecting to database tvbarn? [XXXXXX]
Driver mysql is using the following settings for tests:
Database tvbarn
Host pine.he.net
DSN DBI:mysql:database=tvbarn
User tvbarn
Password XXXXXX
Creating files for MySQL ....................
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Using DBI 1.30 installed in
/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules
pine:~/src/Msql-Mysql-modules-1.2219$ make
/home/tvbarn/my/lib/pod2text mysql/lib/DBD/mysql.pm >README
make[1]: Entering directory
`/home/tvbarn/src/Msql-Mysql-modules-1.2219/mysql'
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/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/local/include/mysql -I../dbd
-I/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux/auto/DBI
-I/home/tvbarn/my/perl/lib/5.6.1/i686-linux -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.0419\"
-DXS_VERSION=\"2.0419\" -fpic
-I/home/tvbarn/my/perl/lib/5.6.1/i686-linux/CORE -DDBD_MYSQL dbdimp.c
/home/tvbarn/my/lib/perl -p -e "s/~DRIVER~/mysql/g" <
/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux/auto/DBI/Driver.xst
> mysql.xsi
/home/tvbarn/my/lib/perl -I/home/tvbarn/my/perl/lib/5.6.1/i686-linux
-I/home/tvbarn/my/perl/lib/5.6.1
/home/tvbarn/my/perl/lib/5.6.1/ExtUtils/xsubpp -typemap
/home/tvbarn/my/perl/lib/5.6.1/ExtUtils/typemap mysql.xs > mysql.xsc &&
mv mysql.xsc mysql.c
Warning: duplicate function definition 'rows' detected in mysql.xs,
line 407
cc -c -I/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/local/include/mysql -I../dbd
-I/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux/auto/DBI
-I/home/tvbarn/my/perl/lib/5.6.1/i686-linux -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.0419\"
-DXS_VERSION=\"2.0419\" -fpic
-I/home/tvbarn/my/perl/lib/5.6.1/i686-linux/CORE -DDBD_MYSQL mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f ../blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/lib:/usr/local/lib:/usr/lib/gcc-lib/i486-linux/2.7.2" cc
-shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/lib/mysql -o
../blib/arch/auto/DBD/mysql/mysql.so
/usr/local/lib/mysql/libmysqlclient.a -lm -lz
-L/usr/lib/gcc-lib/i486-linux/2.7.2 -lgcc
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/Bundle::DBD::mysql.3
Manifying ../blib/man3/Mysql.3
make[1]: Leaving directory
`/home/tvbarn/src/Msql-Mysql-modules-1.2219/mysql'
cp dbimon blib/script/dbimon
/home/tvbarn/my/lib/perl -I/home/tvbarn/my/perl/lib/5.6.1/i686-linux
-I/home/tvbarn/my/perl/lib/5.6.1 -MExtUtils::MakeMaker -e
"MY->fixin(shift)" blib/script/dbimon
Manifying blib/man1/dbimon.1
pine:~/src/Msql-Mysql-modules-1.2219$ make test
make[1]: Entering directory
`/home/tvbarn/src/Msql-Mysql-modules-1.2219/mysql'
make[1]: Leaving directory
`/home/tvbarn/src/Msql-Mysql-modules-1.2219/mysql'
make[1]: Entering directory
`/home/tvbarn/src/Msql-Mysql-modules-1.2219/mysql'
PERL_DL_NONLAZY=1 /home/tvbarn/my/lib/perl -I../blib/arch -I../blib/lib
-I/home/tvbarn/my/perl/lib/5.6.1/i686-linux
-I/home/tvbarn/my/perl/lib/5.6.1 -e 'use Test::Harness qw(&runtests
$verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base...........
t/00base...........ok 1/5
t/00base...........ok 2/5
t/00base...........ok 3/5
t/00base...........ok 4/5
t/00base...........ok 5/5
t/00base...........ok
t/10dsnlist........
t/10dsnlist........dubious
Test returned status 0 (wstat 11, 0xb)
t/20createdrop.....
t/20createdrop.....dubious
Test returned status 0 (wstat 11, 0xb)
t/30insertfetch....
t/30insertfetch....dubious
Test returned status 0 (wstat 11, 0xb)
t/40bindparam......
t/40bindparam......dubious
Test returned status 0 (wstat 11, 0xb)
t/40blobs..........
t/40blobs..........dubious
Test returned status 0 (wstat 11, 0xb)
t/40listfields.....
t/40listfields.....dubious
Test returned status 0 (wstat 11, 0xb)
t/40nulls..........
t/40nulls..........dubious
Test returned status 0 (wstat 11, 0xb)
t/40numrows........
t/40numrows........dubious
Test returned status 0 (wstat 11, 0xb)
t/50chopblanks.....
t/50chopblanks.....dubious
Test returned status 0 (wstat 11, 0xb)
t/50commit.........
t/50commit.........dubious
Test returned status 0 (wstat 11, 0xb)
t/60leaks..........t/ak-dbd...........
t/ak-dbd...........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 1-90
Failed 90/90 tests, 0.00% okay
t/dbdadmin.........
t/dbdadmin.........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 1-20
Failed 20/20 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10dsnlist.t 0 11 ?? ?? % ??
t/20createdrop.t 0 11 ?? ?? % ??
t/30insertfetch.t 0 11 ?? ?? % ??
t/40bindparam.t 0 11 ?? ?? % ??
t/40blobs.t 0 11 ?? ?? % ??
t/40listfields.t 0 11 ?? ?? % ??
t/40nulls.t 0 11 ?? ?? % ??
t/40numrows.t 0 11 ?? ?? % ??
t/50chopblanks.t 0 11 ?? ?? % ??
t/50commit.t 0 11 ?? ?? % ??
t/ak-dbd.t 0 11 90 90 100.00% 1-90
t/dbdadmin.t 0 11 20 20 100.00% 1-20
Failed 12/14 test scripts, 7.14% okay. 110/115 subtests failed, 4.35%
okay.
make[1]: *** [test_dynamic] Error 2
make[1]: Leaving directory
`/home/tvbarn/src/Msql-Mysql-modules-1.2219/mysql'
make: *** [test] Error 2
pine:~/src/Msql-Mysql-modules-1.2219$ uname -a
Linux pine.he.net 2.2.20 #5 SMP Tue Nov 13 18:55:01 PST 2001 i686
pine:~/src/Msql-Mysql-modules-1.2219$ gcc --version
2.7.2
pine:~/src/Msql-Mysql-modules-1.2219$ perl -V
Summary of my perl5 (revision 5.0 version 6 subversion 1)
configuration:
Platform:
osname=linux, osvers=2.2.20, archname=i686-linux
uname='linux pine.he.net 2.2.20 #5 smp tue nov 13 18:55:01 pst 2001
i686 '
config_args='-Dprefix=/home/tvbarn/my/perl'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
Compiler:
cc='cc', ccflags ='-I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-I/usr/local/include'
ccversion='', gccversion='2.7.2', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lndbm -lgdbm -ldbm -ldb -ldl -lm -lc
perllibs=-ldl -lm -lc
libc=, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef,
ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under linux
Compiled at May 25 2002 07:49:58
@INC:
/home/tvbarn/my/perl/lib/5.6.1/i686-linux
/home/tvbarn/my/perl/lib/5.6.1
/home/tvbarn/my/perl/lib/site_perl/5.6.1/i686-linux
/home/tvbarn/my/perl/lib/site_perl/5.6.1
/home/tvbarn/my/perl/lib/site_perl
.
pine:~/src/Msql-Mysql-modules-1.2219$ /sbin/ldconfig -p
139 libs found in cache `/etc/ld.so.cache' (version 1.7.0)
libz.so.1 (ELF) => /usr/local/lib/libz.so.1
libz.so (ELF) => /usr/local/lib/libz.so
libvgagl.so.1 (ELF) => /usr/lib/libvgagl.so.1
libvga.so.1 (DLL) => /usr/i486-linuxaout/lib/libvga.so.1
libvga.so.1 (ELF) => /usr/lib/libvga.so.1
libundel.so.1 (ELF-libc5) => /usr/local/lib/libundel.so.1
libundel.so (ELF-libc5) => /usr/local/lib/libundel.so
libttf.so.2 (ELF-libc5) => /usr/lib/libttf.so.2
libttf.so (ELF-libc5) => /usr/lib/libttf.so
libtkx.so.1 (ELF-libc5) => /usr/lib/libtkx.so.1
libtkx.so (ELF-libc5) => /usr/lib/libtkx.so
libtk.so.1 (ELF) => /usr/lib/libtk.so.1
libtk.so (ELF) => /usr/lib/libtk.so
libtermcap.so.2 (ELF) => /lib/libtermcap.so.2
libtermcap.so (ELF) => /usr/lib/libtermcap.so
libtclx.so.1 (ELF-libc5) => /usr/lib/libtclx.so.1
libtclx.so (ELF-libc5) => /usr/lib/libtclx.so
libtcl.so.1 (ELF) => /usr/lib/libtcl.so.1
libtcl.so (ELF) => /usr/lib/libtcl.so
libstdc++.so.27 (ELF-libc5) => /usr/lib/libstdc++.so.27
libstdc++.so.2.8 (ELF-libc6) => /usr/lib/libstdc++.so.2.8
libstdc++.so (ELF-libc5) => /usr/lib/libstdc++.so
libss.so.2 (ELF) => /lib/libss.so.2
libpthread.so.0 (ELF) => /lib/libpthread.so.0
libpthread.so (ELF) => /usr/lib/libpthread.so
libproc.so.1.2.6 (ELF-libc5) => /usr/lib/libproc.so.1.2.6
libproc.so (ELF-libc5) => /usr/lib/libproc.so
libpng.so.2 (ELF-libc5) => /usr/lib/libpng.so.2
libpng.so (ELF-libc5) => /usr/lib/libpng.so
libpanel.so.3.0 (ELF) => /usr/lib/libpanel.so.3.0
libpanel.so.2.1 (ELF) => /usr/lib/libpanel.so.2.1
libpanel.so.1.9 (ELF) => /usr/lib/libpanel.so.1.9
libpanel.so (ELF) => /usr/lib/libpanel.so
libopcodes.so.2.6.0.14 (ELF) => /usr/lib/libopcodes.so.2.6.0.14
libndbm.so (ELF) => /usr/lib/libndbm.so
libncurses.so.3.0 (ELF) => /lib/libncurses.so.3.0
libncurses.so.3 (ELF) => /lib/libncurses.so.3
libncurses.so.2.1 (ELF) => /lib/libncurses.so.2.1
libncurses.so.1.9 (ELF) => /lib/libncurses.so.1.9
libncurses.so (ELF) => /lib/libncurses.so
libmysqlclient.so.10 (ELF-libc5) =>
/usr/local/lib/mysql/libmysqlclient.so.10
libmysqlclient.so.6 (ELF-libc5) =>
/usr/local/lib/mysql/libmysqlclient.so.6
libmysqlclient.so (ELF-libc5) =>
/usr/local/lib/mysql/libmysqlclient.so
libmenu.so.3.0 (ELF) => /usr/lib/libmenu.so.3.0
libmenu.so.2.1 (ELF) => /usr/lib/libmenu.so.2.1
libmenu.so.1.9 (ELF) => /usr/lib/libmenu.so.1.9
libmenu.so (ELF) => /usr/lib/libmenu.so
libm.so.5 (ELF-libc5) => /lib/libm.so.5
libm.so.4 (DLL) => /lib/libm.so.4
libm.so (ELF-libc5) => /usr/lib/libm.so
libjpeg.so.62 (ELF) => /usr/lib/libjpeg.so.62
libjpeg.so (ELF) => /usr/lib/libjpeg.so
libgdbm.so.2 (ELF) => /usr/lib/libgdbm.so.2
libgdbm.so.1 (ELF) => /lib/libgdbm.so.1
libgdbm.so (ELF) => /usr/lib/libgdbm.so
libgd.so.2.0.0 (ELF) => /usr/lib/libgd.so.2.0.0
libgd.so.2 (ELF) => /usr/lib/libgd.so.2
libgd.so (ELF) => /usr/lib/libgd.so
libg++.so.27 (ELF-libc5) => /usr/lib/libg++.so.27
libg++.so (ELF-libc5) => /usr/lib/libg++.so
libfreetype.so.6 (ELF-libc5) => /usr/lib/libfreetype.so.6
libfreetype.so (ELF-libc5) => /usr/lib/libfreetype.so
libform.so.3.0 (ELF) => /usr/lib/libform.so.3.0
libform.so.2.1 (ELF) => /usr/lib/libform.so.2.1
libform.so.1.9 (ELF) => /usr/lib/libform.so.1.9
libform.so (ELF) => /usr/lib/libform.so
libfixframeinfo.so (ELF) => /usr/lib/libfixframeinfo.so
libe2p.so.2 (ELF) => /lib/libe2p.so.2
libext2fs.so.2 (ELF) => /lib/libext2fs.so.2
libdl.so.2 (ELF-libc6) => /lib/libdl.so.2
libdl.so.1 (ELF-libc5) => /lib/libdl.so.1
libdl.so (ELF-libc5) => /lib/libdl.so
libdbm.so (ELF) => /usr/lib/libdbm.so
libdb.so.2 (ELF) => /usr/lib/libdb.so.2
libdb.so.1 (DLL) => /usr/i486-linuxaout/lib/libdb.so.1
libdb.so.1 (ELF) => /usr/lib/libdb.so.1
libdb.so (ELF) => /usr/lib/libdb.so
libcurses.so.1 (ELF) => /lib/libcurses.so.1
libcurses.so.0 (DLL) => /lib/libcurses.so.0
libcurses.so (ELF) => /usr/lib/libcurses.so
libcom_err.so.2 (ELF) => /lib/libcom_err.so.2
libc.so.5 (ELF-libc5) => /lib/libc.so.5
libc.so.4 (DLL) => /lib/libc.so.4
libc.so (ELF-libc5) => /usr/lib/libc.so
libbfd.so.2.6.0.14 (ELF) => /usr/lib/libbfd.so.2.6.0.14
libX11.so.6 (ELF) => /usr/X11R6/lib/libX11.so.6
libX11.so.6 (ELF) => /usr/X11/lib/libX11.so.6
libX11.so (ELF) => /usr/X11R6/lib/libX11.so
libX11.so (ELF) => /usr/X11/lib/libX11.so
libXtst.so.6 (ELF) => /usr/X11R6/lib/libXtst.so.6
libXtst.so.6 (ELF) => /usr/X11/lib/libXtst.so.6
libXtst.so (ELF) => /usr/X11R6/lib/libXtst.so
libXtst.so (ELF) => /usr/X11/lib/libXtst.so
libXt.so.6 (ELF) => /usr/X11R6/lib/libXt.so.6
libXt.so.6 (ELF) => /usr/X11/lib/libXt.so.6
libXt.so (ELF) => /usr/X11R6/lib/libXt.so
libXt.so (ELF) => /usr/X11/lib/libXt.so
libXpm.so.4 (ELF) => /usr/X11R6/lib/libXpm.so.4
libXpm.so.4 (ELF) => /usr/X11/lib/libXpm.so.4
libXp.so.6 (ELF) => /usr/X11R6/lib/libXp.so.6
libXp.so.6 (ELF) => /usr/X11/lib/libXp.so.6
libXp.so (ELF) => /usr/X11R6/lib/libXp.so
libXp.so (ELF) => /usr/X11/lib/libXp.so
libXmu.so.6 (ELF) => /usr/X11R6/lib/libXmu.so.6
libXmu.so.6 (ELF) => /usr/X11/lib/libXmu.so.6
libXmu.so (ELF) => /usr/X11R6/lib/libXmu.so
libXmu.so (ELF) => /usr/X11/lib/libXmu.so
libXi.so.6 (ELF) => /usr/X11R6/lib/libXi.so.6
libXi.so.6 (ELF) => /usr/X11/lib/libXi.so.6
libXi.so (ELF) => /usr/X11R6/lib/libXi.so
libXi.so (ELF) => /usr/X11/lib/libXi.so
libXext.so.6 (ELF) => /usr/X11R6/lib/libXext.so.6
libXext.so.6 (ELF) => /usr/X11/lib/libXext.so.6
libXext.so (ELF) => /usr/X11R6/lib/libXext.so
libXext.so (ELF) => /usr/X11/lib/libXext.so
libXaw.so.6 (ELF) => /usr/X11R6/lib/libXaw.so.6
libXaw.so.6 (ELF) => /usr/X11/lib/libXaw.so.6
libXaw.so (ELF) => /usr/X11R6/lib/libXaw.so
libXaw.so (ELF) => /usr/X11/lib/libXaw.so
libXIE.so.6 (ELF) => /usr/X11R6/lib/libXIE.so.6
libXIE.so.6 (ELF) => /usr/X11/lib/libXIE.so.6
libXIE.so (ELF) => /usr/X11R6/lib/libXIE.so
libXIE.so (ELF) => /usr/X11/lib/libXIE.so
libSM.so.6 (ELF) => /usr/X11R6/lib/libSM.so.6
libSM.so.6 (ELF) => /usr/X11/lib/libSM.so.6
libSM.so (ELF) => /usr/X11R6/lib/libSM.so
libSM.so (ELF) => /usr/X11/lib/libSM.so
libPEX5.so.6 (ELF-libc5) => /usr/X11R6/lib/libPEX5.so.6
libPEX5.so.6 (ELF-libc5) => /usr/X11/lib/libPEX5.so.6
libPEX5.so (ELF-libc5) => /usr/X11R6/lib/libPEX5.so
libPEX5.so (ELF-libc5) => /usr/X11/lib/libPEX5.so
libICE.so.6 (ELF) => /usr/X11R6/lib/libICE.so.6
libICE.so.6 (ELF) => /usr/X11/lib/libICE.so.6
libICE.so (ELF) => /usr/X11R6/lib/libICE.so
libICE.so (ELF) => /usr/X11/lib/libICE.so
ld-linux.so.2 (ELF) => /lib/ld-linux.so.2
ld-linux.so.1.8.2 (ELF) => /lib/ld-linux.so.1.8.2
ld-linux.so.1 (ELF) => /lib/ld-linux.so.1
ld-linux.so (ELF) => /lib/ld-linux.so
pine:~/src/Msql-Mysql-modules-1.2219$ exit
exit
Script done on Tue Sep 3 21:49:32 2002
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
