Page MenuHomePhabricator

Need to check MySQL username length during installation
Closed, ResolvedPublic

Description

Author: iain-mediazilla

Description:
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.

Version: unspecified
Severity: normal

Details

Reference
bz7285

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:26 PM
bzimport set Reference to bz7285.
bzimport added a subscriber: Unknown Object (MLST).

iain-mediazilla wrote:

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
Check mysql user lenght is not > 16

Patch to check if the username is 16 or less chars.

Attached: