i am using solidcp with windows 2019 . when users and admin try to backup mysql database , below error shown :
i check mysql setting and root password , every thing is ok.
below is my mysql setting :
how can i solve this problem?
i am using ver 1.4.3
i did not found folder you said : “C:\SolidCP\Server asp.net v4.5\bin”
i could only find this folder : “C:\SolidCP\Server\bin” then i replaced it but now i get below error in event viewer just when click on DB name i want to backup :
[9/9/2019 8:23:35 PM] ERROR: ‘MySQL Server 5.7’ GetDatabase
System.IO.FileLoadException: Could not load file or assembly ‘SolidCP.Providers.Base, Version=184.108.40.206, Culture=neutral, PublicKeyToken=da8782a6fc4d0081’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
File name: ‘SolidCP.Providers.Base, Version=220.127.116.11, Culture=neutral, PublicKeyToken=da8782a6fc4d0081’
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)
at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)
at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
at System.Type.GetType(String typeName)
at SolidCP.Server.DatabaseServer.GetDatabase(String databaseName)
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].
that dll you used is for the 1.4.4 version. I would maybe reccomend upgrading to 1.4.4, what version is your enterprise server, and portal server ?
i upgrade all servers to 1.4.4 successfully .
then replace downloaded .dll s from http://installer.solidcp.com/Files/1.4.4/SQLProvider-Fix.zip to C:\SolidCP\Server\bin
but again when try to backup mysql below error is in event viewer :
[9/10/2019 9:21:02 PM] ERROR: ‘MySQL Server 5.7’ BackupDatabase
System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at SolidCP.Providers.Utils.DefaultCommandLineProvider.Execute(String filePath, String args, String outputFile)
at SolidCP.Providers.Database.MySqlServer.BackupDatabase(String databaseName, String backupName)
at SolidCP.Providers.Database.MySqlServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
at SolidCP.Server.DatabaseServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
what must i do?
Can you confirm the path we have set before does contain the mysqldump.exe file?
If not you will need to locate this and set that to the MySQL path.
yes it has
the path is “C:\Program Files\MySQL\MySQL Server 5.7\bin” in server setting
and there is mysqldump.exe
i use this .exe in cmd successfully , but from solid cp portal , it does not work returning same error i sent before
Its difficult for us to be able to debug this issue as we cannot recreate it and nobody else appears to have this issue.
It might be easier if we are able to connect to your environment using our premium support. You can find the support plans at https://solidcp.com/services/server-support/ and using the contact form above to create a premium support ticket.
I did every thing you said me and sent you the results .
i am so sorry solidcp does not do very essential action like backing up mysql from panel and phpmyadmin
I found what made issue .
you gave me the wrong path for mysql server.
you said i set it as “C:\Program Files\MySQL\MySQL Server 5.7\bin”
but the correct path is “C:\Program Files\MySQL\MySQL Server 5.7”
- Views2906 times
- Answers20 answers