backup script error

[striker]

hi

VERSION: 2.4-285 BUILD: 101022-1427 | vicibox_redux 3.0.6|digium card


whenever i run the backup script i got this error
/usr/share/astguiclient/ADMIN_backup.pl --db-only --debug

----- DEBUG -----


----- Backup Database Only -----

mysqldump: Got error: 1227: Access denied; you need the RELOAD privilege for this operation when doing refresh
/bin/tar: Removing leading `/' from member names


&
/usr/share/astguiclient/ADMIN_backup.pl --debug

----- DEBUG -----

mysqldump: Got error: 1227: Access denied; you need the RELOAD privilege for this operation when doing refresh
/bin/tar: Removing leading `/' from member names
/bin/tar: /etc/zaptel.conf: Cannot stat: No such file or directory
/bin/tar: Exiting with failure status due to previous errors
/bin/tar: Removing leading `/' from member names
/bin/tar: Removing leading `/' from member names
/bin/tar: Removing leading `/' from member names
/bin/tar: Removing leading `/' from member names
/bin/tar: Removing leading `/' from member names
/bin/tar: Removing leading `/' from member names
You have new mail in /var/mail/root

[williamconley]

from linux command line:

Code: Select all

mysql mysql --execute="UPDATE user SET Reload_priv = 'Y' WHERE user = 'cron'"
mysql mysql --execute="FLUSH PRIVILEGES;"


if you HAVE a mysql root password:

Code: Select all

mysql mysql --execute="UPDATE user SET Reload_priv = 'Y' WHERE user = 'cron'" -p
mysql mysql --execute="FLUSH PRIVILEGES;" -p


[striker]

hi william

what was the problem , and wat does the command u posted here

[williamconley]

mysqldump: Got error: 1227: Access denied; you need the RELOAD privilege for this operation when doing refresh

I'm thinkin' ... the problem was the you NEED reload, the code i posted GIVES reload.

[striker]

its working now

thanks

[ruben23]

hi guys how about this log error on my admin-backup script

i got 1 asterisk/vicidial and 1 database server
scratch install/ 2.4 SVN

i run the script on teh asterisk/vicidial server adn i get this debug error:

Code: Select all

   1.
      root@dialer4:/usr/share/astguiclient# /usr/share/astguiclient/ADMIN_backup.pl --db-only --debugX
   2.
       
   3.
      ----- DEBUG -----
   4.
       
   5.
       
   6.
      ----- SUPER DEBUG -----
   7.
       
   8.
       
   9.
      ----- Backup Database Only -----
  10.
       
  11.
      /usr/bin/mysqldump --user=cron --password=1234 --lock-tables --flush-logs asterisk | /bin/gzip > /var/log/astguiclient/archive/temp/172.16.0.35asterisk2.gz
  12.
      mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
  13.
      /bin/tar cf /var/log/astguiclient/archive/172.16.0.35_ALL_2.tar /var/log/astguiclient/archive/temp
  14.
      /bin/tar: Removing leading `/' from member names
  15.
      rm -f /var/log/astguiclient/archive/172.16.0.35_ALL_2.tar.gz
  16.
      /bin/gzip -9 /var/log/astguiclient/archive/172.16.0.35_ALL_2.tar
  17.
      rm -fR /var/log/astguiclient/archive/temp
  18.
      DONE, Exiting...


any idea guys what went wrong

[williamconley]

you really should have started a new thread for this.

is mysql running?

try running the command that failed manually (as root of course) and see if it works.

PS I'm gonna move this to "support"

[ruben23]

hi what should be the case when i got separate Databased with asterisk/vicidial;

How should i do teh backup withy databsd and where should we run the backup script, any idea guys..?

one for databsed and one for asterisk/vici..? or

should we run it all on asterisk/vicidial

[williamconley]

Sorry, I have no idea what you just asked.