MySQL Backend Capitalization

 
From: "Moshe Katz" <kohenkatz@PROTECTED>
Date: May 26th 2009
I have been using dada for several years on one server.  I am now migrating it to a different host and I had issues connecting to the MySQL Server.

I received the following error:
install_driver(MySQL) failed: Can't locate DBD/MySQL.pm in @INC (@INC contains: ../../ ../../perllib /sw/lib/perl5/5.8.6/darwin-thread-multi-2level /sw/lib/perl5 ../../DADA/perllib ./ ../ ../../../ ./../../DADA ../../DADA ../DADA ../DADA/perllib ./DADA ./DADA/perllib ../../../perl ../../../perllib /usr/local/lib/perl5/5.8.9/BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach /usr/local/lib/perl5/5.8.9 .) at (eval 23) line 3, line 1.
Perhaps the DBD::MySQL perl module hasn't been fully installed, or perhaps the capitalisation of 'MySQL' isn't right.
Available drivers: CSV, DBM, ExampleP, Excel, File, Gofer, Mock, Proxy, SQLite, SQLite2, Sponge, mysql.
at /DADA/App/DBIHandle.pm line 163
In my config file, I have the following:
$SUBSCRIBER_DB_TYPE        = 'MySQL';
$ARCHIVE_DB_TYPE           = 'MySQL';
$SETTINGS_DB_TYPE          = 'MySQL';
$SESSION_DB_TYPE           = 'MySQL';

It appears that different servers have the MySQL package installed with different capitalization.  The error message that lists the available database engines has 'mysql' in lowercase.

I tried switching my settings to lower case but now I get a different error from dada:
Base class package "DADA::MailingList::Subscribers::mysql" is empty.
(Perhaps you need to 'use' the module which defines that package first,
or make that module available in @INC (@INC contains: ./ ../ ../../ ../../DADA ../../perllib ../DADA ../DADA/perllib ./DADA ./DADA/perllib ../../../perl ../../../perllib /usr/local/lib/perl5/5.8.9/BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach /usr/local/lib/perl5/5.8.9 .).
at /DADA/MailingList/Subscribers.pm line 23
BEGIN failed--compilation aborted at /DADA/MailingList/Subscribers.pm line 23, <CONFIG> line 1.
Compilation failed in require at /home/public/cgi-bin/dada/mail.cgi line 183, <CONFIG> line 1.
BEGIN failed--compilation aborted at /home/public/cgi-bin/dada/mail.cgi line 183, <CONFIG> line 1.

Has anyone else had this issue?  What did you do?

If it helps, I am migrating to http://nearlyfreespeech.net/ and they have several successful Dada users already (as per their forums) (although I don't know if any use the MySQL backend.)

Also, does anyone know why the package can have different names?

Thanks.

------------------------------
Moshe Katz
KatzNet Computers
-- moshe@PROTECTED
-- kohenkatz@PROTECTED
-- +1(301)867-3732
-- +972(52)8016245

Post:
mailto:[list_settings.discussion_pop_email]

Unsubscribe:
http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/[list]/

List Information:
[PROGRAM_URL]/list/[list_settings.list]

Archive:
[PROGRAM_URL]/archive/[list_settings.list]

Mailing List Powered by Dada Mail

  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is a group discussion list (unmoderated)
  • Start a new thread, email: dadadev@dadamailproject.com

This is the developer discussion mailing list for Dada Mail.

If you are just looking for support Dada Mail, consult the message boards at:

https://forum.dadamailproject.com

Documentation for Dada Mail:

https://dadamailproject.com/d

Specifically, see the Error FAQ:

https://dadamailproject.com/d/FAQ-errors.pod.html

To post to this list, send a message to:

mailto:dadadev@dadamailproject.com

All subscribers of this list may post to the list itself.

Topics that are welcome:

  • Constructive critiques on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
  • Bug/Error reports
  • Bug fixes
  • Request For Comments on any changes to the program
  • Help customizing Dada Mail for your own needs
  • Patches
  • Language Translations
  • Support Documentation/Doc editing, FAQ's, etc.
  • Discussion of any changes that you would like to be committed to the next version of Dada Mail -

Dada Mail is on Github:

https://github.com/justingit/dada-mail/

If you would like to fork, branch, send over PRs, open up issues, etc.

Privacy Policy:

This Privacy Policy is for this mailing list, and this mailing list only.

Email addresses collection through this mailing list are used explicitly to work within this email discussion list.

We only collect email addresses through our Closed-Loop Opt-In system.

We don't use your email address for any other purpose.

We won't be sharing your email address with any other entity.

Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.

All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.

All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.