I have solved my problem. It was a problem with the database. The
restoration of the database has solved the error.
Thank you
Ronan
Michel Romy a écrit :
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
--
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
