Tags:
create new tag
, view all tags

SID-01189: Database Plugin error

Status: Answered Answered TWiki version: Perl version:
Category: DatabasePlugin Server OS: redhat Last update: 3 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:

-- PeterThoeny - 2011-10-25

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

      Change status to:
ALERT! 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.
SupportForm
Status Answered
Title Database Plugin error
SupportCategory DatabasePlugin
TWiki version

Server OS redhat
Web server apache
Perl version

Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r10 - 2012-01-23 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2015 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.