[Opensim-users] SQL error or connection string configuration error

[Jeff Mao]

I've just downloaded opensim 0.7.0.2 and mysql 5.1.56. I've set up mysql, and I can connect to the server, do things to the opensim db that I created, etc. So mysql seems happy. When I try and start up the opensim server, it runs through its set routine including lots of notes about "migrating". In all that output there are a number of places where it complains that tables already exist or that it can't find a table called users (ie opensim.users) doesn't exist. It eventually gets to the prompt about joining an existing estate. When I give the default answer of No it then errors out with lots of stuff about mysql (below).

I can see in mysql that opensim is talking to the server because it has created 25 tables. So it isn't a db connection issue, but clearly there are some assumptions being made in the set up that are not valid...ie there are create table commands being issued when tables already exist, or alterations to tables that don't exist or trying to access data from a table called 'users' that doesn't exist.

I can re-run some of the table creation commands and such by manually dropping tables, then re-running the commands to re-create those tables using the output from the set up process...but in instances where it is seeking data from a table that doesn't exist, I don't know what to do. For example:

23:23:58 - [MIGRATIONS]: Cmd was Table 'opensim.users' doesn't exist in SQL: BEGIN; INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users; COMMIT; 

Is there a place to simply download the entire database schema needed that I can just load into mysql myself?

I'm running on my MacBook Pro 10.6.6, 3.06ghz Intel Core 2 Duo. I'm just trying to set up a standalone server so I can play around, build things, etc. and also let my kids play around in a "walled garden"

thanks
Jeff



23:24:06 - [APPLICATION]: 
APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs

Exception: MySql.Data.MySqlClient.MySqlException: Invalid attempt to access a field before calling Read()
  at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue (Int32 index, Boolean checkNull) [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.MySqlDataReader.GetValue (Int32 i) [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.MySqlDataReader.get_Item (Int32 i) [0x00000] in <filename unknown>:0 
  at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000] in <filename unknown>:0 
  at OpenSim.Data.MySQL.MySQLEstateStore.DoLoad (MySql.Data.MySqlClient.MySqlCommand cmd, UUID regionID, Boolean create) [0x00000] in <filename unknown>:0 
  at OpenSim.Data.MySQL.MySQLEstateStore.LoadEstateSettings (UUID regionID, Boolean create) [0x00000] in <filename unknown>:0 
  at OpenSim.Region.Framework.Scenes.Scene..ctor (OpenSim.Framework.RegionInfo regInfo, OpenSim.Framework.AgentCircuitManager authen, OpenSim.Region.Framework.Scenes.SceneCommunicationService sceneGridService, OpenSim.Region.Framework.StorageManager storeManager, OpenSim.Region.Framework.ModuleLoader moduleLoader, Boolean dumpAssetsToFile, Boolean physicalPrim, Boolean SeeIntoRegionFromNeighbor, IConfigSource config, System.String simulatorVersion) [0x00000] in <filename unknown>:0 
  at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo regionInfo, OpenSim.Region.Framework.StorageManager storageManager, OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] in <filename unknown>:0 
  at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo regionInfo, Int32 proxyOffset, IConfigSource configSource, IClientNetworkServer& clientServer) [0x00000] in <filename unknown>:0 
  at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) [0x00000] in <filename unknown>:0 
  at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] in <filename unknown>:0 
  at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise () [0x00000] in <filename unknown>:0 
  at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename unknown>:0 
  at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename unknown>:0 
  at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] in <filename unknown>:0 
  at OpenSim.Application.Main (System.String[] args) [0x00000] in <filename unknown>:0 

Application is terminating: True




On Mar 18, 2011, at 10:10 PM, paul emery wrote:

> Dont know if your problem really requires switching to mySQL since you say
> the installation had been running but here is info on installing mySQL for
> opensim.
> 
> https://github.com/diva/d2/wiki/MySql
> 
> To do it you first need to download and install mySQL after which you use
> the above instructions which will create a data container called opensim in
> mySQL
> Then before running opensim you change sections in the opensim.ini to tell
> opensim to use mySQL rather then lite.
> Then you do run opensim to do the INITIAL INSTALL which will create tables
> in the database (which you already set up) and opensim will continue to
> start up using these new data files. 
> 
> If you have objects in the lite datafiles i am not sure how you migrate them
> to the mySQL container.
> 
> 
> 
> --
> View this message in context: http://opensim-users.2152040.n2.nabble.com/SQL-error-or-connection-string-configuration-error-tp6176396p6186721.html
> Sent from the opensim-users mailing list archive at Nabble.com.
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users