Project

General

Profile

Bug #703

Backup Does not work after upgrade from 2.1 to 3.0

Added by Greg Williams about 5 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
Immediate
Assignee:
-
Category:
-
Target version:
-
Start date:
06/03/2013
Due date:
% Done:

100%

Estimated time:

Description

Get the following error during backup after upgrading from 2.1 to 3.0

[root@go astguiclient]# perl ./ADMIN_backup.pl --debugx

----- DEBUG -----

----- SUPER DEBUG -----

mkdir: cannot create directory `/var/log/astguiclient/archive/temp': File exists
/usr/bin/mysqldump --user=cron --password=1234 --lock-tables --flush-logs asterisk | /usr/bin/gzip > /var/log/astguiclient/archive/temp/192.168.43.202asterisk1.gz
mysqldump: Couldn't execute 'show create table `go_viewLists`': SHOW VIEW command denied to user 'cron'@'localhost' for table 'go_viewLists' (1142)
/bin/tar cf /var/log/astguiclient/archive/temp/192.168.43.202_CONF_1.tar /etc/astguiclient.conf /etc/zaptel.conf /etc/dahdi /etc/asterisk
/bin/tar: Removing leading `/' from member names
/bin/tar cf /var/log/astguiclient/archive/temp/192.168.43.202_LINUX_1.tar /etc/my.cnf /etc/crontab_snapshot /etc/hosts /etc/rc.d/rc.local /etc/resolv.conf
/bin/tar: Removing leading `/' from member names
/bin/tar cf /var/log/astguiclient/archive/temp/192.168.43.202_WEB_1.tar /var/www/html
/bin/tar: Removing leading `/' from member names
/bin/tar cf /var/log/astguiclient/archive/temp/192.168.43.202_BIN_1.tar /var/lib/asterisk/agi-bin /usr/share/astguiclient
/bin/tar: Removing leading `/' from member names
/bin/tar cf /var/log/astguiclient/archive/temp/192.168.43.202_SOUNDS_1.tar /var/lib/asterisk/sounds
/bin/tar: Removing leading `/' from member names
/bin/tar cf /var/log/astguiclient/archive/temp/192.168.43.202_VOICEMAIL_1.tar /var/spool/asterisk/voicemail
/bin/tar: Removing leading `/' from member names
/bin/tar cf /var/log/astguiclient/archive/192.168.43.202_ALL_1.tar /var/log/astguiclient/archive/temp
/bin/tar: Removing leading `/' from member names
rm -f /var/log/astguiclient/archive/192.168.43.202_ALL_1.tar.gz
/usr/bin/gzip -9 /var/log/astguiclient/archive/192.168.43.202_ALL_1.tar
rm -fR /var/log/astguiclient/archive/temp
DONE, Exiting...
You have new mail in /var/spool/mail/root

User Cron does not have enough privileges to view table, resolved by increasing user level but obviously creates a security issue.

History

#1 Updated by Erwin De Luna about 5 years ago

Hi Greg,

You must use your root mysql credentials to make those scripts functional.

Regards,
GoAutoDial Team

#2 Updated by Greg Williams about 5 years ago

Erwin De Luna wrote:

Hi Greg,

You must use your root mysql credentials to make those scripts functional.

Regards,
GoAutoDial Team

Agreed, however this script defaults to the cron user. This should be changed

#3 Updated by Demian Biscocho about 5 years ago

  • Status changed from New to Feedback
  • % Done changed from 0 to 100

Thank you for pointing this out. Looks like CRON doesn't have enough permissions on the additional tables created. This can be fixed by giving user CRON show view privileges.

#mysql -pvicidialnow asterisk;
mysql> GRANT SHOW VIEW ON `asterisk` . * TO 'cron'@'localhost' IDENTIFIED BY '1234';
mysql> GRANT SHOW VIEW ON `asterisk` . * TO 'cron'@'%' IDENTIFIED BY '1234';

Let us know how it goes.

#4 Updated by Greg Williams about 5 years ago

Demian Biscocho wrote:

Thank you for pointing this out. Looks like CRON doesn't have enough permissions on the additional tables created. This can be fixed by giving user CRON show view privileges.

[...]

Let us know how it goes.

Works fine. Thank you

#5 Updated by Demian Biscocho about 5 years ago

  • Status changed from Feedback to Closed

Updates has been posted in our repo. To update system run:

#yum update

Also available in: Atom PDF

Go to top