Error while adding MySQL server in WebsitePanel

While adding MySQL 5.x server in your WebsitePanel, you may receive the following error even if you have installed MySQL .Net connector on your server:

WHMCS Complete Billing and Support

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.IO.FileNotFoundException: Could not load file or assembly ‘MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’ or one of its dependencies. The system cannot find the file specified.
File name: ‘MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’
at WebsitePanel.Providers.Database.MySqlServer.Install()
at WebsitePanel.Server.ServiceProvider.Install()
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
— 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 WebsitePanel.Providers.ServiceProvider.Install()
at WebsitePanel.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 WebsitePanel.EnterpriseServer.esServers.InstallService(Int32 serviceId)
at WebsitePanel.Portal.ServersEditService.btnUpdate_Click(Object sender, EventArgs e)

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.IO.FileNotFoundException: Could not load file or assembly ‘MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’ or one of its dependencies. The system cannot find the file specified. File name: ‘MySql.Data, Version=6.2.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’ at WebsitePanel.Providers.Database.MySqlServer.Install() at WebsitePanel.Server.ServiceProvider.Install()
WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
— 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 WebsitePanel.Providers.ServiceProvider.Install() at WebsitePanel.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 WebsitePanel.EnterpriseServer.esServers.InstallService(Int32 serviceId) at WebsitePanel.Portal.ServersEditService.btnUpdate_Click(Object sender, EventArgs e)

Solution:

This error can be fixed by installin MySQL .Net connector 6.2.4 instead of latest version. Uninstall previously installed MySQL .Net connector and install MySQL .Net connector 6.2.4. After installing 6.2.4, you should not face any problem to add MySQL server in WebsitePanel.

Posted in Web Hosting Control Panels and tagged , , , .

Leave a Reply

Your email address will not be published. Required fields are marked *