[Opensim-users] Asset server problems

[Miss Suzhanna Rossini]

> hi
> I'm new in the list and with OpenSim, this is my situation:
> 
> OpenSim.ini
> 
> [Startup]
> gridmode = true
> storage_plugin = OpenSim.Data.MySQL.dll
> storage_connection_string = "Data
> Source=localhost;Database=opensim;User
> ID=dbuser;Password=********;";
> storage_prim_inventories = true
> appearance_persist = false
> appearance_database = "mysql"
> appearance_connection_string = "Data
> Source=localhost;Database=opensim;User
> ID=dbuser;Password=********;pooling=false;";
> asset_database = "grid"
> see_into_this_sim_from_neighbor = True
> meshing = Meshmerizer
> physics = OpenDynamicsEngine
> startup_console_commands_file = startup_commands.txt
> shutdown_console_commands_file = shutdown_commands.txt
> serverside_object_permissions = false
> physical_prim = true
> script_engine = OpenSim.Region.ScriptEngine.DotNetEngine.dll
> [StandAlone]
> accounts_authenticate = true
> welcome_message = Suca
> asset_plugin = OpenSim.Data.MySQL.dll
> inventory_plugin = OpenSim.Data.MySQL.dll
> userDatabase_plugin = OpenSim.Data.MySQL.dll
> default_location_x = 1000
> default_location_y = 1000
> dump_assets_to_file = false
> [Network]
> http_listener_port = 9000
> remoting_listener_port = 8895
> grid_server_url = http://opensim.oziosi.org:8001
> grid_send_key = null
> grid_recv_key = null
> user_server_url = http://opensim.oziosi.org:8002
> user_send_key = null
> user_recv_key = null
> asset_server_url = http://opensim.oziosi.org:8003
> inventory_server_url = http://opensim.oziosi.org:8004
> 
> 
> this is the "mono OpenSim.Grid.AssetServer.exe" output:
> 
> 12:30:12 - [ASSET SERVER]: LoadDatabasePlugin: Attempting to load
> OpenSim.Data.MySQL.dll
> 12:30:12 - [ASSET]: setupDB() - Exception occured
> 12:30:12 - [ASSET]: System.Exception: Error initialising MySql
> Database:
> System.ArgumentException: Keyword not supported.
> Parameter name: DATA SOURCE
>   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.Data.MySQL.MySQLManager.Initialise (System.String connect)
> [0x00000]
>   at OpenSim.Data.MySQL.MySQLManager.Initialise (System.String connect)
> [0x00000]
>   at OpenSim.Data.MySQL.MySQLManager..ctor (System.String connect)
> [0x00000]
>   at OpenSim.Data.MySQL.MySQLAssetData.Initialise (System.String
> connect) [0x00000]
>   at OpenSim.Grid.AssetServer.OpenAsset_Main.LoadDatabasePlugin
> (System.String FileName, System.String connect) [0x00000]
>   at OpenSim.Grid.AssetServer.OpenAsset_Main.setupDB
> (OpenSim.Framework.AssetConfig config) [0x00000]
> 12:30:12 - [ASSET]: Loading default asset set..
> 
> [...]
> 
> Unhandled Exception: System.NullReferenceException: Object reference
> not
> set to an instance of an object
>   at OpenSim.Grid.AssetServer.OpenAsset_Main.StoreAsset
> (OpenSim.Framework.AssetBase asset) [0x00000]
>   at
> System.Collections.Generic.List`1[OpenSim.Framework.AssetBase].ForEach
> (System.Action`1 action) [0x00000]
>   at
> OpenSim.Framework.AssetLoader.Filesystem.AssetLoaderFileSystem.ForEachD
> efaultXmlAsset (System.String assetSetFilename, System.Action`1 action)
> [0x00000]
>   at
> OpenSim.Framework.AssetLoader.Filesystem.AssetLoaderFileSystem.ForEachD
> efaultXmlAsset (System.Action`1 action) [0x00000]
>   at OpenSim.Grid.AssetServer.OpenAsset_Main.LoadDefaultAssets ()
> [0x00000]
>   at OpenSim.Grid.AssetServer.OpenAsset_Main.Startup () [0x00000]
>   at OpenSim.Grid.AssetServer.OpenAsset_Main.Main (System.String[]
> args)
> [0x00000]
> 
> the the asset server die...
> In particular this line:
> 
> 12:30:12 - [ASSET]: System.Exception: Error initialising MySql
> Database:
> System.ArgumentException: Keyword not supported.
> 
> What does this mean?
> thank you...


My guess is that your database connection info is wrong in "mysql_connection.ini" and/or "AssetServer_Config.xml". The asset server gets its database info from there, and not from OpenSim.ini.

/Suz