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:
Category:MySQL Websites: MySQLForge Severity:S1 (Critical)
Version: OS:Any
Assigned to: Jay Pipes CPU Architecture:Any

[12 Jun 2008 17:56] Alfranio Correia
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 ?


How to repeat:
Create an account on mysql.com and try to use it on mysqlforge.
[12 Jun 2008 20:22] Valeriy Kravchuk
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.
[12 Jun 2008 20:28] Alfranio Correia
Yeah !!! I am able to login on bugs.mysql.com.

[17 Jun 2008 11:18] Shlomo Swidler
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.
[17 Jun 2008 15:35] Jay Pipes
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...
[17 Jun 2008 15:52] Jay Pipes
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.

[17 Jun 2008 17:29] Jay Pipes
Fixed in r540.  Problem was a newly added column in ForgeUser that was not properly populated in the new account creation process.