Question234 < Support

You are here: Foswiki>Support Web>SupportQuestions>Question234 (revision 2) (raw view)

Hi,

   I'm attempting to configure this plugin to use a mysql database to gather the db connection info:

 I've filled out the configuration, here is the out from the LocalSite.cfg:

<font face="Calibri, Verdana, Helvetica, Arial">$Foswiki::cfg{Plugins}{DatabasePlugin}{Enabled} = 1;<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{Module} = 'Foswiki::Plugins::DatabasePlugin';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigSource} = 'Remote';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigHost} = 'localhost';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigDriver} = 'mysql';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigDB} = 'wiki';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigSID} = 'wiki';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigTable} = 'db_connection';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigUsername} = 'wiki_user';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{ConfigPassword} = 'wikiwiki';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{EditURLPrefix} = 'https';<br /> $Foswiki::cfg{Plugins}{DatabasePlugin}{EditURLPath} = 'phpMyAdmin-2.2.2-rc1';</font>

Here is a query from mysql database:

<font face="Calibri, Verdana, Helvetica, Arial">mysql&gt; use wiki</font>

<font face="Calibri, Verdana, Helvetica, Arial">mysql&gt; select * from db_connection;</font>

<font face="Calibri, Verdana, Helvetica, Arial"> +-------------+--------+---------+--------+-------------+-------------+---------------------+------------+<br /> | description | driver | db_name | db_sid | ro_username | ro_password | hostname| table_name |<br /> +-------------+--------+---------+--------+-------------+-------------+---------------------+------------+<br /> | devdb | Oracle | devdb | devdb | query_user | query_user | devdb.tare.local | NULL      | <br /> +-------------+--------+---------+--------+-------------+-------------+---------------------+------------+<br /> </font>

My page returns:

 <font face="Calibri, Verdana, Helvetica, Arial">Can't call method "prepare" on an undefined value at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/Plugins/DatabasePlugin.pm line 57.<br /> at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/Plugins/DatabasePlugin.pm line 57<br /> Foswiki::Plugins::DatabasePlugin::initPlugin('MoscardiniEdward', 'Main', 'emoscard', 'System') called at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/Plugin.pm line 231<br /> Foswiki::Plugin::registerHandlers('Foswiki::Plugin=HASH(0x9d3177c)', 'Foswiki::Plugins=HASH(0x94431e4)') called at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/Plugins.pm line 244<br /> Foswiki::Plugins::enable('Foswiki::Plugins=HASH(0x94431e4)') called at /TARe/wiki/twiki/twiki_dev/lib/Foswiki.pm line 1538<br /> Foswiki::new('Foswiki', 'undef', 'Foswiki::Request=HASH(0x9050f70)', 'HASH(0x93f8254)') called at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/UI.pm line 276<br /> Foswiki::UI::_execute('Foswiki::Request=HASH(0x9050f70)', 'CODE(0x9405128)', 'view', 1) called at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/UI.pm line 258<br /> Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x9050f70)') called at /TARe/wiki/twiki/twiki_dev/lib/Foswiki/Engine/CGI.pm line 26<br /> Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x92c2a98)') called at /TARe/wiki/twiki/twiki_dev/bin/view line 45</font>

I've switched it over to "Local" and configured the local DBI sucessfully without issues.

I just can't seem to be able to get the "Remote" to work. Any sugestions would be appreciated!!

Thanks!

-- Main.EdwardMoscardini - 13 Jul 2009

Closing this ticket due to inactivity. Please re-open, if necessary.

-- Main.OliverKrueger - 09 Oct 2009

QuestionForm edit

Subject	Using an extension
Extension	DatabasePlugin
Version	Foswiki 1.0.5
Status	Closed unanswered

Topic revision: r2 - 09 Oct 2009, OliverKrueger

Support

Quick Links

Tools

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. see CopyrightStatement.