Hi,
I've got MySQL 8.0 set up in SolidCP. When I try to create a database under an account, it tells me that an exception has occurred. I've checked the SolidCP event log, and it is showing this: -
[9/18/2023 9:05:09 PM] ERROR: 'MySQL Server 8.0' DatabaseExists
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MySql.Data.MySqlClient.MySqlField.SetFieldEncoding()
at MySql.Data.MySqlClient.NativeDriver.GetColumnData(MySqlField field)
at MySql.Data.MySqlClient.NativeDriver.GetColumnsData(MySqlField[] columns)
at MySql.Data.MySqlClient.Driver.GetColumns(Int32 count)
at MySql.Data.MySqlClient.ResultSet.LoadColumns(Int32 numCols)
at MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.Close()
at MySql.Data.MySqlClient.MySqlCommand.ResetReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at SolidCP.Providers.Database.MySqlServer.ExecuteQueryDataSet(String commandText, String connectionString)
at SolidCP.Providers.Database.MySqlServer.ExecuteQuery(String commandText)
at SolidCP.Providers.Database.MySqlServer.DatabaseExists(String databaseName)
at SolidCP.Server.DatabaseServer.DatabaseExists(String databaseName)
If I try to import resources for an existing database or user, I get the following stack traces...
[9/18/2023 8:58:29 PM] ERROR: 'MySQL Server 8.0' GetUsers
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MySql.Data.MySqlClient.MySqlField.SetFieldEncoding()
at MySql.Data.MySqlClient.NativeDriver.GetColumnData(MySqlField field)
at MySql.Data.MySqlClient.NativeDriver.GetColumnsData(MySqlField[] columns)
at MySql.Data.MySqlClient.Driver.GetColumns(Int32 count)
at MySql.Data.MySqlClient.ResultSet.LoadColumns(Int32 numCols)
at MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.Close()
at MySql.Data.MySqlClient.MySqlCommand.ResetReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at SolidCP.Providers.Database.MySqlServer.ExecuteQueryDataSet(String commandText, String connectionString)
at SolidCP.Providers.Database.MySqlServer.ExecuteQuery(String commandText)
at SolidCP.Providers.Database.MySqlServer.GetUsers()
at SolidCP.Server.DatabaseServer.GetUsers()
[9/18/2023 8:58:28 PM] ERROR: 'MySQL Server 8.0' GetDatabases
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at MySql.Data.MySqlClient.MySqlField.SetFieldEncoding()
at MySql.Data.MySqlClient.NativeDriver.GetColumnData(MySqlField field)
at MySql.Data.MySqlClient.NativeDriver.GetColumnsData(MySqlField[] columns)
at MySql.Data.MySqlClient.Driver.GetColumns(Int32 count)
at MySql.Data.MySqlClient.ResultSet.LoadColumns(Int32 numCols)
at MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlDataReader.Close()
at MySql.Data.MySqlClient.MySqlCommand.ResetReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at SolidCP.Providers.Database.MySqlServer.ExecuteQueryDataSet(String commandText, String connectionString)
at SolidCP.Providers.Database.MySqlServer.ExecuteQuery(String commandText)
at SolidCP.Providers.Database.MySqlServer.GetDatabases()
at SolidCP.Server.DatabaseServer.GetDatabases()
Any ideas?
Installing Connector/NET 8.0.33 seems to have got rid of this problem, but now I'm getting a StackOverflowException where SolidCP.Providers.Database.MySQL.dll!SolidCP.Providers.Database.MySqlServer.CurrentDomain_AssemblyResolve(object sender, System.ResolveEventArgs args) is calling Assembly.Resolve, which loops back round over and over - I think it is because of the answer on this post, but not sure if that is the case and if so how to work out what the dependencies are https://stackoverflow.com/questions/32245273/assembly-resolve-recurses-into-an-infinite-loop
Worked out from fuslogvw that it couldn't find MySQL.Data.dll, so I added that to the bin folder of SolidCP Server and now I get
Service installation results: Could not connect to the specified MySQL Server: Authentication method 'caching_sha2_password' not supported by any of the available plugins.
Finding this a lot of hassle!
Finally worked it out - I used gacutil /i and added a bindingRedirect to SolidCP Server's web.config to point to the new version of MySQL.Data to install MySQL.Data.dll to the GAC -
