Take the attached .zip file. Unpack it. It contains DataAbstract.daConfig file. Put this file next to Relativity.exe (overwrite the existing one if needed). According to your machine.config posted earlier you already use 6.9.8 drivers so no change is needed. GAC the MySql.Data.dll. Restart Relativity. After that MySQL connector should work.
Thank you for the Testtool. Seems there is a file missing…
C:\Users\csbmobil\Desktop\tmp_server\Release>DriversTest http://mydomain:7099/bin Administrator password
Driver: MSSQL.NET
Is loaded: YES
Driver: MSSQL2005.NET
Is loaded: YES
Driver: MSSQLCE.NET
Is loaded: NO
Load error: DataProvider "MSSQLCE.NET" cannot be loaded. To use the MSSQLCE.NET driver for SQL S
erver Compact v3.5, you must install the SQL Server Compact 3.5 SP1 from http://www.microsoft.com/sq
lserver/2005/en/us/compact-downloads.aspx.
There was a problem loading the Data Abstract for .NET driver assembly for MSSQLCE.NET:
(FileNotFoundException) Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.1.0, C
ulture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies
Driver: ODBC.NET
Is loaded: YES
Driver: OLEDB.NET
Is loaded: YES
Driver: FB.NET
Is loaded: YES
Driver: FB4.NET
Is loaded: YES
Driver: NexusDB.NET
Is loaded: NO
Load error: DataProvider "NexusDB.NET" cannot be loaded. Unable to find the requested .Net Frame
work Data Provider. It may not be installed.
Driver: SQLite.NET
Is loaded: NO
Load error: DataProvider "SQLite.NET" cannot be loaded. To use the SQLite.NET driver, you must i
nstall the free SQLite driver from http://sourceforge.net/projects/sqlite-dotnet2/.
There was a problem loading the Data Abstract for .NET driver assembly for SQLite.NET:
(FileNotFoundException) Could not load file or assembly 'System.Data.SQLite, Version=1.0.96.0, Cultu
re=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies
Driver: NPGSQL.NET
Is loaded: YES
Driver: MySql.NET
Is loaded: YES
Driver: MySqlv4.NET
Is loaded: YES
Driver: ORACLE.NET
Is loaded: YES
Driver: ODP12c.NET
Is loaded: NO
Load error: DataProvider "ODP12c.NET" cannot be loaded. Unable to find the requested .Net Framew
ork Data Provider. It may not be installed.
Driver: ODP10g.NET
Is loaded: NO
Load error: DataProvider "ODP10g.NET" cannot be loaded. Unable to find the requested .Net Framew
ork Data Provider. It may not be installed.
Driver: ODP9i.NET
Is loaded: NO
Load error: DataProvider "ODP9i.NET" cannot be loaded. There was a problem loading the Data Abst
ract for .NET driver assembly for ODP9i.NET:
(FileNotFoundException) Could not load file or assembly 'Oracle.DataAccess, Version=9.2.0.700, Cultu
re=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies
Driver: Advantage.NET
Is loaded: NO
Load error: DataProvider "Advantage.NET" cannot be loaded. Unable to find the requested .Net Fra
mework Data Provider. It may not be installed.
Driver: SQLAnywhere.NET
Is loaded: NO
Load error: DataProvider "SQLAnywhere.NET" cannot be loaded. Unable to find the requested .Net F
ramework Data Provider. It may not be installed.
Driver: ElevateDB.NET
Is loaded: NO
Load error: DataProvider "ElevateDB.NET" cannot be loaded. Unable to find the requested .Net Fra
mework Data Provider. It may not be installed.
Driver: VistaDB5.NET
Is loaded: NO
Load error: DataProvider "VistaDB5.NET" cannot be loaded. To use the VistaDB.NET driver you must
install the VistaDB from http://www.gibraltarsoftware.com/VistaDB
There was a problem loading the Data Abstract for .NET driver assembly for VistaDB5.NET:
(FileNotFoundException) Could not load file or assembly 'VistaDB.5.NET40, Version=5.1.0.0, Culture=n
eutral, PublicKeyToken=dfc935afe2125461' or one of its dependencies
Der Befehl "X" ist entweder falsch geschrieben oder
konnte nicht gefunden werden.
The Problem is just that since the mono Update i am not able to connect to my Database anymore.
Both in Server Admin and in my Application.
In the Application i always get the Message ( see first post ).
The Error in the Serer Admin is:
Please run the attached tool. It will load Data Abstract and will try to connect to the MySQL server via it. Release.zip (764.9 KB)
That said, I just took a clean kubuntu VM, installed there latest Mono, MySQL server, Relativity Server and MySQL driver 6.9.8 - and everything worked as it should.
That said, I just took a clean kubuntu VM, installed there latest Mono, MySQL server, Relativity Server and MySQL driver 6.9.8 - and everything worked as it should.
Just Downloaded the kubuntu VM and will try it also…
The strange sting is just that it worked before and it was fine…
I realized also that when i change the some setting on the Server with the Server Admin the Relativity Server crashes. Will now check if there are some rights issues… ( but the Server runs as root )
I have this on 2 Systems, one freshinstall in vmware ( ubuntu Server 64 Bit ).
Just start the Server, hit enter and get some errors.
Sorry for the late response. ( I work on this Project in my “freetime” )
I tryed also to generate a diverent user and see how this works…
Not Well at all…
( Just for Info ) My production-Server is:
Ubuntu 14.04 with Plesk 12 ( for Administration )
With a new generated user i get Errors in the Mysql Logfie:
151130 18:32:24 [Warning] ‘user’ entry ‘relativity@%’ has both a password and an authentication plugin specified. The password will be ignored.
So i guess this look more of a MySQL + Plesk + Relativity Problem…
Maybe this is related:
( btw. id did run before… i try to look into this… )
Did run the Program on the Server, and did get following Message:
root@www:/var/www/vhosts/release# sudo mono DriversTest.exe
MySQL Connection Test
Error:
System.TypeInitializationException: The type initializer for 'MySql.Data.MySqlClient.MySqlTrace' threw an exception. ---> System.InvalidCastException: Specified cast is not valid.
at System.Diagnostics.DiagnosticsConfiguration.GetConfigSection () <0x40370f20 + 0x00034> in <filename unknown>:0
at System.Diagnostics.DiagnosticsConfiguration.Initialize () <0x40390ef0 + 0x0006f> in <filename unknown>:0
at System.Diagnostics.DiagnosticsConfiguration.get_Sources () <0x403b4f70 + 0x0000f> in <filename unknown>:0
at System.Diagnostics.TraceSource.Initialize () <0x403b4b30 + 0x00073> in <filename unknown>:0
at System.Diagnostics.TraceSource.get_Listeners () <0x403b4b00 + 0x0000f> in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlTrace..cctor () <0x403b4290 + 0x0008b> in <filename unknown>:0
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () <0x403b3b50 + 0x000af> in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlPool.GetConnection () <0x403b3750 + 0x00067> in <filename unknown>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () <0x403b8ac0 + 0x003b3> in <filename unknown>:0
Done
Thanks for the error message. Take a closer look at the stacktrace you posted - the error happens deep in the Mono core, in the place that is not accessible from the user code (mean, it is not possible to pass any parameters to that user code or anyhow affect its behavior from the user code).
I’ve looked thru Mono sources and their change logs and it seems that keeping the old machine.config while updating was the cause of all the problems. They have renamed at least one of the entires stored in the machine.config, so the Mono core was not able to find it and failed (in your case - on opening MySQL connection).
Also it explains why I was not able to reproduce the issue.
You need to:
Completely remove the existing mono installation (including hte directories with macine.config files. Move them somewhere if needed).
Install the mono-complete package.
This should resolve the issue.
Relativity Server cannot anyhow access or affrect server or user settings. so any configuration issues are entirely up to the server administrator.
Relativity Server cannot anyhow access or affrect server or user settings. so any configuration issues are entirely up to the server administrator.
Did not meant that the Relativity Server did cause the truble…
Just taught the Problem ( as you already described ) was in combination with different Parts:
Every Day a new opportunity to learn something… hopefully not always that hard…
It would have been quite stress full if the system would already in use ( by many people)