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

Thu May 29 06:30:51 UTC 2008

I trust that you also changed the other erroneous lines in your sql config file?
There is a template file for MySQL included as well.. ;-)
If that isn't helping, I have no ideas at all, I've been running on Linux for a while, and never seen that particular error, so I'm just guessing.

/Suz

> 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