Install OTRS 3.2.9 - Error create Mysql DB

Moderator: crythias

Locked
vlad11
Znuny newbie
Posts: 1
Joined: 29 Aug 2013, 17:32
Znuny Version: 3.2.9

Install OTRS 3.2.9 - Error create Mysql DB

Post by vlad11 »

Subj.
System - FreeBSD 9.2-RC1.

Code: Select all

# pkg_info | grep mysql
mysql-client-5.6.13 Multithreaded SQL database (client)
mysql-server-5.6.13 Multithreaded SQL database (server)
p5-DBD-mysql-4.023  MySQL driver for the Perl5 Database Interface (DBI)
php5-mysql-5.4.17   The mysql shared extension for php
php5-mysqli-5.4.17  The mysqli shared extension for php
Through the Web-installer get output:

Code: Select all

Creating database 'ticket_tto6_test':

Ok..
Creating tables 'otrs-schema.mysql.sql':

Error! :-(

---==> Specified key was too long; max key length is 767 bytes
Install via the command line:

Code: Select all

[15:49]nagios:root->scripts/database# mysql ticket_tto6_test < otrs-schema.mysql.sql
ERROR 1071 (42000) at line 1057: Specified key was too long; max key length is 767 bytes
InnoDB Database to UTF-8 encoding.
Locked