Hi Demi.
Here's the scoop. The modules on that pkg list seem a
little old.
Here are the only two Debian pkg items you need for PERL
5.8.8_4 (yours) to
run with MySQL:
ii libdbi-perl 1.46-6 Perl5 database interface
by Tim Bunce
ii libdbd-mysql 0.7.1-3.0.1 MySQL database server
driver for libdbi
(I don't recognize the versioning of this libdbd-mysql and
there is no
author mentioned but it looks like it is Patrick
Galbraith's DBI::mysql --
if not it should be this:
http://search.cpan.org/~capttofu/DBD-mysql-3.0002_5/ )
If you invoke CPAN from the command line
(perl -MCPAN -e shell)
and then type a module query like this:
CPAN> m DBI
and
CPAN> m DBD::mysql
You will get information on what is available from the CPAN
repository and
what is installed on your server.
You can then update the module like this:
CPAN> r DBI
and
CPAN r DBD::mysql
Sometimes DBD modules fail to install because your database
doesn't have a
test Db for the test suite or you have already locked down
your RDBMS for
root ocalhost access. You can force "notest
install" to bypass the tests or
"force install" to run the tests but ignore a
fail. If the CPAN install
fails you can go to
/wherever_you_have/.cpan/build/DBD-mysql-3.0002 and do a
module build (ignoring test results if your database
doesn't have a test Db)
make clean
perl Makefile.PL
make
make test
make install
... and you should be good from there 
best...
Mike
Note: In the event that you would want to run DBMail on
PostgreSQL you would
in each case above substitute DBD::pg with DBI instead of
DBD::mysql
Example module reports for DBI and DBD MySQL:
Module id = DBI
DESCRIPTION Generic Database Interface (see DBD modules)
CPAN_USERID DBIML (The DBI Mailing Lists <dbi-usersperl.org>)
CPAN_VERSION 1.50
CPAN_FILE T/TI/TIMB/DBI-1.50.tar.gz
UPLOAD_DATE 2005-12-14
DSLIP_STATUS MmcOp
(mature,mailing-list,C,object-oriented,Standard-Perl)
MANPAGE DBI - Database independent interface for Perl
INST_FILE
/usr/local/lib/perl5/site_perl/5.8.8/mach/DBI.pm
INST_VERSION 1.50
Module id = DBD::mysql
DESCRIPTION MySQL driver for DBI
CPAN_USERID RUDY (Rudy Lippan <rlippanremotelinux.com>)
CPAN_VERSION 3.0002_5
CPAN_FILE C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz
UPLOAD_DATE 2006-01-02
DSLIP_STATUS RmcO?
(released,mailing-list,C,object-oriented,)
MANPAGE DBD::mysql - MySQL driver for the Perl5
Database Interface
(DBI)
INST_FILE
/usr/local/lib/perl5/site_perl/5.8.8/mach/DBD/mysql.pm
INST_VERSION 3.0002_5
----- Original Message -----
From: "Demi" <gruesslegmail.com>
To: "DBMail mailinglist" <dbmaildbmail.org>
Sent: Friday, April 28, 2006 1:48 AM
Subject: Re: [Dbmail] Shared folder
Hi Mike,
The 1st one is solved. How could I forget AddHandler
cgi-script .cgi
On the second one I could have gone the easy way and install
from
MCPAN but I like your alternative better. You know
installing the
debian modules. So I went and installed following:
safe:/# dpkg -l | grep dbi
ii libdbd-mysql 0.7.1-3.0.1 MySQL database server
driver for libdbi
ii libdbi-perl 1.46-6 Perl5 database interface
by Tim Bunce
ii libdbi0 0.7.2-1 Database Independent
Abstraction Layer for
C
ii libdbix-cgi-pe 0.06-5 CGI Extension for
libdbix-easy-perl
ii libdbix-dataso 0.02-3 Database-independent
create and drop
functio
ii libdbix-easy-p 0.15-2 Easy to Use DBI Interface
safe:/# dpkg -l | grep dbd
ii libdbd-mysql 0.7.1-3.0.1 MySQL database server
driver for libdbi
ii libdbd-mysql-p 2.9006-1 A Perl5 database interface
to the MySQL
data
ALSO:
libclass-accessor-perl 0.19-2 [21.8kB]
libclass-data-inheritable-perl 0.02-1 [7014B]
libdbix-contextualfetch-perl 1.02-2 [8116B]
libclass-whitehole-perl 0.04-1 [6404B]
libima-dbi-perl 0.33-1 [25.5kB]
libclass-trigger-perl 0.09-1 [11.9kB]
libuniversal-moniker-perl 0.08-1 [7114B]
libclass-dbi-perl 0.96-1 [92.3kB]
But it is still not working and I am thinking that maybe
MCPAN
installs more then just these when you ask for DBI and
DBD::mysql.
I searched the Debian apt cache for dbi and dbd but the list
was very
long so I went and deleted everything which couldn't be.
Like RUBI,
sqlite, sybase, VCS, cvs, PDF ... lots of stuff believe me.
Below is your list of possibilities, I was wondering if you
could skim
through it real quick and mark what DBMA needs.
That should make it also easier for the next Debian fan, and
there is
lots of us ;)
Thanks for being so sweet about all this Mike
Demi
========= dbi dbd short list / I know it's still long :(
=============
libclass-dbi-plugin-perl - Abstract base class for
Class: BI
plugins
libclass-dbi-plugin-type-perl - Determine type information
for
Class:BI table
columns
libdbd-ram-perl - perl DBI driver for files and data
structures --
transition package
libdbi0-dev - Database Independent Abstraction Layer for C
(dev files)
libdbix-password-perl - Perl module for creating a global
password
file for DB passwords
libdbix-profile-perl - DBI query profiler
libdbix-recordset-perl - Perl extension for DBI recordsets
libuser-identity-perl - manages different identities/roles
used by a
physical person
libdbd-informix-perl - Perl DBI driver for Informix
libcatalyst-model-cdbi-perl - CDBI Model Class for Catalyst
libclass-dbi-abstractsearch-perl - Abstract Class:BI's
SQL with
SQL::Abstract
libclass-dbi-asform-perl - Produce HTML form elements for
database
columns using Class:BI
libclass-dbi-fromcgi-perl - Update Class:BI data
using CGI::Untaint
libclass-dbi-fromform-perl - Perl module to update
Class:BI data
using Data::FormValidator
libclass-dbi-loader-relationship-perl - Easier relationship
specification in Class:BI::Load
er
libclass-dbi-mysql-perl - Class:BI::mysq
l - Extensions to Class:BI for
MySQL
libclass-dbi-plugin-abstractcount-perl -
Class:BI::Plug
in::AbstractCount - get COUNT(*) results with abstract
SQL
libclass-dbi-plugin-pager-perl - Class:BI::Plug
in::Pager - paged
queries for CDBI
libdbd-anydata-perl - perl DBI driver for files and data
structures
libdbd-csv-perl - perl DBD::CSV - DBI driver for CSV files
libdbd-mysql-perl - A Perl5 database interface to the MySQL
database
libdbd-odbc-perl - Perl5 module for an ODBC driver for DBI
libdbd-odbc-ruby - Ruby/DBI driver for ODBC
libdbd-odbc-ruby1.8 - Ruby/DBI ODBC driver for Ruby 1.8
libdbd-pg-perl - a PostgreSQL interface for Perl 5 using DBI
libdbi-ocaml - Database Independent Interface (DBI) for
Objective
CAML, bytecode runtime files
libdbi-ocaml-dev - Database Independent Interface (DBI) for
Objective
CAML, development files
libdbi-perl - Perl5 database interface by Tim Bunce
libdbix-abstract-perl - DBI SQL abstraction
libdbix-class-loader-perl - Dynamic definition of
DBIx::Class sub classes.
libdbix-class-schema-loader-perl - Dynamic definition of a
DBIx::Class::Schema
libdbix-contextualfetch-perl - Add context aware fetches to
DBI
libdbix-dbschema-perl - Database-independent schema objects
libdbix-easy-perl - Easy to Use DBI Interface
libdbix-xml-rdb-perl - perl module for creating XML from a
DBI datasource
libdbix-xmlmessage-perl - perl module for exchanging XML
messages
between DBI data sources
libghc6-hdbc-dev - Haskell Database Connectivity, GHC6
package
libghc6-hsql-dev - Multi-Database Interface System for
Haskell
libghc6-hsql-mysql-dev - Multi-Database Interface System for
Haskell
libghc6-hsql-odbc-dev - Multi-Database Interface System for
Haskell
libghc6-hsql-postgresql-dev - Multi-Database Interface
System for Haskell
libhugs-hdbc - Haskell Database Connectivity, Hugs package
libima-dbi-perl - Database connection caching and
organization
libmodule-pluggable-fast-perl - Fast plugins with
instantiation
libsgutils1-dev - Utilities for working with generic SCSI
devices
(developer files)
libsql-statement-perl - perl SQL::Statement - SQL parsing
and processing
engine
libtangram-perl - Orthogonal Object Persistence in
Relational Databases
libtemplate-plugin-class-perl - Call methods of arbitrary
classes in
perl Template Toolkit
libuser-simple-perl - Simple user sessions management
libxml-filter-xslt-perl - Perl module for XSLT as a SAX
Filter
r-cran-dbi - GNU R package providing a generic database
interface
r-cran-rmysql - GNU R package providing a DBI-compliant
interface to MySQL
dbbalancer - [OBSOLETE] Postgres connection pool, load
balancer and
write-replicator
libcatalyst-model-dbic-perl - DBix::Class Model for Catalyst
Framework
libcatalyst-modules-extra-perl - Extra modules for Catalyst
libcatalyst-modules-perl - Modules for Catalyst
libcgi-application-plugins-perl - Plugins for
CGI::Application
libclass-dbi-loader-perl - Dynamic definition of Class:BI sub
classes.
libclass-dbi-pager-perl - Pager utility for Class:BI
libclass-dbi-pg-perl - Class:BI
extension for Postgres
libclass-dbi-plugin-retrieveall-perl - A more complex
retrieve_all()
method for Class:BI
libdbix-class-perl - Extensible and flexible object
<-> relational mapper
libdbix-searchbuilder-perl - Encapsulate SQL queries and
rows in
simple perl objects
libembperl-perl - A system for building dynamic websites
with Perl
libspf-dev - the ANSI C SPF reference library (development
files)
libspf-doc - the ANSI C SPF reference library
(documentation)
libspf0 - the ANSI C SPF reference library (runtime library)
libsql-abstract-perl - Generate SQL from Perl data
structures
# apt-cache search dbd
dbtcp - Miscellaneous command-line DBTCP utils
libapache-dbilogger-perl - Tracks what's being transferred
in a DBI database
libdbd-dbftp-perl - Perl bindings for DBTCP
libdbd-mysql - MySQL database server driver for libdbi
libdbd-pgsql - PostgreSQL database server driver for libdbi
libdbd-ram-perl - perl DBI driver for files and data
structures --
transition package
freecdb - creating and reading constant databases
libdbd-anydata-perl - perl DBI driver for files and data
structures
libdbd-csv-perl - perl DBD::CSV - DBI driver for CSV files
libdbd-ldap-perl - Perl extension for LDAP access via an
SQL/Perl DBI
interface
libdbd-mysql-perl - A Perl5 database interface to the MySQL
database
libdbd-odbc-perl - Perl5 module for an ODBC driver for DBI
libdbd-pg-perl - a PostgreSQL interface for Perl 5 using DBI
libdbd-pg-ruby - Ruby/DBI PostgreSQL driver
libdbd-pg-ruby1.8 - Ruby/DBI PostgreSQL driver for Ruby 1.8
libsql-statement-perl - perl SQL::Statement - SQL parsing
and processing
engine
libtangram-perl - Orthogonal Object Persistence in
Relational Databases
libuser-simple-perl - Simple user sessions management
libdbd-sqlrelay-perl - SQL Relay Perl DBD API
libfirstworks-sqlr-perl - SQL Relay Perl API
sqlrelay - Database connection pooling, proxying and load
balancing
sqlrelay-dev - SQL Relay C and C++ APIs
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|