MySQL Bugs: #37378: Error creating a local account on login

Bug #37378	Error creating a local account on login
Submitted:	12 Jun 2008 17:56	Modified:	17 Jun 2008 17:29
Reporter:	Alfranio Correia	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Websites: MySQLForge	Severity:	S1 (Critical)
Version:		OS:	Any
Assigned to:	Jay Pipes	CPU Architecture:	Any

Description:
I have an account in mysql.com but I cannot log in into mysqlforge.
The system recognizes my remote account (in the mysql.com) and says that a local account will be created.
However, after typing the "challenge" it returns the following message: "We could not create a local account."

What am I supposed to do ? What am I doing wrong ?

Cheers.

How to repeat:
Create an account on mysql.com and try to use it on mysqlforge.

Thank you for a problem report. 

Please, check if you can login into bugs.mysql.com, for example, with that same email address. I was able to use mine from mysql.com without any problems on forge.mysql.com.

Yeah !!! I am able to login on bugs.mysql.com.

Cheers.
Alfranio.

I am experiencing the same issue. I have a mysql.com account and a bugs.mysql.com account, both of which I have no problem accessing. MySQL Forge is not allowing me to login - the issue reported in this bug occurs.

This kinda sucks because I want to participate in some upcoming MySQL University sessions, but I cannot do that effectively without a working Forge login.

Please note that bugs.mysql.com, forge.mysql.com and mysql.com use the same user account system for *authentication*.  The Forge has an additional user account system which is needed for the wiki and profile areas of the Forge, which is where the problem is happening...

OK, the bug has been found, and a fix is in the works.  Here is the current conditions which reproduces the bug:

1) User must have *already* created a MediaWiki account prior to 16.04.08 with email address XYZ@ABC.com

2) User must NOT have created a Forge user account prior to 16.04.08 with email address XYZ@ABC.com

3) User must have created an account on mysql.com for email address XYZ@ABC.com

4) User must login to Forge using XYZ@ABC.com

At this point, the system recognizes the remote account in mysql.com.  The system then calls PeopleHandler::get_local_user_id_from_email() and finds no local Forge user profile.  It pulls the user account information from the remote central API and attempts to create a local Forge user account.  This succeeds, however, immediately afterwards, it attempts to create a local wiki account for that email address and fails on a key violation, rolling the entire transaction back.

I'm working on a check of the local wiki account creation piece currently.  The fix should be pushed to forge.mysql.com within a couple hours.  Thanks for your continued patience.

-Jay

Fixed in r540.  Problem was a newly added column in ForgeUser that was not properly populated in the new account creation process.