Question

I have DBI modules installed, and the DatabasePlugin working perfectly. However, I need the better reporting capibilities of DBIQueryPlugin and my call to DBI_QUERY shows as plain text:

%DBI_QUERY{db1}%
SELECT
hostname
FROM
os
.header
sampleheader
.body
%hostname%
.footer
samplefooter
%DBI_QUERY%

I've edited the config file for my database (much the same as DatabasePlugin). Does anyone know what I might have done wrong? I've installed the plugin the same way as DatabasePlugin (unzipped the package in the twiki dir and activated it via the admin panel). In fact, I've deactivated and activated it a couple times. I've tried both the Dakar and non-Dakar packages. I've also tried double quotes around the db name in the call and no quotes, etc etc..

I would think if there was a problem with the config file or with the parameters, it should give me an error, no?

Environment

-- GeneHorodecki - 23 May 2006

Answer

Hi,

I can't be of much help, but I can tell you that your script, above, looks correct. Also, make sure your lib/DBIQueryPlugin.cfg file is properly configured with the correct username and password for your database. Are you getting any error messages? I never got plain text when I initially installed DBIQueryPlugin, but I did get error messages.

-- JulietHabberstandish - 31 May 2006

Also make sure that lib/DBIQueryPlugin.cfg is readable by the web server user or group.

-- DonWennick - 20 Jun 2008