Project

General

Profile

installation with mysql error

Costantino Riko87
Added over 4 years ago

i have this error when install with mysql:

Checking the database schema    Can't load schema: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the right syntax to use
near 'CREATE INDEX part_of_user_id ON tig_users (user_id(255))' at line 1
Checking whether the database needs conversion  Something wrong, the schema still is not loaded...
Loading socks5 component schema Can't load socks5 schema: Specified key was too long; max key length is 767 bytes

who can help me?


Replies (4)

Added by Costantino Riko87 over 4 years ago

No one know how to solve?

the sql scripts in database folder of the project are bugged :(

Avatar?id=6023&size=32x32

Added by Artur Hefczyc TigaseTeam over 4 years ago

The scripts are not bugged for sure. We use them all the time.

Before we can help you with anything, please provide some more details:

  1. What version of the Tigase server are you trying to install?

  2. What version of MySQL do you use?

  3. How do you install Tigase?

  4. Where do you see the above errors - logs, console....

  5. What operating system do you use?

Added by Costantino Riko87 over 4 years ago

Hi,

i follow this tutorial to build last version: http://www.tigase.org/content/tigase-xmpp-server-520-and-later-compilation-and-generating-distribution-packages

i'm using MySQL Community Server 5.6.19 on Ubuntu/Debian 14.04 LTS (GNU/Linux 3.13.0-24-generic x86_64)

Added by Wojciech Kapcia TigaseTeam over 4 years ago

Just to make sure - you are using generated installer - correct? Can you try to setup schema using shellscripts:

/scripts/db-create-mysql.sh tigase_username tigase_password database_name root_username root_password database_host

    (1-4/4)