|
From: Christian B. <chr...@us...> - 2017-03-03 21:15:18
|
- **status**: open --> closed-fixed - **Comment**: Thanks for the confirmation that the latest upgrade.php works :-) I'll close this bug as fixed (in 3.0.3 or 3.1, whatever number the next release will have) --- ** [bugs:#379] Setup fails on MySQL with non-Latin1 as default charset** **Status:** closed-fixed **Group:** v3.0 **Created:** Sat Sep 17, 2016 11:54 PM UTC by M. Buecher **Last Updated:** Thu Mar 02, 2017 10:46 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. |
