Help: Backup mysql problem

[mach]

I have the mysql backup utility installed on version 1.2.6 and it all worked fine for months. I recently installed the quickbooks add on. i don't know if this is a factor or not. I did a backup on 5 Aug, now I get this error code.

Result code: 127
ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.

the path to MYSQLDump is correct.

The admin/includes/configure.php has all three new admin folder names. Not sure when I changed the admin folder name, but all 3 references are correct

the backups folder is 777

the admin folder is 755

i am using https for admin login, but turned it off for all admin to make sure that wasn't a problem.

Please help. I am out of ideas.

I also re-installed the mysql backup utility, no help

[DrByte]

I have the mysql backup utility installed on version 1.2.6 and it all worked fine for months.

I did a backup on 5 Aug, now I get this error code.

Result code: 127
ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.

the path to MYSQLDump is correct.

Sounds like your webhost changed something on the server between now and your last successful backup (via this method).

You need to talk to your host to determine the new location of the "mysqldump" and "mysql" binaries, and then update the settings in the language file:
/admin/includes/languages/english/backup_mysql.php

// define the locations of the mysql utilities.  Typical location is in '/usr/bin/' ... but not on Windows servers.
// try 'c:/mysql/bin/mysql.exe' and 'c:/mysql/bin/mysqldump.exe' on Windows hosts ... change drive letter and path as needed
define('LOCAL_EXE_MYSQL',     '/usr/bin/mysql');  // used for restores
define('LOCAL_EXE_MYSQLDUMP', '/usr/bin/mysqldump');  // used for backups

[mach]

well. i talked to the host, the path is correct. they haven't changed anything on the configuration. I can backup the database using cpanel. backup.

Something must have changed, i just can't find it.

between now and then is when i may have implememted the security procedures, maybe I have a permission wrong someplace. any ideas, what permissions I should look at?

[mach]

DR.Byte,

the paths are correct
the permissions are correct
i went through and checked everything in the readme file for the plugin
it used to work.
i re-installed the plugin

i can't find anything in the quick books plugin that would matter, i installed that since my last successful backup

I can backup the database with cpanel, is it possible to restore a cpanel backuped up .gz file with the plugin? it looks to be the same file when I open it up.

the admin directorie references are good in the config files

If anybody has any ideas, please let me know.

I haven't tried deleting all the files from the plug in and re-installing, just re-writing over the ones already there.

[mach]

ps. last night while inputting products, the entire site would only display a 1023 error with some kind of reference to mutiple instances of someting. Even the main page showed that. I closed all broweser windows and rebooted the pc and it came back to normal. It looked like some sort of session conflict or major database problem. Is it possiblr something is currupt in the db preventing the script from working to create a backup. I can backup the db fine using cpanel, and everything else appears to be working ok, except the db backup plugin

[mach]

here is a line from the error log

sh: line 1: /usr/local/phpchroot/mysqldump --host=localhost --user=xxxx --password=xxxxxxx --opt --complete-insert --result-file=/home/xxxx/public_html/adminxxxxxx/backups/xxxxxx-20060904173837.sql": No such file or directory


xxxx are used to hide the admin folder and passwords and such

[DrByte]

This is evidently the name of the binary file/path that the backup script is trying to use:

/usr/local/phpchroot/mysqldump

Is that what your host said it should be?

If not, then your host has changed their PHP configuration to force you to be chroot'ed while running PHP. Perhaps they have an idea how to get around that with an alternate path/configuration for your account?

[mach]

no. the host said it is /usr/bin/mysqldump

I had two different tech people tell me the same path

no where in the script that I can find does it reference this path. I tried changing the path in the script to that path, it didn't work either.

[mach]

what does chrotted while running php mean

unfortunately i don't have the logs from when it worked

[DrByte]

chroot is like a jailshell
these are linux/unix terms related to forcing security settings

if you are chroot'ed, that means your working area (in this case command-execution environment, akin to a DOS window) is restricted to only have access to the files/folders specified.

In your case, it appears that when PHP is granted exec() access, it's being chroot'ed to a path that doesn't have access/permission to the "required" binaries.

It would seem that your host has changed their PHP security restrictions since you last ran the program.