New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists
This question about Configuration: Asked

DATABASE_SQL configuration

-- JackieLester - 20 Nov 2013

I've found my version! It says it is Foswiki-1.1.7, Plugin API version 2.2

-- JackieLester - 20 Nov 2013

I am a complete newcomer to this foswiki world (I can't even work out what version I am using - that's how much of a numpty I am) so please be patient with me.

I am trying to use the DATABASE_SQL plugin to get some data out of an Oracle database and display it in my wiki page. The database is on a different server. I have attempted to configure the database plugin, assumed I shoud use "remote" and told it things like servername, database SID, username, password, but when I subsequently try and use %DATABASE_SQL% in my wiki page, nothing happens - it just sits there with its % signs as a bit of text instead of weaving the magic.

At least two things are confusing me:

1) It never asks me for a port number for the database listener, so how will it try and connect to my database?

2) The DATABASE_SQL uses a description in its syntax and I can't work out what value I should be using.

All top tips gratefully received.

QuestionForm edit

Subject Configuration
Extension DatabasePlugin
Status Asked
Related Topics
Topic revision: r2 - 20 Nov 2013, JackieLester - This page was cached on 17 Sep 2018 - 23:00.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy