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

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 7285 - Need to check MySQL username length during installation
Need to check MySQL username length during installation
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: easy, patch, patch-need-review
Depends on:
Blocks:
  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: ---


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

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...
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.
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."

http://dev.mysql.com/doc/refman/5.1/en/user-names.html
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.


Navigation
Links