[Opensim-dev] Release 0.7 RC1 Test Feedback
Diva Canto
diva at metaverseink.com
Fri Jun 18 17:26:57 UTC 2010
One thing that would help enormously would be for the people who run
into trouble with this MySql driver to try it with the old one and
report back. You can find the old driver in the 0.6.x installations.
It's called MySql.Data.dll. To use it, drop the old one into the 0.7rc1
bin, clean, rebuild and run. (don't forget to drop any columns you have
added manually and reset the version of the AssetStore back to 7). Note
that the old driver doesn't understand the "Old Guids" config var, so
that needs to be removed from the connection strings.
If more people report #fail with the new MySql.Data.dll and #success
with the old one, then I'll put the old one back -- at least in the
official 0.7 distribution.
As far as I understand it, the new driver was added because it supports
stored procedures [better?]; stored procedures will allow us to speed up
some things. But 0.7 still doesn't have any stored procedures, so the
new capabilities are mute.
On 6/18/2010 7:24 AM, Michael Cerquoni wrote:
> Ai Austin,
>
> Yes, migration to me seems 100% impossible at this time, infact the
> only person I have seem claim it works fine is Melanie_T. I have not
> seen any other person be able to pull off a successful migration
> without manually running it themselves. The problem seems to be with
> the new MySQL connector, I beleive that if this problem is not
> remedied soon, migration to 0.7 will be impossible for the majority of
> OpenSimulator users. We have been screaming about this for the past
> few weeks on the -dev channels, but mostly the problem seems to be
> being ignored right now, I hope this gets some attention for the
> matter. Otherwise at this point my 0.7 testing is pretty much come to
> an end!!
>
> On Fri, Jun 18, 2010 at 4:38 AM, Ai Austin <ai.ai.austin at gmail.com
> <mailto:ai.ai.austin at gmail.com>> wrote:
>
> Hi folks, I am continuing to do initial tests of 0./7 RC1... and
> wanted to give some feedback. I am happy to report anything you
> think needs logging in mantis. But some items are probably simple
> issues that Diva and others might be able to point me in the
> direction of.
>
> I am using Robust.exe -inifile Robust.HG.ini and believe I have
> the .ini files all set up right for my system (baring mistakes of
> course)
>
> All attempts to get Robust.exe to do the asset data base
> migrations have failed. I spotted quite a number of things and
> addressed them as I went along.
>
> ---------------------------
> The documentation suggesting the values for 4 variables in the
> [mysqld] section of the MySQL config file have some issues in them
> (at least for Windows MySQL users). There was a problem with all
> 4 variables or their values as examples. See details at
> http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html It
> may be worth They should be something like:
>
> [mysqld]
> open-files-limit = 20000 (add -limit on end of
> name and yes these are hyphens not underscores)
> interactive_timeout = 1000000 (drop a 0 as it was beyond
> legal upper range)
> wait_timeout = 1000000 (drop a 0 as it was beyond
> legal upper range)
> max_connnections = 2000 (connections plural not
> connection)
>
> I noted these changes, but left Diva's values in for now until we
> verify these are right at
> http://opensimulator.org/wiki/0.7_Release#Before_you_upgrade
>
> ---------------------------
>
> Even with these corrections in place I still get two Cmd time out
> errors on the asset table migrations in Robust.exe after about 40
> seconds. Note that I was able to do the commands manually in
> MySQL Command Line Client and the commands took roughly 2 minutes
> and 1 minute (with 10000 or so assets). I have no idea how to
> make Robust.exe properly wait for the time required.
>
> 2010-06-17 10:26:37,437 INFO - OpenSim.Server.Base.HttpServerBase
> [SERVER]: Starting HTTP server on port 8003
> 2010-06-17 10:26:37,482 INFO - OpenSim.Server.Base.HttpServerBase
> [SERVER]: Requested port 8003
> 2010-06-17 10:26:37,482 INFO - OpenSim.Server.OpenSimServer
> [SERVER]: Loading AssetServiceConnector
> 2010-06-17 10:26:37,744 INFO - OpenSim.Data.Migration
> [MIGRATIONS] Upgrading AssetStore to latest revision 8.
> 2010-06-17 10:26:37,745 INFO - OpenSim.Data.Migration
> [MIGRATIONS] NOTE: this may take a while, don't interupt this process!
> 2010-06-17 10:27:08,648 DEBUG - OpenSim.Data.Migration
> [MIGRATIONS] Cmd was Timeout expired. The timeout period elapsed
> prior to completion of the operation or the server is not
> responding. in SQL: ALTER TABLE assets ADD COLUMN asset_flags
> INTEGER NOT NULL DEFAULT 0;
>
> 2010-06-17 10:27:08,649 DEBUG - OpenSim.Data.Migration
> [MIGRATIONS]: An error has occurred in the migration. This may
> mean you could see errors trying to run OpenSim. If you see
> database related errors, you will need to fix the issue manually.
> Continuing.
> 2010-06-17 10:27:08,650 INFO - OpenSim.Data.Migration
> [MIGRATIONS]: Updating AssetStore to version 7
> 2010-06-17 10:27:39,632 DEBUG - OpenSim.Data.Migration
> [MIGRATIONS] Cmd was Timeout expired. The timeout period elapsed
> prior to completion of the operation or the server is not
> responding. in SQL: ALTER TABLE assets ADD COLUMN CreatorID
> varchar(128) NOT NULL DEFAULT '';
>
> 2010-06-17 10:27:40,850 DEBUG - OpenSim.Data.Migration
> [MIGRATIONS]: An error has occurred in the migration. This may
> mean you could see errors trying to run OpenSim. If you see
> database related errors, you will need to fix the issue manually.
> Continuing.
> 2010-06-17 10:27:40,850 INFO - OpenSim.Data.Migration
> [MIGRATIONS]: Updating AssetStore to version 8
>
>
> ------------------------
> Note also in the log above typo in one of the INFO messages at
> 2010-06-17 10:26:37,745 "interupt" -> "interrupt"
>
> -----------------------
>
> As I said I manually added in these data base column addition to
> let me get further.
> Manually doing the following in MySQL command line client
>
> use opensim;
> ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0;
> ALTER TABLE assets ADD COLUMN CreatorID varchar(128) NOT NULL
> DEFAULT '';
>
> ---------------------
>
> I note that in Robust.exe I get this error message early on in the
> logs.... which I have not yet tracked down.
>
> 2010-06-18 09:23:41,375 INFO - OpenSim.Server.OpenSimServer
> [SERVER]: Loading XInventoryServiceInConnector
> 2010-06-18 09:23:41,375 INFO - OpenSim.Server.OpenSimServer
> [SERVER]: Failed to load
> OpenSim.Server.Handlers.dll:XInventoryServiceInConnector
>
> Note this was NOT shown in red in the log. Should it be? Its
> noted as INFO not an ERROR.
>
> ------------------------
>
> After that I have something up and running, and Opensim.ini looks
> to have started.
>
> -------------------------
> http_loginform.html and http://.../?method=regionImage served
> maps on URLs not serving
>
> I tried to look at the region map tiles using the
> http://.../index.php?method=regionImage<UUID> served maps on a web
> page...e.g.
>
> http://virtual.aiai.ed.ac.uk:9000/index.php?method=regionImagebd09a793eba511dc95ff0800200c9a66
> and the request come sin to the server, but the map fails to be
> generated (yellow warning).
>
>
> On trying SL Viewer 1.23 with my usual working 0.6.9 login
> parameters...
>
> "C:\Program Files\SecondLife\SecondLife.exe" -channel "Opensim"
> -loginuri http://virtual.aiai.ed.ac.uk:8002/ -loginpage
> http://virtual.aiai.ed.ac.uk:8002/?method=login
>
> The splash screen .html file I usually use in 0.6.9 is nt shown,
> though it is present at D:\VW\Opensim\bin\http_loginform.html as
> usual.
>
> Map serving to web also not serving images...
>
>
> http://virtual.aiai.ed.ac.uk:9000/index.php?method=regionImagebd09a793eba511dc95ff0800200c9a66
> ------------------
>
> I have not understood what port 82 is used for, or how it is meant
> to be used, and I should be set in opensim.ini to use my working
> Flotsam groups handling... but groups and port 82 errors are occurring
>
> Opensim.exe - Opensim.log
>
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: RequestingAgentUserService ::
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: RequestingSessionID ::
> 00000000-0000-0000-0000-000000000000
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: WriteKey :: 1234
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: AgentID ::
> e24a9015-f5ca-452b-8c95-d32e34cb9d64
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: ReadKey :: 1234
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: requestingAgentID ::
> 00000000-0000-0000-0000-000000000000
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: An error has occured while
> attempting to access the XmlRpcGroups server method:
> groups.getAgentGroupMemberships
> 09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: System.Net.WebException:
> Unable to connect to the remote server --->
> System.Net.Sockets.SocketException: No connection could be made
> because the target machine actively refused it 129.215.219.138:82
> <http://129.215.219.138:82>
>
> 09:36:08 - [HG INVENTORY CONNECTOR]: GetFolderContent
> d82055f9-7ac1-45bd-ab77-341a7a930b7b
> 09:36:08 - [XINVENTORY CONNECTOR STUB]: Exception in
> GetFolderContent: Root element is missing.
> ... repeated many times....
>
>
> -----------------------
>
> I also have not got the usual 3 hyperlinked regions put in via
> link-region - they all failed at startup. Maybe due to using HG
> 1.5 and the others have to be the same for it to work?
>
> -----------------------
>
> Okay, I am now logged on as my avatar, and I see all the objects i
> all regions in place, scripts seem to work, etc. I can move
> between regions via map teleport. My avatar has the expected UUID
> (as verified by touching an object whose script shows that).
>
> I seem to not have a home or last location on login.
>
> The avatar though is "Ruth", and when I look at the inventory, all
> folders are intact, but there is no content, and I just get
> "Loading"..."
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de <mailto:Opensim-dev at lists.berlios.de>
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>
>
>
> --
> Michael Emory Cerquoni - Nebadon Izumi @ http://osgrid.org
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20100618/037d9f65/attachment-0001.html>
More information about the Opensim-dev
mailing list