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?
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 @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!
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...
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