vicidial.org

Hello i have this error when made the db backup. I saw in this post but the solution remount to 2013

viewtopic.php?f=4&t=28344&p=108315&hilit=mysqldump%3A+Got+error%3A+1105%3A+Unknown+error+when+doing+refresh#p108315

mysqldump: Got error: 1105: "Unknown error" when doing refresh

perl /usr/share/astguiclient/ADMIN_backup.pl --db-only --debugX

----- DEBUG -----


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


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


----- Mysql dump -----

DBX- starting to backup database 0: asterisk
/usr/bin/mysqldump --user=cron --password=1234 --lock-tables --flush-logs asterisk | /usr/bin/gzip > /var/log/astguiclient/archive/temp/192.168.192.133asterisk3.gz
mysqldump: Got error: 1105: "Unknown error" when doing refresh
/usr/bin/tar cf /var/log/astguiclient/archive/192.168.192.133_ALL_3.tar /var/log/astguiclient/archive/temp
/usr/bin/tar: Removing leading `/' from member names
rm -f /var/log/astguiclient/archive/192.168.192.133_ALL_3.tar.gz
/usr/bin/gzip -9 /var/log/astguiclient/archive/192.168.192.133_ALL_3.tar
rm -fR /var/log/astguiclient/archive/temp
script execution time in seconds: 0 minutes: 0
DONE, Exiting...


CentOS Linux 7 (Core) || Linux 3.10.0-1160.25.1.el7.x86_64 || Asterisk 13.21.0-vici || 2.14b0.5 || mysql Ver 15.1 Distrib 5.5.68-MariaDB

try a db repair first

carpenox wrote:try a db repair first

Done but now I have this error

/usr/bin/mysqldump --user=cron --password=password --lock-tables --flush-logs asterisk | /usr/bin/gzip > /usr/src/astguiclient//temp/10.20.13.31asterisk6.gz
mysqldump: Got error: 1045: "Access denied for user 'cron'@'localhost' (using password: YES)" when trying to connect

I made some modifications to test manually and with ' ' in the --password parameter and work fine but from Perl script not
/usr/bin/mysqldump --user=cron --password='password' --lock-tables --flush-logs asterisk | /usr/bin/gzip > /usr/src/astguiclient/10.20.13.31asterisk6.gz


perl ADMIN_backup.pl --archive_path=/usr/src/astguiclient/ --without-web --without-sounds--without-voicemail --debugX

----- DEBUG -----


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


----- No Sounds Backup -----


----- No web files Backup -----


----- No voicemail files Backup -----


----- Archive path set to /usr/src/astguiclient/ -----


----- Mysql dump -----

DBX- starting to backup database 0: asterisk
/usr/bin/mysqldump --user=cron --password=S4turn0$$22 --lock-tables --flush-logs asterisk | /usr/bin/gzip > /usr/src/astguiclient//temp/10.20.13.31asterisk6.gz
mysqldump: Got error: 1045: "Access denied for user 'cron'@'localhost' (using password: YES)" when trying to connect
/usr/bin/tar cf /usr/src/astguiclient//temp/10.20.13.31_CONF_6.tar /etc/astguiclient.conf /etc/asterisk
/usr/bin/tar: Eliminando la `/' inicial de los nombres
/usr/bin/tar cf /usr/src/astguiclient//temp/10.20.13.31_LINUX_6.tar /etc/my.cnf /etc/crontab_snapshot /etc/hosts /etc/rc.d/rc.local /etc/resolv.conf
/usr/bin/tar: Eliminando la `/' inicial de los nombres
/usr/bin/tar cf /usr/src/astguiclient//temp/10.20.13.31_BIN_6.tar /var/lib/asterisk/agi-bin /usr/share/astguiclient
/usr/bin/tar: Eliminando la `/' inicial de los nombres
/usr/bin/tar cf /usr/src/astguiclient//10.20.13.31_ALL_6.tar /usr/src/astguiclient//temp
/usr/bin/tar: Eliminando la `/' inicial de los nombres
rm -f /usr/src/astguiclient//10.20.13.31_ALL_6.tar.gz
/usr/bin/gzip -9 /usr/src/astguiclient//10.20.13.31_ALL_6.tar
rm -fR /usr/src/astguiclient//temp
script execution time in seconds: 1 minutes: 0.0166666666666667
DONE, Exiting...

it seems as if your cron user does not have a password with that response but that doesnt make sense, there is definitely something off with your DB, try runningit as a root user