|
From: Christian B. <chr...@us...> - 2017-03-02 18:09:17
|
- **Comment**: Can you please test with the latest upgrade.php from https://github.com/postfixadmin/postfixadmin ? I fixed several issues with overlong indexes (caused by utf8mb4) some days ago and at least one user confirmed that it works for him now. --- ** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset** **Status:** open **Group:** v3.0 **Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher **Last Updated:** Wed Mar 01, 2017 10:10 PM UTC **Owner:** nobody Experienced on Debian 8 with package postfixadmin 2.3.7-1 with MySQL 5.5. An initial setup of postfixadmin with MySQL fails when a multi-byte charset is used as default (e.g. utf8mb4) due to key length limitiations. UTF8MB4 is need for 100% Unicode support as UTF8 has limitations in MySQL (https://mathiasbynens.be/notes/mysql-utf8mb4). Error messages: Invalid query: Specified key was too long; max key length is 767 bytes (for [InnoDB key column](http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html)) Invalid query: Specified key was too long; max key length is 1000 bytes (for [MyISAM table key](http://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html)) Please consider adding settings in config.inc.php to specify the lengths of the following fields: * domain * username * address * alias_domain * email This will allow users to reduce the character length to keep the byte count under the key length limitation, while keeping a multi-byte charset as default for names, texts, etc. Additionally remove please the LATIN1 definitions for complete tables (see list at the end of the report). Otherwise specify LATIN1 on these fields in the CREATE statements of function upgrade_1_mysql() of upgrade.php, while keeping the MySQL default charset on the table and other fields. Additionally please remove the LATIN1 definitions for complete tables and replace it with a LATIN1 definition only for the above mentions fields. upgrade_1_mysql(): vacation table upgrade_5_mysql(): all tables upgrade_81_mysql(): vacation upgrade_473_mysql: all tables --- Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/bugs/ To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/bugs/options. Or, if this is a mailing list, you can unsubscribe from the mailing list. |
