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 [EMAIL PROTECTED] 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
