Help needed ... from a slow learner (maybe getting too old for this sport).
Environment:
** unix on Cobalt linux release 5.0 (Pacifica) Kernel 2.216C27_III on an
i586 having perl 5.00503 ** PERL runs from anywhere in local workspace. New
db modules must be loaded locally (ISP won't allow root changes)
Goal:
Receive form data from my web site and store in a simple flat, CSV (12
column) db for unsophiscated processing in Excell and/or Access on my PC.
Process:
[1] Following excellent Descartes/Bunce examples in "Programming Perl DBI".
[2] Loaded DBI_File successfully. README says: Check that a DBD::* module
exists for the database you wish to use. Found no DBD::ACCESS or DBD::XCELL
at CPAN. However, I suspect (but don't know) that my unsophiticated usage
plans may not need these if I can make/manipulate a simple table.
[3] Since my version of Access allows separation of the db CSV file from its
overlayer of db manipulation and db interface controls, my task is rather
simple (?) -- create CSV-db, update while flocking for multiple client
access, store, occassionally retrieve file to a PC for SQL-type processing.
[4] THus far, I've downloaded from CPAN mirrors and installed to produce the
following
*.pm file (note redundancies -- are these necessary?) ...
$HOME=/home/sites/site10/users/esickafus
|
|
./perl5/perlmod/DB_File/DB_File-1.803/DB_File.pm
/blib/lib/DB_File.pm
./perl5/perlmod/MakeMaker-5.41/lib/ExtUtils/MakeMaker.pm
/Command.pm
/Mksymlists.pm
/Liblist.pm
/Mkbootstrap.pm
/Install.pm
/MM_Win32.pm
/MM_Unix.pm
./perl5/perlmod/MakeMaker-5.41/blib/lib/ExtUtils/MakeMaker.pm
/Command.pm
/Mksymlists.pm
/Liblist.pm
/Mkbootstrap.pm
/Install.pm
/MM_Win32.pm
/MM_Unix.pm
./perl5/perlmod/SQL-Statement-0.1016/lib/SQL/Statement.pm
/Statement/Hash.pm
/Eval.pm
./perl5/perlmod/SQL-Statement-0.1016/blib/lib/SQL/Statement.pm
/Statement/Hash.pm
/Eval.pm
./perl5/perlmod/DBI-1.20/lib/DBD/NullP.pm
/DBD/Sponge.pm
/DBD/ExampleP.pm
/DBD/Proxy.pm
/DBI/FAQ.pm
/DBI/W32ODBC.pm
/DBI/DBD.pm
/DBI/Format.pm
/DBI/Shell.pm
/DBI/ProxyServer.pm
/Bundle/DBI.pm
/Win32/DBIODBC.pm
./perl5/perlmod/Text-CSV_XS-0.23/CSV_XS.pm
/blib/lib/Text/CSV_XS.pm
./perl5/perlmod/DBI-1.21/lib/DBD/ExampleP.pm
/Proxy.pm
/NullP.pm
/Sponge.pm
/DBI/Shell.pm
/FAQ.pm
/ProxyServer.pm
/DBD.pm
/W32ODBC.pm
/Format.pm
/Bundle/DBI.pm
/Win32/DBIODBC.pm
/blib/lib/DBI/Changes.pm
/W32OCBD.pm
/Shell.pm
/FAQ.pm
/ProxyServer.pm
/Format.pm
/DBD.pm
/DBD/ExampleP.pm
/Proxy.pm
/NullP.pm
/Sponge.pm
/Bundle/DBI.pm
/Win32/DBIODBC.pm
/DBI.pm
./perl5/perlmod/DBD-CSV-0.2002/lib/Bundle/DBD/CSV.pm
/lib/DBD/CSV.pm
/lib/DBD/File.pm
./perl5/perlmod/DBD-CSV-0.2002/blib/lib/Bundle/DBD/CSV.pm
/DBD/CSV.pm
/DBD/File.pm
./perllib/i386-linux/DBI/W32ODBC.pm
/FAQ.pm
/Shell.pm
/ProxyServer.pm
/Format.pm
/DBD.pm
/DBD/Example.pm
/Proxy.pm
/NullP.pm
/Sponge.pm
/Bundle/DBI.pm
/Win32/DBIODBC.pm
/DBI.pm
/Brkly_DB/db-401~1.gz
/CSV_XS.pm
It looks like enough stuff here to run a lot of db script with, perhaps, too
much redundancy (?).
[5] BUT, installations produce warnings leading me to believe that
installation is incomplete, while the above list of modules makes me think
installation has been successful.
Example:
[esickafus DBD-CSV-0.2002]$ perl Makefile.PL
LIB=$HOME/perl5/perlmod/DBI-1.20/li
b/Bundle/ {After many of these failures, this time I pointed LIB a little
deeper
/perlmod/ to /Bundle/ }
Warning: prerequisite DBI 1.00 not found at (eval 1) line 220.
Warning: prerequisite SQL::Statement 0.1011 not found at (eval 1) line 220.
Warning: prerequisite Text::CSV_XS 0.16 not found at (eval 1) line 220.
After receiving these warnings too many times, and reading admonitions to
have the latest modules and have DBI greater than 1.00, I downloaded and
installed DBI-1.21 (since Makefile.PL could never find my DBI-1.20.
Installation of DBI-1.21 had a hitch ...
[esickafus DBI-1.21]$ perl Makefile.PL* LIB=$HOME/perl5/perlmod/
[esickafus DBI-1.21]$ make
[esickafus DBI-1.21]$ make test
t/preparse..........Can't locate Devel/Peek.pm in @INC (@INC contains:
blib/arch
blib/lib /usr/lib/perl5/5.00503/i386-linux
/usr/lib/perl5/5.00503/i386-linux /u
sr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503
/home/sites/site10/users/
esickafus/perl5/perlmod /usr/lib/perl5/5.00503/i386-linux
/usr/lib/perl5/5.00503
/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux
/us
r/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .
/usr/lib
/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/
i386-linux /usr/lib/perl5/site_perl/5.005 .) at t/preparse.t line 4.
Found how to fix this on the web: commented out the use Deval::Peek
'Dump'; line
This worked. It then reduced by one warning the installation of
DBD-CSV-2.002 ...
[esickafus DBD-CSV-0.2002]$ perl Makefile.PL LIB=$HOME/perl5/perllib
Warning: prerequisite SQL::Statement 0.1011 not found at (eval 1) line 220.
Warning: prerequisite Text::CSV_XS 0.16 not found at (eval 1) line 220.
Writing Makefile for DBD::CSV
I find this very confusing, it apparently accepts DBI-1.21 but not DBI-1.20.
Now it's looking for SQL::Statement 0.1011, and Text::CSV_XS 0.16. I wonder
what versions of these I must actually load?
On chasing down "prerequisite not found" type warnings via Google, I
discover that ExtUtils::MakeMaker is recommended. I've read its
documentation several times and don't think I'm at that level of expertise
yet.
Any suggestions will be appreciated.
Ed Sickafus
[EMAIL PROTECTED]
