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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.