Hi,
I have just upgraded mysql version to 5.6.45 through community installer and now opening any database or creating new database is throwing below error
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.IO.FileLoadException: Could not load file or assembly ‘Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
at MySql.Data.MySqlClient.MySqlConnection.Close()
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.Providers.Database.MySqlServer.GetDatabase(String databaseName)
at SolidCP.Server.DatabaseServer.GetDatabase(String databaseName)
— End of inner exception stack trace —
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.Providers.Database.DatabaseServer.GetDatabase(String databaseName)
at SolidCP.EnterpriseServer.DatabaseServerController.GetSqlDatabase(Int32 itemId)
at SolidCP.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esDatabaseServers.GetSqlDatabase(Int32 itemId)
at SolidCP.Portal.SqlEditDatabase.BindItem()
Hi Trevor,
Things are working fine with me as expected post updated Renci.SshNet.dll
have validated with couple of clients as well as different accounts at my end.
Thanks
Hey @Beamer
Can you confirm this fix of the updated Renci.SshNet.dll file is still working for you?
Kind Regards,
Trevor
I had samilar errror. I installed Maria DB 10.2 and after installing MySQL Connector (8.0.17) I was facing same error. I installed MySQL connector 8.0.16 (Previous version) and error resolved on Windows Server.
Hi Trevor,
- Portal website stopped
- Replaced Renci.SshNet.dll with 2016 version of .NET 4.0
- working fine with accessing and creating mysql dbs
will monitor for any other impact observed.
Thanks for all support.
Alrite shall try and update, do i need to replace both .dll and .xml file rite ?
Thank you for your quick update.
Hello,
You can find the SSH.NET 2016.10 version at https://github.com/sshnet/SSH.NET/releases/download/2016.1.0/SSH.NET-2016.1.0-bin.zip you will most likely need the file in lib\net40.
If you can confirm this helps we can look to include it in the next release.
Do note that the forum is community support and done in free time. If you require urgent support you can have Premium (paid) support by using the contact button at the top of the page.
Regards,
Trevor
Hi Trevor,
- File is appearing in solidcp/server/bin location.
- When i check file version it looks old as below
File version 2013.4.7.0
Product name SSH.NET
Product version 2013.4.7 - As per error it seems it required file compatible for 2016 version
kindly suggest further