Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

SQL data does not show on confluence page

Hello,

I want to use confluence on synology NAS. The pages that needs to be shown on confluence come from a postgress sql database. 

I have de confluence page up and running using docker in synology NAS. The postgres container is also up and running. But the data from the database does not show as pages.

How can I fix this?

 

Regards 

2 answers

2 accepted

1 vote
Answer accepted
Mike Rathwell Community Leader Jan 26, 2021

Hi @aysegul erciyas 

Confluence won't directly display the results from a SQL query out of the box. However, there are a variety of apps you can add that will do this for you. I have used both the Bob Swift ones and Pocket Query; they both work great. The nice thing is that you can drop the results of the SQL query into various table formatting macros to improve visuals and/or function of it.

Hope this helps.

Hi @Mike Rathwell 

I've tried Bob Swift but the add-on does not find my database.

Now I'm trying with Pocket Query but how can I connect to the postgres database on the Synology NAS?

Hi @aysegul erciyas,

I'm one of the developers of the PocketQuery for Confluence app that was mentioned by @Mike Rathwell. If you have any questions about it, don't hesitate to ask here or shoot us an email to support@livelyapps.com! :)

Cheers,
Sven 

Hi @Sven Schatter _Lively Apps_ ,

 

As I said to @Mike Rathwell I have installed the add-on but I can not find how to connect to my postgress database on Synology NAS.

@Sven Schatter _Lively Apps_ ,

I've succesfully connected my database, but now when I want to execute a query its gives me the error 'Unexpected error communicating with the server.'

How can I fix this?

Hi @aysegul erciyas,

I'm pretty sure the error you're seeing ("Unexpected error communicating with the server.") is popping up in a flag when you do a live Query Preview inside the PocketQuery admin, correct? If yes, that's a bug that we are currently working on fixing as we speak.

This is really just a wrong error message, what this really means is that something in your SQL statement is likely wrong (e.g. incorrect syntax). You should be able to see more information about the actual error if you insert the PocketQuery macro into a page and execute your Query there. But you can also just share your SQL statement here or raise a support ticket with us if you don't feel like sharing it publicly.

Hope this helps!

Cheers,
Sven

hi @Sven Schatter _Lively Apps_ ,

There was indeed a syntax error, thank you :)

Awesome! Sounds like you're all set up? Great to hear that! :)

Cheers,
Sven

Yes it's all set up. Now I have to create a space and pages using sql :/

Suggest an answer

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

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

101 views 0 3
Read article

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