Question

According to my InstalledPlugins page, the DatabasePlugin is installed, but I can't figure out how to configure it to work.

The documentation says to use configure, but the only option there is to specify whether it's Local or Remote.

After searching a lot, I've found various references to other things to do, but they all appear to not be for the current version.

Can anyone point me to a URL that contains setup information for dummies like me?

Environment

-- TimJacob - 10 Sep 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

OK, I found that after copying config.spec INTO LocalSite.cfg, and then editing the database info at the bottom, I can at least get the message:

"DBI connect('database=equip;host=localhost','mysql',...) failed: Access denied for user 'mysql'@'localhost' (using password: YES) at /srv/www/htdocs/twiki/lib/TWiki/Plugins/DatabasePlugin/Connection.pm line 31 at /usr/lib/perl5/vendor_perl/5.8.8/i586-linux-thread-multi/DBI.pm line 629 DBI::__ANON__('undef', 'undef') called at /usr/lib/perl5/vendor_perl/5.8.8/i586-linux-thread-multi/DBI.pm line 681 DBI::connect('DBI', 'DBI:mysql:database=equip;host=localhost', 'mysql', 'xxxxx', 'HASH(0x8f507cc)') called at /srv/www/htdocs/twiki/lib/TWiki/Plugins/DatabasePlugin/Connection.pm line 31 TWiki::Plugins::DatabasePlugin::Connection::connect('TWiki::Plugins::DatabasePlugin::Connection=HASH(0x8e13370)') called at /srv/www/htdocs/twiki/lib/TWiki/Plugins/DatabasePlugin/DATABASE_SQL.pm line 8 TWiki::Plugins::DatabasePlugin::DATABASE_SQL::handle('TWiki::Plugins::DatabasePlugin::Connection=HASH(0x8e13370)', 'undef') called at /srv/www/htdocs/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 81 eval {...} called at /srv/www/htdocs/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 75 TWiki::Plugins::DatabasePlugin::_dispatch('mysql', 'undef') called at /srv/www/htdocs/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 98 TWiki::Plugins::DatabasePlugin::commonTagsHandler('---+ Equipment List \x{a}#PageTop\x{a}"

I am using the same password that I use to connect with MySQL Administrator. User mysql has been granted ALL rights from ANY computer.

Can anyone help me interpret this?

Many thanks.

-- TimJacob - 11 Sep 2007

Got it. Found that although I had granted rights to the user, I had not granted them for the user from the TWiki server.

-- TimJacob - 13 Sep 2007