Re: A trouble to install DBI and DBD::MySQL into Mac OS x 10.8.2

On 23.02.13 06:18, Jian L wrote:
> Dear Sir/Madam:
>
> I had a problem to install Perl DBI module into my MacBook Pro with OSX
> 10.8.2 which has pre-installed Perl v5.12.4.
>
> After installation of MySQL-5.6.10-osx10.7-x86_64 and Xcode 4.6. I am
> trying to install DBI and DBD::MySQL into my machine by using CPAN via
> Terminal. During the process, I got two kinds of error info as following
>
> ......
> *** Your LANG environment variable is set to 'en_US.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 [email protected] with details
> *** including the output of 'perl -V'
> ......
> Writing Makefile for DBI
>    TIMB/DBI-1.623.tar.gz
>    make -- NOT OK
> 'YAML' not installed, will not store persistent state
> ......
>
> Eventually installation failed. I tried to install YAML, it also failed.
>
> I googled everywhere, and could not find a solution. So I am seeking help
> from you. My questions are
>
> 1. How I can re-set "LANG environment variable" from 'en_US.UTF-8' to
> 'unset'?
> 2. How I can install DBI and DBD::MySQL into my computer?
>
> Any response will be highly appreciated.
>
> Best regard!
>
> Jian Lee
>
>
>
>
> NOTES: The following is all information I got during installation. Hope it
> will be helpful for you to figure out the problem for me.
>
> MyLabs-MacBook-Pro:Desktop mylab$ perl -v
>
> This is perl 5, version 12, subversion 4 (v5.12.4) built for
> darwin-thread-multi-2level
> (with 2 registered patches, see perl -V for more detail)
>
> Copyright 1987-2010, Larry Wall
>
> Perl may be copied only under the terms of either the Artistic License or
> the
> GNU General Public License, which may be found in the Perl 5 source kit.
>
> Complete documentation for Perl, including FAQ lists, should be found on
> this system using "man perl" or "perldoc perl".  If you have access to the
> Internet, point your browser at http://www.perl.org/, the Perl Home Page.
>
>
>
> MyLabs-MacBook-Pro:Desktop mylab$ ./hello.pl V
> Hello, Macinstruct user!
> Hello, V!
> Apple_PubSub_Socket_Render = /tmp/launch-WAq0nS/Render
> Apple_Ubiquity_Message = /tmp/launch-jFuKg3/Apple_Ubiquity_Message
> COMMAND_MODE = unix2003
> HOME = /Users/mylab
> LANG = en_US.UTF-8
> LOGNAME = mylab
> OLDPWD = /Users/mylab
> PATH = /usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin
> PWD = /Users/mylab/Desktop
> SHELL = /bin/bash
> SHLVL = 1
> SSH_AUTH_SOCK = /tmp/launch-7z2Bx5/Listeners
> TERM = xterm-256color
> TERM_PROGRAM = Apple_Terminal
> TERM_PROGRAM_VERSION = 309
> TERM_SESSION_ID = 42238A5D-B0DC-41E8-B525-18D6E19F6D60
> TMPDIR = /var/folders/t0/mg7v3ng52kldypgxx854pdg00000gn/T/
> USER = mylab
> VERSIONER_PERL_PREFER_32_BIT = no
> VERSIONER_PERL_VERSION = 5.12
> _ = ./hello.pl
> __CF_USER_TEXT_ENCODING = 0x1F5:0:0
>
>
>
> MyLabs-MacBook-Pro:Desktop mylab$ CPAN DBI
> Going to read '/Users/mylab/.cpan/Metadata'
>    Database was generated on Fri, 22 Feb 2013 15:07:37 GMT
> Running install for module 'DBI'
> Running make for T/TI/TIMB/DBI-1.623.tar.gz
> Checksum for
> /Users/mylab/.cpan/sources/authors/id/T/TI/TIMB/DBI-1.623.tar.gz ok
>
>    CPAN.pm: Going to build T/TI/TIMB/DBI-1.623.tar.gz
>
> *** Your LANG environment variable is set to 'en_US.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 [email protected] with details
> *** including the output of 'perl -V'
>
> Your perl was compiled with gcc (version 4.2.1 Compatible Apple Clang 4.0
> (tags/Apple/clang-418.0.60)), 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_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_60preparse.t
> t/zvg_65transact.t
> t/zvg_70callbacks.t
> t/zvg_72childhandles.t
> t/zvg_80proxy.t
> t/zvg_85gofer.t
> t/zvg_86gofer_fail.t
> t/zvg_87gofer_cache.t
> t/zvg_90sql_type_cast.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_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_60preparse.t
> t/zvp_65transact.t
> t/zvp_70callbacks.t
> t/zvp_72childhandles.t
> t/zvp_80proxy.t
> t/zvp_85gofer.t
> t/zvp_86gofer_fail.t
> t/zvp_87gofer_cache.t
> t/zvp_90sql_type_cast.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_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_60preparse.t
> t/zvxgp_65transact.t
> t/zvxgp_70callbacks.t
> t/zvxgp_72childhandles.t
> t/zvxgp_80proxy.t
> t/zvxgp_85gofer.t
> t/zvxgp_86gofer_fail.t
> t/zvxgp_87gofer_cache.t
> t/zvxgp_90sql_type_cast.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.012004 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
>    TIMB/DBI-1.623.tar.gz
>    make -- NOT OK
> 'YAML' not installed, will not store persistent state
> Running make test
>    Can't test without successful make
> Running make install
>    Make had returned bad status, install seems impossible
>
>
>
> MyLabs-MacBook-Pro:Desktop mylab$ CPAN YAML
> Going to read '/Users/mylab/.cpan/Metadata'
>    Database was generated on Fri, 22 Feb 2013 15:07:37 GMT
> Running install for module 'YAML'
> Running make for M/MS/MSTROUT/YAML-0.84.tar.gz
> Checksum for
> /Users/mylab/.cpan/sources/authors/id/M/MS/MSTROUT/YAML-0.84.tar.gz ok
> ---- Unsatisfied dependencies detected during ----
> ----         MSTROUT/YAML-0.84.tar.gz         ----
>      ExtUtils::MakeMaker [build_requires]
> Running make test
>    Make had some problems, won't test
>    Delayed until after prerequisites
> Running make install
>    Make had some problems, won't install
>    Delayed until after prerequisites
> Running install for module 'ExtUtils::MakeMaker'
> Running make for M/MS/MSCHWERN/ExtUtils-MakeMaker-6.64.tar.gz
> Checksum for
> /Users/mylab/.cpan/sources/authors/id/M/MS/MSCHWERN/ExtUtils-MakeMaker-6.64.tar.gz
> ok
>
>    CPAN.pm: Going to build M/MS/MSCHWERN/ExtUtils-MakeMaker-6.64.tar.gz
>
> Using included version of CPAN::Meta (2.112621) because it is not already
> installed.
> Using included version of CPAN::Meta::YAML (0.008) because it is not
> already installed.
> Using included version of ExtUtils::Manifest (1.60) as it is newer than the
> installed version (1.57).
> Using included version of File::Copy::Recursive (0.38) because it is not
> already installed.
> Using included version of JSON::PP (2.27200) because it is not already
> installed.
> Using included version of JSON::PP::Compat5006 (1.09) because it is not
> already installed.
> Using included version of Parse::CPAN::Meta (1.4401) as it is newer than
> the installed version (1.40).
> Using included version of version (0.88) as it is newer than the installed
> version (0.82).
> Using included version of Version::Requirements (0.101020) because it is
> not already installed.
> Checking if your kit is complete...
> Looks good
> Writing Makefile for ExtUtils::MakeMaker
> Writing MYMETA.yml and MYMETA.json
>    MSCHWERN/ExtUtils-MakeMaker-6.64.tar.gz
>    make -- NOT OK
> 'YAML' not installed, will not store persistent state
> Running make test
>    Can't test without successful make
> Running make install
>    Make had returned bad status, install seems impossible
> Running make for M/MS/MSTROUT/YAML-0.84.tar.gz
> Warning: Prerequisite 'ExtUtils::MakeMaker => 6.59' for
> 'MSTROUT/YAML-0.84.tar.gz' failed when processing
> 'MSCHWERN/ExtUtils-MakeMaker-6.64.tar.gz' with 'make => NO'. Continuing,
> but chances to succeed are limited.
>
>    CPAN.pm: Going to build M/MS/MSTROUT/YAML-0.84.tar.gz
>
> Checking if your kit is complete...
> Looks good
> Warning: prerequisite ExtUtils::MakeMaker 6.59 not found. We have 6.56.
> Writing Makefile for YAML
> Warning: Prerequisite 'ExtUtils::MakeMaker => 6.59' for
> 'MSTROUT/YAML-0.84.tar.gz' failed when processing
> 'MSCHWERN/ExtUtils-MakeMaker-6.64.tar.gz' with 'make => NO'. Continuing,
> but chances to succeed are limited.
>    MSTROUT/YAML-0.84.tar.gz
>    make -- NOT OK
> Running make test
>    Can't test without successful make
> Running make install
>    Make had returned bad status, install seems impossible
>
> MyLabs-MacBook-Pro:Desktop mylab$

Well, beside any preferrences, I suggest to either build your own perl
environment for working (perlbrew, homebrew, pkgsrc, ...) or at least
use local::lib.

Then you should be able to install via CPAN and fetch all required
dependencies.

Best regards,
-- 
Jens Rehsack