Re: Mysql .net connector 8.0.33 - General Questions

RE: Re: Mysql .net connector 8.0.33

Joe Davis — Wed, 11 Jun 2025 11:16:14 +0000

@trobinson thank you.

I was reminded by one of the guys at the office that I did add an entry for 8.3 in the database a while back. I pointed it at a provider which didn't exist though so it of course didn't work. I've adjusted that entry to point to the MySQL 8 provider and it appears things are rolling along.

Is there a reason the provider hasn't been updated to support MySQL > 8.0?

RE: Re: Mysql .net connector 8.0.33

Beamer — Wed, 11 Jun 2025 10:33:29 +0000

@joedavis As mentioned by Trevor, mysql conn 8.0.27 is the best bet as of now and working well for me in both mysql 8 and mysql 5 versions.

latest mysql conn version is breaking it

RE: Mysql .net connector 8.0.33

Trevor Robinson — Tue, 10 Jun 2025 19:17:45 +0000

Hey,

Normally i would suggest trying MySQL Connector Net 8.0.27 as this generally does work for most versions. If you need the MySQL ODBC connector then 5.2.4 is the best version for that.

@joedavis regarding your error im not sure. We have not released a MySQL 8.3 which might be why your getting the error you do (Im not sure if this was custom development by you). You should try use the Mysql 8.0 provider as it should work.

Regards,

Trevor

RE: Mysql .net connector 8.0.33

Joe Davis — Tue, 10 Jun 2025 18:13:05 +0000

actually, I should say that I am not able to get solidcp to connect to mysql regardless of the version of mysql connector/net. I've tried many different versions. Here's the error message I'm getting:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Can not create 'MySQL Server 8.3' provider instance with 'SolidCP.Providers.Database.MySqlServer83, SolidCP.Providers.Database.MySQL' type ---> Value cannot be null.
Parameter name: type
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.ServiceProvider.Install()
at SolidCP.EnterpriseServer.esServers.InstallService(Int32 serviceId)
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)

RE: Mysql .net connector 8.0.33

Joe Davis — Tue, 10 Jun 2025 18:09:10 +0000

I am having the same issue. I have several servers with mysql 8.3 installed, using the 8.33 connector/net. They worked at one point because we have databases on these servers created through solidcp. Now, with solidcp 1.5.1 installed we cannot get connected to mysql through solidcp.

I'm happy to work with whoever I need to help figure this issue out.

RE: Mysql .net connector 8.0.33

Beamer — Mon, 24 Mar 2025 10:32:01 +0000

Is anyone facing similar issue ?

DB error while upgrading .NET connected to latest version !

but works fine with 8.0.29

Re: Mysql .net connector 8.0.33

Beamer — Sat, 08 Mar 2025 06:51:21 +0000

Hi,

I have recently adding Mysql 8.0 and facing issue with .NET connector 8.0.33 when adding the db

faced similar issue with old mysql 5.6 as well but both works when downgraded to .NET connector 8.0.29

Any solution or work around for this !!

Thanks