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!
Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs