Plugins installed but cannot be used as a macro in the macro browser

[Pangianto Pang]

Hi Support,

i installed confluence version 4.2.8 and installed this sql plugin from https://marketplace.atlassian.com/plugins/org.swift.confluence.sql

the installation is successful, but i cannot use the macro provided by the plugin.

I do not know why.

Can somebody help me out please.

Thanks.

[hsuhailah · Accepted solution]

This macro can be edited and added using Insert wiki markup. They are not listed in the macro browser. For details, you may refer to: https://bobswift.atlassian.net/wiki/display/TBL/2011/09/19/Confluence+4.0+compatibility+for+Table+and+other+plugins

[Pangianto Pang]

Hi all,

Thanks Jo-Anne and Hannis, the plugin is working now.

[Jo-Anne MacLeod]

OK, final update. I got this plugin to work.

To create the datasouce:

we added a user to our Sqlserver database. The user has query permission only.

I created the datasource mine is shown below.

Shutdown confluence install, before editing your server.xml

Back up your server.xml before making changes, in case you mess something up.

I then put the new datasource defination in the server.xml file. This was actually the most troublesome thing to figure out. In the server.xml file, there is a section called <Engine>, within this section is <host>, and within that section is another section called <Context>. The defination of the datasource goes in this section. I put it right before the closing context </Context>

Restart Confluence

name="jdbc/SQLds"
	 auth="Container"
	 type="javax.sql.DataSource"
	 driverClassName="net.sourceforge.jtds.jdbc.Driver"
	 url="jdbc:jtds:sqlserver://sqlsrvr2:1433/<database Name>"
	 username="confluencesql"
	 password="<password>"
	 maxActive="20"
	 maxIdle="10"
	 maxWait="-1"

where:

SQLds is a ramdom name that I chose for my datasource

url - path to my existing database connection

username - new non-priviledged user account

password - pasword for above created account

Hope this helps.

[Jo-Anne MacLeod]

I still don't have the plugin working, but apparently this is what you need to do after the plugin is installed (and licensed).

1) set up a datasource. I'm still trying to figure this out, if I get it working I'll post those steps here as well. Although this part is actually in the documentation.

2) go into the configure setting (on the plugin) and adjust the values if necessary.

3) set up security if you so desire.

To use the plugin, you cannot use it as a standard macro. You will need to go to insert -> Wiki Markup, and put your sql statements there. This is apprently going to be changing in version 5.0.

The usage of the plugin is not described anywhere in the documentation, or if it was I couldn't find it.

The same answers that I have provided here are on the plugin as well. They are actually Bob's comments there, so they are definately correct.

[Jo-Anne MacLeod]

I have exactly the same problem now. I've asked on the plugin page and am waiting for a response back. When I hear back I'll try and update this thread as well.