Perl - 第二十三章 | Perl DBD、DBI::mysql模組安裝

在為了下一章節開始前，必須的前置準備，Perl需要安裝DBI、DBD::mysql模組，本來使用以下指令就可以解決：

for MacOS

1 2	$ cpan DBI $ cpan DBD:mysql

但是⋯事情不是這麼單純⋯

查看已安裝 Perl 模組

NinGoo的檢測系統中已經安裝的Perl模組，寫一個check_module.pl程式碼如下：

#!/usr/bin/perl

use ExtUtils::Installed;
my $inst = ExtUtils::Installed->new();
print join "\n",$inst->modules();
print"\n";

首次執行：

$ ./check_module.pl
App::cpanminus
Bundle::NetSNMP
Devel::CheckLib
ExtUtils::PkgConfig
JSON
JSON::Parse
Mock::Config
Perl
install
mod_perl2

假設成功安裝完DBI、DBD::mysql模組：

$ ./check_module.pl
App::cpanminus
Bundle::NetSNMP
DBD::mysql
DBI
Devel::CheckLib
ExtUtils::PkgConfig
JSON
JSON::Parse
Mock::Config
Perl
install
mod_perl2

編譯安裝

使用 cpan 直接安裝的時候，會有很多例外情況發生；後面我也是手動編譯安裝後成功安裝。

安裝 DBI-1.643

下載DBI-1.643
解壓縮DBI-1.643
cd 到DBI-1.643目錄

sudo perl Makefile.PL

執行訊息

*** Your LANG environment variable is set to 'zh_TW.UTF-8'
*** This may cause problems for some perl installations.
*** If you get test failures, please try again with LANG unset.
*** If that then works, please email dbi-dev@perl.org with details
*** including the output of 'perl -V'

Your perl was compiled with gcc (version 4.2.1 Compatible Apple LLVM 11.0.3 (clang-1103.0.29.20) (-macos10.15-objc-selector-opts)), okay.
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_16destroy.t
t/zvg_17handle_error.t
t/zvg_19fhtrace.t
t/zvg_20meta.t
t/zvg_30subclass.t
t/zvg_31methcache.t
t/zvg_35thrclone.t (use threads)
t/zvg_40profile.t
t/zvg_41prof_dump.t
t/zvg_42prof_data.t
t/zvg_43prof_env.t
t/zvg_48dbi_dbd_sqlengine.t
t/zvg_49dbd_file.t
t/zvg_50dbm_simple.t
t/zvg_51dbm_file.t
t/zvg_52dbm_complex.t
t/zvg_53sqlengine_adv.t
t/zvg_54_dbd_mem.t
t/zvg_60preparse.t
t/zvg_65transact.t
t/zvg_70callbacks.t
t/zvg_72childhandles.t
t/zvg_73cachedkids.t
t/zvg_80proxy.t
t/zvg_85gofer.t
t/zvg_86gofer_fail.t
t/zvg_87gofer_cache.t
t/zvg_90sql_type_cast.t
t/zvg_91_store_warning.t
Creating test wrappers for DBI::SQL::Nano:
t/zvn_48dbi_dbd_sqlengine.t
t/zvn_49dbd_file.t
t/zvn_50dbm_simple.t
t/zvn_51dbm_file.t
t/zvn_52dbm_complex.t
t/zvn_85gofer.t
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_16destroy.t
t/zvp_17handle_error.t
t/zvp_19fhtrace.t
t/zvp_20meta.t
t/zvp_30subclass.t
t/zvp_31methcache.t
t/zvp_35thrclone.t (use threads)
t/zvp_40profile.t
t/zvp_41prof_dump.t
t/zvp_42prof_data.t
t/zvp_43prof_env.t
t/zvp_48dbi_dbd_sqlengine.t
t/zvp_49dbd_file.t
t/zvp_50dbm_simple.t
t/zvp_51dbm_file.t
t/zvp_52dbm_complex.t
t/zvp_53sqlengine_adv.t
t/zvp_54_dbd_mem.t
t/zvp_60preparse.t
t/zvp_65transact.t
t/zvp_70callbacks.t
t/zvp_72childhandles.t
t/zvp_73cachedkids.t
t/zvp_80proxy.t
t/zvp_85gofer.t
t/zvp_86gofer_fail.t
t/zvp_87gofer_cache.t
t/zvp_90sql_type_cast.t
t/zvp_91_store_warning.t
Creating test wrappers for DBD::Gofer + DBI::SQL::Nano:
t/zvxgn_48dbi_dbd_sqlengine.t
t/zvxgn_49dbd_file.t
t/zvxgn_50dbm_simple.t
t/zvxgn_51dbm_file.t
t/zvxgn_52dbm_complex.t
t/zvxgn_85gofer.t
Creating test wrappers for DBD::Gofer + DBI::PurePerl:
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_16destroy.t
t/zvxgp_17handle_error.t
t/zvxgp_19fhtrace.t
t/zvxgp_20meta.t
t/zvxgp_30subclass.t
t/zvxgp_31methcache.t
t/zvxgp_35thrclone.t (use threads)
t/zvxgp_40profile.t
t/zvxgp_41prof_dump.t
t/zvxgp_42prof_data.t
t/zvxgp_43prof_env.t
t/zvxgp_48dbi_dbd_sqlengine.t
t/zvxgp_49dbd_file.t
t/zvxgp_50dbm_simple.t
t/zvxgp_51dbm_file.t
t/zvxgp_52dbm_complex.t
t/zvxgp_53sqlengine_adv.t
t/zvxgp_54_dbd_mem.t
t/zvxgp_60preparse.t
t/zvxgp_65transact.t
t/zvxgp_70callbacks.t
t/zvxgp_72childhandles.t
t/zvxgp_73cachedkids.t
t/zvxgp_80proxy.t
t/zvxgp_85gofer.t
t/zvxgp_86gofer_fail.t
t/zvxgp_87gofer_cache.t
t/zvxgp_90sql_type_cast.t
t/zvxgp_91_store_warning.t
Creating test wrappers for DBI::SQL::Nano + DBI::PurePerl:
t/zvxnp_48dbi_dbd_sqlengine.t
t/zvxnp_49dbd_file.t
t/zvxnp_50dbm_simple.t
t/zvxnp_51dbm_file.t
t/zvxnp_52dbm_complex.t
t/zvxnp_85gofer.t
Creating test wrappers for DBD::Gofer + DBI::SQL::Nano + DBI::PurePerl:
t/zvxgnp_48dbi_dbd_sqlengine.t
t/zvxgnp_49dbd_file.t
t/zvxgnp_50dbm_simple.t
t/zvxgnp_51dbm_file.t
t/zvxgnp_52dbm_complex.t
t/zvxgnp_85gofer.t
Checking if your kit is complete...
Looks good

    I see you're using perl 5.018004 on darwin-thread-multi-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
Writing MYMETA.yml and MYMETA.json

sudo make

執行訊息

/usr/bin/perl -MExtUtils::Command -e 'mkpath' -- blib/lib/DBI
rm -f blib/lib/DBI/Changes.pm
cp Changes blib/lib/DBI/Changes.pm
cp lib/DBI/Gofer/Transport/pipeone.pm blib/lib/DBI/Gofer/Transport/pipeone.pm
cp lib/DBI/ProfileDumper/Apache.pm blib/lib/DBI/ProfileDumper/Apache.pm
cp lib/DBI/Gofer/Transport/Base.pm blib/lib/DBI/Gofer/Transport/Base.pm
cp lib/DBI/Const/GetInfo/ANSI.pm blib/lib/DBI/Const/GetInfo/ANSI.pm
cp lib/DBI/Const/GetInfoType.pm blib/lib/DBI/Const/GetInfoType.pm
cp lib/DBD/Gofer/Policy/Base.pm blib/lib/DBD/Gofer/Policy/Base.pm
cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm
cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm
cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm
cp lib/DBI/Util/CacheMemory.pm blib/lib/DBI/Util/CacheMemory.pm
cp lib/DBD/Gofer/Transport/Base.pm blib/lib/DBD/Gofer/Transport/Base.pm
cp lib/DBI/Const/GetInfo/ODBC.pm blib/lib/DBI/Const/GetInfo/ODBC.pm
cp lib/DBD/File.pm blib/lib/DBD/File.pm
cp lib/DBI/ProfileSubs.pm blib/lib/DBI/ProfileSubs.pm
cp lib/DBI/Gofer/Serializer/Storable.pm blib/lib/DBI/Gofer/Serializer/Storable.pm
cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm
cp dbixs_rev.pl blib/lib/dbixs_rev.pl
cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h
cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm
cp lib/DBD/Mem.pm blib/lib/DBD/Mem.pm
cp lib/DBI/Const/GetInfoReturn.pm blib/lib/DBI/Const/GetInfoReturn.pm
cp lib/DBD/Gofer/Transport/pipeone.pm blib/lib/DBD/Gofer/Transport/pipeone.pm
cp lib/DBD/Gofer/Transport/corostream.pm blib/lib/DBD/Gofer/Transport/corostream.pm
cp dbipport.h blib/arch/auto/DBI/dbipport.h
cp lib/DBD/Gofer/Policy/classic.pm blib/lib/DBD/Gofer/Policy/classic.pm
cp lib/DBD/Gofer/Transport/stream.pm blib/lib/DBD/Gofer/Transport/stream.pm
cp lib/DBD/Gofer/Policy/pedantic.pm blib/lib/DBD/Gofer/Policy/pedantic.pm
cp lib/DBI/Gofer/Serializer/Base.pm blib/lib/DBI/Gofer/Serializer/Base.pm
cp lib/DBI/Gofer/Transport/stream.pm blib/lib/DBI/Gofer/Transport/stream.pm
cp Driver.xst blib/arch/auto/DBI/Driver.xst
cp lib/DBD/File/Roadmap.pod blib/lib/DBD/File/Roadmap.pod
cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm
cp DBI.pm blib/lib/DBI.pm
cp lib/DBD/File/Developers.pod blib/lib/DBD/File/Developers.pod
cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm
cp lib/DBI/DBD/SqlEngine/Developers.pod blib/lib/DBI/DBD/SqlEngine/Developers.pod
cp lib/DBI/SQL/Nano.pm blib/lib/DBI/SQL/Nano.pm
cp DBIXS.h blib/arch/auto/DBI/DBIXS.h
cp lib/DBI/DBD/Metadata.pm blib/lib/DBI/DBD/Metadata.pm
cp lib/DBI/Gofer/Response.pm blib/lib/DBI/Gofer/Response.pm
cp lib/DBI/Gofer/Serializer/DataDumper.pm blib/lib/DBI/Gofer/Serializer/DataDumper.pm
cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm
cp lib/DBD/Gofer.pm blib/lib/DBD/Gofer.pm
cp lib/DBI/Profile.pm blib/lib/DBI/Profile.pm
cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm
cp dbixs_rev.h blib/arch/auto/DBI/dbixs_rev.h
cp lib/DBI/ProfileData.pm blib/lib/DBI/ProfileData.pm
cp lib/DBI/DBD/SqlEngine/HowTo.pod blib/lib/DBI/DBD/SqlEngine/HowTo.pod
cp dbivport.h blib/arch/auto/DBI/dbivport.h
cp lib/DBI/ProfileDumper.pm blib/lib/DBI/ProfileDumper.pm
cp lib/DBI/Gofer/Request.pm blib/lib/DBI/Gofer/Request.pm
cp lib/DBI/Gofer/Execute.pm blib/lib/DBI/Gofer/Execute.pm
cp lib/DBI/DBD/SqlEngine.pm blib/lib/DBI/DBD/SqlEngine.pm
cp lib/DBI/Util/_accessor.pm blib/lib/DBI/Util/_accessor.pm
cp lib/DBD/Gofer/Policy/rush.pm blib/lib/DBD/Gofer/Policy/rush.pm
cp lib/DBI/PurePerl.pm blib/lib/DBI/PurePerl.pm
cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm
cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h
cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h
cp lib/DBD/File/HowTo.pod blib/lib/DBD/File/HowTo.pod
cp lib/DBD/Gofer/Transport/null.pm blib/lib/DBD/Gofer/Transport/null.pm
/usr/bin/perl -p -e "s/~DRIVER~/Perl/g" ./Driver.xst > Perl.xsi
/usr/bin/perl /System/Library/Perl/5.18/ExtUtils/xsubpp  -typemap /System/Library/Perl/5.18/ExtUtils/typemap -typemap typemap  Perl.xs > Perl.xsc && mv Perl.xsc Perl.c
cc -c   -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os   -DVERSION=\"1.643\" -DXS_VERSION=\"1.643\"  -iwithsysroot "/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE"  -W -Wall -Wpointer-arith -Wbad-function-cast -Wno-comment -Wno-sign-compare -Wno-cast-qual -Wmissing-noreturn -Wno-unused-parameter Perl.c
/usr/bin/perl /System/Library/Perl/5.18/ExtUtils/xsubpp  -typemap /System/Library/Perl/5.18/ExtUtils/typemap -typemap typemap  DBI.xs > DBI.xsc && mv DBI.xsc DBI.c
cc -c   -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os   -DVERSION=\"1.643\" -DXS_VERSION=\"1.643\"  -iwithsysroot "/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE"  -W -Wall -Wpointer-arith -Wbad-function-cast -Wno-comment -Wno-sign-compare -Wno-cast-qual -Wmissing-noreturn -Wno-unused-parameter DBI.c
Running Mkbootstrap for DBI ()
chmod 644 DBI.bs
rm -f blib/arch/auto/DBI/DBI.bundle
cc  -bundle -undefined dynamic_lookup -fstack-protector 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
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiproxy.PL dbiproxy
Extracted dbiproxy from dbiproxy.PL with variable substitutions.
cp dbiproxy blib/script/dbiproxy
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/dbiproxy
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbilogstrip.PL dbilogstrip
Extracted dbilogstrip from dbilogstrip.PL with variable substitutions.
cp dbilogstrip blib/script/dbilogstrip
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/dbilogstrip
/usr/bin/perl "-Iblib/arch" "-Iblib/lib" dbiprof.PL dbiprof
Extracted dbiprof from dbiprof.PL with variable substitutions.
cp dbiprof blib/script/dbiprof
/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/dbiprof
Manifying blib/man1/dbiprof.1
Manifying blib/man1/dbilogstrip.1
Manifying blib/man1/dbiproxy.1
Manifying blib/man3/DBD::Gofer::Policy::pedantic.3pm
Manifying blib/man3/DBI::DBD.3pm
Manifying blib/man3/DBI::Const::GetInfoReturn.3pm
Manifying blib/man3/DBI::Gofer::Execute.3pm
Manifying blib/man3/DBI::Profile.3pm
Manifying blib/man3/DBD::File.3pm
Manifying blib/man3/DBD::File::HowTo.3pm
Manifying blib/man3/DBI::ProfileDumper.3pm
Manifying blib/man3/DBD::Gofer::Transport::pipeone.3pm
Manifying blib/man3/DBD::Gofer::Policy::classic.3pm
Manifying blib/man3/DBI::Const::GetInfo::ODBC.3pm
Manifying blib/man3/DBD::Gofer::Transport::Base.3pm
Manifying blib/man3/DBI::ProfileDumper::Apache.3pm
Manifying blib/man3/DBI::DBD::SqlEngine::Developers.3pm
Manifying blib/man3/DBI::Gofer::Serializer::Base.3pm
Manifying blib/man3/Bundle::DBI.3pm
Manifying blib/man3/DBD::Gofer::Transport::corostream.3pm
Manifying blib/man3/DBI::Gofer::Transport::stream.3pm
Manifying blib/man3/DBI::Gofer::Serializer::Storable.3pm
Manifying blib/man3/DBD::Gofer::Policy::rush.3pm
Manifying blib/man3/DBI::ProxyServer.3pm
Manifying blib/man3/DBI::SQL::Nano.3pm
Manifying blib/man3/DBI::W32ODBC.3pm
Manifying blib/man3/DBI::Gofer::Transport::Base.3pm
Manifying blib/man3/DBI::ProfileData.3pm
Manifying blib/man3/DBD::Sponge.3pm
Manifying blib/man3/DBI::DBD::Metadata.3pm
Manifying blib/man3/DBI::Gofer::Response.3pm
Manifying blib/man3/DBI::Const::GetInfo::ANSI.3pm
Manifying blib/man3/DBI::Gofer::Serializer::DataDumper.3pm
Manifying blib/man3/DBI::DBD::SqlEngine.3pm
Manifying blib/man3/DBD::File::Developers.3pm
Manifying blib/man3/DBI::Util::CacheMemory.3pm
Manifying blib/man3/DBD::Gofer::Transport::stream.3pm
Manifying blib/man3/DBI::Const::GetInfoType.3pm
Manifying blib/man3/DBI::PurePerl.3pm
Manifying blib/man3/DBD::Gofer.3pm
Manifying blib/man3/DBD::Gofer::Transport::null.3pm
Manifying blib/man3/DBD::Proxy.3pm
Manifying blib/man3/DBD::DBM.3pm
Manifying blib/man3/DBI::Gofer::Request.3pm
Manifying blib/man3/DBD::Mem.3pm
Manifying blib/man3/DBI::DBD::SqlEngine::HowTo.3pm
Manifying blib/man3/DBI::ProfileSubs.3pm
Manifying blib/man3/DBD::File::Roadmap.3pm
Manifying blib/man3/DBI::Gofer::Transport::pipeone.3pm
Manifying blib/man3/Win32::DBIODBC.3pm
Manifying blib/man3/DBD::Gofer::Policy::Base.3pm
Manifying blib/man3/DBI.3pm

