We did experience an issue with the Renci.SshNet.dll issue that was reported was seen before this where we copied the Renci.SshNet.dll from github to the mysql servers solidcp/bin folder which resolved the issue for that problem, However the issue is now is we cant connect to the mysql server from solidcp.

We have updated the ado drivers. tried variations of passwords and options in solidcp, to no avail. We can however connect to the mysql server using sqlyog with the correct passwords and user.

The mysql server solidcp eventlog has this error in it

Authentication to host '192.168.1.100' for user '`root`' using method 'mysql_native_password' failed with message: Access denied for user '`root`'@'192.168.1.100' (using password: YES)

despit this username and password working in other apps.

WE created a brand new server running mysql 5.6 added it to the solidcp system, can get all the rest working, same issue with cannot authenticate to the server, and also same issue with the 1.4.4 client installed it moaned about the Renci.SshNet.dll was incorrect version, after copying this file and the xml file this issue went away, but the authentication is an issue, so its not specific to our other db server. This server is a win 2016 server with fresh mysql 5.6.

Hello,

Can you please try download this file: http://installer.solidcp.com/Files/1.4.4/SQLProvider-Fix.zip

The DLL files should override the files in C:SolidCPServer asp.net v4.5bin on the server running the SQL server.

Regards,

Trevor

I also had the problem connecting to mysql after upgrading to v1.4.4.  I downloaded the dll files from your post and it fixed the problem so thank you!!

However, I am also having another problem since upgrading to v1.4.4.  The scheduler service is crashing with the two errors shown below.  This only started with v1.4.4 and the service crashes immediately when a task is run.  Please advise...

[Application Error]

Faulting application name: SolidCP.SchedulerService.exe, version: 1.4.4.0, time stamp: 0x5d6d4137
Faulting module name: KERNELBASE.dll, version: 6.3.9600.19425, time stamp: 0x5d26b6e9
Exception code: 0xe0434352
Fault offset: 0x000000000000908c
Faulting process id: 0x87c
Faulting application start time: 0x01d567ff32933130
Faulting application path: C:WebsitePanelEnterprise ServerbinSolidCP.SchedulerService.exe
Faulting module path: C:Windowssystem32KERNELBASE.dll
Report Id: 7c7ca8fd-d3f2-11e9-8135-001dd8b71c2f
Faulting package full name:
Faulting package-relative application ID:

[.NET runtime]

Application: SolidCP.SchedulerService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.ComponentModel.Win32Exception

Exception Info: System.Data.SqlClient.SqlException
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(System.Data.ProviderBase.DbConnectionPoolIdentity, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SqlCredential, System.Object, System.String, System.Security.SecureString, Boolean, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SessionData, System.Data.ProviderBase.DbConnectionPool, System.String, Boolean, System.Data.SqlClient.SqlAuthenticationProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Data.Common.DbConnectionOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(System.Data.Common.DbConnection, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(System.Data.Common.DbConnection, UInt32, Boolean, Boolean, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal ByRef)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal ByRef)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, System.Data.ProviderBase.DbConnectionInternal ByRef)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>)
at System.Data.SqlClient.SqlConnection.TryOpen(System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(System.String, System.Data.CommandType, System.String, System.Data.SqlClient.SqlParameter[])
at SolidCP.EnterpriseServer.Scheduler.RunManualTasks()
at SolidCP.EnterpriseServer.Scheduler.ScheduleTasks()
at SolidCP.SchedulerService.SchedulerService.Process(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.TimerQueueTimer.CallCallback()
at System.Threading.TimerQueueTimer.Fire()
at System.Threading.TimerQueue.FireNextTimers()

I figured out the issue with the scheduler service.  The SolidCP-EnterpriseServer-Update.zip file contains a copy of the SolidCP.SchedulerService.exe.config.  When I did the update it overwrote my config file which contains the sql credentials and crypto key.  You may want to remove the config file file from the update downloads so other people don't run into the same problem.  Thanks!!