List:General Discussion« Previous MessageNext Message »
From:Tristan Fiedler Date:February 12 2004 3:04am
Subject:CPAN - DBI & MySQL problems with make test & make install
View as plain text  
Greetings MySQL gurus!

I am setting up a local db and plan to access it via perl & DBI.  on a Mac
iBook running OSX 10.3.2

After creating a new user account to run the sql server, I connected to
the sql server with my personal account and all works fine regarding
accessing my tables, etc.

I then went  to CPAN to get DBI, DBD::mysql, and CGI, but ran into many
problems, mostly with make test and make install.

Any advice would be truly appreciated.  Should I not use CPAN?

Here's briefly the log (Note : I cancelled a previous cpan> install
Bundle::CPAN with Ctrl-C, which probably caused the "lock" which I
over-came by using 'sudo' superuser)

---------------------------------------------

% perl -MCPAN -e shell
Terminal does not support AddHistory.


Your configuration suggests that CPAN.pm should use a working
directory of
    /Users/tfiedler/.cpan
Unfortunately we could not create the lock file
    /Users/tfiedler/.cpan/.lock
due to permission problems.

Please make sure that the configuration variable
    $CPAN::Config->{cpan_home}
points to a directory where you can write a .lock file. You can set
this variable in either
    /System/Library/Perl/5.8.1/CPAN/Config.pm
or
    /Users/tfiedler/.cpan/CPAN/MyConfig.pm

Could not open >/Users/tfiedler/.cpan/.lock: Permission denied
~                                                                         
                                                                          
        % less .cpan/.lock
.cpan/.lock: No such file or directory
~                                                                         
                                                                          
        % sudo perl -MCPAN -e shell
Password:
Terminal does not support AddHistory.

cpan shell -- CPAN exploration and modules installation (v1.76)
ReadLine support available (try 'install Bundle::CPAN')

cpan> install DBI
CPAN: Storable loaded ok
Going to read /Users/tfiedler/.cpan/Metadata
  Database was generated on Wed, 11 Feb 2004 09:50:11 GMT
Running install for module DBI
Running make for T/TI/TIMB/DBI-1.40.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for
/Users/tfiedler/.cpan/sources/authors/id/T/TI/TIMB/DBI-1.40.tar.gz ok
Scanning cache /Users/tfiedler/.cpan/build for sizes
DBI-1.40/
DBI-1.40/Driver_xst.h
DBI-1.40/t/
DBI-1.40/t/40profile.t
DBI-1.40/t/06attrs.t
DBI-1.40/t/08keeperr.t
DBI-1.40/t/42prof_data.t
DBI-1.40/t/01basics.t
DBI-1.40/t/60preparse.t
DBI-1.40/t/41prof_dump.t
DBI-1.40/t/04mods.t
DBI-1.40/t/05thrclone.t
DBI-1.40/t/02dbidrv.t
DBI-1.40/t/80proxy.t
DBI-1.40/t/07kids.t
DBI-1.40/t/20meta.t
DBI-1.40/t/10examp.t
DBI-1.40/t/30subclass.t
DBI-1.40/t/15array.t
DBI-1.40/t/03handle.t
DBI-1.40/DBI.xs
DBI-1.40/lib/
DBI-1.40/lib/DBD/
DBI-1.40/lib/DBD/NullP.pm
DBI-1.40/lib/DBD/Sponge.pm
DBI-1.40/lib/DBD/ExampleP.pm
DBI-1.40/lib/DBD/Proxy.pm
DBI-1.40/lib/DBI/
DBI-1.40/lib/DBI/Const/
DBI-1.40/lib/DBI/Const/GetInfo/
DBI-1.40/lib/DBI/Const/GetInfo/ANSI.pm
DBI-1.40/lib/DBI/Const/GetInfo/ODBC.pm
DBI-1.40/lib/DBI/Const/GetInfoType.pm
DBI-1.40/lib/DBI/Const/GetInfoReturn.pm
DBI-1.40/lib/DBI/FAQ.pm
DBI-1.40/lib/DBI/W32ODBC.pm
DBI-1.40/lib/DBI/DBD.pm
DBI-1.40/lib/DBI/ProfileData.pm
DBI-1.40/lib/DBI/ProfileDumper/
DBI-1.40/lib/DBI/ProfileDumper/Apache.pm
DBI-1.40/lib/DBI/ProfileDumper.pm
DBI-1.40/lib/DBI/DBD/
DBI-1.40/lib/DBI/DBD/Metadata.pm
DBI-1.40/lib/DBI/PurePerl.pm
DBI-1.40/lib/DBI/Profile.pm
DBI-1.40/lib/DBI/ProxyServer.pm
DBI-1.40/lib/Bundle/
DBI-1.40/lib/Bundle/DBI.pm
DBI-1.40/lib/Win32/
DBI-1.40/lib/Win32/DBIODBC.pm
DBI-1.40/MANIFEST
DBI-1.40/dbipport.h
DBI-1.40/Changes
DBI-1.40/dbi_sql.h
DBI-1.40/Perl.xs
DBI-1.40/Driver.xst
DBI-1.40/README
DBI-1.40/DBIXS.h
DBI-1.40/test.pl
DBI-1.40/dbd_xsh.h
DBI-1.40/META.yml
DBI-1.40/Makefile.PL
DBI-1.40/DBI.pm
DBI-1.40/dbiprof.PL
DBI-1.40/typemap
DBI-1.40/dbiproxy.PL
DBI-1.40/ToDo
Removing previously used /Users/tfiedler/.cpan/build/DBI-1.40

  CPAN.pm: Going to build T/TI/TIMB/DBI-1.40.tar.gz


