Re: MySQL and Installation Wizard

Ok, I wasn't aware Java does not have a support for Unix Socket
binding as I had my database (MySQL) configured as such. Anyway, I had
to comment out "skip-networking" from MySQL config file to have it to
work with TCP. In addition, for people who don't have character
support for UTF8 in their database, you have to do it when you create
your database like following:

mysql> create database yourdb character set utf8;

That's it. Moving on to the next issue... *sigh*

On 8/4/06, Evan J <[email protected]> wrote:
> 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
>