<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
On 6/18/2010 7:24 AM, Michael Cerquoni wrote:
<blockquote
cite="mid:AANLkTinSvmXVbYAM2tZHG32h_NRCmGNVDoeGVYCdf8z_@mail.gmail.com"
type="cite">Ai Austin,<br>
<br>
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!!<br>
<br>
<div class="gmail_quote">On Fri, Jun 18, 2010 at 4:38 AM, Ai Austin <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:ai.ai.austin@gmail.com">ai.ai.austin@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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.<br>
<br>
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)<br>
<br>
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.<br>
<br>
---------------------------<br>
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<br>
<a moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html"
target="_blank">http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html</a>
It may be worth They should be something like:<br>
<br>
[mysqld]<br>
open-files-limit = 20000 (add -limit on end of name
and yes these are hyphens not underscores)<br>
interactive_timeout = 1000000 (drop a 0 as it was beyond legal
upper range)<br>
wait_timeout = 1000000 (drop a 0 as it was beyond legal
upper range)<br>
max_connnections = 2000 (connections plural not connection)<br>
<br>
I noted these changes, but left Diva's values in for now until we
verify these are right at<br>
<a moz-do-not-send="true"
href="http://opensimulator.org/wiki/0.7_Release#Before_you_upgrade"
target="_blank">http://opensimulator.org/wiki/0.7_Release#Before_you_upgrade</a><br>
<br>
---------------------------<br>
<br>
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.<br>
<br>
2010-06-17 10:26:37,437 INFO - OpenSim.Server.Base.HttpServerBase
[SERVER]: Starting HTTP server on port 8003<br>
2010-06-17 10:26:37,482 INFO - OpenSim.Server.Base.HttpServerBase
[SERVER]: Requested port 8003<br>
2010-06-17 10:26:37,482 INFO - OpenSim.Server.OpenSimServer [SERVER]:
Loading AssetServiceConnector<br>
2010-06-17 10:26:37,744 INFO - OpenSim.Data.Migration [MIGRATIONS]
Upgrading AssetStore to latest revision 8.<br>
2010-06-17 10:26:37,745 INFO - OpenSim.Data.Migration [MIGRATIONS]
NOTE: this may take a while, don't interupt this process!<br>
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;<br>
<br>
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.<br>
2010-06-17 10:27:08,650 INFO - OpenSim.Data.Migration [MIGRATIONS]:
Updating AssetStore to version 7<br>
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 '';<br>
<br>
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.<br>
2010-06-17 10:27:40,850 INFO - OpenSim.Data.Migration [MIGRATIONS]:
Updating AssetStore to version 8<br>
<br>
<br>
------------------------<br>
Note also in the log above typo in one of the INFO messages at
2010-06-17 10:26:37,745 "interupt" -> "interrupt"<br>
<br>
-----------------------<br>
<br>
As I said I manually added in these data base column addition to let me
get further.<br>
Manually doing the following in MySQL command line client<br>
<br>
use opensim;<br>
ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0;<br>
ALTER TABLE assets ADD COLUMN CreatorID varchar(128) NOT NULL DEFAULT
'';<br>
<br>
---------------------<br>
<br>
I note that in Robust.exe I get this error message early on in the
logs.... which I have not yet tracked down.<br>
<br>
2010-06-18 09:23:41,375 INFO - OpenSim.Server.OpenSimServer [SERVER]:
Loading XInventoryServiceInConnector<br>
2010-06-18 09:23:41,375 INFO - OpenSim.Server.OpenSimServer [SERVER]:
Failed to load OpenSim.Server.Handlers.dll:XInventoryServiceInConnector<br>
<br>
Note this was NOT shown in red in the log. Should it be? Its noted as
INFO not an ERROR.<br>
<br>
------------------------<br>
<br>
After that I have something up and running, and Opensim.ini looks to
have started.<br>
<br>
-------------------------<br>
http_loginform.html and <a class="moz-txt-link-freetext" href="http://.../?method=regionImage">http://.../?method=regionImage</a> served maps on
URLs not serving<br>
<br>
I tried to look at the region map tiles using the
<a class="moz-txt-link-freetext" href="http://.../index.php?method=regionImage">http://.../index.php?method=regionImage</a><UUID> served maps on a
web page...e.g.<br>
<br>
<a moz-do-not-send="true"
href="http://virtual.aiai.ed.ac.uk:9000/index.php?method=regionImagebd09a793eba511dc95ff0800200c9a66"
target="_blank">http://virtual.aiai.ed.ac.uk:9000/index.php?method=regionImagebd09a793eba511dc95ff0800200c9a66</a><br>
and the request come sin to the server, but the map fails to be
generated (yellow warning).<br>
<br>
<br>
On trying SL Viewer 1.23 with my usual working 0.6.9 login parameters...<br>
<br>
"C:\Program Files\SecondLife\SecondLife.exe" -channel "Opensim"
-loginuri <a moz-do-not-send="true"
href="http://virtual.aiai.ed.ac.uk:8002/" target="_blank">http://virtual.aiai.ed.ac.uk:8002/</a>
-loginpage <a moz-do-not-send="true"
href="http://virtual.aiai.ed.ac.uk:8002/?method=login" target="_blank">http://virtual.aiai.ed.ac.uk:8002/?method=login</a><br>
<br>
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.<br>
<br>
Map serving to web also not serving images...<br>
<br>
<br>
<a moz-do-not-send="true"
href="http://virtual.aiai.ed.ac.uk:9000/index.php?method=regionImagebd09a793eba511dc95ff0800200c9a66"
target="_blank">http://virtual.aiai.ed.ac.uk:9000/index.php?method=regionImagebd09a793eba511dc95ff0800200c9a66</a><br>
------------------<br>
<br>
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<br>
<br>
Opensim.exe - Opensim.log<br>
<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: RequestingAgentUserService ::<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: RequestingSessionID ::
00000000-0000-0000-0000-000000000000<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: WriteKey :: 1234<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: AgentID ::
e24a9015-f5ca-452b-8c95-d32e34cb9d64<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: ReadKey :: 1234<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: requestingAgentID ::
00000000-0000-0000-0000-000000000000<br>
09:35:38 - [XMLRPC-GROUPS-CONNECTOR]: An error has occured while
attempting to access the XmlRpcGroups server method:
groups.getAgentGroupMemberships<br>
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 <a moz-do-not-send="true"
href="http://129.215.219.138:82" target="_blank">129.215.219.138:82</a><br>
<br>
09:36:08 - [HG INVENTORY CONNECTOR]: GetFolderContent
d82055f9-7ac1-45bd-ab77-341a7a930b7b<br>
09:36:08 - [XINVENTORY CONNECTOR STUB]: Exception in GetFolderContent:
Root element is missing.<br>
... repeated many times....<br>
<br>
<br>
-----------------------<br>
<br>
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?<br>
<br>
-----------------------<br>
<br>
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).<br>
<br>
I seem to not have a home or last location on login.<br>
<br>
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"..."<br>
<br>
<br>
_______________________________________________<br>
Opensim-dev mailing list<br>
<a moz-do-not-send="true" href="mailto:Opensim-dev@lists.berlios.de"
target="_blank">Opensim-dev@lists.berlios.de</a><br>
<a moz-do-not-send="true"
href="https://lists.berlios.de/mailman/listinfo/opensim-dev"
target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Michael Emory Cerquoni - Nebadon Izumi @ <a moz-do-not-send="true"
href="http://osgrid.org">http://osgrid.org</a><br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Opensim-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-dev">https://lists.berlios.de/mailman/listinfo/opensim-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>