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
[EMAIL PROTECTED] 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 :o)
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 <[email protected]>)
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 <[EMAIL PROTECTED]>)
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" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
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::DBI plugins
libclass-dbi-plugin-type-perl - Determine type information for
Class::DBI 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::DBI's SQL with
SQL::Abstract
libclass-dbi-asform-perl - Produce HTML form elements for database
columns using Class::DBI
libclass-dbi-fromcgi-perl - Update Class::DBI data using CGI::Untaint
libclass-dbi-fromform-perl - Perl module to update Class::DBI data
using Data::FormValidator
libclass-dbi-loader-relationship-perl - Easier relationship
specification in Class::DBI::Loader
libclass-dbi-mysql-perl - Class::DBI::mysql - Extensions to Class::DBI for
MySQL
libclass-dbi-plugin-abstractcount-perl -
Class::DBI::Plugin::AbstractCount - get COUNT(*) results with abstract
SQL
libclass-dbi-plugin-pager-perl - Class::DBI::Plugin::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::DBI sub classes.
libclass-dbi-pager-perl - Pager utility for Class::DBI
libclass-dbi-pg-perl - Class::DBI extension for Postgres
libclass-dbi-plugin-retrieveall-perl - A more complex retrieve_all()
method for Class::DBI
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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
