[Opensim-users] Opensim-users Digest, Vol 9, Issue 18

Browser [ICE] browser_ice at hotmail.com
Thu May 29 04:42:11 UTC 2008 

Still cannot get it to work.  I was counting on a problem free installation so I could work on it on my 2 days off.

- I fixed the 'mssql' to 'mysql' in the mysql_connection.ini. Tried it again and it failed on same thing.
- replaced my OpenSim.ini with the one given as exemple in http://opensimulator.org/wiki/Opensim.ini_example1. It goes further as it builds its assets but fails on same problem. It seams to keep failing on the same task: loading the  Attempting to load OpenSim.Framework.Data.MySQL.dll

Has anyone ever had the same problem ?
By the way, why is it still using SQLite when I replaced all SQL statements with MySql ones ?

00:36:18 - ====================================================================
00:36:19 - ========================= STARTING OPENSIM =========================
00:36:19 - ====================================================================
Creating new local console
00:36:19 - [Region]: Started at 5/29/2008 12:36:19 AM
00:36:19 - [DATASTORE]: Attempting to load OpenSim.Framework.Data.MySQL.dll
00:36:19 - [DATASTORE]: MySql - connecting: Data Source=localhost;Database=opensim;User ID=root;Password=masteradmin;
00:36:20 - [DATASTORE]: Added IRegionDataStore Interface
00:36:20 - [ASSET SERVER]: Starting asset storage system
00:36:20 - [SQLAssetServer]: AssetStorage: Attempting to load OpenSim.Framework.Data.SQLite.dll
00:36:20 - [AssetStorage]: Added SQLite Asset storage engine 1.0.0.0
00:36:20 - [ASSET SERVER]: Setting up asset database
00:36:20 - [ASSETS]: Loading asset set ./assets/OpenSimAssetSet/OpenSimAssetSet.xml
. . .
00:36:21 - [ASSETS]: Loading: [Moon][./assets/TexturesAssetSet/moon.jp2]
00:36:21 - [ASSETS]: Loading: [Cloud][./assets/TexturesAssetSet/cloud.jp2]
00:36:21 - [SQLITE]: Creating Asset d342e6c0b9d211dc95ff0800200c9a66
00:36:21 - [SQLITE]: Asset exists already, ignoring.
. . .
00:36:22 - [SQLITE]: Attempting commit
00:36:22 - [ASSET CACHE]: Creating Asset cache
00:36:22 - [REGION]: Starting HTTP server
00:36:22 - [HTTPD]: Starting up HTTP Server
00:36:22 - [HTTPD]: Spawned main thread OK
00:36:22 - [AGENTINVENTORY]: Inventorystorage: Attempting to load OpenSim.Framework.Data.MySQL.dll
[APPLICATION]: 
APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs

Exception: System.Exception: Error initialising MySql Database: System.FormatException: Input string was not in the correct format
  at System.UInt32.Parse (System.String s, NumberStyles style, IFormatProvider fp) [0x00000] 
  at System.UInt32.Parse (System.String s, IFormatProvider provider) [0x00000] 
  at System.Convert.ToUInt32 (System.String value, IFormatProvider provider) [0x00000] 
  at System.String.System.IConvertible.ToUInt32 (IFormatProvider provider) [0x00000] 
  at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.ConvertToUInt (System.Object value) [0x00000] 
  at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue (Keyword kw, System.Object value) [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.MySQL.MySQLManager..ctor (System.String hostname, System.String database, System.String username, System.String password, System.String cpooling, System.String port) [0x00000] 
  at OpenSim.Framework.Data.MySQL.MySQLManager..ctor (System.String hostname, System.String database, System.String username, System.String password, System.String cpooling, System.String port) [0x00000] 
  at OpenSim.Framework.Data.MySQL.MySQLInventoryData.Initialise () [0x00000] 
  at OpenSim.Framework.Communications.InventoryServiceBase.AddPlugin (System.String FileName) [0x00000] 
  at OpenSim.OpenSimMain.StartUp () [0x00000] 
  at OpenSim.Application.Main (System.String[] args) [0x00000] 

Application is terminating: True

----------------------------------------
> From: opensim-users-request at lists.berlios.de
> Subject: Opensim-users Digest, Vol 9, Issue 18
> To: opensim-users at lists.berlios.de
> Date: Wed, 28 May 2008 08:13:40 +0200
> 
> Send Opensim-users mailing list submissions to
> 	opensim-users at lists.berlios.de
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.berlios.de/mailman/listinfo/opensim-users
> or, via email, send a message with subject or body 'help' to
> 	opensim-users-request at lists.berlios.de
> 
> You can reach the person managing the list at
> 	opensim-users-owner at lists.berlios.de
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Opensim-users digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: Problem starting Linux OpenSim with MySQL
>       (Miss Suzhanna Rossini)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 28 May 2008 08:13:12 +0200
> From: "Miss Suzhanna Rossini" 
> Subject: Re: [Opensim-users] Problem starting Linux OpenSim with MySQL
> To: 
> Message-ID: 
> Content-Type: text/plain;	charset="UTF-8"
> 
> I'm in no way a programmer...
> That said, I directly saw that you have used the MSSQL ini file template, and NOT the MySQL one!
> 
> My mysql_connection.ini looks like this;
> 
> [mysqlconnection]
> hostname=192.168.222.230
> database=opensim
> username=----
> password=----
> pooling=false
> port=3306
> 
> ; These entries are only for if you, for some reason, wish to customize your user server table names.
> ; Do note that if you change the table names, you might have to change the sql resources too manually
> ; If ommitted, default values will be used.
> 
> userstablename=users
> userfriendstablename=userfriends
> agentstablename=agents
> 
> As you see, it reads [mysqlconnection] and not [mssqlconnection] as you listed.
> 
> /Suz
> 
> 
> 
>> -----Ursprungligt meddelande-----
>> Fr?n: opensim-users-bounces at lists.berlios.de [mailto:opensim-users-
>> bounces at lists.berlios.de] F?r Browser [ICE]
>> Skickat: den 28 maj 2008 00:09
>> Till: opensim-users at lists.berlios.de
>> ?mne: [Opensim-users] Problem starting Linux OpenSim with MySQL
>> 
>> 
>> I downloaded OpenSim v0.5.4 Linux + MySql v5.  I initially had OpenSim
>> running on Windows XP but encountered problems with MySQL. So I decided
>> to swtich to my Ubuntu 7.10 environment for running OpenSim.
>> 
>> I followed the informations to modify both my OpenSim and Mysql ini
>> files but when I started OpenSim, it fails with an MySQL error
>> "Exception: System.Exception: Error initialising MySql Database:
>> System.FormatException: Input string was not in the correct format". I
>> looked it up on Google, mysql.org and OsGrid's forum but didn't find
>> anything on it.
>> 
>> Here are the infos that might be needed to investigate (I masked the
>> password). Tell me if you need anything else.  Thank you.
>> 
>> 
. . .
> 
> 
> ------------------------------
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
> 
> 
> End of Opensim-users Digest, Vol 9, Issue 18
> ********************************************

_________________________________________________________________
Find hidden words, unscramble celebrity names, or try the ultimate crossword puzzle with Live Search Games. Play now!
http://g.msn.ca/ca55/212

More information about the Opensim-users mailing list