Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004610opensim[GRID] User Servicepublic2010-03-03 14:162011-08-25 23:01
ReporterJeff1564 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionsuspended 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0004610: auth tables not being populated from old users table
Descriptionnew installation of ROBUST, restored users and friends table from the old database, the auth table is not populated with the old hash pass and salt, usersaccounts and friends are populated fine. New created users can login normally but the log in fail for old users since the hash is not there..
TagsNo tags attached.
Git Revision or version number2348
Run Mode Grid (1 Region per Sim)
Physics EngineODE
Script Engine
Environment.NET / Windows32
Mono VersionNone
Viewer
Attached Files

- Relationships
related to 0004604closedjohndrellwolf Unable to login to region 

-  Notes
(0015091)
Diva (administrator)
2010-03-03 14:44

yeah, there seems to be problems with the migration for auth. See the related issue, and how he fixed it. But we need to figure out why it doesn't work the first time.
(0015095)
Jeff1564 (reporter)
2010-03-03 15:02
edited on: 2010-03-03 15:16

Running some tests... if the first run the migration find NULL as webLoginKey from the (old)users table it will not populate the auth table. We have about 1000 users with NULL since or DB is running since september 2007. After "Fix" the NULL field to UUID.Zero it still not populating.

(DO NOT DO THIS WITH YOUR DATABASE THIS IS JUST TESTING)
Solution -- > fixed the NULL fields. Purge all new tables (just keep (old)users,(old)userfriends. Run the ROBUST and it will populate.

(0015100)
Diva (administrator)
2010-03-03 16:30

There's something fishy going on with being able to migrate after the first auth table is dropped. It's a WFT situation. Melanie probably needs to look into this.
(0019706)
makopoppo (manager)
2011-08-25 23:01

It anyway seems to be an obsolete issue today, just closing it.

- Issue History
Date Modified Username Field Change
2010-03-03 14:16 Jeff1564 New Issue
2010-03-03 14:16 Jeff1564 Git Revision => 2348
2010-03-03 14:16 Jeff1564 SVN Revision => 0
2010-03-03 14:16 Jeff1564 Run Mode => Grid (1 Region per Sim)
2010-03-03 14:16 Jeff1564 Physics Engine => ODE
2010-03-03 14:16 Jeff1564 Environment => .NET / Windows32
2010-03-03 14:16 Jeff1564 Mono Version => None
2010-03-03 14:43 Diva Relationship added related to 0004604
2010-03-03 14:44 Diva Note Added: 0015091
2010-03-03 15:02 Jeff1564 Note Added: 0015095
2010-03-03 15:03 Jeff1564 Note Edited: 0015095
2010-03-03 15:16 Jeff1564 Note Edited: 0015095
2010-03-03 16:30 Diva Note Added: 0015100
2011-08-25 23:01 makopoppo Note Added: 0019706
2011-08-25 23:01 makopoppo Status new => closed
2011-08-25 23:01 makopoppo Resolution open => suspended


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker