If you have recently upgraded WebsitePanel version, you may face creating MySQL databases from WebsitePanel and you may receive the following error:
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Could not load file or assembly ‘MySql.Data, Version=6.3.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d’ or one of its dependencies. The system cannot find the file specified. 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.Database.DatabaseServer.GetUser(String username, String[] databases) at WebsitePanel.EnterpriseServer.DatabaseServerController.GetSqlUser(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 WebsitePanel.EnterpriseServer.esDatabaseServers.GetSqlUser(Int32 itemId) at WebsitePanel.Portal.SqlEditUser.BindItem()
This error occurs due to MySQL .Net connector. You can download MySQL .Net connector 6.3.7.0 from the following URL:
http://download.softagency.net/MySQL/Downloads/Connector-Net/
If you are using the latest version, you may first require uninstalling it before installing MySQL .Net connector 6.3.7.0.
Kailash Aghera
