search

sentora / sentora-installers

Provides a central place to store, version and distribute the Sentora installer and upgrade scripts from.
GNU General Public License v3.0
154 stars 148 forks source link

ERROR 1071 (42000) at line 115: Specified key was too long; max key length is 1000 bytes #53

Closed bigretromike closed 9 years ago

bigretromike commented 9 years ago

Im using CentOS7 on VPS OVH

When ever I install it i get this:

-- Installing Postfix
ERROR 1071 (42000) at line 115: Specified key was too long; max key length is 1000 bytes

# Building suhosin
2015-02-23 12:54:54 URL:https://codeload.github.com/stefanesser/suhosin/zip/0.9.37.1 [238480] -> "suhosin.zip" [1]
Installing shared extensions: /usr/lib64/php/modules/
ln -s '/usr/lib/systemd/system/httpd.service' '/etc/systemd/system/multi-user.target.wants/httpd.service'
Job for httpd.service failed. See 'systemctl status httpd.service' and 'journalctl -xn' for details.
bigretromike commented 9 years ago

AdamG4Corps post this on forum but it is not implemented still:

"Hi, I have same problem with fresh install on Centos 7 VPS.

There are two errors in script sentora_postfix.sql:

  1. in table quota engine is set MyISAM and for keys bigger than 1000 bytes just use Engine=InnoDB
  2. in table vacation_notification there is foreign key on col on_vacation to table vacation (email). But email is defined as utf8 varchar and on_vacation is latin1 varchar which leads to error

    1005

    • Can't create table 'sentora_postfix.vacation_notification' (errno: 150)"
andykimpe commented 9 years ago

vps clasic or cloud ?

thank you to provide the complete log file

without this information is not perssone poura check it comes to a bug in the installer or system

a problem on the OVH interface that I want checked

bigretromike commented 9 years ago

ovh vps cloud

Caffe1neAdd1ct commented 9 years ago

InnoDB has now been fixed in preconf/sentora-install/sql/sentora_postfix.sql at master, so should be fixed.

I'm thinking of changing all to use InnoDB engine, will update once implemented.

Caffe1neAdd1ct commented 9 years ago

Fixed in master and upgrade script added to 1.0.4 release in preconf/sentora-update/1-0-4/sql/1-postfix-innodb. Initial installs fixed in preconf/sentora-install/sql/sentora_postfix

Closing for now, any issues please let us know.