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

[Kevin Buckley]

I meant I copied the v067 built (/bin) directory to the place where I want
it.  Then I compared the original ini's with the v067 versions and amended
accordingly (using a fabulous programme called 'Beyond Compare' which I
highly recommend!).

I then used MySQL administrator GUI to take a .sql snapshot of my current
database, created a new empty database (opensimtest) and 'restored' the
snapshot to it (and changed the appropriate entries in the ini files to now
point at opensimtest) - so that the new v067 build will have all my old
inventories and assets (substantial!).

Surely, if I drop the tables from Opensimtest that will be like starting
from scratch with a world empty of assets?

Cheers, Kevin

-----Original Message-----
From: Clive Gould [mailto:cliveg at gmail.com] 
Sent: 28 October 2009 11:05
To: kevin at buckley70.freeserve.co.uk
Cc: opensim-users at lists.berlios.de
Subject: Re: [Opensim-users] Errors trying to use MySQL data with new


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