Last modified: 2007-04-16 16:48:45 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T9285, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 7285 - Need to check MySQL username length during installation
Need to check MySQL username length during installation
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: easy, patch, patch-need-review
Depends on:
  Show dependency treegraph
Reported: 2006-09-10 19:17 UTC by Iain (Libre) Davidson
Modified: 2007-04-16 16:48 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Check mysql user lenght is not > 16 (452 bytes, patch)
2007-02-03 13:55 UTC, Antoine "hashar" Musso (WMF)

Description Iain (Libre) Davidson 2006-09-10 19:17:41 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...
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.
Comment 1 Iain (Libre) Davidson 2006-09-10 19:19:06 UTC
Easily re-producible... available to test/debug if needed.
Comment 2 Brion Vibber 2006-09-10 19:51:43 UTC
"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."
Comment 3 Antoine "hashar" Musso (WMF) 2007-02-03 13:55:01 UTC
Created attachment 3174 [details]
Check mysql user lenght is not > 16

Patch to check if the username is 16 or less chars.
Comment 4 Antoine "hashar" Musso (WMF) 2007-04-16 16:48:45 UTC
applied in r21297

Note You need to log in before you can comment on or make changes to this bug.