Hi and merry Xmas,,
I have been trying install DBI for mysql on my, recently upgraded to 'snow
leopard', Mac Book with no luck.
I have included the requested output from the installation process, which
appeared to me to be OK but when tried my test script also included I
could not connect to the database.
If you can check this out and advise of a solution or direct me to on it
would be greatly appreciated.
Thanks
Peter Hesp.
peter-hesps-macbook:DBI-1.609 peterhesp$ perl Makefile.PL
Your perl was compiled with gcc (version 4.2.1 (Apple Inc. build 5646)),
okay.
Creating test wrappers for DBI::PurePerl:
t/zvp_01basics.t
t/zvp_02dbidrv.t
t/zvp_03handle.t
t/zvp_04mods.t
t/zvp_05concathash.t
t/zvp_06attrs.t
t/zvp_07kids.t
t/zvp_08keeperr.t
t/zvp_09trace.t
t/zvp_10examp.t
t/zvp_11fetch.t
t/zvp_12quote.t
t/zvp_13taint.t
t/zvp_14utf8.t
t/zvp_15array.t
t/zvp_19fhtrace.t
t/zvp_20meta.t
t/zvp_30subclass.t
t/zvp_35thrclone.t
t/zvp_40profile.t
t/zvp_41prof_dump.t
t/zvp_42prof_data.t
t/zvp_43prof_env.t
t/zvp_50dbm.t
t/zvp_60preparse.t
t/zvp_65transact.t
t/zvp_70callbacks.t
t/zvp_72childhandles.t
t/zvp_80proxy.t
t/zvp_85gofer.t
t/zvp_86gofer_fail.t
t/zvp_87gofer_cache.t
Creating test wrappers for DBD::Gofer:
t/zvg_01basics.t
t/zvg_02dbidrv.t
t/zvg_03handle.t
t/zvg_04mods.t
t/zvg_05concathash.t
t/zvg_06attrs.t
t/zvg_07kids.t
t/zvg_08keeperr.t
t/zvg_09trace.t
t/zvg_10examp.t
t/zvg_11fetch.t
t/zvg_12quote.t
t/zvg_13taint.t
t/zvg_14utf8.t
t/zvg_15array.t
t/zvg_19fhtrace.t
t/zvg_20meta.t
t/zvg_30subclass.t
t/zvg_35thrclone.t
t/zvg_40profile.t
t/zvg_41prof_dump.t
t/zvg_42prof_data.t
t/zvg_43prof_env.t
t/zvg_50dbm.t
t/zvg_60preparse.t
t/zvg_65transact.t
t/zvg_70callbacks.t
t/zvg_72childhandles.t
t/zvg_80proxy.t
t/zvg_85gofer.t
t/zvg_86gofer_fail.t
t/zvg_87gofer_cache.t
Creating test wrappers for PurePerl & Gofer:
t/zvxgp_01basics.t
t/zvxgp_02dbidrv.t
t/zvxgp_03handle.t
t/zvxgp_04mods.t
t/zvxgp_05concathash.t
t/zvxgp_06attrs.t
t/zvxgp_07kids.t
t/zvxgp_08keeperr.t
t/zvxgp_09trace.t
t/zvxgp_10examp.t
t/zvxgp_11fetch.t
t/zvxgp_12quote.t
t/zvxgp_13taint.t
t/zvxgp_14utf8.t
t/zvxgp_15array.t
t/zvxgp_19fhtrace.t
t/zvxgp_20meta.t
t/zvxgp_30subclass.t
t/zvxgp_35thrclone.t
t/zvxgp_40profile.t
t/zvxgp_41prof_dump.t
t/zvxgp_42prof_data.t
t/zvxgp_43prof_env.t
t/zvxgp_50dbm.t
t/zvxgp_60preparse.t
t/zvxgp_65transact.t
t/zvxgp_70callbacks.t
t/zvxgp_72childhandles.t
t/zvxgp_80proxy.t
t/zvxgp_85gofer.t
t/zvxgp_86gofer_fail.t
t/zvxgp_87gofer_cache.t
Checking if your kit is complete...
Looks good
I see you're using perl 5.008009 on darwin-2level, 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
___________________________________________________________________________
MAKE
peter-hesps-macbook:DBI-1.609 peterhesp$ make
/opt/local/bin/perl "-MExtUtils::Command" -e mkpath blib/lib/DBI
rm -f blib/lib/DBI/Changes.pm
cp Changes blib/lib/DBI/Changes.pm
/opt/local/bin/perl "-MExtUtils::Command" -e mkpath blib/lib/DBI
rm -f blib/lib/DBI/Roadmap.pm
cp Roadmap.pod blib/lib/DBI/Roadmap.pm
cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h
cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm
cp lib/DBI/Gofer/Response.pm blib/lib/DBI/Gofer/Response.pm
cp lib/DBI/Gofer/Transport/Base.pm blib/lib/DBI/Gofer/Transport/Base.pm
cp lib/DBI/Util/_accessor.pm blib/lib/DBI/Util/_accessor.pm
cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm
cp DBIXS.h blib/arch/auto/DBI/DBIXS.h
cp Roadmap.pod blib/lib/Roadmap.pod
cp dbixs_rev.pl blib/lib/dbixs_rev.pl
cp lib/DBI/Const/GetInfoType.pm blib/lib/DBI/Const/GetInfoType.pm
cp lib/DBI/Gofer/Serializer/DataDumper.pm
blib/lib/DBI/Gofer/Serializer/DataDumper.pm
cp lib/DBI/DBD/Metadata.pm blib/lib/DBI/DBD/Metadata.pm
cp lib/DBD/Gofer/Transport/pipeone.pm blib/lib/DBD/Gofer/Transport/pipeone.pm
cp lib/DBI/Const/GetInfo/ODBC.pm blib/lib/DBI/Const/GetInfo/ODBC.pm
cp lib/DBI/ProfileDumper/Apache.pm blib/lib/DBI/ProfileDumper/Apache.pm
cp Driver.xst blib/arch/auto/DBI/Driver.xst
cp lib/DBD/File.pm blib/lib/DBD/File.pm
cp lib/DBI/Util/CacheMemory.pm blib/lib/DBI/Util/CacheMemory.pm
cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm
cp lib/DBI/ProfileSubs.pm blib/lib/DBI/ProfileSubs.pm
cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h
cp lib/DBD/Gofer.pm blib/lib/DBD/Gofer.pm
cp dbivport.h blib/arch/auto/DBI/dbivport.h
cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h
cp dbixs_rev.h blib/arch/auto/DBI/dbixs_rev.h
cp lib/DBD/Gofer/Transport/Base.pm blib/lib/DBD/Gofer/Transport/Base.pm
cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm
cp lib/DBD/Gofer/Policy/rush.pm blib/lib/DBD/Gofer/Policy/rush.pm
cp lib/DBI/SQL/Nano.pm blib/lib/DBI/SQL/Nano.pm
cp lib/DBI/Gofer/Request.pm blib/lib/DBI/Gofer/Request.pm
cp lib/DBI/Const/GetInfo/ANSI.pm blib/lib/DBI/Const/GetInfo/ANSI.pm
cp lib/DBD/Gofer/Transport/stream.pm blib/lib/DBD/Gofer/Transport/stream.pm
cp lib/DBD/Gofer/Policy/classic.pm blib/lib/DBD/Gofer/Policy/classic.pm
cp lib/DBI/Const/GetInfoReturn.pm blib/lib/DBI/Const/GetInfoReturn.pm
cp lib/DBD/Gofer/Policy/Base.pm blib/lib/DBD/Gofer/Policy/Base.pm
cp DBI.pm blib/lib/DBI.pm
cp lib/DBI/Gofer/Serializer/Storable.pm
blib/lib/DBI/Gofer/Serializer/Storable.pm
cp lib/DBI/Gofer/Transport/stream.pm blib/lib/DBI/Gofer/Transport/stream.pm
cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm
cp lib/DBD/Gofer/Policy/pedantic.pm blib/lib/DBD/Gofer/Policy/pedantic.pm
cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm
cp lib/DBI/Gofer/Transport/pipeone.pm blib/lib/DBI/Gofer/Transport/pipeone.pm
cp lib/DBD/Gofer/Transport/null.pm blib/lib/DBD/Gofer/Transport/null.pm
cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm
cp TASKS.pod blib/lib/TASKS.pod
cp lib/DBI/Profile.pm blib/lib/DBI/Profile.pm
cp lib/DBI/ProfileDumper.pm blib/lib/DBI/ProfileDumper.pm
cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm
cp lib/DBI/Gofer/Serializer/Base.pm blib/lib/DBI/Gofer/Serializer/Base.pm
cp dbipport.h blib/arch/auto/DBI/dbipport.h
cp lib/DBI/Gofer/Execute.pm blib/lib/DBI/Gofer/Execute.pm
cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm
cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm
cp lib/DBI/PurePerl.pm blib/lib/DBI/PurePerl.pm
cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm
cp lib/DBI/ProfileData.pm blib/lib/DBI/ProfileData.pm
/opt/local/bin/perl -p -e "s/~DRIVER~/Perl/g" ./Driver.xst > Perl.xsi
/opt/local/bin/perl /opt/local/lib/perl5/5.8.9/ExtUtils/xsubpp -typemap
/opt/local/lib/perl5/5.8.9/ExtUtils/typemap -typemap typemap Perl.xs >
Perl.xsc && mv Perl.xsc Perl.c
/usr/bin/gcc-4.2 -c -fno-common -DPERL_DARWIN -I/opt/local/include
-no-cpp-precomp -fno-strict-aliasing -pipe -I/usr/local/include
-I/opt/local/include -O3 -DVERSION=\"1.609\" -DXS_VERSION=\"1.609\"
"-I/opt/local/lib/perl5/5.8.9/darwin-2level/CORE" -W -Wall
-Wpointer-arith -Wbad-function-cast -Wno-comment -Wno-sign-compare
-Wno-cast-qual -Wmissing-noreturn -Wno-unused-parameter -DDBI_NO_THREADS
Perl.c
/opt/local/bin/perl /opt/local/lib/perl5/5.8.9/ExtUtils/xsubpp -typemap
/opt/local/lib/perl5/5.8.9/ExtUtils/typemap -typemap typemap DBI.xs >
DBI.xsc && mv DBI.xsc DBI.c
/usr/bin/gcc-4.2 -c -fno-common -DPERL_DARWIN -I/opt/local/include
-no-cpp-precomp -fno-strict-aliasing -pipe -I/usr/local/include
-I/opt/local/include -O3 -DVERSION=\"1.609\" -DXS_VERSION=\"1.609\"
"-I/opt/local/lib/perl5/5.8.9/darwin-2level/CORE" -W -Wall
-Wpointer-arith -Wbad-function-cast -Wno-comment -Wno-sign-compare
-Wno-cast-qual -Wmissing-noreturn -Wno-unused-parameter -DDBI_NO_THREADS
DBI.c
DBI.xs: In function 'set_err_sv':
DBI.xs:623: warning: value computed is not used
DBI.xs: In function 'dbih_setup_handle':
DBI.xs:1289: warning: value computed is not used
DBI.xs:1290: warning: value computed is not used
DBI.xs:1295: warning: value computed is not used
DBI.xs:1298: warning: value computed is not used
DBI.xs: In function 'dbih_set_attr_k':
DBI.xs:1926: warning: value computed is not used
DBI.xs: In function 'dbih_get_attr_k':
DBI.xs:2017: warning: value computed is not used
DBI.xs:2241: warning: value computed is not used
DBI.xs: In function '_profile_next_node':
DBI.xs:2447: warning: value computed is not used
DBI.xs: In function 'XS_DBI_dispatch':
DBI.xs:3000: warning: value computed is not used
DBI.xs:3075: warning: value computed is not used
DBI.xs: In function 'XS_DBI__new_handle':
DBI.xs:4092: warning: value computed is not used
DBI.xs: In function 'XS_DBD_____st_fetchrow_hashref':
DBI.xs:4801: warning: value computed is not used
Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
rm -f blib/arch/auto/DBI/DBI.bundle
env MACOSX_DEPLOYMENT_TARGET=10.3 /usr/bin/gcc-4.2 -L/opt/local/lib
-bundle -undefined dynamic_lookup -L/usr/local/lib DBI.o -o
blib/arch/auto/DBI/DBI.bundle \
\
chmod 755 blib/arch/auto/DBI/DBI.bundle
cp DBI.bs blib/arch/auto/DBI/DBI.bs
chmod 644 blib/arch/auto/DBI/DBI.bs
/opt/local/bin/perl "-Iblib/arch" "-Iblib/lib" dbiprof.PL dbiprof
Extracted dbiprof from dbiprof.PL with variable substitutions.
dbiprof syntax OK
cp dbiprof blib/script/dbiprof
/opt/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbiprof
/opt/local/bin/perl "-Iblib/arch" "-Iblib/lib" dbiproxy.PL dbiproxy
Extracted dbiproxy from dbiproxy.PL with variable substitutions.
dbiproxy syntax OK
cp dbiproxy blib/script/dbiproxy
/opt/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbiproxy
/opt/local/bin/perl "-Iblib/arch" "-Iblib/lib" dbilogstrip.PL dbilogstrip
Extracted dbilogstrip from dbilogstrip.PL with variable substitutions.
dbilogstrip syntax OK
cp dbilogstrip blib/script/dbilogstrip
/opt/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)"
blib/script/dbilogstrip
Manifying blib/man1/dbiprof.1pm
Manifying blib/man1/dbiproxy.1pm
Manifying blib/man1/dbilogstrip.1pm
Manifying blib/man3/DBI::Gofer::Response.3pm
Manifying blib/man3/DBD::Proxy.3pm
Manifying blib/man3/DBI::Gofer::Transport::Base.3pm
Manifying blib/man3/DBD::DBM.3pm
Manifying blib/man3/DBI::Gofer::Serializer::DataDumper.3pm
Manifying blib/man3/DBI::Const::GetInfoType.3pm
Manifying blib/man3/Roadmap.3pm
Manifying blib/man3/DBI::DBD::Metadata.3pm
Manifying blib/man3/DBI::Const::GetInfo::ODBC.3pm
Manifying blib/man3/DBD::Gofer::Transport::pipeone.3pm
Manifying blib/man3/DBI::ProfileDumper::Apache.3pm
Manifying blib/man3/DBD::File.3pm
Manifying blib/man3/DBI::Util::CacheMemory.3pm
Manifying blib/man3/DBI::ProfileSubs.3pm
Manifying blib/man3/DBD::Gofer.3pm
Manifying blib/man3/DBD::Gofer::Transport::Base.3pm
Manifying blib/man3/DBI::FAQ.3pm
Manifying blib/man3/DBD::Gofer::Policy::rush.3pm
Manifying blib/man3/DBI::SQL::Nano.3pm
Manifying blib/man3/DBI::Gofer::Request.3pm
Manifying blib/man3/DBI::Const::GetInfo::ANSI.3pm
Manifying blib/man3/DBD::Gofer::Transport::stream.3pm
Manifying blib/man3/DBD::Gofer::Policy::classic.3pm
Manifying blib/man3/DBI::Gofer::Transport::stream.3pm
Manifying blib/man3/DBI::Gofer::Serializer::Storable.3pm
Manifying blib/man3/DBI.3pm
Manifying blib/man3/DBD::Gofer::Policy::Base.3pm
Manifying blib/man3/DBI::Const::GetInfoReturn.3pm
Manifying blib/man3/DBD::Sponge.3pm
Manifying blib/man3/DBD::Gofer::Policy::pedantic.3pm
Manifying blib/man3/DBI::Gofer::Transport::pipeone.3pm
Manifying blib/man3/DBI::W32ODBC.3pm
Manifying blib/man3/DBD::Gofer::Transport::null.3pm
Manifying blib/man3/Bundle::DBI.3pm
Manifying blib/man3/TASKS.3pm
Manifying blib/man3/DBI::Profile.3pm
Manifying blib/man3/DBI::ProfileDumper.3pm
Manifying blib/man3/DBI::Gofer::Serializer::Base.3pm
Manifying blib/man3/DBI::ProxyServer.3pm
Manifying blib/man3/DBI::Gofer::Execute.3pm
Manifying blib/man3/DBI::DBD.3pm
Manifying blib/man3/Win32::DBIODBC.3pm
Manifying blib/man3/DBI::PurePerl.3pm
Manifying blib/man3/DBI::ProfileData.3pm
___________________________________________________________________________
MAKE TEST
PERL_DL_NONLAZY=1 /opt/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01basics................ok
4/130 skipped: various reasons
t/02dbidrv................ok
t/03handle................ok
t/04mods..................ok
t/05concathash............ok
t/06attrs.................ok
t/07kids..................ok
t/08keeperr...............ok
t/09trace.................ok
t/10examp.................ok
t/11fetch.................ok
t/12quote.................ok
t/13taint.................ok
t/14utf8..................ok
t/15array.................ok
t/19fhtrace...............ok
t/20meta..................ok
t/30subclass..............ok
t/35thrclone..............skipped
all skipped: this darwin perl 5.008009 not supported for DBI iThreads
t/40profile...............ok
t/41prof_dump.............ok
1/15 skipped: various reasons
t/42prof_data.............ok
t/43prof_env..............ok
t/50dbm...................ok
t/60preparse..............ok
t/65transact..............ok
t/70callbacks.............ok
t/72childhandles..........ok
t/80proxy.................skipped
all skipped: modules required for proxy are probably not installed
(e.g., RPC/PlClient.pm)
t/85gofer.................ok
18/234 skipped: various reasons
t/86gofer_fail............ok
t/87gofer_cache...........ok
t/pod-coverage............skipped
all skipped: Test::Pod::Coverage 1.04 required for testing POD
coverage
t/pod.....................skipped
all skipped: Test::Pod 1.00 required for testing POD
t/zvg_01basics............ok
4/130 skipped: various reasons
t/zvg_02dbidrv............ok
t/zvg_03handle............ok
44/137 skipped: various reasons
t/zvg_04mods..............ok
t/zvg_05concathash........ok
t/zvg_06attrs.............ok
2/145 skipped: various reasons
t/zvg_07kids..............ok
t/zvg_08keeperr...........ok
t/zvg_09trace.............ok
t/zvg_10examp.............ok
t/zvg_11fetch.............ok
t/zvg_12quote.............ok
1/10 skipped: various reasons
t/zvg_13taint.............skipped
all skipped: Taint attribute tests not functional with DBI_AUTOPROXY
t/zvg_14utf8..............ok
t/zvg_15array.............ok
t/zvg_19fhtrace...........ok
t/zvg_20meta..............ok
t/zvg_30subclass..........ok
t/zvg_35thrclone..........skipped
all skipped: this darwin perl 5.008009 not supported for DBI iThreads
t/zvg_40profile...........ok
t/zvg_41prof_dump.........ok
1/15 skipped: various reasons
t/zvg_42prof_data.........ok
t/zvg_43prof_env..........ok
t/zvg_50dbm...............ok
2/14 skipped: various reasons
t/zvg_60preparse..........ok
t/zvg_65transact..........skipped
all skipped: Transactions not supported by DBD::Gofer
t/zvg_70callbacks.........ok
t/zvg_72childhandles......ok
2/16 skipped: various reasons
t/zvg_80proxy.............skipped
all skipped: modules required for proxy are probably not installed
(e.g., RPC/PlClient.pm)
t/zvg_85gofer.............ok
45/234 skipped: various reasons
t/zvg_86gofer_fail........skipped
all skipped: Gofer DBI_AUTOPROXY
t/zvg_87gofer_cache.......skipped
all skipped: Gofer DBI_AUTOPROXY
t/zvp_01basics............ok
6/130 skipped: various reasons
t/zvp_02dbidrv............ok
10/53 skipped: various reasons
t/zvp_03handle............ok
57/137 skipped: various reasons
t/zvp_04mods..............ok
t/zvp_05concathash........ok
t/zvp_06attrs.............ok
7/145 skipped: various reasons
t/zvp_07kids..............skipped
all skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zvp_08keeperr...........ok
t/zvp_09trace.............ok
t/zvp_10examp.............ok
3/210 skipped: various reasons
t/zvp_11fetch.............ok
t/zvp_12quote.............ok
t/zvp_13taint.............skipped
all skipped: Taint attributes not supported with DBI::PurePerl
t/zvp_14utf8..............ok
t/zvp_15array.............ok
t/zvp_19fhtrace...........ok
t/zvp_20meta..............ok
t/zvp_30subclass..........ok
t/zvp_35thrclone..........skipped
all skipped: this darwin perl 5.008009 not supported for DBI iThreads
t/zvp_40profile...........skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvp_41prof_dump.........skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvp_42prof_data.........skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvp_43prof_env..........skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvp_50dbm...............ok
t/zvp_60preparse..........skipped
all skipped: preparse not supported for DBI::PurePerl
t/zvp_65transact..........ok
t/zvp_70callbacks.........skipped
all skipped: $h->{Callbacks} attribute not supported for
DBI::PurePerl
t/zvp_72childhandles......ok
t/zvp_80proxy.............skipped
all skipped: modules required for proxy are probably not installed
(e.g., RPC/PlClient.pm)
t/zvp_85gofer.............ok
18/234 skipped: various reasons
t/zvp_86gofer_fail........skipped
all skipped: requires Callbacks which are not supported with PurePerl
t/zvp_87gofer_cache.......ok
t/zvxgp_01basics..........ok
6/130 skipped: various reasons
t/zvxgp_02dbidrv..........ok
10/53 skipped: various reasons
t/zvxgp_03handle..........ok
76/137 skipped: various reasons
t/zvxgp_04mods............ok
t/zvxgp_05concathash......ok
t/zvxgp_06attrs...........ok
9/145 skipped: various reasons
t/zvxgp_07kids............skipped
all skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zvxgp_08keeperr.........ok
t/zvxgp_09trace...........ok
t/zvxgp_10examp...........ok
3/210 skipped: various reasons
t/zvxgp_11fetch...........ok
t/zvxgp_12quote...........ok
1/10 skipped: various reasons
t/zvxgp_13taint...........skipped
all skipped: Taint attributes not supported with DBI::PurePerl
t/zvxgp_14utf8............ok
t/zvxgp_15array...........ok
t/zvxgp_19fhtrace.........ok
t/zvxgp_20meta............ok
t/zvxgp_30subclass........ok
t/zvxgp_35thrclone........skipped
all skipped: this darwin perl 5.008009 not supported for DBI iThreads
t/zvxgp_40profile.........skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvxgp_41prof_dump.......skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvxgp_42prof_data.......skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvxgp_43prof_env........skipped
all skipped: profiling not supported for DBI::PurePerl
t/zvxgp_50dbm.............ok
2/14 skipped: various reasons
t/zvxgp_60preparse........skipped
all skipped: preparse not supported for DBI::PurePerl
t/zvxgp_65transact........skipped
all skipped: Transactions not supported by DBD::Gofer
t/zvxgp_70callbacks.......skipped
all skipped: $h->{Callbacks} attribute not supported for
DBI::PurePerl
t/zvxgp_72childhandles....ok
2/16 skipped: various reasons
t/zvxgp_80proxy...........skipped
all skipped: modules required for proxy are probably not installed
(e.g., RPC/PlClient.pm)
t/zvxgp_85gofer...........ok
45/234 skipped: various reasons
t/zvxgp_86gofer_fail......skipped
all skipped: requires Callbacks which are not supported with PurePerl
t/zvxgp_87gofer_cache.....skipped
all skipped: Gofer DBI_AUTOPROXY
All tests successful, 34 tests and 379 subtests skipped.
Files=130, Tests=5825, 46 wallclock secs (36.79 cusr + 6.54 csys = 43.33
CPU)
PERL_DL_NONLAZY=1 /opt/local/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
test.pl
DBI test application $Revision: 12537 $
Switch: DBI 1.609 by Tim Bunce, 1.609
Available Drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql
dbi:ExampleP:: testing 3 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...
connect 20 and disconnect them, 3 times: 0.0032s / 60 = 0.0001s
Testing handle creation speed...
44444 NullP sth/s perl 5.008009 darwin-2level (gcc 4.2.1 -O3) 0.000023s
test.pl done
___________________________________________________________________________
MAKE INSTALL
peter-hesps-macbook:DBI-1.609 peterhesp$ sudo make install
Password:
Manifying blib/man1/dbiproxy.1pm
Manifying blib/man1/dbilogstrip.1pm
Files found in blib/arch: installing files in blib/lib into architecture
dependent library tree
Writing /opt/local/lib/perl5/site_perl/5.8.9/darwin-2level/auto/DBI/.packlist
Appending installation info to
/opt/local/lib/perl5/5.8.9/darwin-2level/perllocal.pod
___________________________________________________________________________
PERL -V
peter-hesps-macbook:cgi-bin peterhesp$ perl -V
Summary of my perl5 (revision 5 version 8 subversion 9) configuration:
Platform:
osname=darwin, osvers=10.2.0, archname=darwin-2level
uname='darwin peter-hesps-macbook.local 10.2.0 darwin kernel version
10.2.0: tue nov 3 10:37:10 pst 2009; root:xnu-1486.2.11~1release_i386
i386 '
config_args='-des -D prefix=/opt/local -D scriptdir=/opt/local/bin -D
cppflags=-I/opt/local/include -D ldflags=-L/opt/local/lib -D
vendorprefix=/opt/local -D man1ext=1pm -D man3ext=3pm -D
cc=/usr/bin/gcc-4.2 -D ld=/usr/bin/gcc-4.2 -D
man1dir=/opt/local/share/man/man1p -D
man3dir=/opt/local/share/man/man3p -D
siteman1dir=/opt/local/share/man/man1 -D
siteman3dir=/opt/local/share/man/man3 -D
vendorman1dir=/opt/local/share/man/man1 -D
vendorman3dir=/opt/local/share/man/man3 -D inc_version_list=5.8.8
5.8.8/darwin-2level'
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=define use64bitall=define uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='/usr/bin/gcc-4.2', ccflags ='-fno-common -DPERL_DARWIN
-I/opt/local/include -no-cpp-precomp -fno-strict-aliasing -pipe
-I/usr/local/include -I/opt/local/include',
optimize='-O3',
cppflags='-I/opt/local/include -no-cpp-precomp -fno-common
-DPERL_DARWIN -I/opt/local/include -no-cpp-precomp
-fno-strict-aliasing -pipe -I/usr/local/include -I/opt/local/include'
ccversion='', gccversion='4.2.1 (Apple Inc. build 5646)', gccosandvers=''
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld='env MACOSX_DEPLOYMENT_TARGET=10.3 /usr/bin/gcc-4.2', ldflags
='-L/opt/local/lib -L/usr/local/lib'
libpth=/usr/local/lib /opt/local/lib /usr/lib
libs=-ldbm -ldl -lm -lutil -lc
perllibs=-ldl -lm -lutil -lc
libc=/usr/lib/libc.dylib, so=dylib, useshrplib=false, libperl=libperl.a
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=bundle, d_dlsymun=undef, ccdlflags=' '
cccdlflags=' ', lddlflags='-L/opt/local/lib -bundle -undefined
dynamic_lookup -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT
USE_FAST_STDIO USE_LARGE_FILES USE_PERLIO
Built under darwin
Compiled at Dec 18 2009 11:58:21
@INC:
/opt/local/lib/perl5/site_perl/5.8.9/darwin-2level
/opt/local/lib/perl5/site_perl/5.8.9
/opt/local/lib/perl5/site_perl
/opt/local/lib/perl5/vendor_perl/5.8.9/darwin-2level
/opt/local/lib/perl5/vendor_perl/5.8.9
/opt/local/lib/perl5/vendor_perl
/opt/local/lib/perl5/5.8.9/darwin-2level
/opt/local/lib/perl5/5.8.9
.
___________________________________________________________________________
A TEST SCRIPT TO CONNECT TO THE DB
#!/opt/local/bin/perl -w
use strict;
use DBI;
my ( $user, $passwd, $connString);
($connString, $user, $passwd) =
("dbi:mysql:database=contacts;host=localhost", 'root','*******');
my $dbh = DBI->connect($connString)
or die "Couldn't connect to database: " . DBI->errstr;
my $sth = $dbh->prepare('SELECT * FROM people ')
or die "Couldn't prepare statement: " . $dbh->errstr;
$sth->execute() ;
AND ITS OUTPUT
peter-hesps-macbook:cgi-bin peterhesp$ ./th_db.pl
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
Referenced from:
/opt/local/lib/perl5/site_perl/5.8.9/darwin-2level/auto/DBD/mysql/mysql.bundle
Expected in: dynamic lookup
dyld: Symbol not found: _mysql_init
Referenced from:
/opt/local/lib/perl5/site_perl/5.8.9/darwin-2level/auto/DBD/mysql/mysql.bundle
Expected in: dynamic lookup
Trace/BPT trap
