<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><div style="text-align: left;">Yes, avatar appearance only works with MySQL.<br></div><br>/Stefan<br><br><hr id="stopSpelling">> Date: Wed, 26 Mar 2008 05:28:52 -0700<br>> From: aerowolf@gmail.com<br>> To: opensim-dev@lists.berlios.de<br>> Subject: [Opensim-dev] Fwd: trouble with appearance persistence (r4004)<br>> <br>> justincc clued me in that this version I was testing wasn't truly<br>> r4004 (I must have checked out a release tag without remembering), but<br>> the problem does still exist with the true trunk. He also said that<br>> mw doesn't monitor -users, so I'm forwarding here.<br>> <br>> My environment is MacOSX 10.5.2, Mono 1.9 (tarball), x86.<br>> <br>> Please see the tag end of the forwarded message for the log from trunk r4004.<br>> <br>> -Kyle H<br>> <br>> ---------- Forwarded message ----------<br>> From: Kyle Hamilton <aerowolf@gmail.com><br>> Date: Wed, Mar 26, 2008 at 4:46 AM<br>> Subject: trouble with appearance persistence (r4004)<br>> To: opensim-users@lists.berlios.de<br>> <br>> <br>> I'm trying to use appearance persistence in r4004, but I seem to be<br>> running into a trouble that it's hard-coded to use MySQL (I'm using<br>> SQLite). In my OpenSim.ini, I have all MySQL lines commented out.<br>> <br>> It starts up fine, but once I try to log in Test User, I get an exception:<br>> <br>> Region# :<br>> 04:38:36 - [LOGIN]: Client Version Second Life Release 1.19.0.5 for Test User<br>> 04:38:36 - [LOGIN]: Authenticating Test User<br>> 04:38:36 - [INVENTORY]: Found root folder for user with ID<br>> f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be. Retrieving inventory contents.<br>> 04:38:36 - [CONNECTION DEBUGGING]: Setting up CAPS handler for<br>> f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be at<br>> 3fb8eb16-4c46-401a-823b-4cf91cb5<br>> 04:38:36 - [CAPS]: Registering CAPS handlers<br>> 04:38:36 - [CONNECTION DEBUGGING]: Creating new circuit code<br>> (314156373) for f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be<br>> 04:38:36 - [SQLITE]: Syncing user database: 1 users stored<br>> 04:38:37 - [UDPSERVER]: Adding New Client<br>> 04:38:37 - [CLIENT]: Started up new client thread to handle incoming request<br>> 04:38:37 - [CLIENT]: Got authenticated connection from 127.0.0.1:50971<br>> 04:38:37 - [CLIENT]: Adding viewer agent to scene<br>> 04:38:37 - [CONNECTION DEBUGGING]: Creating new client for<br>> f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be<br>> 04:38:37 - [GROUP]: Adding Test User to OpenSimulator Tester group<br>> [APPLICATION]:<br>> APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs<br>> <br>> Exception: System.ArgumentException: Keyword not supported.<br>> Parameter name: URI<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.GetKey<br>> (System.String key) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue<br>> (System.String keyword, System.Object value) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item<br>> (System.String key, System.Object value) [0x00000]<br>> at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString<br>> (System.String value) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor<br>> (System.String connectionString) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString<br>> (System.String value) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnection..ctor (System.String<br>> connectionString) [0x00000]<br>> at (wrapper remoting-invoke-with-check)<br>> MySql.Data.MySqlClient.MySqlConnection:.ctor (string)<br>> at OpenSim.Framework.Data.MySQLDatabaseMapper.GetNewConnection () [0x00000]<br>> at TribalMedia.Framework.Data.BaseTableMapper.WithConnection<br>> (System.Action`1 action) [0x00000]<br>> at TribalMedia.Framework.Data.BaseTableMapper`2[OpenSim.Region.Environment.Modules.AppearanceRowMapper,System.Guid].TryGetValue<br>> (Guid primaryKey,<br>> OpenSim.Region.Environment.Modules.AppearanceRowMapper& value)<br>> [0x00000]<br>> at OpenSim.Region.Environment.Modules.AppearanceTableMapper.TryGetValue<br>> (Guid presenceID, OpenSim.Region.Environment.Scenes.AvatarAppearance&<br>> val) [0x00000]<br>> at OpenSim.Region.Environment.Modules.AvatarFactoryModule.CheckDatabase<br>> (LLUUID avatarId) [0x00000]<br>> at OpenSim.Region.Environment.Modules.AvatarFactoryModule.TryGetAvatarAppearance<br>> (LLUUID avatarId, OpenSim.Region.Environment.Scenes.AvatarAppearance&<br>> appearance) [0x00000]<br>> at OpenSim.Region.Environment.Scenes.Scene.GetAvatarAppearance<br>> (IClientAPI client,<br>> OpenSim.Region.Environment.Scenes.AvatarAppearance& appearance)<br>> [0x00000]<br>> at OpenSim.Region.Environment.Scenes.Scene.CreateAndAddScenePresence<br>> (IClientAPI client, Boolean child) [0x00000]<br>> at OpenSim.Region.Environment.Scenes.Scene.AddNewClient (IClientAPI<br>> client, Boolean child) [0x00000]<br>> at OpenSim.Region.ClientStack.ClientView.InitNewClient () [0x00000]<br>> at OpenSim.Region.ClientStack.ClientView.AuthUser () [0x00000]<br>> <br>> Application is terminating: True<br>> <br>> The apparent problem is:<br>> appearance_connection_string = "URI=file:Appearance.db,version=3";<br>> <br>> This is a valid connection string for SQLite, but not MySQL.<br>> <br>> I have tried adding:<br>> appearance_plugin="OpenSim.Framework.Data.SQLite.dll"<br>> <br>> but it's not apparently recognized. The asset_database line is:<br>> asset_database = "sqlite"<br>> <br>> This exception does not occur if I have:<br>> appearance_persist = false<br>> <br>> I'm given to understand that since I've been "contaminated" by the GPL<br>> and membership to sldev, I cannot submit patches.<br>> <br>> I would prefer not to have to run an instance of MySQL on my machine.<br>> <br>> -Kyle H<br>> <br>> [[appended: the log from r4004 trunk]]<br>> <br>> 05:21:43 - [LOGIN]: Received login request message from user Test User<br>> 05:21:43 - [LOGIN]: Client version: Second Life Release 1.19.0.5<br>> 05:21:43 - [LOGIN]: Client requested start location: last<br>> 05:21:43 - [LOGIN]: Authenticating Test User<br>> 05:21:43 - [INVENTORY]: Found root folder for user with ID<br>> f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be. Retrieving inventory contents.<br>> 05:21:43 - [CAPS]: Sending new CAPS seed url<br>> http://127.0.0.1:9000/CAPS/e00b33cd-df7c-4921-8174-d3b902790000/ to<br>> client f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be<br>> 05:21:43 - [LOGIN]: Telling region kyanha @ 255,255 (127.0.0.1:9000)<br>> to expect user connection<br>> 05:21:43 - [CAPS]: Setting up CAPS handler for root agent<br>> f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be in kyanha<br>> 05:21:43 - [CONNECTION DEBUGGING]: Creating new circuit code<br>> (314156373) for avatar f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be at kyanha<br>> 05:21:43 - [SQLITE]: Syncing user database: 1 users stored<br>> 05:21:43 - [LOGIN]: Authentication of user Test User successful.<br>> Sending response to client.<br>> 05:21:45 - [UDPSERVER]: Adding New Client<br>> 05:21:45 - [CLIENT]: Started up new client thread to handle incoming request<br>> 05:21:45 - [CLIENT]: Got authenticated connection from 127.0.0.1:51034<br>> 05:21:45 - [CLIENT]: Adding viewer agent to scene<br>> 05:21:45 - [CONNECTION DEBUGGING]: Creating new client for<br>> f94a3dc1-d7b4-4ee7-9c1b-8e4acf77b4be at kyanha<br>> 05:21:45 - [GROUP]: Adding Test User to OpenSimulator Tester group<br>> 05:21:45 - [REGION]: Add New Scene Presence<br>> [APPLICATION]:<br>> APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs<br>> <br>> Exception: System.ArgumentException: Keyword not supported.<br>> Parameter name: URI<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.GetKey<br>> (System.String key) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue<br>> (System.String keyword, System.Object value) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item<br>> (System.String key, System.Object value) [0x00000]<br>> at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString<br>> (System.String value) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor<br>> (System.String connectionString) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString<br>> (System.String value) [0x00000]<br>> at MySql.Data.MySqlClient.MySqlConnection..ctor (System.String<br>> connectionString) [0x00000]<br>> at (wrapper remoting-invoke-with-check)<br>> MySql.Data.MySqlClient.MySqlConnection:.ctor (string)<br>> at OpenSim.Framework.Data.MySQLMapper.MySQLDatabaseMapper.GetNewConnection<br>> () [0x00000]<br>> at OpenSim.Framework.Data.Base.BaseTableMapper.WithConnection<br>> (System.Action`1 action) [0x00000]<br>> at OpenSim.Framework.Data.Base.BaseTableMapper`2[OpenSim.Region.Modules.AvatarFactory.AppearanceRowMapper,System.Guid].TryGetValue<br>> (Guid primaryKey,<br>> OpenSim.Region.Modules.AvatarFactory.AppearanceRowMapper& value)<br>> [0x00000]<br>> at OpenSim.Region.Modules.AvatarFactory.AppearanceTableMapper.TryGetValue<br>> (Guid presenceID, OpenSim.Region.Environment.Scenes.AvatarAppearance&<br>> val) [0x00000]<br>> at OpenSim.Region.Modules.AvatarFactory.AvatarFactoryModule.CheckDatabase<br>> (LLUUID avatarId) [0x00000]<br>> at OpenSim.Region.Modules.AvatarFactory.AvatarFactoryModule.TryGetAvatarAppearance<br>> (LLUUID avatarId, OpenSim.Region.Environment.Scenes.AvatarAppearance&<br>> appearance) [0x00000]<br>> at OpenSim.Region.Environment.Scenes.Scene.GetAvatarAppearance<br>> (IClientAPI client,<br>> OpenSim.Region.Environment.Scenes.AvatarAppearance& appearance)<br>> [0x00000]<br>> at OpenSim.Region.Environment.Scenes.Scene.CreateAndAddScenePresence<br>> (IClientAPI client, Boolean child) [0x00000]<br>> at OpenSim.Region.Environment.Scenes.Scene.AddNewClient (IClientAPI<br>> client, Boolean child) [0x00000]<br>> at OpenSim.Region.ClientStack.ClientView.InitNewClient () [0x00000]<br>> at OpenSim.Region.ClientStack.ClientView.AuthUser () [0x00000]<br>> <br>> Application is terminating: True<br>> _______________________________________________<br>> Opensim-dev mailing list<br>> Opensim-dev@lists.berlios.de<br>> https://lists.berlios.de/mailman/listinfo/opensim-dev<br></body>
</html>