Hello,

Thank-you Melanie, your reply helped me to solve the issue.
One needs to remember that the "Example" files can and sometime do contain errors.
Things are working well now.

In the Robust.HG.ini.Example file included in the current build, this section....
[AuthenticationService]
    ; for the server connector
LocalServiceModule = "OpenSim.Services.AuthenticationService.dll:PasswordAuthenticationService"
    ; Realm = "useraccounts"


Realm is wrong... it should be "Auth" and NOT "useraccounts".

it should look like:
[AuthenticationService]
    ; for the server connector
LocalServiceModule = "OpenSim.Services.AuthenticationService.dll:PasswordAuthenticationService"
    Realm = "auth"




On 6/27/2014 5:05 PM, Melanie wrote:
The AuthenticationData refers to a table named "auth", NOT
UserAccounts. The code is good as it is, you have something
misconfigured.

- Melanie

On 27/06/2014 22:54, BoneZ wrote:
Hi all,

I have a grid configured for hypergrid...
Once robust is running I try to create a new user and I get:
OpenSim.Server.Base.ServicesServerBase Command error:
MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column
'UUID' in 'where clause'

In the OpenSim.Data.MySQL project there is a file...
"MySQLAuthenticationData.cs"

On line 85:
using (MySqlCommand cmd = new MySqlCommand("select * from `" + m_Realm +
"` where UUID = ?principalID", dbcon))


Is this an error??
the m_Realm variable seems to be assigned "useraccounts" and this query
seems to be looking for the column "UUID" in the table... but it does
not exist.

I've changed it to:

using (MySqlCommand cmd = new MySqlCommand("select * from `" + m_Realm +
"` where `PrincipalID` = ?principalID", dbcon))

That seems to have satisfied it for another step.. but now
AuthenticationServiceBase.cs in the
OpenSim.Services.AuthenticationService project is throwing:
OpenSim.Server.Base.ServicesServerBase Command error:
MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter
'?principalID' has already been defined.

I've been chasing this for some time now and wanted to see if anyone
else can lend an eye??

Thanks.
_______________________________________________
Opensim-users mailing list
Opensim-users@opensimulator.org
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users


_______________________________________________
Opensim-users mailing list
Opensim-users@opensimulator.org
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users


_______________________________________________
Opensim-users mailing list
Opensim-users@opensimulator.org
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users

Reply via email to