sudo make test

執行訊息

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01basics.t .................... # --- Perl 5.018004 on darwin-thread-multi-2level
t/01basics.t .................... ok
t/02dbidrv.t .................... 1/54 SV = IV(0x7f92a30d1ed8) at 0x7f92a30d1ee8
  REFCNT = 1
  FLAGS = (ROK,READONLY)
  RV = 0x7f92a580a800
    SV = PVHV(0x7f92a500eda0) at 0x7f92a580a800
      REFCNT = 1
      FLAGS = (OBJECT,SHAREKEYS)
      STASH = 0x7f92a401d950	"DBI::dr"
      ARRAY = 0x7f92a3c28f40  (0:9, 1:6, 2:1)
      hash quality = 115.0%
      KEYS = 8
      FILL = 7
      MAX = 15
        Elt "Errstr" HASH = 0xa439cc11
        SV = IV(0x7f92a580a850) at 0x7f92a580a860
          REFCNT = 1
          FLAGS = (ROK)
          RV = 0x7f92a48b1be0
            SV = PV(0x7f92a500a1a0) at 0x7f92a48b1be0
              REFCNT = 1
              FLAGS = (PADMY,POK,pPOK)
              PV = 0x7f92a3c330f0 ""\0
              CUR = 0
              LEN = 16
        Elt "ImplementorClass" HASH = 0xe8c4da94
        SV = PV(0x7f92a500a160) at 0x7f92a48b1ac0
          REFCNT = 1
          FLAGS = (PADMY,POK,pPOK)
          PV = 0x7f92a3c3f210 "DBD::Test::OverLongxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"\0
          CUR = 319
          LEN = 320
        Elt "Version" HASH = 0xef5c7158
        SV = PV(0x7f92a500a260) at 0x7f92a58241f0
          REFCNT = 1
          FLAGS = (POK,pPOK)
          PV = 0x7f92a3c31230 "Test"\0
          CUR = 4
          LEN = 16
	(in cleanup) dbih_getcom handle DBI::dr=HASH(0x7f92a580a800) is not a DBI handle (has no magic) during global destruction.
t/02dbidrv.t .................... ok
t/03handle.t .................... ok
t/04mods.t ...................... ok
t/05concathash.t ................ ok
t/06attrs.t ..................... ok
t/07kids.t ...................... ok
t/08keeperr.t ................... ok
t/09trace.t ..................... ok
t/10examp.t ..................... Can't load 'blib/arch/auto/DBI/DBI.bundle' for module DBI: dlopen(blib/arch/auto/DBI/DBI.bundle, 2): no suitable image found.  Did find:
	file system relative paths not allowed in hardened programs at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.
 at blib/lib/DBI.pm line 284.
