[Opensim-users] Help: Self registration script no longer working

[Clive Gould]

Hi

I've been comparing the OpenSim database tables before and after creating a
user account.

There appear to be three tables affected when a new user is added:

auth
inventoryfolders
 UserAccounts

auth and UserAccounts look quite straightforward to write to using an
external PHP script, but inventoryfolders looks a complete nightmare as it
appears to be completely regenerated.

Does anyone have any idea if I modify the OpenSim 0.6.9 self registration
scripts to write to auth and UserAccounts if OpenSim will automatically
recognise the new records and make the appropriate additions to the
inventoryfolders tables???

Suggestions most welcome.

Clive



On Fri, Mar 11, 2011 at 4:32 PM, Diva Canto <diva at metaverseink.com> wrote:

> I don't see any differences besides capitalization, which works differently
> in linux and Windows.
>
>
> On 3/11/2011 8:30 AM, Clive Gould wrote:
>
> Hi Diva
>
> Looking at the new table structure shown in the diagram on the Wiki it
> appears to bear little resemblance to the table structure on my fresh
> install of opensim.0.7.0.2 standalone taken from git head this morning
>
> Am I missing something here???
>
> Thanks
>
> Clive
>
> mysql> show tables;
> +-------------------+
> | Tables_in_opensim |
> +-------------------+
> | Avatars           |
> | Friends           |
> | GridUser          |
> | UserAccounts      |
> | assets            |
> | auth              |
> | estate_groups     |
> | estate_managers   |
> | estate_map        |
> | estate_settings   |
> | estate_users      |
> | estateban         |
> | inventoryfolders  |
> | inventoryitems    |
> | land              |
> | landaccesslist    |
> | migrations        |
> | primitems         |
> | prims             |
> | primshapes        |
> | regionban         |
> | regions           |
> | regionsettings    |
> | regionwindlight   |
> | terrain           |
> | tokens            |
> +-------------------+
> 26 rows in set (0.00 sec)
>
>
> On Fri, Mar 11, 2011 at 3:53 PM, Diva Canto <diva at metaverseink.com> wrote:
>
>> The release notes describe the database changes:
>> http://opensimulator.org/wiki/0.7_Release
>>
>>
>> On 3/11/2011 7:43 AM, Clive Gould wrote:
>>
>>  Hi
>>
>> I have a set of PHP scripts originally developed at Glagow Caledonian
>> University that allow users to self register with our OpenSim standalone
>> installation, provided they have a valid institutional email address.
>>
>> These worked fine with OpenSim 0.6.9 but no longer work with OpenSim 0.7
>> as there appears to have been a change in the database tables between the
>> two versions.
>>
>> Looking at the original script, which worked with 0.6.9 the following user
>> table settings are written:
>>
>> UUID, username, lastname, passwordHash, passwordSalt, homeRegion,
>> homeLocationX, homeLocationY, homeLocationZ, homeLookAtX, homeLookAtY,
>> homeLookAtZ, created, lastLogin, userInventoryURI,userAssetURI,
>> profileCanDoMask, profileWantDoMask, profileAboutText, profileFirstText,
>> profileImage, profileFirstImage, webLoginKey,
>> homeRegionID,userFlags,godLevel,customType,partner,email
>>
>> Looking at the new database structure with 0.7 the UserAccounts table now
>> contains the following fields:
>>
>>
>> PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created, UserLevel, UserFlags, UserTitle
>>
>> Does anyone have a set of self-registration scripts that will work with
>> OpenSim 0.7 or can advise me what tables a self registration script would
>> now need to write to?
>>
>> Thanks very much
>>
>> Clive
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.dehttps://lists.berlios.de/mailman/listinfo/opensim-users
>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20110312/fb230a1d/attachment.html>