Last modified: 2007-04-16 16:48:45 UTC
During a clean/new installation of Mediawiki 1.7.1 / Php 5.0.1 / MySql 4.1.10a . Mysql error is returned when db username is more than 16 characters. Installation process crashes and doesn't give suggestion on how to fix. # Granting user permissions... Query "GRANT DELETE,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES ON `_wikidb`.* TO 'REALLY_LONG_WIKIUSER_NAME'@'%' IDENTIFIED BY 'falsepassword' " failed with error code "The host or user argument to GRANT is too long (localhost)". Suggestion, Checking for 'wiki username' of greater that 16 characters, and fail customized username, if so. Notes: * Version numbers: Mediawiki 1.7.1 on SuSE 9.3, Mysql 4.1.10a, PhpAdmin 2.7.0-pl2, Php 5.0.1 , Apache 2.0.53 . * Username's of greater than 16 characters also sometimes lockup mysql/apache webserver. * MyPhpAdmin also prevents creation of usernames of greater than 16 characters.
Easily re-producible... available to test/debug if needed.
"MySQL usernames can be up to 16 characters long. This limit is hard-coded in the MySQL servers and clients, and trying to circumvent it by modifying the definitions of the tables in the mysql database does not work." http://dev.mysql.com/doc/refman/5.1/en/user-names.html
Created attachment 3174 [details] Check mysql user lenght is not > 16 Patch to check if the username is 16 or less chars.
applied in r21297
