Error message possibly related to mysqladmin?

[kamm]

Hi Folks,

Firstly, I've got a managed server and I've submitted a ticket for this and they say there's no cause for concern, but I'm wondering what you guys think.

So, the possible problem is...

This morning I received this error message:

The backup of xxx_user_xxx's account encountered errors Please check
/usr/local/cpanel/logs/error_log and
/usr/local/cpanel/logs/cpbackup/1235_xxx.log for more information.

cpbackup log appeared to be much like any other night.
logs/error_log appeared to be new and had the following errors.

2009-02-21 00:00:27 info [mysqladmin] Not updating privileges for xxx_user_1_xxx (reseller login and no password specified in ~/.my.cnf)
2009-02-21 00:01:00 info [mysqladmin] Not updating privileges for xxx_user_2_xxx (reseller login and no password specified in ~/.my.cnf)
etc...

There was one of the above errors for each account.

Strangely, the time in the error_log appears to be out of sync with the backup by exactly one hour.

So backup started at. 01:00:02 for user_1
first error_log message shows a time for 00:00:27 for user_1
last error_log message shows a time for 00:29:25 for the last user
with backup ending at 01:29:40

Should I be concerned?

[larwilliams]

Hi Folks,

Firstly, I've got a managed server and I've submitted a ticket for this and they say there's no cause for concern, but I'm wondering what you guys think.

So, the possible problem is...

This morning I received this error message:

The backup of xxx_user_xxx's account encountered errors Please check
/usr/local/cpanel/logs/error_log and
/usr/local/cpanel/logs/cpbackup/1235_xxx.log for more information.

cpbackup log appeared to be much like any other night.
logs/error_log appeared to be new and had the following errors.

2009-02-21 00:00:27 info [mysqladmin] Not updating privileges for xxx_user_1_xxx (reseller login and no password specified in ~/.my.cnf)
2009-02-21 00:01:00 info [mysqladmin] Not updating privileges for xxx_user_2_xxx (reseller login and no password specified in ~/.my.cnf)
etc...

There was one of the above errors for each account.

Strangely, the time in the error_log appears to be out of sync with the backup by exactly one hour.

So backup started at. 01:00:02 for user_1
first error_log message shows a time for 00:00:27 for user_1
last error_log message shows a time for 00:29:25 for the last user
with backup ending at 01:29:40

Should I be concerned?

run this command (replacing the cpbackup log file name with the right one)

grep "error" /usr/local/cpanel/logs/cpbackup/1235_xxx.log

In my case, it shows:
/bin/gtar: Error exit delayed from previous errors
/bin/gtar: Error exit delayed from previous errors

Looking over the log file, gtar is unable to trying to include the "public_ftp" folder and failing due to insufficient user privileges. I assume this is an issue introduced with the latest cPanel update, as this has never occurred on our servers before.

[larwilliams]

Here is what I ran on my most recent cpbackup log and got:

grep "/bin/gtar" /usr/local/cpanel/logs/cpbackup/1235536201.log

Copying homedir..../bin/gtar: ./public_ftp: Cannot savedir: Permission denied
/bin/gtar: Error exit delayed from previous errors
Copying homedir..../bin/gtar: ./public_ftp: Cannot savedir: Permission denied
/bin/gtar: Error exit delayed from previous errors
Copying homedir..../bin/gtar: ./public_ftp: Cannot savedir: Permission denied
/bin/gtar: Error exit delayed from previous errors
Copying homedir..../bin/gtar: ./public_ftp: Cannot savedir: Permission denied
/bin/gtar: Error exit delayed from previous errors
Copying homedir..../bin/gtar: ./public_ftp: Cannot savedir: Permission denied

[kamm]

That sounds a bit different to the errors I'm getting.

I was thinking the problem might be related to this entry in cpanel's recent changelog:

http://changelog.cpanel.net/

Edge 34170
2009-02-20 13:16:30

Fixes
/scripts/mysql now checks for proper datadir in /etc/my.cnf

My hosting company tells me they are going to submit a ticket to cpanel about the issue. Here's hoping!

[cPanelKenneth]

The mysqladmin entries in the cPanel error log are unrelated to the backup issues. The mysqladmin entries are generated by a reseller logging into a customer's cPanel account.

