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.
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
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>
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"
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.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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