nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL data does not show on confluence page

aysegul erciyas

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

Accepted answers

Mike Rathwell

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.

Former user

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

All comments

Hope this helps.

Cheers,
Sven

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?

aysegul erciyas

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.

aysegul erciyas

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

Former user

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

confluence

server

confluence-server

sql

postgres