The Admin DSN page also contains content authentication settings. See Content Authentication for more information about that
To use the SQL plugin, you must do the following:
This documentation was originaly based on Tikiwiki 1.7.5 but has been succesfully used for TikiWiki 2.2.
How to Define a DSN
1. On the main Tiki menu, click Admin (if necessary to show the options below this menu item).
2. You'll see the Admin DSN page, shown here:
3. In the Name area, type a name for the external database you want to use. The name cannot contain spaces.
4. In the DSN area, type a valid DSN. See "DSN Syntax," below.
5. Click Save.
DSN format: database-type://user:password@host/database-name
Here's how the DSN looks:
In older versions of tikiwiki this permission needed to be added manually in the users_permissions table and the following syntax was suggested:
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_dsn_localhost', 'Can query localhost', 'dsn', '', '');
It should not be needed in more recent versions (certainly 2.2 and above) but if you do need to add the permission manually consider using the following, which also sets the permission type:
INSERT INTO users_permissions (permName, permDesc, level, type, admin) VALUES ('tiki_p_dsn_localhost', 'Can query localhost', 'dsn', 'dsn', '');
For more information
See PluginSQL to learn how to insert SQL queries in Wiki pages.