BEGIN failed--compilation aborted at blib/lib/DBI.pm line 284.
Compilation failed in require at t/10examp.t line 4.
BEGIN failed--compilation aborted at t/10examp.t line 4.
t/10examp.t ..................... Dubious, test returned 255 (wstat 65280, 0xff00)
No subtests run
t/11fetch.t ..................... ok
t/12quote.t ..................... Can't load 'blib/arch/auto/DBI/DBI.bundle' for module DBI: dlopen(blib/arch/auto/DBI/DBI.bundle, 2): no suitable image found.  Did find:
	file system relative paths not allowed in hardened programs at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.
 at blib/lib/DBI.pm line 284.
BEGIN failed--compilation aborted at blib/lib/DBI.pm line 284.
Compilation failed in require at t/12quote.t line 8.
BEGIN failed--compilation aborted at t/12quote.t line 8.
# Looks like your test exited with 255 before it could output anything.
t/12quote.t ..................... Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 10/10 subtests
t/13taint.t ..................... Can't load 'blib/arch/auto/DBI/DBI.bundle' for module DBI: dlopen(blib/arch/auto/DBI/DBI.bundle, 2): no suitable image found.  Did find:
	file system relative paths not allowed in hardened programs at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.
 at blib/lib/DBI.pm line 284.
BEGIN failed--compilation aborted at blib/lib/DBI.pm line 284.
Compilation failed in require at t/13taint.t line 4.
BEGIN failed--compilation aborted at t/13taint.t line 4.
t/13taint.t ..................... Dubious, test returned 255 (wstat 65280, 0xff00)
No subtests run
t/14utf8.t ...................... ok
t/15array.t ..................... ok
t/16destroy.t ................... ok
t/17handle_error.t .............. ok
t/19fhtrace.t ................... ok
t/20meta.t ...................... ok
t/30subclass.t .................. ok
t/31methcache.t ................. ok
t/35thrclone.t .................. ok
t/40profile.t ................... ok
t/41prof_dump.t ................. ok
t/42prof_data.t ................. ok
t/43prof_env.t .................. ok
t/48dbi_dbd_sqlengine.t ......... ok
t/49dbd_file.t .................. ok
t/50dbm_simple.t ................ ok
t/51dbm_file.t .................. ok
t/52dbm_complex.t ............... skipped: DBI::SQL::Nano is being used
t/53sqlengine_adv.t ............. ok
t/54_dbd_mem.t .................. ok
t/60preparse.t .................. ok
t/65transact.t .................. ok
t/70callbacks.t ................. ok
t/72childhandles.t .............. ok
t/73cachedkids.t ................ ok
t/80proxy.t ..................... skipped: modules required for proxy are probably not installed (e.g., RPC/PlClient.pm)
t/85gofer.t ..................... ok
t/86gofer_fail.t ................ ok
t/87gofer_cache.t ............... ok
t/90sql_type_cast.t ............. ok
t/91_store_warning.t ............ ok
t/pod-coverage.t ................ skipped: Test::Pod::Coverage 1.04 required for testing POD coverage
t/pod.t ......................... ok
t/zvg_01basics.t ................ # --- Perl 5.018004 on darwin-thread-multi-2level
t/zvg_01basics.t ................ ok
t/zvg_02dbidrv.t ................ 1/54 SV = IV(0x7f83090c15e8) at 0x7f83090c15f8
  REFCNT = 1
  FLAGS = (ROK,READONLY)
  RV = 0x7f830a099180
    SV = PVHV(0x7f830a097d20) at 0x7f830a099180
      REFCNT = 1
      FLAGS = (OBJECT,SHAREKEYS)
      STASH = 0x7f830904c9b0	"DBI::dr"
      ARRAY = 0x7f8309b0fe70  (0:9, 1:6, 2:1)
      hash quality = 115.0%
      KEYS = 8
      FILL = 7
      MAX = 15
        Elt "Name" HASH = 0xbabe66c1
        SV = PV(0x7f830c072620) at 0x7f830a099228
          REFCNT = 1
          FLAGS = (POK,pPOK)
          PV = 0x7f8309b0f270 "Test"\0
          CUR = 4
          LEN = 16
        Elt "FetchHashKeyName" HASH = 0x4690d0d2
        SV = PV(0x7f830c072640) at 0x7f830a0991f8
          REFCNT = 1
          FLAGS = (POK,pPOK)
          PV = 0x7f8309b0eeb0 "NAME"\0
          CUR = 4
          LEN = 16
        Elt "Errstr" HASH = 0x1064c9a4
        SV = IV(0x7f830a0991b8) at 0x7f830a0991c8
          REFCNT = 1
          FLAGS = (ROK)
          RV = 0x7f83090a9e40
            SV = PV(0x7f830c07d7d0) at 0x7f83090a9e40
              REFCNT = 1
              FLAGS = (PADMY,POK,pPOK)
              PV = 0x7f8309b0efc0 ""\0
              CUR = 0
              LEN = 16
	(in cleanup) dbih_getcom handle DBI::dr=HASH(0x7f830a099180) is not a DBI handle (has no magic) during global destruction.
t/zvg_02dbidrv.t ................ ok
t/zvg_03handle.t ................ ok
t/zvg_04mods.t .................. ok
t/zvg_05concathash.t ............ ok
t/zvg_06attrs.t ................. ok
t/zvg_07kids.t .................. ok
t/zvg_08keeperr.t ............... ok
t/zvg_09trace.t ................. ok
t/zvg_10examp.t ................. Can't load 'blib/arch/auto/DBI/DBI.bundle' for module DBI: dlopen(blib/arch/auto/DBI/DBI.bundle, 2): no suitable image found.  Did find:
	file system relative paths not allowed in hardened programs at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.
 at blib/lib/DBI.pm line 284.
BEGIN failed--compilation aborted at blib/lib/DBI.pm line 284.
Compilation failed in require at ./t/10examp.t line 4.
BEGIN failed--compilation aborted at ./t/10examp.t line 4.
Compilation failed in require at t/zvg_10examp.t line 4.
t/zvg_10examp.t ................. Dubious, test returned 255 (wstat 65280, 0xff00)
No subtests run
t/zvg_11fetch.t ................. ok
t/zvg_12quote.t ................. Can't load 'blib/arch/auto/DBI/DBI.bundle' for module DBI: dlopen(blib/arch/auto/DBI/DBI.bundle, 2): no suitable image found.  Did find:
	file system relative paths not allowed in hardened programs at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.
 at blib/lib/DBI.pm line 284.
BEGIN failed--compilation aborted at blib/lib/DBI.pm line 284.
Compilation failed in require at ./t/12quote.t line 8.
BEGIN failed--compilation aborted at ./t/12quote.t line 8.
Compilation failed in require at t/zvg_12quote.t line 4.
# Looks like your test exited with 255 before it could output anything.
t/zvg_12quote.t ................. Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 10/10 subtests
t/zvg_13taint.t ................. Can't load 'blib/arch/auto/DBI/DBI.bundle' for module DBI: dlopen(blib/arch/auto/DBI/DBI.bundle, 2): no suitable image found.  Did find:
	file system relative paths not allowed in hardened programs at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.
 at blib/lib/DBI.pm line 284.
BEGIN failed--compilation aborted at blib/lib/DBI.pm line 284.
Compilation failed in require at ./t/13taint.t line 4.
BEGIN failed--compilation aborted at ./t/13taint.t line 4.
Compilation failed in require at t/zvg_13taint.t line 4.
t/zvg_13taint.t ................. Dubious, test returned 255 (wstat 65280, 0xff00)
No subtests run
t/zvg_14utf8.t .................. ok
t/zvg_15array.t ................. ok
t/zvg_16destroy.t ............... ok
t/zvg_17handle_error.t .......... ok
t/zvg_19fhtrace.t ............... ok
t/zvg_20meta.t .................. ok
t/zvg_30subclass.t .............. ok
t/zvg_31methcache.t ............. ok
t/zvg_35thrclone.t .............. ok
t/zvg_40profile.t ............... ok
t/zvg_41prof_dump.t ............. ok
t/zvg_42prof_data.t ............. ok
t/zvg_43prof_env.t .............. ok
t/zvg_48dbi_dbd_sqlengine.t ..... ok
t/zvg_49dbd_file.t .............. ok
t/zvg_50dbm_simple.t ............ ok
t/zvg_51dbm_file.t .............. ok
t/zvg_52dbm_complex.t ........... skipped: DBI::SQL::Nano is being used
t/zvg_53sqlengine_adv.t ......... skipped: Modifying driver state won't compute running behind Gofer
t/zvg_54_dbd_mem.t .............. skipped: modifying meta data doesn't work with Gofer-AutoProxy
t/zvg_60preparse.t .............. ok
t/zvg_65transact.t .............. skipped: Transactions not supported by DBD::Gofer
t/zvg_70callbacks.t ............. ok
t/zvg_72childhandles.t .......... ok
t/zvg_73cachedkids.t ............ ok
t/zvg_80proxy.t ................. skipped: modules required for proxy are probably not installed (e.g., RPC/PlClient.pm)
t/zvg_85gofer.t ................. ok
t/zvg_86gofer_fail.t ............ skipped: Gofer DBI_AUTOPROXY
t/zvg_87gofer_cache.t ........... skipped: Gofer DBI_AUTOPROXY
t/zvg_90sql_type_cast.t ......... ok
t/zvg_91_store_warning.t ........ ok
t/zvn_48dbi_dbd_sqlengine.t ..... ok
t/zvn_49dbd_file.t .............. ok
t/zvn_50dbm_simple.t ............ ok
t/zvn_51dbm_file.t .............. ok
t/zvn_52dbm_complex.t ........... skipped: DBI::SQL::Nano is being used
t/zvn_85gofer.t ................. ok
t/zvp_01basics.t ................ # --- Perl 5.018004 on darwin-thread-multi-2level
t/zvp_01basics.t ................ ok
t/zvp_02dbidrv.t ................ ok
t/zvp_03handle.t ................ ok
t/zvp_04mods.t .................. ok
t/zvp_05concathash.t ............ ok
t/zvp_06attrs.t ................. ok
t/zvp_07kids.t .................. skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zvp_08keeperr.t ............... ok
t/zvp_09trace.t ................. ok
t/zvp_10examp.t ................. ok
t/zvp_11fetch.t ................. ok
t/zvp_12quote.t ................. ok
t/zvp_13taint.t ................. skipped: Taint attributes not supported with DBI::PurePerl
t/zvp_14utf8.t .................. ok
t/zvp_15array.t ................. ok
t/zvp_16destroy.t ............... ok
t/zvp_17handle_error.t .......... ok
t/zvp_19fhtrace.t ............... ok
t/zvp_20meta.t .................. ok
t/zvp_30subclass.t .............. ok
t/zvp_31methcache.t ............. ok
t/zvp_35thrclone.t .............. ok
t/zvp_40profile.t ............... skipped: profiling not supported for DBI::PurePerl
t/zvp_41prof_dump.t ............. skipped: profiling not supported for DBI::PurePerl
t/zvp_42prof_data.t ............. skipped: profiling not supported for DBI::PurePerl
t/zvp_43prof_env.t .............. skipped: profiling not supported for DBI::PurePerl
t/zvp_48dbi_dbd_sqlengine.t ..... ok
t/zvp_49dbd_file.t .............. ok
t/zvp_50dbm_simple.t ............ ok
t/zvp_51dbm_file.t .............. ok
t/zvp_52dbm_complex.t ........... skipped: DBI::SQL::Nano is being used
t/zvp_53sqlengine_adv.t ......... ok
t/zvp_54_dbd_mem.t .............. ok
t/zvp_60preparse.t .............. skipped: preparse not supported for DBI::PurePerl
t/zvp_65transact.t .............. ok
t/zvp_70callbacks.t ............. skipped: $h->{Callbacks} attribute not supported for DBI::PurePerl
t/zvp_72childhandles.t .......... ok
t/zvp_73cachedkids.t ............ ok
t/zvp_80proxy.t ................. skipped: modules required for proxy are probably not installed (e.g., RPC/PlClient.pm)
t/zvp_85gofer.t ................. ok
t/zvp_86gofer_fail.t ............ skipped: requires Callbacks which are not supported with PurePerl
t/zvp_87gofer_cache.t ........... ok
t/zvp_90sql_type_cast.t ......... ok
t/zvp_91_store_warning.t ........ ok
t/zvxgn_48dbi_dbd_sqlengine.t ... ok
t/zvxgn_49dbd_file.t ............ ok
t/zvxgn_50dbm_simple.t .......... ok
t/zvxgn_51dbm_file.t ............ ok
t/zvxgn_52dbm_complex.t ......... skipped: DBI::SQL::Nano is being used
t/zvxgn_85gofer.t ............... ok
t/zvxgnp_48dbi_dbd_sqlengine.t .. ok
t/zvxgnp_49dbd_file.t ........... ok
t/zvxgnp_50dbm_simple.t ......... ok
t/zvxgnp_51dbm_file.t ........... ok
t/zvxgnp_52dbm_complex.t ........ skipped: DBI::SQL::Nano is being used
t/zvxgnp_85gofer.t .............. ok
t/zvxgp_01basics.t .............. # --- Perl 5.018004 on darwin-thread-multi-2level
t/zvxgp_01basics.t .............. ok
t/zvxgp_02dbidrv.t .............. ok
t/zvxgp_03handle.t .............. ok
t/zvxgp_04mods.t ................ ok
t/zvxgp_05concathash.t .......... ok
t/zvxgp_06attrs.t ............... ok
t/zvxgp_07kids.t ................ skipped: $h->{Kids} attribute not supported for DBI::PurePerl
t/zvxgp_08keeperr.t ............. ok
t/zvxgp_09trace.t ............... ok
t/zvxgp_10examp.t ............... ok
t/zvxgp_11fetch.t ............... ok
t/zvxgp_12quote.t ............... ok
t/zvxgp_13taint.t ............... skipped: Taint attributes not supported with DBI::PurePerl
t/zvxgp_14utf8.t ................ ok
t/zvxgp_15array.t ............... ok
t/zvxgp_16destroy.t ............. ok
t/zvxgp_17handle_error.t ........ ok
t/zvxgp_19fhtrace.t ............. ok
t/zvxgp_20meta.t ................ ok
t/zvxgp_30subclass.t ............ ok
t/zvxgp_31methcache.t ........... ok
t/zvxgp_35thrclone.t ............ ok
t/zvxgp_40profile.t ............. skipped: profiling not supported for DBI::PurePerl
t/zvxgp_41prof_dump.t ........... skipped: profiling not supported for DBI::PurePerl
t/zvxgp_42prof_data.t ........... skipped: profiling not supported for DBI::PurePerl
t/zvxgp_43prof_env.t ............ skipped: profiling not supported for DBI::PurePerl
t/zvxgp_48dbi_dbd_sqlengine.t ... ok
t/zvxgp_49dbd_file.t ............ ok
t/zvxgp_50dbm_simple.t .......... ok
t/zvxgp_51dbm_file.t ............ ok
t/zvxgp_52dbm_complex.t ......... skipped: DBI::SQL::Nano is being used
t/zvxgp_53sqlengine_adv.t ....... skipped: Modifying driver state won't compute running behind Gofer
t/zvxgp_54_dbd_mem.t ............ skipped: modifying meta data doesn't work with Gofer-AutoProxy
t/zvxgp_60preparse.t ............ skipped: preparse not supported for DBI::PurePerl
t/zvxgp_65transact.t ............ skipped: Transactions not supported by DBD::Gofer
t/zvxgp_70callbacks.t ........... skipped: $h->{Callbacks} attribute not supported for DBI::PurePerl
t/zvxgp_72childhandles.t ........ ok
t/zvxgp_73cachedkids.t .......... ok
t/zvxgp_80proxy.t ............... skipped: modules required for proxy are probably not installed (e.g., RPC/PlClient.pm)
t/zvxgp_85gofer.t ............... ok
t/zvxgp_86gofer_fail.t .......... skipped: requires Callbacks which are not supported with PurePerl
t/zvxgp_87gofer_cache.t ......... skipped: Gofer DBI_AUTOPROXY
t/zvxgp_90sql_type_cast.t ....... ok
t/zvxgp_91_store_warning.t ...... ok
t/zvxnp_48dbi_dbd_sqlengine.t ... ok
t/zvxnp_49dbd_file.t ............ ok
t/zvxnp_50dbm_simple.t .......... ok
t/zvxnp_51dbm_file.t ............ ok
t/zvxnp_52dbm_complex.t ......... skipped: DBI::SQL::Nano is being used
t/zvxnp_85gofer.t ............... ok