*** You are using a perl configured with threading enabled.
*** You should be aware that using multiple threads is
*** not recommended for production environments.

*** Note:
    The optional PlRPC-modules (RPC::PlServer etc) are not installed.
    If you want to use the DBD::Proxy driver and DBI::ProxyServer
    modules, then you'll need to install the RPC::PlServer, RPC::PlClient,
    Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you.
    You can install them any time after installing the DBI.
    You do *not* need these modules for typical DBI usage.

Optional modules are available from any CPAN mirror, in particular
    http://search.cpan.org/
    http://www.perl.com/CPAN/modules/by-module
    http://www.perl.org/CPAN/modules/by-module
    ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module

Creating extra DBI::PurePerl test: t/zz_01basics_pp.t
Creating extra DBI::PurePerl test: t/zz_02dbidrv_pp.t
Creating extra DBI::PurePerl test: t/zz_03handle_pp.t
Creating extra DBI::PurePerl test: t/zz_04mods_pp.t
Creating extra DBI::PurePerl test: t/zz_05thrclone_pp.t (use threads)
Creating extra DBI::PurePerl test: t/zz_06attrs_pp.t
Creating extra DBI::PurePerl test: t/zz_07kids_pp.t
Creating extra DBI::PurePerl test: t/zz_08keeperr_pp.t
Creating extra DBI::PurePerl test: t/zz_10examp_pp.t
Creating extra DBI::PurePerl test: t/zz_15array_pp.t
Creating extra DBI::PurePerl test: t/zz_20meta_pp.t
Creating extra DBI::PurePerl test: t/zz_30subclass_pp.t
Creating extra DBI::PurePerl test: t/zz_40profile_pp.t
Creating extra DBI::PurePerl test: t/zz_41prof_dump_pp.t
Creating extra DBI::PurePerl test: t/zz_42prof_data_pp.t
Creating extra DBI::PurePerl test: t/zz_60preparse_pp.t
Creating extra DBI::PurePerl test: t/zz_80proxy_pp.t
Checking if your kit is complete...
Looks good

Error: Unable to locate installed Perl libraries or Perl source code.

It is recommended that you install perl in a standard location before
building extensions. Some precompiled versions of perl do not contain
these header files, so you cannot build extensions. In such a case,
please build and install your perl from a fresh perl distribution. It
usually solves this kind of problem.

(You get this message, because MakeMaker could not find
"/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h")
Running make test
  Make had some problems, maybe interrupted? Won't test
Running make install
  Make had some problems, maybe interrupted? Won't install



-- 
Tristan J. Fiedler, Ph.D.
Postdoctoral Research Fellow - Walsh Laboratory
NIEHS Marine & Freshwater Biomedical Sciences Center
Rosenstiel School of Marine & Atmospheric Sciences
University of Miami

tfiedler@stripped
t.fiedler@stripped (alias)
305-361-4626
Thread
CPAN - DBI & MySQL problems with make test & make installTristan Fiedler12 Feb