Like Share Discussion Bookmark Smile

J.J. Huang   2021-06-13   Perl   瀏覽次數:

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

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

  • for MacOS
1
2
$ cpan DBI
$ cpan DBD:mysql

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

查看已安裝 Perl 模組

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

1
2
3
4
5
6
#!/usr/bin/perl

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

首次執行:

1
2
3
4
5
6
7
8
9
10
11
$ ./check_module.pl
App::cpanminus
Bundle::NetSNMP
Devel::CheckLib
ExtUtils::PkgConfig
JSON
JSON::Parse
Mock::Config
Perl
install
mod_perl2

假設成功安裝完DBIDBD::mysql模組:

1
2
3
4
5
6
7
8
9
10
11
12
13
$ ./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

  1. 下載DBI-1.643
  2. 解壓縮DBI-1.643
  3. cd 到DBI-1.643目錄
  4. sudo perl Makefile.PL
    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
    178
    179
    180
    181
    182
    *** 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
  5. sudo make
    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    /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
  6. sudo make test
    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
    178
    179
    180
    181
    182
    183
    184
    185
    186
    187
    188
    189
    190
    191
    192
    193
    194
    195
    196
    197
    198
    199
    200
    201
    202
    203
    204
    205
    206
    207
    208
    209
    210
    211
    212
    213
    214
    215
    216
    217
    218
    219
    220
    221
    222
    223
    224
    225
    226
    227
    228
    229
    230
    231
    232
    233
    234
    235
    236
    237
    238
    239
    240
    241
    242
    243
    244
    245
    246
    247
    248
    249
    250
    251
    252
    253
    254
    255
    256
    257
    258
    259
    260
    261
    262
    263
    264
    265
    266
    267
    268
    269
    270
    271
    272
    273
    274
    275
    276
    277
    278
    279
    280
    281
    282
    283
    284
    285
    286
    287
    288
    289
    290
    291
    292
    293
    294
    295
    296
    297
    298
    299
    300
    301
    302
    303
    304
    305
    306
    307
    308
    309
    310
    311
    312
    313
    314
    315
    316
    317
    318
    319
    320
    321
    322
    323
    324
    325
    326
    327
    328
    329
    330
    331
    332
    333
    334
    335
    336
    337
    338
    339
    340
    341
    342
    343
    344
    345
    346
    347
    348
    349
    350
    351
    352
    353
    354
    355
    356
    357
    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
  7. subo make install
    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    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

  1. 下載DBD-mysql-4.050
  2. 解壓縮DBD-mysql-4.050
  3. cd 到DBD-mysql-4.050目錄
  4. 執行 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版本路徑要是正確的。

    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    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
  5. sudo make test
    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    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
  6. sudo make install
    執行訊息
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    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
  • 檢查:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$ 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