Hi Ronan,
is it a problem that happened after you change
something either in the configuration of Mysql or
the database settings of Jahia ? Is it on a fresh Jahia install ?
It seems the default charset of the database and
the charset of some tables is not the same.
Michel
Hi,
I use jahia 4.1.0_01 build6070 with MySQL 4.1.14. The sever runs under linux.
When jahia starts, it generates a SQLException :
5 [main] ERROR
org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUserInDB:818
- SQL Exception occured : Co
uld not read the user [root:0]
java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '
='
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347)
at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:958)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.jahia.services.database.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:77)
at
org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUserInDB(JahiaUserManagerDBProvider.java:794)
at
org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUser(JahiaUserManagerDBProvider.java:295)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
This exception appears just after the jahia 's logo in the catalina.out file.
I have tried to modify the default-character-set
and the default-collation properties in the
configuration file of MySQL (my.cnf) but I always have the same error.
Can someone help me ? I search a solution for 2
days and I have found nothing about this error.
Thank you.
--
MARQUET Ronan - Collaborateur SILICOMP - AQL
Rue de la Châtaigneraie
CS 51766
35517 CESSON SEVIGNE
Tel : 02 99 12 50 00
Fax : 02 99 63 70 40
