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:
URL: jdbc:mysql://192.0.0.277/parts_database
Driver: com.mysql.jdbc.Driver
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:
jdbc:mysql://192.0.0.277:3306/parts_database
Let me tell you my problem and my solution solution:
For inspection, add a logging entry with level debug and
class
"de.scandio.confluence.plugins.pocketquery.util.LogUtil"
at Confluence Admin =>
"Logging and Profiling"
de.scandio.confluence.plugins.pocketquery.util.LogUtil
and select debug
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
Best regards
J.D.
Thank you J D! I updated our documentation with the port part in the MySQL URL and the driver requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Excellent, thanks for doing that, it would have helped me at the time :P One suggestions is that you do not actually have to restart the server, just the Confluence process.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yeah, by that I actually meant Confluence. I'll change this too ;). Would you consider to leave a review at the marketplace if you like PocketQuery?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
Update:
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I´m glad you did it. For me it took at least one or two hours to find all components to make this work. :D In the end it looks like the easiest thing xD I help where i can :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.