MySQL and Installation Wizard
"Evan J " <[email protected]>
| Newsgroups | gmane.comp.cms.jahia.install |
|---|---|
| Message-ID | <[email protected]> |
Hi, I am having some problem getting MySQL to work with Jahia. I have created an appropriate database for jahia with user/password manually and I've not problem connecting to the database with jahia user (mysql -D jahia -u jahiau -p...) through commandline. The URL to database is jdbc:mysql://localhost/jahia?useUnicode=true&characterEncoding=UTF-8 and I receive the following exception stack trace from the wizard: Error while connecting to the database with url=[jdbc:mysql://localhost/jahia?useUnicode=true&characterEncoding=UTF-8] user=[jahiau] password=[**EDITED**]: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1765) at com.mysql.jdbc.Connection.(Connection.java:430) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.jahia.admin.database.DatabaseConnection.databaseOpen(DatabaseConnection.java:250) at org.jahia.admin.database.DatabaseConnection.databaseTest(DatabaseConnection.java:108) at org.jahia.bin.JahiaConfigurationWizard.testDBConnection(JahiaConfigurationWizard.java:1876) at org.jahia.bin.JahiaConfigurationWizard.processAdvSettings(JahiaConfigurationWizard.java:1142) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jahia.utils.ActionHandler.call(ActionHandler.java:142) at org.jahia.bin.JahiaConfigurationWizard.dispatcher(JahiaConfigurationWizard.java:366) at org.jahia.bin.JahiaConfigurationWizard.service(JahiaConfigurationWizard.java:222) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jahia.bin.filters.ntlm.NtlmHttpFilter.doFilter(NtlmHttpFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** I've the following connector in jahia/WEB-INF/lib: mysql-connector-java-3.1.7-bin.jar Again, I can connect to `jahia' database manually fine but I can't get JDBC to connect to the database through jahia application. Any ideas? Any log file I should be checking and if so what? Thank you