Project

General

Profile

WARNING: Problem initializing database. Specified key was too long; max key length is 767 bytes.

Serhii Administrator
Added over 4 years ago

Hello. Can you help me solve this problem.The logs writes that. And the server will not start.

2014-11-04 13:52:26.089 [main] ClConSQLRepository.initRepository() WARNING: Problem initializing database:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

    at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)

    at com.mysql.jdbc.Util.getInstance(Util.java:383)

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)

In init.propirities file I have that:

--user-db = mysql

--user-db-uri = jdbc:mysql://host:3306/name_database?user=user&password=password&autoCreateUser=true&useUnicode=true&characterEncoding=UTF-8

--data-repo-pool-size = 10

I use Tigase 5.2.


Replies (2)

Added by Serhii Administrator over 4 years ago

Can you suggest something.

Added by Igor Karjitski over 4 years ago

Plz check out the answers in other thread: https://projects.tigase.org/boards/15/topics/3244

    (1-2/2)