The change log entry regarding my.cnf is an issue peculiar to mysqlup and not backups.

cpbackup would always skip files and directories not accessible by the user. In the past we never captured the error output to log it. We recently began capturing such output so those issues can be rectified.

[kamm]

Thanks for the response...

The mysqladmin entries in the cPanel error log are unrelated to the backup issues. The mysqladmin entries are generated by a reseller logging into a customer's cPanel account.

This server doesn't have any reseller accounts. There is one error for each and every user appearing in the same sequence as cpanel backups. These errors are occurring every night. I'm not having any real database problems, so I guess these errors are false positives?

The thing that concerns me is that since the 20 Feb I've been receiving night email notifications that a backup has encountered errors. Last night's error was...

The backup of xxxxxx's account encountered errors
Please check /usr/local/cpanel/logs/error_log and /usr/local/cpanel/logs/cpbackup/123595xxxx.log for more information.

It seems to have been triggered here...
Copying homedir..../bin/gtar: ./public_ftp: Cannot savedir: Permission denied
/bin/gtar: Error exit delayed from previous errors
Notification => xxxxx@gmail.com via EMAIL [level => 2]

If I ignore these notifications how will I know when there is a real problem with backup?

[S-Combs]

We are have the same problem on one of our servers that was recently updated to 11.24.4-C34331.

Since once again the cPanel changelog for the Current tree hasn't been updated in a month. I can't see what may have changed to create this new problem.

Logs

/usr/local/cpanel/logs/error_log

