Re: MySQL and Installation Wizard

How did you create the database?

Here is an example:

create database jahia;
alter database jahia CHARACTER SET utf8;
grant all privileges on jahia.* to jahia@localhost identified by 'jahia';
flush privileges;

Cheers,
Philippe.

At 05.08.2006 04:59, you 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

-------=[ pvollenweider at jahia dot com ]=---------
Jahia : A collaborative source CMS and Portal Server
www.jahia.org Community and product web site
www.jahia.com Commercial services company