Hello, I'm new to Confluence. PocketQuery looks like the exact solution I need to be able to incorporate our external data with Confluence, but I cannot get it to connect to our MySQL server.
MySQL platform: Windows Server 2012
MySQL version: 5.6
MySQL port: 3306 (default)
The PocketQuery server entry looks like this:
The username and password are correct, but I receive the following error:
I cannot connect to this database. For inspection, add a logging entry with level debug and class "de.scandio.confluence.plugins.pocketquery.util.LogUtil" at Confluence Admin => "Logging and Profiling". PocketQuery will then log information to atlassian-confluence.log.
I do not know anything about JDBC and cannot find much information about how to enable it on my MySQL server, or if I even need to do that.
Thanks for reading!
Hey, i had the same problem like you.
First try this:
Let me tell you my problem and my solution solution:
For inspection, add a logging entry with level debug and
at Confluence Admin =>
"Logging and Profiling"
If you need more help, copie your log files here in a code makro pls. Also when my hole solution didn´t fit for you or you need more lead, like pictured instructions
Hope this helps
Hello, thanks for the response! I have followed your steps but still receive the error, but my log file has stopped updating!
I installed the mysql-connector-java-5.1.34-bin.jar to the folder /opt/atlassian/confluence/confluence/WEB-INF/lib per this website's instructions: https://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL
The file I downloaded was from this page, I selected the "platform independent" option: http://dev.mysql.com/downloads/connector/j/
The log file has not updated in hours, the last line says this:
2014-11-11 11:41:13,237 DEBUG [http-bio-8090-exec-67] [atlassian.confluence.logging.ConfluenceHomeLogAppender] shutdown closing appender
How can I re-enable logging?
I got it working! I had to reboot the confluence process (sudo ./start-confluence.sh restart) in order for it to work. Seems like we are good.
Thank you for your help, JD!
We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG