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

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.

4 answers

1 accepted

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

Hi all,

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

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.

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.

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/&lt;database Name&gt;"
	 username="confluencesql"
	 password="&lt;password&gt;"
	 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.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,943 views 27 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you