It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Why can't Power Scripts for Confluence use the database to run SIL script?

Hello,

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: 4.8.0.6
Confluence database name: PostgreSQL version 42.1.1

Any ideas why this doesn't work? 

Thank you!

1 answer

Hello Alexandra,

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:

  • Does your query work outside Jira?
  • Try performing that same query using the sql() routine.
    https://confluence.cprime.io/display/SIL/sql
  • A common mistake is that users misspell their datasource connection when performing their query. Check that the datasource referenced in your query matches l the datasource name. The name is case sensitive. 
    https://confluence.cprime.io/display/SIL/Configuring+datasources
  • Look for any error messages in the Confluence log files,  which are normally found at: <CONFLUENCE_HOME>/logs/atlassian-confluence.log

As stated previously, we would love to help you troubleshoot your datasource connection. Please submit a support ticket here:
https://jira.cprime.io/servicedesk/customer/portal/2/create/13

As always, feel free to stop by chat so we can give you immediate service.

https://drift.me/hyrumsteffensen

Regards,

Hyrum Steffensen
Product Engineer, Power Scripts

Hi @Hyrum Steffensen--Cprime ,

Please see below my answers to your questions: 

  • Does your query work outside Jira? Yes! Already tries and it works
  • Try performing that same query using the sql() routine.
    https://confluence.cprime.io/display/SIL/sql  Not working since we cannot connect at all to the datasource
  • A common mistake is that users misspell their datasource connection when performing their query. Check that the datasource referenced in your query matches l the datasource name. The name is case sensitive. Already checked. URL used in datasource si the exact same as the one from System Information section. 
    https://confluence.cprime.io/display/SIL/Configuring+datasources
  • Look for any error messages in the Confluence log files,  which are normally found at: <CONFLUENCE_HOME>/logs/atlassian-confluence.log Already looked but found nothing important to be noted. 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

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...

7,545 views 6 6
Join discussion

Community Events

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

Events near you