[Opensim-users] trouble with appearance persistence (r4004)

[Justin Clark-Casey]

Are you definitely using r4004?  I'm only asking because I know certain 
of the messages below, such as

04:38:36 - [CAPS]: Registering CAPS handlers



got taken out some time before that rev.

--
justincc

Kyle Hamilton wrote:
> 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
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>