Mysqldump path error BUT correct path

alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Mysqldump path error BUT correct path

Post 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 ?
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysqldump path error BUT correct path

Post 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
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysqldump path error BUT correct path

Post by admin »

Hello, looks like I didn't check if exec was on

i'll add some 'ifs' there
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysqldump path error BUT correct path

Post by alexscj »

Enabling php function "escapeshellcmd" also gets rid of the warning

Code: Select all

/usr/bin/mysqldump returns error 0
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysqldump path error BUT correct path

Post by admin »

Thank you
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysqldump path error BUT correct path

Post 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)
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysqldump path error BUT correct path

Post 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
Don't forget to run script update
deeddy
Posts: 14
Joined: Tue Jan 07, 2020 4:00 am

Re: Mysqldump path error BUT correct path

Post 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.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysqldump path error BUT correct path

Post by admin »

What do you have in disable_functions in php ini?
Don't forget to run script update
deeddy
Posts: 14
Joined: Tue Jan 07, 2020 4:00 am

Re: Mysqldump path error BUT correct path

Post 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
Post Reply