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
[EMAIL PROTECTED]
[EMAIL PROTECTED] (alias)
305-361-4626
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
