When attempting a backup of any MySQL DBs from SCP I get the following error:
System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Error executing ‘BACKUP’ task on ‘DB_NAME’ SQL_DATABASE —> Server was unable to process request. —> The directory name is invalid
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.esDatabaseServers.BackupSqlDatabase(Int32 itemId, String backupName, Boolean zipBackup, Boolean download, String folderName)
MySQL Connector NET v6.9.9
Do you mean the configuraiton of MySQL in SCP? If so it is:
Internal Address: mysql01.domain.com
External Address: mysql01.domain.com
MySQL Instllation Folder: C:Program FilesMySQLMySQL Server 5.7bin
Note: mysql01.domain.com is just a host file record.
Everything else (create DB/user & delete DB/user) works fine.
If you are having this very issue, you need to make sure that your application pool is set to the bitness of the apps on the server, ie mysql is running in 64bit mote, your .net app pool on the solidcp website must be 64bit, if you have it set to enable 32bit apps you will get this issue. This seems to go hand in hand with the other apps as well. The issue here is if you have 32bit and 64bit apps on the same server then there is a major issue. this needs to be resolved, maybe a switch needs to be put in the server configs to ask if the app is 64bit or not, and based on this the correct locations are used..