Page 1 of 2

Mysqldump path error BUT correct path

Posted: Fri Jan 31, 2020 6:05 pm
by alexscj
Hello, TCMS Build 202001311825, MariaDB, getting "Mysqldump path error" even if the correct path is entered in Settings:

Code: Select all

Mysqldump path error ? /usr/bin/mysqldump returns error

Code: Select all

which mysqldump
/usr/bin/mysqldump
Any workaround ?

Re: Mysqldump path error BUT correct path

Posted: Fri Jan 31, 2020 6:36 pm
by alexscj
Partially fixed, 'exec' function was disabled in php, I'm able to backup through TCMS now but I'm still getting a warning:

Code: Select all

Mysqldump path error ? /usr/bin/mysqldump returns error 0

Re: Mysqldump path error BUT correct path

Posted: Fri Jan 31, 2020 6:44 pm
by admin
Hello, looks like I didn't check if exec was on

i'll add some 'ifs' there

Re: Mysqldump path error BUT correct path

Posted: Fri Jan 31, 2020 7:27 pm
by alexscj
Enabling php function "escapeshellcmd" also gets rid of the warning

Code: Select all

/usr/bin/mysqldump returns error 0

Re: Mysqldump path error BUT correct path

Posted: Sat Feb 01, 2020 6:53 am
by admin
Thank you

Re: Mysqldump path error BUT correct path

Posted: Mon Mar 09, 2020 10:16 am
by alexscj
If function pcntl_exec is disabled, TCMS gives a false positive:

Code: Select all

Function exec is disabled, script can not make backups
(the backups are created ok with pcntl_exec disabled)

Re: Mysqldump path error BUT correct path

Posted: Mon Mar 09, 2020 3:40 pm
by admin
pcntl_exec and exec are not the same
I believe you just have 2 different php configs: for mod_php and php cli

Re: Mysqldump path error BUT correct path

Posted: Wed Mar 11, 2020 3:14 am
by deeddy
alexscj wrote: Fri Jan 31, 2020 6:36 pm Partially fixed, 'exec' function was disabled in php, I'm able to backup through TCMS now but I'm still getting a warning:

Code: Select all

Mysqldump path error ? /usr/bin/mysqldump returns error 0
Backup works fine when exec and pcntl_exec are disabled. mysqldump path is correct, but I'm still getting that error.

Re: Mysqldump path error BUT correct path

Posted: Wed Mar 11, 2020 4:51 am
by admin
What do you have in disable_functions in php ini?

Re: Mysqldump path error BUT correct path

Posted: Wed Mar 11, 2020 6:39 am
by deeddy
admin wrote: Wed Mar 11, 2020 4:51 am What do you have in disable_functions in php ini?
fpm:

Code: Select all

eval, exec, passthru, system, proc_open, popen, curl_multi_exec, show_source, pcntl_exec, pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wifcontinued, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_get_handler, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_getpriority, pcntl_setpriority, pcntl_async_signals
cli:

Code: Select all

eval, exec, passthru, system, proc_open, popen, curl_multi_exec, show_source, pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wifcontinued, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_get_handler, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_exec, pcntl_getpriority, pcntl_setpriority, pcntl_async_signals