[Opensim-users] Opensim-users Digest, Vol 9, Issue 18
Ursula MATOVA
ursula.matova at klintcentral.net
Thu May 29 05:10:03 UTC 2008
Hi,
• A stupid question : did you create the initial "opensim" MySQL
database before running "OpenSim.exe" ?
That need to be done. The "empty" database will be populated when
running OpenSim for the first time.
• Another point : in the logs below, you have
"OpenSim.Framework.Data.MySQL.dll" ... Please check your OpenSim.ini
and xx_Config.xml files ...
you need to change "OpenSim.Framework.Data.MySQL.dll" into
"OpenSim.Data.MySQL.dll" (( It's valid only if you are using a recent
SVN.SnapShot ))
Regards,
Ursula.
Le 29 mai 08 à 06:42, Browser [ICE] a écrit :
>
> 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
> _______________________________________________
> 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