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