|
From: Paul P. <pa...@us...> - 2017-03-02 22:46:03
|
Thank you for your fast reply. I copied the new upgrade.php into /usr/share/postfixadmin. The setup now runs through: Database is up to date In /etc/postfixadmin I created a new config.local.php and inserted the shown: $CONF['setup_password'] = 'xxx' The problem I have now is that this inserted one line phrase from that file is shown as the first line on the login or setup web pages. And .. I cannot login with the newly created admin e-mail address and my password. I don't think that I made a mistake ... --- ** [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:** Thu Mar 02, 2017 06:09 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. |
