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

[Kyle Hamilton]

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