Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005184opensim[GRID] Robust Serverpublic2010-11-05 00:132011-04-12 14:14
Reporterjezmertel 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0005184: MySQL DB link with MONO on PPC arch
DescriptionWhen launching the Robust server on PPC architecture. Lots of errors relating to MySQL, access denied file not found..... Each service fails with similar. See partial screen dump below.

Additional Information07:57:55 - [SERVER]: Loading AssetServiceConnector
07:57:55 - Error loading plugin from OpenSim.Services.AssetService.dll, exception MySql.Data.MySqlClient.MySqlException: Access denied for user '***'@'localhost' (using password: YES)
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadOk (Boolean read) [0x00000] in <filename unknown>:0

07:57:55 - [SERVER]: AssetServiceConnector loaded successfully
07:57:55 - [SERVER]: Requested port 8003
07:57:55 - [SERVER]: Loading XInventoryInConnector
07:57:55 - [XInventoryInConnector]: Starting with config name InventoryService
07:57:55 - [SERVICE BASE]: Failed to load plugin OpenSim.Data.IXInventoryData from OpenSim.Data.MySQL.dll with args Data Source=localhost;Database=***;User ID=***;Password=***;Old Guids=true;,
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Access denied for user '***'@'localhost' (using password: YES)
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.ReadOk (Boolean read) [0x00000] in <filename unknown>:0
  --- End of inner exception stack trace ---
  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in <filename unknown>:0
  at System.Reflection.MonoCMethod.Invoke (BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in <filename unknown>:0
  at System.Activator.CreateInstance (System.Type type, BindingFlags bindingAttr, System.Reflection.Binder binder, System.Object[] args, System.Globalization.CultureInfo culture, System.Object[] activationAttributes) [0x00000] in <filename unknown>:0
  at System.Activator.CreateInstance (System.Type type, System.Object[] args, System.Object[] activationAttributes) [0x00000] in <filename unknown>:0
  at System.Activator.CreateInstance (System.Type type, System.Object[] args) [0x00000] in <filename unknown>:0
  at OpenSim.Services.Base.ServiceBase.LoadPlugin[IXInventoryData] (System.String dllName, System.String className, System.Object[] args) [0x00000] in <filename unknown>:0

07:57:55 - Error loading plugin from OpenSim.Services.InventoryService.dll, exception System.Exception: Could not find a storage interface in the given module
  at OpenSim.Services.InventoryService.XInventoryService..ctor (IConfigSource config) [0x00000] in <filename unknown>:0
  at (wrapper managed-to-native) System.Reflection.MonoCMethod:InternalInvoke (System.Reflection.MonoCMethod*,object,object[],System.Exception&)
  at System.Reflection.MonoCMethod.Invoke (System.Object obj, BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00000] in <filename unknown>:0
TagsNo tags attached.
Git Revision or version number80f9022
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBasicPhysics
Script Engine
EnvironmentMono / OSX
Mono Version2.8
Viewerdidn't get this far
Attached Files

- Relationships

-  Notes
(0017242)
nebadon (administrator)
2010-11-05 00:22

this is not really a bug, none of the default opensim libraries support PPC you will need to recompile just about all the precompiled libraries - http://opensimulator.org/svn/opensim-libs/ [^] though i am not sure where you get the PPC mysql connector from, probably directly from mysql project, i don't believe the source for mysql driver is in our svn.
(0017243)
jezmertel (reporter)
2010-11-05 01:26
edited on: 2010-11-05 01:30

I reported it as a bug on the basis that 0.7.0.2 worked without hitch, but 0.7.1 nolonger works.
I will compile the libs and report back.
Thanks
Whilst I think about it.... is there a minimum version number of MySQL I need to be running? the last PPC version is 5.0.84 without compiling myself

(0017244)
nebadon (administrator)
2010-11-05 01:34
edited on: 2010-11-05 01:36

ok that makes sense, 0.7.0.2 uses the 0.6.9 opensim (mysql.dll v5.2.5.0) version of mysql connecter. the new version in 0.7.1 (dev) is mysql.dll v6.2.4.0, but the old mysql.dll should work in 0.7.1 if you copy it over and recompile OpenSim.

(0017245)
jezmertel (reporter)
2010-11-05 02:21
edited on: 2010-11-05 02:24

OK I found the location for MySQL.DLL. I can get it from the MySQL site. But the 6.2.4 says platform independent.......

(0017246)
jezmertel (reporter)
2010-11-05 14:09

I downloaded both 6.2.4 and 5.2.5 of the mysql.data.dll and dropped them into a clean source of opensim. Didn't seem to matter what I did the build failed:

[csc] /Users/pp/Desktop/opensim-7b0d643/OpenSim/Data/MySQL/MySQLEstateData.cs(33,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?
                  [csc] /Users/pp/Desktop/opensim-7b0d643/OpenSim/Data/MySQL/MySQLSimulationData.cs(36,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?
                  [csc] Compilation failed: 2 error(s), 0 warnings
            
            BUILD FAILED - 0 non-fatal error(s), 3 warning(s)
            
            /Users/pp/Desktop/opensim-7b0d643/OpenSim/Data/MySQL/OpenSim.Data.MySQL.dll.build(14,6):
            External Program Failed: /opt/local/lib/mono/2.0/gmcs.exe (return code was 1)

I'm right at the limit of my ability here. Any ideas?
(0018259)
justincc (administrator)
2011-04-11 16:02

To be honest, this looks like a mysql connection config problem as you're getting the MySql.Data.MySqlClient.MySqlException: Access denied message.
(0018270)
jezmertel (reporter)
2011-04-11 23:35

Hi Justin,
It's not a config problem, we have had some limited success compiling with the connector pulled from an older version of opensim and recompiling.
Something has changed.
Maybe significant, maybe not, but during the compilation there are dozens of messages saying 'Warning you can not limit the architecture that this will run on' This is me paraphrasing the warning message. I don't see this message when compiling older versions of OpenSim.
(0018271)
justincc (administrator)
2011-04-12 10:36

Don't worry about those messages - I get them as well with no ill effects - I think it's a nant issue.
(0018272)
jezmertel (reporter)
2011-04-12 14:14

OK, I will not worry about those messages during compilation. However, it still doesn't work on PPC since 0.7.1 :(
That used to be our ROBUST server

- Issue History
Date Modified Username Field Change
2010-11-05 00:13 jezmertel New Issue
2010-11-05 00:13 jezmertel Git Revision => 80f9022
2010-11-05 00:13 jezmertel SVN Revision => 0
2010-11-05 00:13 jezmertel Run Mode => Grid (Multiple Regions per Sim)
2010-11-05 00:13 jezmertel Physics Engine => BasicPhysics
2010-11-05 00:13 jezmertel Environment => Mono / OSX
2010-11-05 00:13 jezmertel Mono Version => 2.8
2010-11-05 00:13 jezmertel Viewer => didn't get this far
2010-11-05 00:22 nebadon Note Added: 0017242
2010-11-05 01:26 jezmertel Note Added: 0017243
2010-11-05 01:30 jezmertel Note Edited: 0017243
2010-11-05 01:34 nebadon Note Added: 0017244
2010-11-05 01:34 nebadon Note Edited: 0017244
2010-11-05 01:35 nebadon Note Edited: 0017244
2010-11-05 01:36 nebadon Note Edited: 0017244
2010-11-05 02:21 jezmertel Note Added: 0017245
2010-11-05 02:24 jezmertel Note Edited: 0017245
2010-11-05 14:09 jezmertel Note Added: 0017246
2011-04-11 16:02 justincc Note Added: 0018259
2011-04-11 23:35 jezmertel Note Added: 0018270
2011-04-12 10:36 justincc Note Added: 0018271
2011-04-12 14:14 jezmertel Note Added: 0018272
2014-01-23 15:41 justincc Category Robust Server => [GRID] Robust Server


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker