Hi,
I’m running 2.10 and I cannot seem to get my backups to restore. After selecting a backup the GUI interface goes to a blank screen, nothing restores.
Can you paste the output of from your apache log?
You are looking at this already. View Ticket: #20843
I’m having the same issue, nothing happens when I go to restore a backup.
I can’t find ticket 20843 http://www.freepbx.org/trac/ticket/20843
Ah thanks Bryan,
I was thinking where or where might the logs be for the restore.
So it looks like the main problem I have is that it can’t open amportal.conf (I think) The backup didn’t include voicemails or the fop so no surprise they weren’t found. I’m sure
/tmp/ampbackups.20120408.00.00.01/voicemail.tar.gz
/tmp/ampbackups.20120408.00.00.01/recordings.tar.gz
/tmp/ampbackups.20120408.00.00.01/configurations.tar.gz
/bin/tar: /etc/amportal.conf: Cannot open: File exists
/bin/tar: Error exit delayed from previous errors
/bin/tar: /tmp/ampbackups.20120408.00.00.01/fop.tar.gz: Not found in archive
/bin/tar: /tmp/ampbackups.20120408.00.00.01/cdr.tar.gz: Not found in archive
/bin/tar: Error exit delayed from previous errors
gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
/bin/tar: /tmp/ampbackups.20120408.00.00.01/asteriskcdr.sql: Not found in archive
/bin/tar: Error exit delayed from previous errors
sh: /tmp/ampbackups.20120408.00.00.01/asteriskcdr.sql: No such file or directory
/bin/tar: /tmp/ampbackups.20120408.00.00.01/phoneconfig.tar.gz: Not found in archive
/bin/tar: Error exit delayed from previous errors
gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
Hmm http://www.freepbx.org/trac/ticket/2735 seems to be the same issue from 2008. I’d rather not open up my entire /etc directory is there something else I can do? I guess I could move amportal.conf into a subdirectory is there anything else out there?
I install FreePBX and i get a CloneZilla Image of the hard Disk.
I setup (extensions, trunks, inbound, outbound etc) my freePBX 4.211.64.5-1 (Asterisk v1.8) pc and i do a “full backup” from backup & restore module.
If i restore the FreePBX system (using the clonezilla image file) to “clean” no-settings state and i copy the backup file to /var/spool/asterisk/backup folder and i try to Restore the backup (from local storage (local) on the right-hand side menu) i get the following errors and at the extensions,trunks etc tabs i get no settings…
Intialized!!
Intializing Restore…
Running pre-restore hooks, if any…
Restoring settings…
Getting Settings size…
[FATAL] a:16:{s:7:“fpbx_db”;s:0:"";s:10:“fpbx_cdrdb”;s:7:“mysql-4”;s:4:“name”;s:7:“kinglyr”;s:5:“ctime”;i:1378335029;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:9:“2.11.0.10”;s:14:“backup_version”;s:8:“2.11.0.0”;s:11:“pbx_version”;s:6:“2.11.0”;s:9:“file_list”;a:2:{s:3:“etc”;a:3:{s:8:“asterisk”;a:116:{i:0;s:13:“asterisk.conf”;i:1;s:9:“ccss.conf”;i:2;s:28:“ccss_general_additional.conf”;i:3;s:24:“ccss_general_custom.conf”;i:4;s:8:“cdr.conf”;i:5;s:14:“cdr_mysql.conf”;i:6;s:18:“cdr_mysql.conf.bak”;i:7;s:8:“cel.conf”;i:8;s:20:“cel_custom_post.conf”;i:9;s:27:“cel_general_additional.conf”;i:10;s:23:“cel_general_custom.conf”;i:11;s:13:“cel_odbc.conf”;i:12;s:20:“cel_odbc_custom.conf”;i:13;s:15:“chan_dahdi.conf”;i:14;s:19:“chan_dahdi.conf.old”;i:15;s:24:“chan_dahdi.conf.template”;i:16;s:26:“chan_dahdi_additional.conf”;i:17;s:31:“chan_dahdi_channels_custom.conf”;i:18;s:23:“chan_dahdi_general.conf”;i:19;s:30:“chan_dahdi_general_custom.conf”;i:20;s:22:“chan_dahdi_groups.conf”;i:21;s:11:“codecs.conf”;i:22;s:15:“confbridge.conf”;i:23;s:26:“confbridge_additional.conf”;i:24;s:22:“confbridge_custom.conf”;i:25;s:19:“dahdi-channels.conf”;i:26;s:23:“dahdi-channels.conf.bak”;s:12:“directorypro”;a:1:{i:0;s:10:“yesno.gram”;}i:27;s:11:“dnsmgr.conf”;i:28;s:9:“enum.conf”;i:29;s:15:“extensions.conf”;i:30;s:26:“extensions_additional.conf”;i:31;s:22:“extensions_custom.conf”;i:32;s:29:“extensions_custom.conf.sample”;i:33;s:32:“extensions_override_freepbx.conf”;i:34;s:13:“features.conf”;i:35;s:39:“features_applicationmap_additional.conf”;i:36;s:35:“features_applicationmap_custom.conf”;i:37;s:35:“features_featuremap_additional.conf”;i:38;s:31:“features_featuremap_custom.conf”;i:39;s:32:“features_general_additional.conf”;i:40;s:28:“features_general_custom.conf”;i:41;s:34:“freepbx_featurecodes.conf.template”;i:42;s:26:“freepbx_menu.conf.template”;i:43;s:25:“freepbx_module_admin.conf”;i:44;s:19:“globals_custom.conf”;i:45;s:8:“iax.conf”;i:46;s:19:“iax_additional.conf”;i:47;s:15:“iax_custom.conf”;i:48;s:20:“iax_custom_post.conf”;i:49;s:27:“iax_general_additional.conf”;i:50;s:23:“iax_general_custom.conf”;i:51;s:22:“iax_registrations.conf”;i:52;s:29:“iax_registrations_custom.conf”;i:53;s:16:“indications.conf”;s:6:“ivrpro”;a:1:{i:0;s:10:“yesno.gram”;}i:54;s:18:“localprefixes.conf”;i:55;s:11:“logger.conf”;i:56;s:30:“logger_general_additional.conf”;i:57;s:26:“logger_general_custom.conf”;i:58;s:31:“logger_logfiles_additional.conf”;i:59;s:27:“logger_logfiles_custom.conf”;i:60;s:12:“manager.conf”;i:61;s:16:“manager.conf.bak”;i:62;s:23:“manager_additional.conf”;i:63;s:19:“manager_custom.conf”;i:64;s:11:“meetme.conf”;i:65;s:22:“meetme_additional.conf”;i:66;s:10:“modem.conf”;i:67;s:12:“modules.conf”;i:68;s:24:“modules.conf.2.8.0-1.bak”;i:69;s:16:“musiconhold.conf”;i:70;s:27:“musiconhold_additional.conf”;i:71;s:23:“musiconhold_custom.conf”;i:72;s:10:“phone.conf”;i:73;s:11:“phpagi.conf”;i:74;s:12:“privacy.conf”;i:75;s:15:“queuerules.conf”;i:76;s:26:“queuerules_additional.conf”;i:77;s:22:“queuerules_custom.conf”;i:78;s:11:“queues.conf”;i:79;s:22:“queues_additional.conf”;i:80;s:18:“queues_custom.conf”;i:81;s:26:“queues_custom_general.conf”;i:82;s:30:“queues_general_additional.conf”;i:83;s:23:“queues_post_custom.conf”;i:84;s:12:“res_fax.conf”;i:85;s:19:“res_fax_custom.conf”;i:86;s:19:“res_fax_digium.conf”;i:87;s:26:“res_fax_digium_custom.conf”;i:88;s:13:“res_odbc.conf”;i:89;s:24:“res_odbc_additional.conf”;i:90;s:20:“res_odbc_custom.conf”;i:91;s:21:“res_stun_monitor.conf”;i:92;s:8:“rtp.conf”;i:93;s:19:“rtp_additional.conf”;i:94;s:15:“rtp_custom.conf”;i:95;s:8:“sip.conf”;i:96;s:19:“sip_additional.conf”;i:97;s:15:“sip_custom.conf”;i:98;s:20:“sip_custom_post.conf”;i:99;s:27:“sip_general_additional.conf”;i:100;s:23:“sip_general_custom.conf”;i:101;s:12:“sip_nat.conf”;i:102;s:15:“sip_notify.conf”;i:103;s:26:“sip_notify_additional.conf”;i:104;s:22:“sip_notify_custom.conf”;i:105;s:27:“sip_notify_endpointman.conf”;i:106;s:22:“sip_registrations.conf”;i:107;s:29:“sip_registrations_custom.conf”;i:108;s:7:“version”;i:109;s:12:“vm_email.inc”;i:110;s:14:“vm_general.inc”;i:111;s:14:“voicemail.conf”;i:112;s:23:“voicemail.conf.template”;i:113;s:20:“zapata.conf.template”;}s:5:“dahdi”;a:5:{i:0;s:18:“genconf_parameters”;i:1;s:9:“init.conf”;i:2;s:7:“modules”;i:3;s:11:“system.conf”;i:4;s:15:“system.conf.bak”;}i:0;s:12:“freepbx.conf”;}s:3:“var”;a:1:{s:3:“lib”;a:1:{s:8:“asterisk”;a:1:{s:3:“bin”;a:33:{i:0;s:18:“archive_recordings”;i:1;s:14:“audio-email.pl”;i:2;s:10:“backup.php”;i:3;s:8:“callback”;i:4;s:20:“callerid_updater.php”;s:3:“enc”;a:1:{i:0;s:17:“faxpro_helper.php”;}i:5;s:21:“endpoint_firmware.php”;i:6;s:12:“fax2mail.php”;i:7;s:17:“faxpro_helper.php”;i:8;s:26:“freepbx-cron-scheduler.php”;i:9;s:14:“freepbx_engine”;i:10;s:31:“freepbx_engine_hook_dahdiconfig”;i:11;s:28:“freepbx_engine_hook_endpoint”;i:12;s:31:“freepbx_engine_hook_endpointman”;i:13;s:29:“freepbx_engine_hook_pagingpro”;i:14;s:28:“freepbx_engine_hook_sysadmin”;i:15;s:24:“freepbx_engine_hook_xmpp”;i:16;s:15:“freepbx_setting”;i:17;s:16:“gen_amp_conf.php”;i:18;s:18:“generate_hints.php”;i:19;s:24:“generate_queue_hints.php”;i:20;s:22:“libfreepbx.confgen.php”;i:21;s:12:“module_admin”;i:22;s:20:“one_touch_record.php”;i:23;s:18:“opencnam-alert.php”;i:24;s:21:“pagepro-scheduler.php”;i:25;s:19:“pagepro-startup.php”;i:26;s:21:“queue_reset_stats.php”;i:27;s:11:“restore.php”;i:28;s:13:“retrieve_conf”;i:29;s:31:“retrieve_parse_amportal_conf.pl”;i:30;s:11:“schedtc.php”;i:31;s:11:“storage.php”;}}}}}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:0:{}}}s:5:“astdb”;s:5:“astdb”;s:8:“hostname”;s:20:“elastix.kinglyr.awmn”;s:10:“file_count”;i:165;s:11:“mysql_count”;i:1;s:11:“astdb_count”;i:1;s:5:“ftime”;i:1378335030;}
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:7:"kingl’ 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:7:“kinglyr”;s:5:“ctime”;i:1378335029;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:9:“2.11.0.10”;s:14:“backup_version”;s:8:“2.11.0.0”;s:11:“pbx_version”;s:6:“2.11.0”;s:9:“file_list”;a:2:{s:3:“etc”;a:3:{s:8:“asterisk”;a:116:{i:0;s:13:“asterisk.conf”;i:1;s:9:“ccss.conf”;i:2;s:28:“ccss_general_additional.conf”;i:3;s:24:“ccss_general_custom.conf”;i:4;s:8:“cdr.conf”;i:5;s:14:“cdr_mysql.conf”;i:6;s:18:“cdr_mysql.conf.bak”;i:7;s:8:“cel.conf”;i:8;s:20:“cel_custom_post.conf”;i:9;s:27:“cel_general_additional.conf”;i:10;s:23:“cel_general_custom.conf”;i:11;s:13:“cel_odbc.conf”;i:12;s:20:“cel_odbc_custom.conf”;i:13;s:15:“chan_dahdi.conf”;i:14;s:19:“chan_dahdi.conf.old”;i:15;s:24:“chan_dahdi.conf.template”;i:16;s:26:“chan_dahdi_additional.conf”;i:17;s:31:“chan_dahdi_channels_custom.conf”;i:18;s:23:“chan_dahdi_general.conf”;i:19;s:30:“chan_dahdi_general_custom.conf”;i:20;s:22:“chan_dahdi_groups.conf”;i:21;s:11:“codecs.conf”;i:22;s:15:“confbridge.conf”;i:23;s:26:“confbridge_additional.conf”;i:24;s:22:“confbridge_custom.conf”;i:25;s:19:“dahdi-channels.conf”;i:26;s:23:“dahdi-channels.conf.bak”;s:12:“directorypro”;a:1:{i:0;s:10:“yesno.gram”;}i:27;s:11:“dnsmgr.conf”;i:28;s:9:“enum.conf”;i:29;s:15:“extensions.conf”;i:30;s:26:“extensions_additional.conf”;i:31;s:22:“extensions_custom.conf”;i:32;s:29:“extensions_custom.conf.sample”;i:33;s:32:“extensions_override_freepbx.conf”;i:34;s:13:“features.conf”;i:35;s:39:“features_applicationmap_additional.conf”;i:36;s:35:“features_applicationmap_custom.conf”;i:37;s:35:“features_featuremap_additional.conf”;i:38;s:31:“features_featuremap_custom.conf”;i:39;s:32:“features_general_additional.conf”;i:40;s:28:“features_general_custom.conf”;i:41;s:34:“freepbx_featurecodes.conf.template”;i:42;s:26:“freepbx_menu.conf.template”;i:43;s:25:“freepbx_module_admin.conf”;i:44;s:19:“globals_custom.conf”;i:45;s:8:“iax.conf”;i:46;s:19:“iax_additional.conf”;i:47;s:15:“iax_custom.conf”;i:48;s:20:“iax_custom_post.conf”;i:49;s:27:“iax_general_additional.conf”;i:50;s:23:“iax_general_custom.conf”;i:51;s:22:“iax_registrations.conf”;i:52;s:29:“iax_registrations_custom.conf”;i:53;s:16:“indications.conf”;s:6:“ivrpro”;a:1:{i:0;s:10:“yesno.gram”;}i:54;s:18:“localprefixes.conf”;i:55;s:11:“logger.conf”;i:56;s:30:“logger_general_additional.conf”;i:57;s:26:“logger_general_custom.conf”;i:58;s:31:“logger_logfiles_additional.conf”;i:59;s:27:“logger_logfiles_custom.conf”;i:60;s:12:“manager.conf”;i:61;s:16:“manager.conf.bak”;i:62;s:23:“manager_additional.conf”;i:63;s:19:“manager_custom.conf”;i:64;s:11:“meetme.conf”;i:65;s:22:“meetme_additional.conf”;i:66;s:10:“modem.conf”;i:67;s:12:“modules.conf”;i:68;s:24:“modules.conf.2.8.0-1.bak”;i:69;s:16:“musiconhold.conf”;i:70;s:27:“musiconhold_additional.conf”;i:71;s:23:“musiconhold_custom.conf”;i:72;s:10:“phone.conf”;i:73;s:11:“phpagi.conf”;i:74;s:12:“privacy.conf”;i:75;s:15:“queuerules.conf”;i:76;s:26:“queuerules_additional.conf”;i:77;s:22:“queuerules_custom.conf”;i:78;s:11:“queues.conf”;i:79;s:22:“queues_additional.conf”;i:80;s:18:“queues_custom.conf”;i:81;s:26:“queues_custom_general.conf”;i:82;s:30:“queues_general_additional.conf”;i:83;s:23:“queues_post_custom.conf”;i:84;s:12:“res_fax.conf”;i:85;s:19:“res_fax_custom.conf”;i:86;s:19:“res_fax_digium.conf”;i:87;s:26:“res_fax_digium_custom.conf”;i:88;s:13:“res_odbc.conf”;i:89;s:24:“res_odbc_additional.conf”;i:90;s:20:“res_odbc_custom.conf”;i:91;s:21:“res_stun_monitor.conf”;i:92;s:8:“rtp.conf”;i:93;s:19:“rtp_additional.conf”;i:94;s:15:“rtp_custom.conf”;i:95;s:8:“sip.conf”;i:96;s:19:“sip_additional.conf”;i:97;s:15:“sip_custom.conf”;i:98;s:20:“sip_custom_post.conf”;i:99;s:27:“sip_general_additional.conf”;i:100;s:23:“sip_general_custom.conf”;i:101;s:12:“sip_nat.conf”;i:102;s:15:“sip_notify.conf”;i:103;s:26:“sip_notify_additional.conf”;i:104;s:22:“sip_notify_custom.conf”;i:105;s:27:“sip_notify_endpointman.conf”;i:106;s:22:“sip_registrations.conf”;i:107;s:29:“sip_registrations_custom.conf”;i:108;s:7:“version”;i:109;s:12:“vm_email.inc”;i:110;s:14:“vm_general.inc”;i:111;s:14:“voicemail.conf”;i:112;s:23:“voicemail.conf.template”;i:113;s:20:“zapata.conf.template”;}s:5:“dahdi”;a:5:{i:0;s:18:“genconf_parameters”;i:1;s:9:“init.conf”;i:2;s:7:“modules”;i:3;s:11:“system.conf”;i:4;s:15:“system.conf.bak”;}i:0;s:12:“freepbx.conf”;}s:3:“var”;a:1:{s:3:“lib”;a:1:{s:8:“asterisk”;a:1:{s:3:“bin”;a:33:{i:0;s:18:“archive_recordings”;i:1;s:14:“audio-email.pl”;i:2;s:10:“backup.php”;i:3;s:8:“callback”;i:4;s:20:“callerid_updater.php”;s:3:“enc”;a:1:{i:0;s:17:“faxpro_helper.php”;}i:5;s:21:“endpoint_firmware.php”;i:6;s:12:“fax2mail.php”;i:7;s:17:“faxpro_helper.php”;i:8;s:26:“freepbx-cron-scheduler.php”;i:9;s:14:“freepbx_engine”;i:10;s:31:“freepbx_engine_hook_dahdiconfig”;i:11;s:28:“freepbx_engine_hook_endpoint”;i:12;s:31:“freepbx_engine_hook_endpointman”;i:13;s:29:“freepbx_engine_hook_pagingpro”;i:14;s:28:“freepbx_engine_hook_sysadmin”;i:15;s:24:“freepbx_engine_hook_xmpp”;i:16;s:15:“freepbx_setting”;i:17;s:16:“gen_amp_conf.php”;i:18;s:18:“generate_hints.php”;i:19;s:24:“generate_queue_hints.php”;i:20;s:22:“libfreepbx.confgen.php”;i:21;s:12:“module_admin”;i:22;s:20:“one_touch_record.php”;i:23;s:18:“opencnam-alert.php”;i:24;s:21:“pagepro-scheduler.php”;i:25;s:19:“pagepro-startup.php”;i:26;s:21:“queue_reset_stats.php”;i:27;s:11:“restore.php”;i:28;s:13:“retrieve_conf”;i:29;s:31:“retrieve_parse_amportal_conf.pl”;i:30;s:11:“schedtc.php”;i:31;s:11:“storage.php”;}}}}}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:0:{}}}s:5:“astdb”;s:5:“astdb”;s:8:“hostname”;s:20:“elastix.kinglyr.awmn”;s:10:“file_count”;i:165;s:11:“mysql_count”;i:1;s:11:“astdb_count”;i:1;s:5:“ftime”;i:1378335030;}
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:7:"kingl’ at line 1]
/var/www/html/admin/libraries/sql.functions.php:130 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:7:“kinglyr”;s:5:“ctime”;i:1378335029;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:9:“2.11.0.10”;s:14:“backup_version”;s:8:“2.11.0.0”;s:11:“pbx_version”;s:6:“2.11.0”;s:9:“file_list”;a:2:{s:3:“etc”;a:3:{s:8:“asterisk”;a:116:{i:0;s:13:“asterisk.conf”;i:1;s:9:“ccss.conf”;i:2;s:28:“ccss_general_additional.conf”;i:3;s:24:“ccss_general_custom.conf”;i:4;s:8:“cdr.conf”;i:5;s:14:“cdr_mysql.conf”;i:6;s:18:“cdr_mysql.conf.bak”;i:7;s:8:“cel.conf”;i:8;s:20:“cel_custom_post.conf”;i:9;s:27:“cel_general_additional.conf”;i:10;s:23:“cel_general_custom.conf”;i:11;s:13:“cel_odbc.conf”;i:12;s:20:“cel_odbc_custom.conf”;i:13;s:15:“chan_dahdi.conf”;i:14;s:19:“chan_dahdi.conf.old”;i:15;s:24:“chan_dahdi.conf.template”;i:16;s:26:“chan_dahdi_additional.conf”;i:17;s:31:“chan_dahdi_channels_custom.conf”;i:18;s:23:“chan_dahdi_general.conf”;i:19;s:30:“chan_dahdi_general_custom.conf”;i:20;s:22:“chan_dahdi_groups.conf”;i:21;s:11:“codecs.conf”;i:22;s:15:“confbridge.conf”;i:23;s:26:“confbridge_additional.conf”;i:24;s:22:“confbridge_custom.conf”;i:25;s:19:“dahdi-channels.conf”;i:26;s:23:“dahdi-channels.conf.bak”;s:12:“directorypro”;a:1:{i:0;s:10:“yesno.gram”;}i:27;s:11:“dnsmgr.conf”;i:28;s:9:“enum.conf”;i:29;s:15:“extensions.conf”;i:30;s:26:“extensions_additional.conf”;i:31;s:22:“extensions_custom.conf”;i:32;s:29:“extensions_custom.conf.sample”;i:33;s:32:“extensions_override_freepbx.conf”;i:34;s:13:“features.conf”;i:35;s:39:“features_applicationmap_additional.conf”;i:36;s:35:“features_applicationmap_custom.conf”;i:37;s:35:“features_featuremap_additional.conf”;i:38;s:31:“features_featuremap_custom.conf”;i:39;s:32:“features_general_additional.conf”;i:40;s:28:“features_general_custom.conf”;i:41;s:34:“freepbx_featurecodes.conf.template”;i:42;s:26:“freepbx_menu.conf.template”;i:43;s:25:“freepbx_module_admin.conf”;i:44;s:19:“globals_custom.conf”;i:45;s:8:“iax.conf”;i:46;s:19:“iax_additional.conf”;i:47;s:15:“iax_custom.conf”;i:48;s:20:“iax_custom_post.conf”;i:49;s:27:“iax_general_additional.conf”;i:50;s:23:“iax_general_custom.conf”;i:51;s:22:“iax_registrations.conf”;i:52;s:29:“iax_registrations_custom.conf”;i:53;s:16:“indications.conf”;s:6:“ivrpro”;a:1:{i:0;s:10:“yesno.gram”;}i:54;s:18:“localprefixes.conf”;i:55;s:11:“logger.conf”;i:56;s:30:“logger_general_additional.conf”;i:57;s:26:“logger_general_custom.conf”;i:58;s:31:“logger_logfiles_additional.conf”;i:59;s:27:“logger_logfiles_custom.conf”;i:60;s:12:“manager.conf”;i:61;s:16:“manager.conf.bak”;i:62;s:23:“manager_additional.conf”;i:63;s:19:“manager_custom.conf”;i:64;s:11:“meetme.conf”;i:65;s:22:“meetme_additional.conf”;i:66;s:10:“modem.conf”;i:67;s:12:“modules.conf”;i:68;s:24:“modules.conf.2.8.0-1.bak”;i:69;s:16:“musiconhold.conf”;i:70;s:27:“musiconhold_additional.conf”;i:71;s:23:“musiconhold_custom.conf”;i:72;s:10:“phone.conf”;i:73;s:11:“phpagi.conf”;i:74;s:12:“privacy.conf”;i:75;s:15:“queuerules.conf”;i:76;s:26:“queuerules_additional.conf”;i:77;s:22:“queuerules_custom.conf”;i:78;s:11:“queues.conf”;i:79;s:22:“queues_additional.conf”;i:80;s:18:“queues_custom.conf”;i:81;s:26:“queues_custom_general.conf”;i:82;s:30:“queues_general_additional.conf”;i:83;s:23:“queues_post_custom.conf”;i:84;s:12:“res_fax.conf”;i:85;s:19:“res_fax_custom.conf”;i:86;s:19:“res_fax_digium.conf”;i:87;s:26:“res_fax_digium_custom.conf”;i:88;s:13:“res_odbc.conf”;i:89;s:24:“res_odbc_additional.conf”;i:90;s:20:“res_odbc_custom.conf”;i:91;s:21:“res_stun_monitor.conf”;i:92;s:8:“rtp.conf”;i:93;s:19:“rtp_additional.conf”;i:94;s:15:“rtp_custom.conf”;i:95;s:8:“sip.conf”;i:96;s:19:“sip_additional.conf”;i:97;s:15:“sip_custom.conf”;i:98;s:20:“sip_custom_post.conf”;i:99;s:27:“sip_general_additional.conf”;i:100;s:23:“sip_general_custom.conf”;i:101;s:12:“sip_nat.conf”;i:102;s:15:“sip_notify.conf”;i:103;s:26:“sip_notify_additional.conf”;i:104;s:22:“sip_notify_custom.conf”;i:105;s:27:“sip_notify_endpointman.conf”;i:106;s:22:“sip_registrations.conf”;i:107;s:29:“sip_registrations_custom.conf”;i:108;s:7:“version”;i:109;s:12:“vm_email.inc”;i:110;s:14:“vm_general.inc”;i:111;s:14:“voicemail.conf”;i:112;s:23:“voicemail.conf.template”;i:113;s:20:“zapata.conf.template”;}s:5:“dahdi”;a:5:{i:0;s:18:“genconf_parameters”;i:1;s:9:“init.conf”;i:2;s:7:“modules”;i:3;s:11:“system.conf”;i:4;s:15:“system.conf.bak”;}i:0;s:12:“freepbx.conf”;}s:3:“var”;a:1:{s:3:“lib”;a:1:{s:8:“asterisk”;a:1:{s:3:“bin”;a:33:{i:0;s:18:“archive_recordings”;i:1;s:14:“audio-email.pl”;i:2;s:10:“backup.php”;i:3;s:8:“callback”;i:4;s:20:“callerid_updater.php”;s:3:“enc”;a:1:{i:0;s:17:“faxpro_helper.php”;}i:5;s:21:“endpoint_firmware.php”;i:6;s:12:“fax2mail.php”;i:7;s:17:“faxpro_helper.php”;i:8;s:26:“freepbx-cron-scheduler.php”;i:9;s:14:“freepbx_engine”;i:10;s:31:“freepbx_engine_hook_dahdiconfig”;i:11;s:28:“freepbx_engine_hook_endpoint”;i:12;s:31:“freepbx_engine_hook_endpointman”;i:13;s:29:“freepbx_engine_hook_pagingpro”;i:14;s:28:“freepbx_engine_hook_sysadmin”;i:15;s:24:“freepbx_engine_hook_xmpp”;i:16;s:15:“freepbx_setting”;i:17;s:16:“gen_amp_conf.php”;i:18;s:18:“generate_hints.php”;i:19;s:24:“generate_queue_hints.php”;i:20;s:22:“libfreepbx.confgen.php”;i:21;s:12:“module_admin”;i:22;s:20:“one_touch_record.php”;i:23;s:18:“opencnam-alert.php”;i:24;s:21:“pagepro-scheduler.php”;i:25;s:19:“pagepro-startup.php”;i:26;s:21:“queue_reset_stats.php”;i:27;s:11:“restore.php”;i:28;s:13:“retrieve_conf”;i:29;s:31:“retrieve_parse_amportal_conf.pl”;i:30;s:11:“schedtc.php”;i:31;s:11:“storage.php”;}}}}}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:0:{}}}s:5:“astdb”;s:5:“astdb”;s:8:“hostname”;s:20:“elastix.kinglyr.awmn”;s:10:“file_count”;i:165;s:11:“mysql_count”;i:1;s:11:“astdb_count”;i:1;s:5:“ftime”;i:1378335030;}
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:7:"kingl’ at line 1]
/var/www/html/admin/modules/backup/bin/restore.php:264 db_e()
[0]: DB Error: syntax error
Restoring an elastix image to your new system will never work properly, they forked up FreePBX a few years ago.
Few here will bother to interpret the ansi sequences in your post, find a cleaner way to post your logs.
IT is not an elastix image.
It is a clean setup of freePBX distro 4.211.64-5.iso on a clean system.
Don’t be fooled my the hostname of the system. I used hostname elastix because it is on my DNS server.
If you do not believe me that the Backup & Restore funtion is not working working you can reproduce the issue by trying to follow my methodology on my first post.
Regards,
Kinglyr.
The image i use is:
freepbx.4.211.64-5 32bit with asterisk 1.8
Sorry Could Not Reproduce . Works Fine Here.
Maybe Paste Your Errors In Readable Format
kinglyr,
I’m not able to reproduce this either however that doesn’t mean it isn’t an issue. Do you have multiple backups? If so, is this happening with all of them or specific ones? If you create a new backup on a fresh system (even if it has minimal config), and do a restore, does the same issue occur?
Dear Bryan Good morning,
It is strange because i am dead sure here that there is an issue.
No i do not have multiple backup. What i do is:
- Install FreePBX distro 4.211.64-5 32bit with asterisk 1.8 doing clean install from boot CD on a system with a wctdm card (opnevox tdm400p card)
- as soos as the system reboots for the first time after installation, i alter the general setting of the system (GUI > Settings > Advanced Settings > Asterisk Manager Password+ Email “From:” Address(backup module)+Asterisk Dial Options+Asterisk Outbound Trunk Dial Options+Country Indication Tones+Ringtime Default+User Portal Admin Password) and (GUI > Settings > Asterisk SIP Settings).
- I reboot the system, hoop up a USB flash drive and take the system an image backup using CloneZilla
- I reboot from clonezilla back to FreePBX and now i do all other fine tuning inside GUI and from CentOS CLI, in order to complete installation (Extensions, Trunks, Outbound Routes, Inbound Routes, Custom Destinations, Ring Groups, IVR etc etc). I check the system it is working using Asterisk CLI (asterisk -r > core set verbose 9 etc etc) by doing test calls, check the additional modules that are loaded etc etc
- I USE THE FREEPBX BACKUP & RESTORE module (GUI > Admin > BackUp & Restore > New Backup Button > Set Backup Name to “Kinglyr” > Set backup Description to “20130908FreePBX” > Drag from templates Full Backup > Drag from Storage Local Storage > Click Save > Then i click “And Run”)
Saving Backup 2…Intializing Backup 2
Backup Lock acquired!
Running pre-backup hooks…
Adding items…
/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
Bulding manifest…
Creating backup…
Storing backup…
Running post-backup hooks…
Backup successfully completed!
done!
- Goto var/spool/asterisk/backup and using WinSCP i copy the directory “Kinglyr” created to my computer desktop
- Reboot system using the USB flash drive to CloneZilla and Restore the image i had created in step 3. Clonezilla says Successfully!
- Reboot from clonezilla to FreePBX and using WinSCP again i copy the directory “Kinglyr” from my desktop back to it original location. i go to Backup & Restore Mobule and i click “Local Storage” and then “Kinglyr” and then " 20130908-140609-1378638369-418473084.tgz" file.
Wait a momment to do it again in order to double check it and get again the errors. I will post a new message.
John
Well !
Now it is working! When i went to Restore Module (GUI > Admin > Backup & Restore > Restore) and dragged an dropped the “full Backup” from right to left and clicked “Go” It showed:
Intialized!!
Intializing Restore…
Running pre-restore hooks, if any…
Restoring files…
/bin/tar: ./etc/freepbx.conf: Cannot open: File exists
/bin/tar: Exiting with failure status due to previous errors
File restore complete!
Restoring settings…
Getting Settings size…
Processed 100% of Settings’s!
Restoring astDB…
Restoring Settings’s complete
Running post-restore hooks, if any…
Cleaning up…
Restore complete!
Reloading…
Done!
And checking the tabs i see that all the information is there! (extensions, Trunks, ring group, inbound, outbound).
I do not know what went wrong the previous time, but now seems it is working…
(i think that the previous time i did not draged the “Full backup” template like i did now but i just clicked the “/etc”, “/var”, “PBX Settings” only that’s why it did not worked, maybe i do not know)
Sorry for giving you this false alarm.
Thank you for you immediate replies.
Regards,
John