2009-03-02 11:26:52 info [mysqladmin] Not updating privileges for cxxxxxed (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:28:02 info [mysqladmin] Not updating privileges for exxxxxas (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:38:13 info [mysqladmin] Not updating privileges for cxxxxxle (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:46:26 info [mysqladmin] Not updating privileges for mxxxxxse (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:49:02 info [mysqladmin] Not updating privileges for jxxxxxqu (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:51:40 info [mysqladmin] Not updating privileges for bxxxxxbe (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:52:32 info [mysqladmin] Not updating privileges for hxxxxxho (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:54:58 info [mysqladmin] Not updating privileges for cxxxxxyf (reseller login and no password specified in ~/.my.cnf)
2009-03-02 11:56:27 info [mysqladmin] Not updating privileges for wxxxxxhc (reseller login and no password specified in ~/.my.cnf)

[EDIT] None of these accounts are resellers [/EDIT]

/usr/local/cpanel/logs/cpbackup/1235992250.log
Shows many of the following errors from every account. These are mostly cache files from both CS-Cart and X-Cart scripts which we host many of.

Copying homedir....
/bin/gtar: ./public_html/var/compiled/cstempMC4jyU: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempsdiPEM: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempkyE8I9: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempy5Lo2J: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempOgJGrp: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemp5qf5SX: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemp4wFPCe: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempuxAtEU: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempEtJBi1: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemp2rp6z4: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempHOPSYh: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempILLGsQ: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempUJw2PY: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempExxnPV: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempJitMKR: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemp0qVOKn: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemphQdasj: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempueTsGU: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempCGI0XF: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemp0mEKXx: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempEQFBKX: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempIfsVxV: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemp0LnVxN: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempesCkZX: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempC94zVN: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempTz9TTH: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempMVk3s1: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempu7GwdS: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstemptjLPsM: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/cstempQlFgHR: Cannot open: Permission denied
/bin/gtar: Error exit delayed from previous errors

Copying homedir....
/bin/gtar: ./public_html/var/compiled/detailed_clones3RFn8: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_cloneyOudNJ: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_cloneIRByKY: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_clonekwjmrb: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_cloneMxhwRU: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_clonegSMBp5: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_clonecqgpyE: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneUOiu2G: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_clonemARIA2: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_clone0Gwu3q: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_clonewaBg1C: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_clonetVpk0C: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneeYpnq4: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneGsemNf: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneOrmP3t: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_clone0yXL8w: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneZt30du: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_clone0p5xIM: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_cloneqELfC7: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneMxJUwe: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_clonecmsUbo: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_clonekvIg69: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/image_cloneJY7UUL: Cannot open: Permission denied
/bin/gtar: ./public_html/var/compiled/detailed_cloneQdi3JP: Cannot open: Permission denied
/bin/gtar: Error exit delayed from previous errors

Copying homedir....
/bin/gtar: ./public_html/emailmarketer/admin/com/storage/session_files/sess_b478f07f105f5e853299311353b714d3: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpTpEiGM: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmplYA0px: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpwwXLOB: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpMcyVWL: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpVdFDog: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpkmYubP: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpDEKr7Y: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpL9caXM: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpPve3IM: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmppQGKoK: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp3CEiPt: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp9nsFhk: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpd6Eq68: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp6kM7lc: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpfYyZ0g: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpdTJApV: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp9SVgql: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpAzzMdD: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpEPahT4: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmptEUsK8: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpO7wAYk: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpD6fH0V: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpFjwM6f: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpRzZxwQ: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmplrJXE1: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpuc4S0P: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmptzSsuA: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp2qax2l: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpiBm822: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpVQfGJC: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp3TqVGA: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp1N78kW: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmp5dkV7H: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpTkETaV: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmppoFi5u: Cannot open: Permission denied
/bin/gtar: ./public_html/var/tmp/xctmpNxEePV: Cannot open: Permission denied
/bin/gtar: Error exit delayed from previous errors

[S-Combs]

Backup also seems to hang on many accounts while processing cpbackup-exclude.conf

lfd on xq41.cyberlnc.com: Excessive resource usage: cxxxxxro (24934)

Time:         Mon Mar  2 06:36:57 2009 -0600
Account:      cxxxxxro
Resource:     Process Time
Exceeded:     2405 > 2400 (seconds)
Executable:   /bin/tar
Command Line: /bin/gtar -c -f - -X /etc/cpbackup-exclude.conf .
PID:          24934
Killed:       No

[kamm]

For information my server is also running cPanel 11.24.4-C34331

[cPanelKenneth]

The "Cannot open: Permission denied" messages are from tar. In the past, these messages were never captured or logged. All files and directories that have such entries are skipped by tar ( and always have been ).

The "[mysqladmin] Not updating privileges for cxxxxxed" message may be due to the root user ( who is also a reseller ) accessing the databases for backup purposes. That should be easy to test and verify. Please remember these entries are not errors. They are informational only.

[vincentg]

What is the extracpus set at on your server?

I starting getting this message when it was changed to 15 on my server.

Cpanel set this to 15 due to this server getting this error.
While processing, the cpu has been
maxed out for more than a 6 hour period.

The server does not have a high load for more than 6 hours as the message stated but does go above 2 for a short time due to quota checking and backups.

I changed a second server to this setting of 15 and both servers come back with this Backup error:
Please check /usr/local/cpanel/logs/error_log

[vincentg]

ok - here's the problem - The backup is done as the cpanel user.

If you set the extracpus to 15 which seems to be what Cpanel recommends you will get these backup error messages.

From Cpanel:
These files and/or directories need to be readable by the cPanel user as gtar is run as the cPanel user and not as root.

Thus if files are saved by applications as the owner nobody - it does not get backed up unless it's readable by the Cpanel user!

This then requires all servers to install SuPHP which so far I found increases the server load.

What is the thoughts of others on this subject???

[rs-freddo]

Seems to be a cpanel bug. I don't change anything with the accounts and they backup fine the next night and it's someone elses' turn to not backup. Consistently 1 account per server has an error and it's a different one each night. I don't bother to try and find the problem as there is obviously no problem.

Just a FYI.

[kamm]

I'm dealing with this problem by using the cpbackup-exclude.conf file found in each user's account.

To exclude a directory such as...
cache

I'm using...
./public_html/cache

I also had to exclude some temporary files that were being created that looked like this...
tmpHzDg4A.pdf
tmpgd61iQ.pdf

To exclude them I'm using...
./public_html/pdf/tmp*.pdf

This strategy seems to be successful if not a little time consuming to implement.

It would be nice to see cPanel give non-SuPHP users a way to exclude files and directories globally.

Also, some people have said that this issue isn't a problem at all. I don't agree with that. Receiving error messages every night that user's backups are failing, is a problem in itself.

Cheers,
kamm...

[cPanelKenneth]

It would be nice to see cPanel give non-SuPHP users a way to exclude files and directories globally.

Such functionality does exist in the latest RELEASE, CURRENT and EDGE builds. The global exclude file is /etc/cpbackup-exclude.conf