Installer 1.0.1 on CentOS7

[sapsa]

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.

For now, there is no problem with sentora - but I probably didnt test all of it tools.
Should I be worried with ERROR 1071?
I didn't have any sendmail/postfix before instaling sentora

The second error im ignoring because apache (httpd) started without any problem and working ok (but im writing about it so it can be fixed with newer version of sentora installer)

[Me.B]

This error seem related to MySQL

http://dba.stackexchange.com/questions/4...-mysql-5-6

we are still investigating it.

[sapsa]

Dear Me.B,

I manage to find the problem (you probably too).
sentora_postfix.sql
this database structure script is executed till 115 line which is "CREATE TABLE 'quota' (" anything after that table including that table aint created so probably postfix is broken.

Probably because usernamer is VarChar255 and Path is 100; the primary key is on both so:
255 * 3 + 100 * 3 = 1065 which is more than 1000;

[Me.B]

Yep likely installer will be updater quickly

[sapsa]

This error seem related to MySQL

http://dba.stackexchange.com/questions/4...-mysql-5-6

we are still investigating it.

Yep likely installer will be updater quickly

im hoping that it will be fixed with some kind of script and there wont be need for reinstall centos to make clean sentora installation.

[Me.B]

ok a patch is easy to set too. Checking my own centos 7 installs

M B

[sapsa]

was it a success ?
could you shear the script ?

[AdamG4Corps]

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)

[sapsa]

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)

Thanka for this information. This probably is workaround but I would like to get official fix, so I wont have problem in future. Its been over two weeks now... support it probably hard coding the solution...... Me.B had probably some issues with this... I will still wait because you never knew what outcomes your will get with not official workarounds.

[Me.B]

The official fix will be the same likely.

M B