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 <[email protected]
<mailto:[email protected]>> 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
[email protected] <mailto:[email protected]>
https://lists.berlios.de/mailman/listinfo/opensim-dev
--
Michael Emory Cerquoni - Nebadon Izumi @ http://osgrid.org
_______________________________________________
Opensim-dev mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-dev
_______________________________________________
Opensim-dev mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-dev
