SID-01189: Database Plugin error

Status:	Answered	TWiki version:		Perl version:
Category:	DatabasePlugin	Server OS:	redhat	Last update:	14 years ago

i keep getting this error when using the database plugin:

"No such DB test1 at /usr/lib/perl5/5.8.8/CGI/Carp.pm line 314."

in the configure script my settings are:

{Plugins}{DatabasePlugin}{ConfigHost}δ: 192.168.1.12
{Plugins}{DatabasePlugin}{ConfigDriver}δ: mysql
{Plugins}{DatabasePlugin}{ConfigDB}δ: test1
{Plugins}{DatabasePlugin}{ConfigSID}: ''
{Plugins}{DatabasePlugin}{ConfigTable}: ''
{Plugins}{DatabasePlugin}{ConfigUsername}δ: user1
{Plugins}{DatabasePlugin}{ConfigPassword}δ: passwduser1

and

{Plugins}{DatabasePlugin}{EditURLPrefix}δ
{Plugins}{DatabasePlugin}{EditURLPath}δ

are blank.

In the page im making a call like so: %DATABASE_SQL{description="test1" sql="SELECT * from testTable" format="| $name $address $number |"}%

-- AndrewKim - 2011-05-31

Discussion and Answer

Please use your real account. I removed the BitCloud account. As indicated in the registration page, please use your real name. This gives a personal touch to our community where people know each other by their real name.

-- PeterThoeny - 2011-05-31

So an update:

i updated all the CPAN modules and now it seems like it got past that issue. now this is the current issue at hand. the error message is:

No such DB test1 at /var/www/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 106.

the configs and call is still the same.

-- AndrewKim - 2011-06-02

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- PeterThoeny - 2011-07-08

I have the exact same error when configured with a local database. The plugin is only making a connection to the database when it is configured 'remote'.

No such DB test at /var/www/twiki/lib/TWiki/Plugins/DatabasePlugin.pm line 92.

My setup is the same as the setup of AndrewKim.

-- TimmoVerlaan - 2011-10-25

Is the DBD::mysql database driver properly installed and configured? The DatabasePlugin depends on Perl DBI, which depends on DBD::mysql if you want to connect to a MySQL database.

FYI, I once had to install a driver for Microsoft SQL Server. It was challenging to get it working. FWIW, here is the DatabasePlugin configuration I used (which can't be applied directly in your case) :

$TWiki::cfg{Plugins}{DatabasePlugin}{Databases} = [
 {
   'sid' => 'sid',
   'hostname' => 'db.example.com',
   'description' => 'ExampleData',
   'username' => 'example',
   'password' => 'password',
   'database' => 'ExampleData',
   'table_name' => '',
   'driver' => 'ODBC'
 }
];

To debug, make sure you can talk to the mysql database on the DBI level first. Some pointers:

• http://www.perl.com/pub/1999/10/DBI.html - guide to Perl DBI module
• http://dev.mysql.com/downloads/dbi.html - DBD::mysql database driver

Related question: SID-01305.

-- PeterThoeny - 2011-10-25

Hi Peter,

I tested with this small script:

#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect('dbi:mysql:dbname=rt;host=192.168.2.11','hdtools','password',{AutoCommit=>1,RaiseError=>1,PrintError=>0});
print "2+2=",$dbh->selectrow_array("SELECT 2+2"),"\n";

And this was the result:

./test.pl
2+2=4

This result indicates me the DBI is functioning as it should.

Still the error is the same as Timmo: No such DB rt at /var/www/wiki.xxxx.nl/lib/TWiki/Plugins/DatabasePlugin.pm line 91

Can this problem be caused by using an external DB instead of a localhost?

-- MarkVanWinsen - 2011-11-18

Peter,

Can you give us an idea on what to do next to fix this issue? Is there something else we could test?

Kind regards,

Mark

-- MarkVanWinsen - 2011-12-05

Sorry, I can't spend more time on this. TWiki is open source, where people take and give back. If inclined you can hire a consultant to help you out in a timely manner.

-- PeterThoeny - 2011-12-05

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.