[Opensim-users] Recovering from Groups misconfiguration, need to generate folderID
Rick Anderson
rianders at docs.rutgers.edu
Wed Aug 27 18:49:33 UTC 2014
Ok. folderID is a primary key and should create a unique identifier when I
insert a new line.
--Rick
On Wed, Aug 27, 2014 at 2:46 PM, Rick Anderson <rianders at docs.rutgers.edu>
wrote:
>
> I misconfigured the groups module then create users that were unable to
> get a "My Inventory" folder. These users can't log in right now. I could
> delete them and start over. However, I was looking to repair them.
>
> Find the problem users in MySQL:
> select PrincipalID, FirstName, LastName from useraccounts where
> PrincipalID NOT IN (select agentID from inventoryFolders);
>
> Review the users with good inventory in MySQL:
> select * from inventoryFolders where type='9';
>
> Example Result:
>
> | folderName | type | version | folderID |
> agentID | parentFolderID
> |
>
>
> +--------------+------+---------+--------------------------------------+--------------------------------------+--------------------------------------+
>
> | My Inventory | 9 | 18 | 15f6ef74-647e-466c-b374-125c162109e5 |
> aa011451-9b44-4133-af1e-2bcfb66bbfeb | 00000000-0000-0000-0000-000000000000
> |
>
>
> Issue:
> I need to generate a folderID.
>
> Questions:
> Is there a way to generate inventory folders from the command line?
>
> How do I get a no colliding folderID?
>
>
> Thanks,
>
> --Rick
>
> --
> Rick Anderson
> Director of Virtual Worlds
> Division of Continuing Studies (DoCS)
> Rutgers University
> (732) 586-3265
>
--
Rick Anderson
Director of Virtual Worlds
Division of Continuing Studies (DoCS)
Rutgers University
(732) 586-3265
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20140827/95934b7c/attachment.html>
More information about the Opensim-users
mailing list