Re: What Version's are needed

Hi.

I resolved problem of "lower case table name" on Windows.
And I tested XoopenSim on Windows. But there is no problem. I can create new avatar and login to OpenSim.

Is your MySQL DB on Windows or Linux?
If you use MySQL on Windows, do you have problem of "lower case table name" ?
In this case, home page of XoopenSim indicates "OFFLINE".

Corrected XoopenSim is here http://www.nsl.tuis.ac.jp/DownLoad/SoftWare/Xoops/xoopensim-1.40-nosl-2.tgz


>> 2010-07-02 14:56:27,468 INFO - OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login request for master xxxxx from
>> 71.244.130.xx with user agent 0.6.3 (LL 1.23.5) starting in last
>> 2010-07-02 14:56:27,468 DEBUG - OpenSim.Services.AuthenticationService.PasswordAuthenticationService [PASS AUTH]:
>> got e8ac2303df8e22eccb537ae1180ba905; hashed = c3d8d89d4b62ccdbb29d0acbec8e76a0; stored = 8aba233413a0b5a9e2c805b81d01f43a
>> 2010-07-02 14:56:27,468 DEBUG - OpenSim.Services.AuthenticationService.PasswordAuthenticationService [AUTH SERVICE]:
>> PrincipalID 34ca37ec-7d83-41ce-96af-dc620aa8a3f7 or its data not found
>> 2010-07-02 14:56:27,484 INFO - OpenSim.Services.LLLoginService.LLLoginService [LLOGIN SERVICE]: Login failed, reason: authentication failed

Above error indicates "password mismatch".

Please execute MySQL command.

mysql> use "your OpenSim Database name";
mysql> select FirstName, passwordHash, passwordSalt from auth, UserAccounts where PrincipalID=UUID and FirstName='master';

Here, master is your avatar's first name.
Then your avatar's first name, password hash and password salt are displayed.

Next, please create php program. Example, filename is pass.php

<?php
print("Password Hash = ".md5(md5("your avatar's password").":"."above MySQL avatar's password salt")."\n<br />");
?>

And access to pass.php with web browser. Or execute command "php pass.php"
Is "pass.php's password hash" corresponding to "MySQL password hash" ?