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

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.


4 answers

1 accepted

1 vote
Answer 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:

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

	 url="jdbc:jtds:sqlserver://sqlsrvr2:1433/&lt;database Name&gt;"


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
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,416 views 3 13
Read article

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