Mysqldump path error BUT correct path

admin
Site Admin
Posts: 37250
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysqldump path error BUT correct path

Post by admin »

That's strange ..

exec($mysql_str, $output, $error);

this is how it creates backups , and that's why I check 'exec('
you say it's disabled but somehow manages to create baxckups

so there are 2 options:

1. blindly remove warning and in some cases it won't work for no reason w\o any warning ans so on
2. you send me ssh so I can check why it is this way at your server
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 »

:lol: Replying with YOUR specific settings doesn't help the discussion, he asked for MY settings as this was an ongoing conversation.
deeddy wrote: Wed Mar 11, 2020 6:39 am
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
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysqldump path error BUT correct path

Post by alexscj »

Those are not MY disabled functions, deedy felt the need to reply with HIS :lol:
admin wrote: Wed Mar 11, 2020 6:48 am That's strange ..

exec($mysql_str, $output, $error);

this is how it creates backups , and that's why I check 'exec('
you say it's disabled but somehow manages to create baxckups

so there are 2 options:

1. blindly remove warning and in some cases it won't work for no reason w\o any warning ans so on
2. you send me ssh so I can check why it is this way at your server
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysqldump path error BUT correct path

Post by alexscj »

Getting back on track, by default I use these disabled functions:

Code: Select all

getmyuid,passthru,leak,listen,diskfreespace,tmpfile,link,ignore_user_abort,shell_exec,dl,set_time_limit,exec,system,highlight_file,source,show_source,fpassthru,virtual,posix_ctermid,posix_getcwd,posix_getegid,posix_geteuid,posix_getgid,posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid,posix,_getppid,posix_getpwuid,posix_getrlimit,posix_getsid,posix_getuid,posix_isatty,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_times,posix_ttyname,posix_uname,proc_open,proc_close,proc_nice,proc_terminate,escapeshellcmd,ini_alter,popen,pcntl_exec,socket_accept,socket_bind,socket_clear_error,socket_close,socket_connect,symlink,posix_geteuid,ini_alter,socket_listen,socket_create_listen,socket_read,socket_create_pair,stream_socket_server
Enabling the following functions seem to fix all TCMS warnings and everything seems to be running properly:

Code: Select all

exec
escapeshellcmd
pcntl_exec
set_time_limit
shell_exec
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysqldump path error BUT correct path

Post by alexscj »

You missed my previous reply,

enabling escapeshellcmd takes care of the Mysqldump path error ? /usr/bin/mysqldump returns error 0 warning.
deeddy wrote: Wed Mar 11, 2020 3:14 am
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: 37250
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysqldump path error BUT correct path

Post by admin »

Yes, thank you, I've fixed it )
Don't forget to run script update
Post Reply