[Opensim-users] Errors trying to use MySQL data with new

[Clive Gould]

Hi Kevin

Are you trying to make a fresh install of 0.6.7, because if you are
the error messages suggest the database tables already exist.

For a fresh install the database needs to exist but the tables should
not be there. Try dropping all the tables in the database before you
restart OpenSim.

Also you say you've copied over the /bin directory - you only need to
copy over and modify where appropriate OpenSim.ini,
Regions/Regions.ini and any terrain files from the old version to the
new one.

Good luck

Clive


Message: 8
Date: Wed, 28 Oct 2009 09:49:35 -0000
From: "Kevin Buckley" <kevin at buckley70.freeserve.co.uk>
Subject: [Opensim-users] Errors trying to use MySQL data with new
       opensim release
To: <opensim-users at lists.berlios.de>
Message-ID: <01a501ca57b3$f4f91ed0$deeb5c70$@freeserve.co.uk>
Content-Type: text/plain; charset="us-ascii"

I am trying to use the latest v0.6.7-post release Opensim in standalone.  I
have a 'production grid' which is based on the OSGrid downloadable (with the
ini files suitably changed) working with MySQL.  This has been working well
for some time (but has some issues - well known).



I have:



O Downloaded the latest 0.6.7 following the instructions provided by Clive
Gould, prebuilt and compiled it, copied the /bin directory to make a 'Test
Grid' and changed the ini's to reflect my MySQL settings

O Made a snapshot of my Opensim MySQL database and created a new copy
(opensimtest) which is referenced in the 'Test Grid' Opensim ini's



When I try to run it I get a bunch of errors that look like this and it
terminates:



2009-10-28 09:30:23,490 INFO  - OpenSim.Data.MySQL.MySQLManager [MYSQL]:
Connection established

2009-10-28 09:30:23,490 DEBUG - OpenSim.Data.MySQL.MySQLManager [REGION DB]:
Connection wait timeout 28860 seconds

2009-10-28 09:30:23,511 INFO  - OpenSim.Data.Migration [MIGRATIONS]
Upgrading AssetStore to latest revision.

2009-10-28 09:30:23,511 INFO  - OpenSim.Data.Migration [MIGRATIONS] NOTE:
this may take a while, don't interupt this process!

2009-10-28 09:30:23,631 ERROR - OpenSim.Server.Base.ServerUtils Error
loading plugin from OpenSim.Services.AssetService.dll, exception
MySql.Data.MySqlClient.MySqlException: Table 'assets' already exists

  at MySql.Data.MySqlClient.MySqlStream.OpenPacket()

  at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows,
Int64& lastInsertId)

  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()

  at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
behavior)

  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

  at OpenSim.Data.Migration.Update() in c:\Documents and
Settings\Kevin\opensim\OpenSim\Data\Migration.cs:line 141

  at OpenSim.Data.MySQL.MySQLAssetData.Initialise(String connect) in
c:\Documents and
Settings\Kevin\opensim\OpenSim\Data\MySQL\MySQLAssetData.cs:line 83

  at OpenSim.Services.AssetService.AssetServiceBase..ctor(IConfigSource
config) in c:\Documents and
Settings\Kevin\opensim\OpenSim\Services\AssetService\AssetServiceBase.cs:lin
e 80

  at OpenSim.Services.AssetService.AssetService..ctor(IConfigSource config)
in c:\Documents and
Settings\Kevin\opensim\OpenSim\Services\AssetService\AssetService.cs:line 46

2009-10-28 09:30:23,871 ERROR -
OpenSim.Region.CoreModules.ServiceConnectorsOut.Asset.LocalAssetServicesConn
ector [ASSET CONNECTOR]: Can't load asset service



Any suggestions? - Thanks, Kevin