Talk:Troubleshooting
From OpenSimulator
(Erasing my mistaking text.) |
(→Neither there is a "users" table, nor any table has a "userInventoryURI" field...: new section) |
||
| Line 10: | Line 10: | ||
--[[User:Magneto CartWheel|Magneto CartWheel]] 15:01, 19 October 2010 (UTC) | --[[User:Magneto CartWheel|Magneto CartWheel]] 15:01, 19 October 2010 (UTC) | ||
| + | |||
| + | == Neither there is a "users" table, nor any table has a "userInventoryURI" field... == | ||
| + | |||
| + | On section [[Troubleshooting#After_starting_OpenSimulator_with_Hypergrid_enabled_my_inventory_wont_load.21|"After starting OpenSimulator with Hypergrid enabled my inventory wont load!"]] ''(sic)'' it is claimed that the following two commands will 'fix' Hypergrid-related issues with profiles, inventories, etc. not loading properly: | ||
| + | |||
| + | update users set userInventoryURI="http://new.UGAIM.address:8004" where userInventoryURI = "http://old.UGAIM.address:8004"; | ||
| + | update users set userAssetURI="http://new.UGAIM.address:8003" where userAssetURI = "http://old.UGAIM.address:8003"; | ||
| + | |||
| + | Now, please correct me if I'm wrong, but under OpenSimulator 0.9.3.0, there is no <code>users</code> table any longer. | ||
| + | |||
| + | Instead, there are essentially two tables with user-related information: | ||
| + | |||
| + | # <code>UserAccounts</code> | ||
| + | # <code>GridUser</code> (if your grid is configured to allow Hyperjumps) | ||
| + | |||
| + | Neither has a <code>userInventoryURI</code> or a <code>userAssetURI</code> row; this might have been true in the distant past, but not any longer. <code>UserAccounts</code> stores the local users, so there is a <code>ServiceURLs</code> column, which essentially contains a list of the many service URLs (beyond Inventory and Asset server(s)), one per line; as a consequence, you cannot write a simple one-liner as suggested above — that is, even if the table and the columns exist (legacy?), if you replace the code above with <code>UserAccounts</code> and <code>ServiceURLs</code> instead, then, well, congrats, you've just bricked your own configuration :-( | ||
| + | |||
| + | <code>GridUser</code> seems to deal both with remote accounts hyperjumping to your grid, and, conversely, with 'gridnauts' among your own users that (may) have teleported to a different grid. As such, to track these down, <code>GridUser</code> includes the 'base URI' for the visitor origin grid, saved directly to the <code>UserId</code> field. Currently, the format of this field is made of three subfields — avatar UUID, an URI (to the grid of origin), and the avatar name, all separated by semicolons. The URI ''is'' the 'main' grid URI, that is, the one where the login server is running, and which will probably be able to retrieve the URI for the Inventory & Asset servers of the origin grid. | ||
| + | |||
| + | So... whatever was meant with that suggestion, it definitely requires an update! | ||
| + | |||
| + | — [[User:Gwyneth Llewelyn|Gwyneth Llewelyn]] ([[User talk:Gwyneth Llewelyn|talk]]) 09:45, 26 September 2023 (PDT) | ||
Revision as of 09:45, 26 September 2023
Union section proposal and discussion
Is the situation under "Errors from incomplete data migrations" really and Opensim migration to MySQL from Windows to Linux?.
Should they join these two situations or are they different?
Is the migration table erase a good solution or remigration could damage the integrity of the database?.
Thank you very much.
--Magneto CartWheel 15:01, 19 October 2010 (UTC)
Neither there is a "users" table, nor any table has a "userInventoryURI" field...
On section "After starting OpenSimulator with Hypergrid enabled my inventory wont load!" (sic) it is claimed that the following two commands will 'fix' Hypergrid-related issues with profiles, inventories, etc. not loading properly:
update users set userInventoryURI="http://new.UGAIM.address:8004" where userInventoryURI = "http://old.UGAIM.address:8004"; update users set userAssetURI="http://new.UGAIM.address:8003" where userAssetURI = "http://old.UGAIM.address:8003";
Now, please correct me if I'm wrong, but under OpenSimulator 0.9.3.0, there is no users table any longer.
Instead, there are essentially two tables with user-related information:
-
UserAccounts -
GridUser(if your grid is configured to allow Hyperjumps)
Neither has a userInventoryURI or a userAssetURI row; this might have been true in the distant past, but not any longer. UserAccounts stores the local users, so there is a ServiceURLs column, which essentially contains a list of the many service URLs (beyond Inventory and Asset server(s)), one per line; as a consequence, you cannot write a simple one-liner as suggested above — that is, even if the table and the columns exist (legacy?), if you replace the code above with UserAccounts and ServiceURLs instead, then, well, congrats, you've just bricked your own configuration :-(
GridUser seems to deal both with remote accounts hyperjumping to your grid, and, conversely, with 'gridnauts' among your own users that (may) have teleported to a different grid. As such, to track these down, GridUser includes the 'base URI' for the visitor origin grid, saved directly to the UserId field. Currently, the format of this field is made of three subfields — avatar UUID, an URI (to the grid of origin), and the avatar name, all separated by semicolons. The URI is the 'main' grid URI, that is, the one where the login server is running, and which will probably be able to retrieve the URI for the Inventory & Asset servers of the origin grid.
So... whatever was meant with that suggestion, it definitely requires an update!
— Gwyneth Llewelyn (talk) 09:45, 26 September 2023 (PDT)
