I’ve just noticed that the backup/restore module does not seem to be backing up and restoring the CDR DB to my secondary backup pbx. - Yes I have it in the list to be backed up.
Can anyone confirm? - Just incase its something i’m doing wrong.
THanks
I created another backup job that just does the CDR data and set it to ‘Daily’. It ran at midnight last night and failed with the output below. If I run the job manually it manages to export the DB but it does not import it to the secondary server as per my first post.
Intializing Backup 4
Connecting to remote server…
Prossesing received file…
Storing backup…
Running post-backup hooks…
Restoring backup…
[FATAL] a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-
4”;s:4:“name”;s:11:“CDR Reports”;s:5:“ctime”;i:1332802801;s:5:“hooks”;a:4:{s:10:“pre_backup”;s:0:"";s:11:“post_backup”;s:0:"";s:11:“pre_restore”;s:0:"";s:
12:“post_restore”;s:0:"";}s:21:“pbx_framework_version”;s:8:“2.10.0.2”;s:14:“back
up_version”;s:9:“2.10.0.23”;s:11:“pbx_version”;s:6:“2.10.0”;s:9:“file_list”;a:0:
{}s:5:“mysql”;a:1:{i:4;a:6:{s:4:“file”;s:11:“mysql-4.sql”;s:4:“host”;s:9:“localhost”;s:4:“port”;s:4:“3306”;s:4:“name”;s:10:“CDR
server”;s:6:“dbname”;s:13:“asteriskcdrdb”;s:7:“exclude”;a:1:{i:0;s:0:"";}}}s:5:“astdb”;s:0:"";s:8:“hostname”;s:5:“voip1”;s:10:“file_count”;i:0;s:11:“mysql_count”;i:1;s:11:“astdb_count”;i:0;s:5:“ftime”;i:1332802802;}
DROP TABLE IF EXISTS cdr; [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-4”;s:4:“name”;s:11:"CDR ’ at line 1]
Trace Back:
: die_freepbx()
[0]: a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-4”;s:4:“name”;s:11:“CDR Reports”;s:5:“ctime”;i:1332802801;s:5:“hooks”;a:4:{s:10:“pre_backup”;s:0:"";s:11:“post_backup”;s:0:"";s:11:“pre_restore”;s:0:"";s:12:“post_restore”;s:0:"";}s:21:“pbx_framework_version”;s:8:“2.10.0.2”;s:14:“backup_version”;s:9:“2.10.0.23”;s:11:“pbx_version”;s:6:“2.10.0”;s:9:“file_list”;a:0:{}s:5:“mysql”;a:1:{i:4;a:6:{s:4:“file”;s:11:“mysql-4.sql”;s:4:“host”;s:9:“localhost”;s:4:“port”;s:4:“3306”;s:4:“name”;s:10:“CDR server”;s:6:“dbname”;s:13:“asteriskcdrdb”;s:7:“exclude”;a:1:{i:0;s:0:"";}}}s:5:“astdb”;s:0:"";s:8:“hostname”;s:5:“voip1”;s:10:“file_count”;i:0;s:11:“mysql_count”;i:1;s:11:“astdb_count”;i:0;s:5:“ftime”;i:1332802802;}
DROP TABLE IF EXISTS cdr; [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-4”;s:4:“name”;s:11:"CDR ’ at line 1]
/var/www/html/admin/libraries/sql.functions.php:116 call_user_func()
[0]: die_freepbx
[1]: a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-4”;s:4:“name”;s:11:“CDR Reports”;s:5:“ctime”;i:1332802801;s:5:“hooks”;a:4:{s:10:“pre_backup”;s:0:"";s:11:“post_backup”;s:0:"";s:11:“pre_restore”;s:0:"";s:12:“post_restore”;s:0:"";}s:21:“pbx_framework_version”;s:8:“2.10.0.2”;s:14:“backup_version”;s:9:“2.10.0.23”;s:11:“pbx_version”;s:6:“2.10.0”;s:9:“file_list”;a:0:{}s:5:“mysql”;a:1:{i:4;a:6:{s:4:“file”;s:11:“mysql-4.sql”;s:4:“host”;s:9:“localhost”;s:4:“port”;s:4:“3306”;s:4:“name”;s:10:“CDR server”;s:6:“dbname”;s:13:“asteriskcdrdb”;s:7:“exclude”;a:1:{i:0;s:0:"";}}}s:5:“astdb”;s:0:"";s:8:“hostname”;s:5:“voip1”;s:10:“file_count”;i:0;s:11:“mysql_count”;i:1;s:11:“astdb_count”;i:0;s:5:“ftime”;i:1332802802;}
DROP TABLE IF EXISTS cdr; [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-4”;s:4:“name”;s:11:"CDR ’ at line 1]
/var/www/html/admin/modules/backup/functions.inc/restore.php:577 db_e()
[0]:
/var/www/html/admin/modules/backup/bin/backup.php:118 backup_restore()
[0]: /var/spool/asterisk/tmp/20120327-000001-1332802801-1254038384.tgz
[1]: