[Opensim-users] OpenSim.Data.MySQL....

[Melanie]

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 at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> 
>