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

Kyle Hamilton aerowolf at gmail.com
Wed Mar 26 12:23:56 UTC 2008


svn update says:

At revision 4004.

I did:

./runprebuild.sh
nant clean
./runprebuild.sh
nant

before I submitted the report.

I'm checking out a new copy from trunk just to be absolutely certain.

The log I get is:

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

I apparently did not have the true trunk, but the problem still exists.

-Kyle H

On Wed, Mar 26, 2008 at 4:58 AM, Justin Clark-Casey
<jjustincc at googlemail.com> wrote:
> 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
>  >
>  >
>
>



More information about the Opensim-users mailing list