Test Summary Report
-------------------
t/10examp.t                   (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: No plan found in TAP output
t/12quote.t                   (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 10 tests but ran 0.
t/13taint.t                   (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: No plan found in TAP output
t/zvg_10examp.t               (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: No plan found in TAP output
t/zvg_12quote.t               (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 10 tests but ran 0.
t/zvg_13taint.t               (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: No plan found in TAP output
Files=202, Tests=10432, 75 wallclock secs ( 1.44 usr  0.50 sys + 55.49 cusr 11.19 csys = 68.62 CPU)
Result: FAIL
Failed 6/202 test programs. 0/10432 subtests failed.
make: *** [test_dynamic] Error 255

subo make install

執行訊息

Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/dbipport.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/DBI.bundle
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/dbivport.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/dbi_sql.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/Driver.xst
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/dbd_xsh.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/dbixs_rev.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/DBIXS.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/DBI.bs
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/Driver_xst.h
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/dbixs_rev.pl
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Changes.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/ProfileDumper.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/PurePerl.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Profile.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/ProfileData.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/DBD.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/W32ODBC.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/ProxyServer.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/ProfileSubs.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Util/_accessor.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Util/CacheMemory.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Execute.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Response.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Request.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Serializer/DataDumper.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Serializer/Storable.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Serializer/Base.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Transport/pipeone.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Transport/stream.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Gofer/Transport/Base.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Const/GetInfoType.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Const/GetInfoReturn.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Const/GetInfo/ODBC.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/Const/GetInfo/ANSI.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/DBD/Metadata.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/DBD/SqlEngine.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/DBD/SqlEngine/Developers.pod
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/DBD/SqlEngine/HowTo.pod
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/ProfileDumper/Apache.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBI/SQL/Nano.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/Bundle/DBI.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/DBM.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/NullP.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Proxy.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/ExampleP.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/File.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Mem.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Sponge.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/File/Developers.pod
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/File/Roadmap.pod
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/File/HowTo.pod
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Transport/pipeone.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Transport/null.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Transport/stream.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Transport/corostream.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Transport/Base.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Policy/classic.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Policy/pedantic.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Policy/Base.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/Gofer/Policy/rush.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/Win32/DBIODBC.pm
Installing /usr/local/share/man/man1/dbilogstrip.1
Installing /usr/local/share/man/man1/dbiproxy.1
Installing /usr/local/share/man/man1/dbiprof.1
Installing /usr/local/share/man/man3/DBI::ProfileDumper.3pm
Installing /usr/local/share/man/man3/DBI::DBD::SqlEngine::Developers.3pm
Installing /usr/local/share/man/man3/DBI::Profile.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Response.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Serializer::Storable.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Policy::classic.3pm
Installing /usr/local/share/man/man3/DBI::ProfileSubs.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Transport::stream.3pm
Installing /usr/local/share/man/man3/DBI::W32ODBC.3pm
Installing /usr/local/share/man/man3/DBI::Const::GetInfo::ANSI.3pm
Installing /usr/local/share/man/man3/DBI.3pm
Installing /usr/local/share/man/man3/DBI::DBD.3pm
Installing /usr/local/share/man/man3/DBI::DBD::SqlEngine::HowTo.3pm
Installing /usr/local/share/man/man3/DBI::ProxyServer.3pm
Installing /usr/local/share/man/man3/DBI::DBD::Metadata.3pm
Installing /usr/local/share/man/man3/DBI::Const::GetInfoType.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Transport::null.3pm
Installing /usr/local/share/man/man3/DBD::File::HowTo.3pm
Installing /usr/local/share/man/man3/DBD::File::Developers.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Serializer::Base.3pm
Installing /usr/local/share/man/man3/DBI::PurePerl.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Transport::corostream.3pm
Installing /usr/local/share/man/man3/DBI::Util::CacheMemory.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Execute.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Transport::Base.3pm
Installing /usr/local/share/man/man3/DBD::Mem.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Transport::stream.3pm
Installing /usr/local/share/man/man3/DBD::File.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Policy::Base.3pm
Installing /usr/local/share/man/man3/DBI::Const::GetInfoReturn.3pm
Installing /usr/local/share/man/man3/DBD::DBM.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Transport::pipeone.3pm
Installing /usr/local/share/man/man3/DBI::Const::GetInfo::ODBC.3pm
Installing /usr/local/share/man/man3/Bundle::DBI.3pm
Installing /usr/local/share/man/man3/DBD::Sponge.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Policy::rush.3pm
Installing /usr/local/share/man/man3/DBI::ProfileDumper::Apache.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Request.3pm
Installing /usr/local/share/man/man3/DBD::Gofer.3pm
Installing /usr/local/share/man/man3/Win32::DBIODBC.3pm
Installing /usr/local/share/man/man3/DBD::File::Roadmap.3pm
Installing /usr/local/share/man/man3/DBD::Gofer::Policy::pedantic.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Serializer::DataDumper.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Transport::pipeone.3pm
Installing /usr/local/share/man/man3/DBI::DBD::SqlEngine.3pm
Installing /usr/local/share/man/man3/DBI::Gofer::Transport::Base.3pm
Installing /usr/local/share/man/man3/DBI::SQL::Nano.3pm
Installing /usr/local/share/man/man3/DBI::ProfileData.3pm
Installing /usr/local/share/man/man3/DBD::Proxy.3pm
Installing /usr/local/bin/dbiprof
Installing /usr/local/bin/dbilogstrip
Installing /usr/local/bin/dbiproxy
Appending installation info to /Library/Perl/Updates/5.18.4/darwin-thread-multi-2level/perllocal.pod

安裝 DBI-mysql-4.050

下載DBD-mysql-4.050
解壓縮DBD-mysql-4.050
cd 到DBD-mysql-4.050目錄

執行 Makefile.PL

1	sudo perl Makefile.PL --libs="-L/usr/local/opt/openssl/lib -lssl -lcrypto -L/usr/local/lib -L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient"

注意：這邊要注意openssl路徑和mysql版本路徑要是正確的。

執行訊息

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 's3kr1t';

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/Cellar/mysql/8.0.25_1/include/mysql
  embedded      (guessed      ) =
  libs          (User's choice) = -L/usr/local/opt/openssl/lib -lssl -lcrypto -L/usr/local/lib -L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient
  mysql_config  (guessed      ) = mysql_config
  nocatchstderr (default      ) = 0
  nofoundrows   (default      ) = 0
  nossl         (default      ) = 0
  testdb        (default      ) = test
  testhost      (default      ) =
  testpassword  (default      ) =
  testport      (default      ) =
  testsocket    (default      ) =
  testuser      (guessed      ) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc DBD::mysql::INSTALL'.

Checking if libs are available for compiling...
Looks good.

Checking if your kit is complete...
Looks good
Multiple copies of Driver.xst found in: /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.18/darwin-thread-multi-2level/auto/DBI/ at Makefile.PL line 896.
Using DBI 1.643 (for perl 5.018004 on darwin-thread-multi-2level) installed in /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/
Writing Makefile for DBD::mysql
Wide character in print at /System/Library/Perl/5.18/ExtUtils/MakeMaker.pm line 1034.
Wide character in print at /System/Library/Perl/5.18/ExtUtils/MakeMaker.pm line 1034.
Writing MYMETA.yml and MYMETA.json

sudo make test

執行訊息

cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cc -c  -I/Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI -I/usr/local/Cellar/mysql/8.0.25_1/include/mysql -DDBD_MYSQL_WITH_SSL -g  -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os   -DVERSION=\"4.050\" -DXS_VERSION=\"4.050\"  -iwithsysroot "/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE"   dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /System/Library/Perl/5.18/ExtUtils/xsubpp  -typemap /System/Library/Perl/5.18/ExtUtils/typemap  mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 247
Warning: duplicate function definition 'rows' detected in mysql.xs, line 683
cc -c  -I/Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI -I/usr/local/Cellar/mysql/8.0.25_1/include/mysql -DDBD_MYSQL_WITH_SSL -g  -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os   -DVERSION=\"4.050\" -DXS_VERSION=\"4.050\"  -iwithsysroot "/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE"   mysql.c
cc -c  -I/Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI -I/usr/local/Cellar/mysql/8.0.25_1/include/mysql -DDBD_MYSQL_WITH_SSL -g  -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os   -DVERSION=\"4.050\" -DXS_VERSION=\"4.050\"  -iwithsysroot "/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE"   socket.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.bundle
LD_RUN_PATH="/usr/local/opt/openssl/lib:/usr/local/lib" cc  -bundle -undefined dynamic_lookup -fstack-protector dbdimp.o mysql.o socket.o  -o blib/arch/auto/DBD/mysql/mysql.bundle 	\
	   -L/usr/local/opt/openssl/lib -lssl -lcrypto -L/usr/local/lib -L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient  	\

chmod 755 blib/arch/auto/DBD/mysql/mysql.bundle
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.t .............................. 1/6 # Driver version is 4.050
t/00base.t .............................. ok
t/05dbcreate.t .......................... # DBI connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/05dbcreate.t line 16.
t/05dbcreate.t .......................... skipped: no database connection
t/10connect.t ........................... # DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/10connect.t line 14.
t/10connect.t ........................... skipped: no database connection
t/15reconnect.t ......................... skipped: no database connection
t/16dbi-get_info.t ...................... skipped: no database connection
t/20createdrop.t ........................ skipped: no database connection
t/25lockunlock.t ........................ skipped: no database connection
t/29warnings.t .......................... skipped: no database connection
t/30insertfetch.t ....................... skipped: no database connection
t/31insertid.t .......................... skipped: no database connection
t/32insert_error.t ...................... skipped: no database connection
t/35limit.t ............................. skipped: no database connection
t/35prepare.t ........................... skipped: no database connection
t/40bindparam.t ......................... skipped: no database connection
t/40bindparam2.t ........................ skipped: no database connection
t/40bit.t ............................... skipped: no database connection
t/40blobs.t ............................. skipped: no database connection
t/40catalog.t ........................... skipped: no database connection
t/40keyinfo.t ........................... skipped: no database connection
t/40listfields.t ........................ skipped: no database connection
t/40nulls.t ............................. skipped: no database connection
t/40nulls_prepare.t ..................... skipped: no database connection
t/40numrows.t ........................... skipped: no database connection
t/40server_prepare.t .................... skipped: no database connection
t/40server_prepare_crash.t .............. skipped: no database connection
t/40server_prepare_error.t .............. skipped: no database connection
t/40types.t ............................. skipped: no database connection
t/41bindparam.t ......................... skipped: no database connection
t/41blobs_prepare.t ..................... skipped: no database connection
t/41int_min_max.t ....................... skipped: no database connection
t/42bindparam.t ......................... skipped: no database connection
t/43count_params.t ...................... skipped: no database connection
t/50chopblanks.t ........................ skipped: no database connection
t/50commit.t ............................ skipped: no database connection
t/51bind_type_guessing.t ................ skipped: no database connection
t/52comment.t ........................... skipped: no database connection
t/53comment.t ........................... skipped: no database connection
t/55utf8.t .............................. skipped: no database connection
t/55utf8mb4.t ........................... skipped: no database connection
t/56connattr.t .......................... skipped: no database connection
t/60leaks.t ............................. skipped: Skip $ENV{EXTENDED_TESTING} is not set
t/65segfault.t .......................... skipped: no database connection
t/65types.t ............................. skipped: no database connection
t/70takeimp.t ........................... skipped: no database connection
t/71impdata.t ........................... skipped: no database connection
t/75supported_sql.t ..................... skipped: no database connection
t/76multi_statement.t ................... skipped: no database connection
t/80procs.t ............................. skipped: no database connection
t/81procs.t ............................. skipped: no database connection
t/85init_command.t ...................... skipped: no database connection
t/86_bug_36972.t ........................ skipped: no database connection
t/87async.t ............................. skipped: no database connection
t/88async-multi-stmts.t ................. skipped: no database connection
t/89async-method-check.t ................ skipped: no database connection
t/91errcheck.t .......................... skipped: no database connection
t/92ssl_backronym_vulnerability.t ....... skipped: no database connection: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/lib.pl line 57.
t/92ssl_optional.t ...................... skipped: no database connection: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/lib.pl line 57.
t/92ssl_riddle_vulnerability.t .......... skipped: no database connection: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at t/lib.pl line 57.
t/99_bug_server_prepare_blob_null.t ..... skipped: no database connection
t/manifest.t ............................ skipped: these tests are for release testing
t/pod.t ................................. ok
t/rt110983-valid-mysqlfd.t .............. skipped: no database connection
t/rt118977-zerofill.t ................... skipped: no database connection
t/rt25389-bin-case.t .................... skipped: no database connection
t/rt50304-column_info_parentheses.t ..... skipped: no database connection
t/rt61849-bind-param-buffer-overflow.t .. skipped: no database connection
t/rt75353-innodb-lock-timeout.t ......... skipped: no database connection
t/rt83494-quotes-comments.t ............. skipped: no database connection
t/rt85919-fetch-lost-connection.t ....... skipped: no database connection
t/rt86153-reconnect-fail-memory.t ....... skipped: $ENV{EXTENDED_TESTING} is not set
t/rt88006-bit-prepare.t ................. skipped: no database connection
t/rt91715.t ............................. skipped: no database connection
t/version.t ............................. ok
All tests successful.
Files=73, Tests=13,  5 wallclock secs ( 0.18 usr  0.14 sys +  3.40 cusr  0.99 csys =  4.71 CPU)
Result: PASS

sudo make install

執行訊息

Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bs
Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Installing /Library/Perl/5.18/darwin-thread-multi-2level/Bundle/DBD/mysql.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/mysql.pm
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/mysql/INSTALL.pod
Installing /Library/Perl/5.18/darwin-thread-multi-2level/DBD/mysql/GetInfo.pm
Installing /usr/local/share/man/man3/DBD::mysql::INSTALL.3pm
Installing /usr/local/share/man/man3/DBD::mysql.3pm
Installing /usr/local/share/man/man3/Bundle::DBD::mysql.3pm
Appending installation info to /Library/Perl/Updates/5.18.4/darwin-thread-multi-2level/perllocal.pod

到這邊後理論上已經安裝完畢，可以使用查看已安裝 Perl 模組

使用 cpan 安裝失敗訊息與解決對應

執行安裝 cpan DBD:mysql時出現的問題：

mysql_config 問題

問題訊息：

1
2
3

Can't exec "mysql_config": No such file or directory at Makefile.PL line 603.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Failed to determine directory of mysql.h. Use

解決方式：

1	brew install mysql

檢查：

$ mysql_config
Usage: /usr/local/bin/mysql_config [OPTIONS]
Compiler: AppleClang 12.0.0.12000032
Options:
        --cflags         [-I/usr/local/Cellar/mysql/8.0.25_1/include/mysql ]
        --cxxflags       [-I/usr/local/Cellar/mysql/8.0.25_1/include/mysql ]
        --include        [-I/usr/local/Cellar/mysql/8.0.25_1/include/mysql]
        --libs           [-L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv]
        --libs_r         [-L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv]
        --plugindir      [/usr/local/Cellar/mysql/8.0.25_1/lib/plugin]
        --socket         [/tmp/mysql.sock]
        --port           [0]
        --version        [8.0.25]
        --variable=VAR   VAR is one of:
                pkgincludedir [/usr/local/Cellar/mysql/8.0.25_1/include/mysql]
                pkglibdir     [/usr/local/Cellar/mysql/8.0.25_1/lib]
                plugindir     [/usr/local/Cellar/mysql/8.0.25_1/lib/plugin]

註：--libs [-L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient末端的-l是-lmysqlclient

library 'ssl', 'crypto' 問題

問題訊息：

1 2	Checking if libs are available for compiling... Can't link/include C library 'ssl', 'crypto', aborting.

解決方式：

1	brew install openssl

註：這段後續沒在嘗試安裝，建議還是使用手動編譯安裝。

註：以上參考了
meta::cpan
perl DBI模組和DBD-mysql模組安裝
 cpan install of DBD::mysql failing on tests and symbol not found. OSX Mojave

Perl - 第二十二章 | Perl 面向對象編程

Perl - 第二十四章 | Perl 資料庫訪問

↑
If you enjoy the article, please feel free to donate~ Thx.
若本文對您有幫助，您也願意支持打賞，謝謝您的鼓勵。

本文由J.J. Huang 創作，採用CC BY 3.0 TW協議進行許可。可自由轉載、引用，但需署名作者且註明文章出處。

J.J.'s Blogs

J.J. Huang 2021-06-13 Perl 瀏覽次數：次 {{moment(1623546000000).fromNow()}}

Perl - 第二十三章 | Perl DBD、DBI::mysql模組安裝

查看已安裝 Perl 模組

編譯安裝

安裝 DBI-1.643

安裝 DBI-mysql-4.050

使用 cpan 安裝失敗訊息與解決對應