vicidial.org

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

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


hi william

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

striker wrote: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.

its working now

thanks

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

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"

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

Sorry, I have no idea what you just asked.