[Opensim-users] How do you force a clean install instead of an upgrade?

[Teravus Ovares]

Unfortunately, SQLite is broken on a mac post 0.6.9 because of a
crypto library incompatibility with mac.

I'd suggest dumping the database and setting it up on a mySQL server
temporarily.   It's been broken like this for about 4 months.

Regards

Teravus

On Wed, Sep 22, 2010 at 11:28 PM, bodzette Coignet
<bodzettecoignet at gmail.com> wrote:
> Hi, on my mac I have somehow corrupted the db's when upgrading from 0.6.9 to
> 0.7.
> The problem now is it's irrevocably corrupted. Even if I drop the directory
> and copy fresh files down from the open simulator site and run the install
> again it somehow finds corruption from previous installs and chokes out.
> I think there is a duplicate entry somewhere and I can't get rid of it.
> Is there any way to either: uninstall sqlite and all sqlite databases
> OR
> force a clean install of 0.7?
> FYI here are the errors I get:
> 21:24:47 - [APPLICATION]:
> APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs
> Exception: System.Exception: There was a SQL error or connection string
> configuration error when saving the region settings.  This could be a bug,
> it could also happen if ConnectionString is defined in the [DatabaseService]
> section of StandaloneCommon.ini in the config_include folder.  This could
> also happen if the config_include folder doesn't exist or if the OpenSim.ini
> [Architecture] section isn't set.  If this is your first time running
> OpenSimulator, please restart the simulator and bug a developer to fix this!
> ---> Mono.Data.Sqlite.SqliteException: Abort due to constraint violation
> column regionUUID is not unique
>   at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000] in <filename unknown>:0
>   at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000] in <filename unknown>:0
>   at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename
> unknown>:0
>   at (wrapper remoting-invoke-with-check)
> Mono.Data.Sqlite.SqliteDataReader:NextResult ()
>   at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand
> cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
>   at (wrapper remoting-invoke-with-check)
> Mono.Data.Sqlite.SqliteDataReader:.ctor
> (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
>   at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior)
> [0x00000] in <filename unknown>:0
>   at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior
> behavior) [0x00000] in <filename unknown>:0
>   at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior)
> [0x00000] in <filename unknown>:0
>   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
> (CommandBehavior behavior) [0x00000] in <filename unknown>:0
>   at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]
> dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in
> <filename unknown>:0
>   --- End of inner exception stack trace ---
>   at OpenSim.Data.SQLite.SQLiteRegionData.Commit () [0x00000] in <filename
> unknown>:0
>   at OpenSim.Data.SQLite.SQLiteRegionData.StoreRegionSettings
> (OpenSim.Framework.RegionSettings rs) [0x00000] in <filename unknown>:0
>   at OpenSim.Data.SQLite.SQLiteRegionData.LoadRegionSettings (UUID
> regionUUID) [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
> InnerException: Mono.Data.Sqlite.SqliteException: Abort due to constraint
> violation
> column regionUUID is not unique
>   at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000] in <filename unknown>:0
>   at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt)
> [0x00000] in <filename unknown>:0
>   at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in <filename
> unknown>:0
>   at (wrapper remoting-invoke-with-check)
> Mono.Data.Sqlite.SqliteDataReader:NextResult ()
>   at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand
> cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
>   at (wrapper remoting-invoke-with-check)
> Mono.Data.Sqlite.SqliteDataReader:.ctor
> (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
>   at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior)
> [0x00000] in <filename unknown>:0
>   at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior
> behavior) [0x00000] in <filename unknown>:0
>   at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior)
> [0x00000] in <filename unknown>:0
>   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
> (CommandBehavior behavior) [0x00000] in <filename unknown>:0
>   at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]
> dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in
> <filename unknown>:0
> Application is terminating: True
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>