We have an old server that needs to install BDI and DBD module. The server is
running with Perl 5.8.7 and MySQL 4.1.13
We have DBI-1.41 and DBD-mysql-2.9003. However, it was failed when I installed
these modules.
These are the outputs for DBI and DBD:
I also tried the latest versions and still failed
I really appreciate your help.
Thanks,
Tim Pham
Network Engineer
Cox Communications
Orange Coast - Banderas Campus
Phone: 949-546-2912
Cell: 949-257-6932
roverdb# perl Makefile.PL
*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use the DBD::Proxy driver and DBI::ProxyServer
modules, then you'll need to install the RPC::PlServer, RPC::PlClient,
Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.
You can install them any time after installing the DBI.
You do *not* need these modules for typical DBI usage.
Optional modules are available from any CPAN mirror, in particular
http://search.cpan.org/
http://www.perl.com/CPAN/modules/by-module
http://www.perl.org/CPAN/modules/by-module
ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module
Creating extra DBI::PurePerl test: t/zz_01basics_pp.t
Creating extra DBI::PurePerl test: t/zz_02dbidrv_pp.t
Creating extra DBI::PurePerl test: t/zz_03handle_pp.t
Creating extra DBI::PurePerl test: t/zz_04mods_pp.t
Creating extra DBI::PurePerl test: t/zz_05thrclone_pp.t
Creating extra DBI::PurePerl test: t/zz_06attrs_pp.t
Creating extra DBI::PurePerl test: t/zz_07kids_pp.t
Creating extra DBI::PurePerl test: t/zz_08keeperr_pp.t
Creating extra DBI::PurePerl test: t/zz_10examp_pp.t
Creating extra DBI::PurePerl test: t/zz_15array_pp.t
Creating extra DBI::PurePerl test: t/zz_20meta_pp.t
Creating extra DBI::PurePerl test: t/zz_30subclass_pp.t
Creating extra DBI::PurePerl test: t/zz_40profile_pp.t
Creating extra DBI::PurePerl test: t/zz_41prof_dump_pp.t
Creating extra DBI::PurePerl test: t/zz_42prof_data_pp.t
Creating extra DBI::PurePerl test: t/zz_60preparse_pp.t
Creating extra DBI::PurePerl test: t/zz_80proxy_pp.t
Warning: By default new modules are installed into your 'site_lib'
directories. Since site_lib directories come after the normal library
directories you must delete old DBI files and directories from your
'privlib' and 'archlib' directories and their auto subdirectories.
Reinstall DBI and your DBD::* drivers after deleting the old directories.
Here's a list of probable old files and directories:
/usr/local/lib/perl5/5.8.7/man/man3/Bundle::DBI.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfo::ANSI.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfo::ODBC.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfoReturn.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfoType.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD::Metadata.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD::SqlEngine.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD::SqlEngine::Developers.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD::SqlEngine::HowTo.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::FAQ.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Execute.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Request.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Response.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Serializer::Base.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Serializer::DataDumper.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Serializer::Storable.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Transport::Base.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Transport::pipeone.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Gofer::Transport::stream.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Profile.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileData.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileDumper.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileDumper::Apache.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileSubs.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::ProxyServer.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::PurePerl.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::SQL::Nano.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::Util::CacheMemory.3
/usr/local/lib/perl5/5.8.7/man/man3/DBI::W32ODBC.3
/usr/local/lib/perl5/5.8.7/man/man3/Win32::DBIODBC.3
I see you're using perl 5.008007 on i386-freebsd-64int, okay.
Remember to actually *read* the README file!
Use 'make' to build the software (dmake or nmake on Windows).
Then 'make test' to execute self tests.
Then 'make install' to install the DBI and then delete this working
directory before unpacking and building any DBD::* drivers.
Writing Makefile for DBI
roverdb# make
Skip blib/arch/auto/DBI/dbd_xsh.h (unchanged)
Skip blib/arch/auto/DBI/dbivport.h (unchanged)
Skip blib/lib/DBI/FAQ.pm (unchanged)
Skip blib/arch/auto/DBI/Driver_xst.h (unchanged)
Skip blib/lib/DBD/Proxy.pm (unchanged)
Skip blib/lib/DBI/Const/GetInfo/ANSI.pm (unchanged)
Skip blib/lib/DBI.pm (unchanged)
Skip blib/arch/auto/DBI/DBIXS.h (unchanged)
Skip blib/lib/DBI/Const/GetInfoReturn.pm (unchanged)
Skip blib/lib/DBD/Sponge.pm (unchanged)
Skip blib/lib/DBI/Const/GetInfoType.pm (unchanged)
Skip blib/lib/DBI/W32ODBC.pm (unchanged)
Skip blib/lib/DBI/DBD/Metadata.pm (unchanged)
Skip blib/lib/DBI/Const/GetInfo/ODBC.pm (unchanged)
Skip blib/lib/DBI/ProfileDumper/Apache.pm (unchanged)
Skip blib/lib/Bundle/DBI.pm (unchanged)
Skip blib/lib/DBI/Profile.pm (unchanged)
Skip blib/lib/DBI/ProfileDumper.pm (unchanged)
Skip blib/arch/auto/DBI/Driver.xst (unchanged)
Skip blib/lib/DBI/ProxyServer.pm (unchanged)
Skip blib/arch/auto/DBI/dbipport.h (unchanged)
Skip blib/lib/DBD/NullP.pm (unchanged)
Skip blib/lib/DBI/DBD.pm (unchanged)
Skip blib/lib/Win32/DBIODBC.pm (unchanged)
Skip blib/lib/DBI/PurePerl.pm (unchanged)
Skip blib/lib/DBD/ExampleP.pm (unchanged)
Skip blib/arch/auto/DBI/dbi_sql.h (unchanged)
Skip blib/lib/DBI/ProfileData.pm (unchanged)
/usr/bin/perl -p -e "s/~DRIVER~/Perl/g" blib/arch/auto/DBI/Driver.xst > Perl.xsi
/usr/bin/perl /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.7/ExtUtils/typemap -typemap typemap Perl.xs >
Perl.xsc && mv Perl.xsc Perl.c
cc -c -DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -I/usr/local/include -O -pipe
-DVERSION=\"1.41\" -DXS_VERSION=\"1.41\" -DPIC -fPIC
"-I/usr/local/lib/perl5/5.8.7/mach/CORE" -Wall -Wno-comment -DDBI_NO_THREADS
Perl.c
/usr/bin/perl /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.7/ExtUtils/typemap -typemap typemap DBI.xs > DBI.xsc
&& mv DBI.xsc DBI.c
cc -c -DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -I/usr/local/include -O -pipe
-DVERSION=\"1.41\" -DXS_VERSION=\"1.41\" -DPIC -fPIC
"-I/usr/local/lib/perl5/5.8.7/mach/CORE" -Wall -Wno-comment -DDBI_NO_THREADS
DBI.c
Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
rm -f blib/arch/auto/DBI/DBI.so
cc -shared -L/usr/local/lib DBI.o -o blib/arch/auto/DBI/DBI.so
chmod 755 blib/arch/auto/DBI/DBI.so
cp DBI.bs blib/arch/auto/DBI/DBI.bs
chmod 644 blib/arch/auto/DBI/DBI.bs
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiprof.PL dbiprof
Extracted dbiprof from dbiprof.PL with variable substitutions.
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiproxy.PL dbiproxy
Extracted dbiproxy from dbiproxy.PL with variable substitutions.
cp dbiprof blib/script/dbiprof
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/dbiprof
cp dbiproxy blib/script/dbiproxy
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/dbiproxy
Manifying blib/man1/dbiprof.1
Manifying blib/man1/dbiproxy.1
Manifying blib/man3/DBI::FAQ.3
Manifying blib/man3/DBD::Proxy.3
Manifying blib/man3/DBI::Const::GetInfo::ANSI.3
Manifying blib/man3/DBI::Const::GetInfoReturn.3
Manifying blib/man3/DBI.3
Manifying blib/man3/DBD::Sponge.3
Manifying blib/man3/DBI::Const::GetInfoType.3
Manifying blib/man3/DBI::DBD::Metadata.3
Manifying blib/man3/DBI::W32ODBC.3
Manifying blib/man3/DBI::Const::GetInfo::ODBC.3
Manifying blib/man3/DBI::ProfileDumper::Apache.3
Manifying blib/man3/Bundle::DBI.3
Manifying blib/man3/DBI::Profile.3
Manifying blib/man3/DBI::ProfileDumper.3
Manifying blib/man3/DBI::ProxyServer.3
Manifying blib/man3/DBI::DBD.3
Manifying blib/man3/Win32::DBIODBC.3
Manifying blib/man3/DBI::PurePerl.3
Manifying blib/man3/DBI::ProfileData.3
roverdb# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/01basics.............ok
t/02dbidrv.............ok
t/03handle.............ok
t/04mods...............ok
t/05thrclone...........skipped
all skipped: this freebsd perl 5.008007 not configured to support
iThreads
t/06attrs..............ok
t/07kids...............ok
t/08keeperr............ok
t/10examp..............ok
t/15array..............ok
t/20meta...............ok
t/30subclass...........ok
t/40profile............ok
t/41prof_dump..........ok
t/42prof_data..........ok
t/60preparse...........ok
t/80proxy..............skipped
all skipped: modules required for proxy are probably not installed
(e.g., RPC/PlClient.pm)
t/zz_01basics_pp....... Using DBI::PurePerl (DBI_PUREPERL=2) on
i386-freebsd-64int
t/zz_01basics_pp.......ok
t/zz_02dbidrv_pp.......ok
t/zz_03handle_pp.......ok
t/zz_04mods_pp.........ok
t/zz_05thrclone_pp.....skipped
all skipped: this freebsd perl 5.008007 not configured to support
iThreads
t/zz_06attrs_pp........ok
t/zz_07kids_pp.........skipped
all skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zz_08keeperr_pp......ok
t/zz_10examp_pp........ok 1/245 Taint mode switching tests skipped
t/zz_10examp_pp........ok
t/zz_15array_pp........ok
t/zz_20meta_pp.........ok
t/zz_30subclass_pp.....ok
t/zz_40profile_pp......skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_41prof_dump_pp....skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_42prof_data_pp....skipped
all skipped: profiling not supported for DBI::PurePerl
t/zz_60preparse_pp.....skipped
all skipped: preparse not supported for DBI::PurePerl
t/zz_80proxy_pp........skipped
all skipped: modules required for proxy are probably not installed
(e.g., RPC/PlClient.pm)
All tests successful, 9 tests skipped.
Files=34, Tests=1429, 6 wallclock secs ( 4.48 cusr + 0.69 csys = 5.16 CPU)
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
test.pl
DBI test application $Revision: 11.7 $
Switch: DBI 1.41 by Tim Bunce, 1.41
Available Drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql
dbi:ExampleP:: testing 5 sets of 20 connections:
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Connecting... 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Disconnecting...
Made 100 connections in 0 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU)
Testing handle creation speed...
18285 NullP sth/sec on this perl 5.008007 i386-freebsd-64int (10000 in 0.5
cpu+sys secs)
roverdb# make install
Manifying blib/man1/dbiprof.1
Manifying blib/man1/dbiproxy.1
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/Driver_xst.h
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/DBIXS.h
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/dbipport.h
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/dbd_xsh.h
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/dbivport.h
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/dbi_sql.h
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/Driver.xst
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/DBI.so
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/Changes.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/ProfileDumper.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/PurePerl.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/Profile.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/FAQ.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/W32ODBC.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/DBD.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/ProfileData.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/ProxyServer.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/DBD/Metadata.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/Const/GetInfoReturn.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/Const/GetInfoType.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/Const/GetInfo/ANSI.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/Const/GetInfo/ODBC.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI/ProfileDumper/Apache.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/Bundle/DBI.pm
Installing /usr/local/lib/perl5/site_perl/5.8.7/mach/Win32/DBIODBC.pm
Installing /usr/local/man/man1/dbiprof.1
Installing /usr/local/man/man1/dbiproxy.1
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileDumper.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD::Metadata.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfoReturn.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfo::ANSI.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::Profile.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::PurePerl.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::FAQ.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/Bundle::DBI.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/Win32::DBIODBC.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::W32ODBC.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::DBD.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileData.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::ProxyServer.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfoType.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBD::Proxy.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::ProfileDumper::Apache.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBI::Const::GetInfo::ODBC.3
Installing /usr/local/lib/perl5/5.8.7/man/man3/DBD::Sponge.3
Installing /usr/local/bin/dbiproxy
Installing /usr/local/bin/dbiprof
FreeBSD: Registering installation in the package database
Cannot create directory /var/db/pkg/bsdpan-DBI-1.41: File exists
Appending installation info to /usr/local/lib/perl5/5.8.7/mach/perllocal.podroverdb# perl Makefile.PL
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/local/include/mysql -O -pipe
libs (mysql_config) = -L/usr/local/lib/mysql -lmysqlclient -lz
-lcrypt -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Using DBI 1.41 (for perl 5.008007 on i386-freebsd-64int) installed in
/usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI
Writing Makefile for DBD::mysql
roverdb# make
Skip blib/lib/DBD/mysql.pm (unchanged)
Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged)
Skip blib/lib/Mysql.pm (unchanged)
Skip blib/lib/DBD/mysql/INSTALL.pod (unchanged)
Skip blib/lib/Mysql/Statement.pm (unchanged)
Skip blib/lib/Bundle/DBD/mysql.pm (unchanged)
cc -c -I/usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI
-I/usr/local/include/mysql -O -pipe
-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -I/usr/local/include -O -pipe
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -DPIC -fPIC
"-I/usr/local/lib/perl5/5.8.7/mach/CORE" dbdimp.c
dbdimp.c: In function `mysql_db_FETCH_attrib':
dbdimp.c:1456: warning: cast from pointer to integer of different size
dbdimp.c: In function `mysql_st_FETCH_attrib':
dbdimp.c:2146: warning: cast from pointer to integer of different size
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g"
/usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/5.8.7/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 192
Warning: duplicate function definition 'rows' detected in mysql.xs, line 290
cc -c -I/usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI
-I/usr/local/include/mysql -O -pipe
-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.7/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -I/usr/local/include -O -pipe
-DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\" -DPIC -fPIC
"-I/usr/local/lib/perl5/5.8.7/mach/CORE" mysql.c
mysql.xs: In function `XS_DBD__mysql__dr__admin_internal':
mysql.xs:100: error: too few arguments to function `mysql_shutdown'
*** Error code 1
Stop in /usr/home/tpham/DBD-mysql-2.9003.
