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)".
Checking for 'wiki username' of greater that 16 characters, and fail
customized username, if so.
* 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
* 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."
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