We have a SIL script in Confluence that retrieves / uses data directly from the database and it refuses to work. We believe to be a problem of the Power scripts plug-in that connects to the datasource.
The same script is used in JIRA and there it works, but it refuses to do so in Confluence.
The Database Connection URL from System Information found in Confluence Administration section is the same as the one configured in the JDBC URL from Datasources in Confluence Cprime Tools section.
Also, if we try to connect to the database locally we are able to do so, but not with the Power scripts plug-in in Confluence.
Power Scripts for Confluence Installed version: 1.1.6
Power Scripts for JIRA Installed version: 18.104.22.168
Confluence database name: PostgreSQL version 42.1.1
Any ideas why this doesn't work?
This is an interesting if complicated question. Databases can be finicky which requires some finesse and patience. Usually in such situations as you describe, we suggest opening a support ticket so we can ask additional questions about your setup. That being said, here are a list of things to check:
As stated previously, we would love to help you troubleshoot your datasource connection. Please submit a support ticket here:
As always, feel free to stop by chat so we can give you immediate service.
Product Engineer, Power Scripts
Please see below my answers to your questions:
Does your query work outside Jira? Yes! Already tries and it works
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events