Hi Folks:
Installed on my new Windows Server 2022 machine are MySQL 8.0, MySQL Connector/Net 9.7.0, MySQL Workbench 26.7.0, phpMyAdmin 5.2.3, and SolidCP 1.5.1. Workbench and phpMyAdmin as well as WordPress for two test sites can access MySQL just fine, but SolidCP cannot. Also if I go into a customer, Space Statistics, Import Resources, MySQL 8 Database (or User), it shows nothing, which I guess makes sense given the other issue. In case it makes a difference, I did make two changes to my.ini to make v8 more compatible with the incoming v5.7 databases. 1) For sql-mode=, I removed NO_ZERO_IN_DATE and NO_ZERO_DATE, and 2) under [mysqld], I entered default-authentication-plugin=mysql_native_password.
When I try to save server settings for MySQL, even though the settings I've entered do seem to save, I get the error below. (Please forgive the length; I don't write the code.)
Page URL: https://* .****.com/Default.aspx?pid=Servers&mid=260&ctl=edit_service&ServiceID=6&ServerID=1
Logged User: serveradmin
Work on Behalf: serveradmin
Hosting Space: 0
Stack Trace: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at Microsoft.Web.Services3.WebServicesClientProtocol.GetResponse(WebRequest request, IAsyncResult result)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.Providers.ServiceProvider.Install()
at SolidCP.EnterpriseServer.esServers.InstallService(Int32 serviceId)
--- 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.EnterpriseServer.esServers.InstallService(Int32 serviceId)
at SolidCP.Portal.ServersEditService.btnUpdate_Click(Object sender, EventArgs e)
Any help would be most appreciated.
Thank you!
Scott
