{"id":1504,"date":"2021-02-04T06:56:48","date_gmt":"2021-02-04T11:56:48","guid":{"rendered":"https:\/\/cyburityllc.com\/?p=1504"},"modified":"2022-03-19T00:58:48","modified_gmt":"2022-03-19T04:58:48","slug":"how-to-backup-and-restore-your-vicidial-cyburdial-server","status":"publish","type":"post","link":"https:\/\/dialer.one\/index.php\/how-to-backup-and-restore-your-vicidial-cyburdial-server\/","title":{"rendered":"How to &#8211; Backup and Restore your Vicidial server"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">How to &#8211; Backup and Restore your Vicidial server<\/h2>\n\n\n\n<p>Why would you need to backup and restore your vicidial server? Suppose you need to&nbsp;<strong>migrate or duplicate Vicidial data<\/strong>&nbsp;(campaigns, leads, phones and so on) from one&nbsp;<strong>Vicibox<\/strong>&nbsp;server to another. In case two&nbsp;<strong>Vicidial<\/strong>&nbsp;boxes of the same versions the process will be simpler. In case the source server has older Vicibox version than the destination one you will have to perform additional steps to get the destination server working. Both cases are covered in the article below.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Backup \/ restore Vicidial data between the same version of Vicibox<\/h3>\n\n\n\n<p>Basically, to get the&nbsp;<strong>Vicidial backup<\/strong>&nbsp;you will need to run&nbsp;<code>\/usr\/share\/astguiclient\/ADMIN_backup.pl<\/code>&nbsp;script that has the following options:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\n\n\/usr\/share\/astguiclient\/ADMIN_backup.pl --help\nallowed run time options:\n  &#91;--db-only] = only backup the database\n  &#91;--db-settings-only] = only backup the database without leads, logs, servers or phones\n  &#91;--db-without-logs] = do not backup the log tables in the database\n  &#91;--db-without-archives] = do not backup the archive tables in the database\n  &#91;--dbs-selected=X] = backup only selected databases, default uses conf file db only to backup databases X and Y, use X---Y, can use --ALL-- for all dbs on serveryou can use --ALLNS-- for all non-mysql dbs(will ignore 'test', 'mysql','information_schema')\nThis feature will NOT work with '--db_raw_files_copy' option\n  &#91;--conf-only] = only backup the asterisk conf files\n  &#91;--without-db] = do not backup the database\n  &#91;--without-conf] = do not backup the conf files\n  &#91;--without-web] = do not backup web files\n  &#91;--without-sounds] = do not backup asterisk sounds\n  &#91;--without-voicemail] = do not backup asterisk voicemail\n  &#91;--without-crontab] = do not backup crontab\n  &#91;--ftp-transfer] = Transfer backup to the 'REPORTS' FTP server\n  &#91;--ftp-server=XXXXXXXX] = OVERRIDE FTP server to send file to\n  &#91;--ftp-login=XXXXXXXX] = OVERRIDE FTP user\n  &#91;--ftp-pass=XXXXXXXX] = OVERRIDE FTP pass\n  &#91;--ftp-dir=XXXXXXXX] = OVERRIDE remote FTP server directory to post files to\n  &#91;--debugX] = super debug\n  &#91;--debug] = debug\n  &#91;--test] = test\n  &#91;--db_raw_files_copy] = if set the backup won't be a mysql dump. It will tar the \/var\/lib\/mysql folder. WARNING, THIS OPTION WILL STOP THE MYSQL SERVER!\n  &#91;--archive_path=\/PATH\/FROM\/ROOT] = absolute path to store the resulting backup<\/code><\/pre>\n\n\n\n<p>As you see it is capable to create partial backup, but in my example I run it like this to get a<strong>&nbsp;full backup of Vicidial<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \/usr\/share\/astguiclient\/ADMIN_backup.pl --archive_path=\/root\n \n----- Archive path set to \/root -----\n \n \n----- Mysql dump -----\n \n\/bin\/tar: Removing leading `\/' from member names\n\/bin\/tar: Removing leading `\/' from member names\n\/bin\/tar: Removing leading `\/' from member names\n\/bin\/tar: Removing leading `\/' from member names\n\/bin\/tar: Removing leading `\/' from member names\n\/bin\/tar: Removing leading `\/' from member names\n\/bin\/tar: Removing leading `\/' from member names\nscript execution time in seconds: 48     minutes: 0.8<\/code><\/pre>\n\n\n\n<p>If the server has address 192.168.10.3 this will create&nbsp;<code>192.168.10.3_ALL_1.tar.gz<\/code>&nbsp;archive that contains a set of archives with database dump and configuration files in their respective paths.<\/p>\n\n\n\n<p>Now transfer it to the destination server (192.168.10.4) via SCP or any other suitable method. For example:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td># scp \/root\/192.168.10.3_ALL_1.tar.gz root@192.168.10.4:\/<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Now on the destination server navigate to&nbsp;<code>\/<\/code>&nbsp;folder and extract the&nbsp;<strong>Vicidial backup<\/strong>&nbsp;archive:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td># tar -zxvf 192.168.10.3_ALL_1.tar.gz<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Inside the main archive there will be separate archives for different parts of Vicidial system:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># ls -l \/\n&#91;...]\n192.168.10.3_BIN_1.tar\n192.168.10.3_CONF_1.tar\n192.168.10.3_LINUX_1.tar\n192.168.10.3_SOUNDS_1.tar\n192.168.10.3_VOICEMAIL_1.tar\n192.168.10.3_WEB_1.tar\n192.168.10.3asterisk1.gz\n&#91;...]<\/code><\/pre>\n\n\n\n<p>In tar archives config files are packed in their respective paths so in order&nbsp;<strong>restore Vicidial configuration files<\/strong>&nbsp;just unpack the .tar archives:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td># tar -xvf *.tar<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Now extract and&nbsp;<strong>restore Vicidial database<\/strong>&nbsp;dump:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td>1<br>2<br>3<\/td><td># gunzip 192.168.10.3asterisk1.gz<br>192.168.10.3asterisk1<br># mysql -u root asterisk &lt; 192.168.10.3asterisk1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>At this point you have configuration files and database from the old server applied on the new one. We must change IP addresses in all configuration files and in database before we can use the new server.<\/p>\n\n\n\n<p>To&nbsp;<strong>change IP address in all Vicidial configuration files<\/strong>&nbsp;and database run:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \/usr\/share\/astguiclient\/ADMIN_update_server_ip.pl\nPrevious astGUIclient configuration file found at: \/etc\/astguiclient.conf\n \nWould you like to use interactive mode (y\/n): &#91;y]\n \nSTARTING SERVER IP ADDRESS CHANGE FOR VICIDIAL...\n \nOld server IP address or press enter for default: &#91;192.168.10.4] 192.168.10.3\n \nserver IP address or press enter for default: &#91;192.168.10.4]\n \n  old server_ip:      192.168.10.3\n  new server_ip:      192.168.10.4\n \nAre these settings correct?(y\/n): &#91;y]\nWriting change to astguiclient.conf file: \/etc\/astguiclient.conf\n \nSTARTING DATABASE TABLES UPDATES PHASE...\n  Updating servers table...\n     |0E0|UPDATE servers SET server_ip='192.168.10.4' where server_ip='192.168.10.3';|\n\t &#91;...]<\/code><\/pre>\n\n\n\n<p>This script is interactive and will guide you through the process.<br>Make sure there are no errors in the script\u2019s output.<br>Now reboot your server and check functionality!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Migrate Vicidial data from Vicibox 8 to Vicibox 9<\/h2>\n\n\n\n<p>1.&nbsp;<a href=\"https:\/\/dialer.one\/vicidial-error-code-expects-different-schema\/\">Upgrade database schema<\/a>.&nbsp;<strong>Vicibox 9<\/strong>&nbsp;has new and altered tables and functions so you will have to add them to the restored database before you can use system<\/p>\n\n\n\n<p>2. Run&nbsp;<code>\/usr\/share\/astguiclient\/ADMIN_update_server_ip.pl<\/code>&nbsp;again<\/p>\n\n\n\n<p>3. Try to log in as agent. If you have the error&nbsp;<strong>There is a time synchronization problem with your system, please tell your system administrator&nbsp;<\/strong>\u2013 fix it as described&nbsp;<a href=\"https:\/\/dialer.one\/vicidial-there-is-a-time-synchronization-problem-with-your-system-please-tell-your-system-administrator\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a><strong>.<\/strong><\/p>\n\n\n\n<p>4. If you have the error&nbsp;<strong>Delays on agent login No one is on your session 8600051<\/strong>&nbsp;check that in&nbsp;<strong>Admin -&gt; Servers<\/strong>&nbsp;you have correct Asterisk Version set:<\/p>\n\n\n\n<p>For Vicibox 8 it will be 11.21.2.-vici&nbsp; but for&nbsp;<strong>Vicibox 9<\/strong>&nbsp;it should be at least&nbsp;<code>13.29.2-vici<\/code> up to 13.38.0-vici<\/p>\n\n\n\n<p>Correct version of the Asterisk you can obtain by:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>1<\/td><td># asterisk -rx &#8220;core show version&#8221;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Set the correct version in Vicidial\u2019s settings make sure the error is gone.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"548\" height=\"54\" src=\"https:\/\/cyburityllc.com\/wp-content\/uploads\/2021\/02\/image.png\" alt=\"backup\" class=\"wp-image-1510\" title=\"\" srcset=\"https:\/\/dialer.one\/wp-content\/uploads\/2021\/02\/image.png 548w, https:\/\/dialer.one\/wp-content\/uploads\/2021\/02\/image-300x30.png 300w, https:\/\/dialer.one\/wp-content\/uploads\/2021\/02\/image-500x49.png 500w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/figure>\n\n\n\n<p>That&#8217;s all there is to it. If you have any questions feel free to comment here.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>-Chris<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to &#8211; Backup and Restore your Vicidial server Why would you need to backup and restore your vicidial server? Suppose you need to&nbsp;migrate or duplicate Vicidial data&nbsp;(campaigns, leads, phones and so on) from one&nbsp;Vicibox&nbsp;server to another. In case two&nbsp;Vicidial&nbsp;boxes of the same versions the process will be simpler. In case the source server has [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1505,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[],"tags":[],"class_list":["post-1504","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/dialer.one\/wp-content\/uploads\/2021\/02\/server1.jpg","jetpack-related-posts":[{"id":2394,"url":"https:\/\/dialer.one\/index.php\/how-to-setup-a-vicidial-cluster\/","url_meta":{"origin":1504,"position":0},"title":"How to &#8211; Setup a ViciDial Cluster","author":"carpenox","date":"March 12, 2022","format":false,"excerpt":"How to - Setup a ViciDial Cluster This article is going to go over the steps I suggest to take in order to setup a ViciDial Cluster. I do things a little different when it comes to this to prepare for worst case scenario that a server may have problems\u2026","rel":"","context":"In &quot;CyburDial&quot;","block_context":{"text":"CyburDial","link":"https:\/\/dialer.one\/index.php\/category\/cyburdial\/"},"img":{"alt_text":"ViciDial Cluster","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-4.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-4.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-4.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-4.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":2378,"url":"https:\/\/dialer.one\/index.php\/table-of-contents\/","url_meta":{"origin":1504,"position":1},"title":"Table of Contents &#8211; Knowledge Base","author":"carpenox","date":"March 7, 2022","format":false,"excerpt":"Welcome to my blog, some of you may know me from the ViciDial forums, I am carpenox and I am here to share my knowledge with everyone, for free!","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"CyburDial","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":2961,"url":"https:\/\/dialer.one\/index.php\/why-doesnt-my-vicibox-10-0-2-install-work\/","url_meta":{"origin":1504,"position":2},"title":"Why doesn&#8217;t my ViciBox 10.0.2 install work?","author":"carpenox","date":"June 2, 2023","format":false,"excerpt":"Why doesn't my ViciBox 10.0.2 install work? So it seems that there is duplicate Listen directives for apache, more specifically, targeted towards the dynamic portal. What you need to do it edit the listen.conf for apache. You can do so by copying and pasting the following command into your Linux\u2026","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"Data Center","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/08\/data-centre-1024x420-1.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/08\/data-centre-1024x420-1.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/08\/data-centre-1024x420-1.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/08\/data-centre-1024x420-1.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1913,"url":"https:\/\/dialer.one\/index.php\/how-to-install-asterisk-16-on-vicidial\/","url_meta":{"origin":1504,"position":3},"title":"How to &#8211; Install Asterisk 16 on Vicidial","author":"carpenox","date":"April 7, 2021","format":false,"excerpt":"How to - Install Asterisk 16 on Vicidial In this article, I will demonstrate Install Asterisk 16 on Vicidial aka vicibox 9. In theory it should also work for you CentOS lovers (bleh) too, but just change the zypper commands to yum. Step 1 - Remove Asterisk 13 & install\u2026","rel":"","context":"With 5 comments","block_context":{"text":"With 5 comments","link":"https:\/\/dialer.one\/index.php\/how-to-install-asterisk-16-on-vicidial\/#comments"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2021\/04\/image-4.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4511,"url":"https:\/\/dialer.one\/index.php\/custom-vicidial-reports-on-github\/","url_meta":{"origin":1504,"position":4},"title":"Custom VICIdial Reports on GitHub","author":"carpenox","date":"January 11, 2025","format":false,"excerpt":"Custom VICIdial Reports on GitHub Introducing My New GitHub Repository for Custom VICIdial Reports Hey there, fellow VICIdial enthusiasts! I am thrilled to announce the launch of my latest GitHub repository, dedicated to creating custom reports for VICIdial. As a long-time user and developer in the VICIdial community, I understand\u2026","rel":"","context":"In &quot;CyburDial&quot;","block_context":{"text":"CyburDial","link":"https:\/\/dialer.one\/index.php\/category\/cyburdial\/"},"img":{"alt_text":"Custom Reports","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2025\/01\/image-png.webp?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2025\/01\/image-png.webp?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2025\/01\/image-png.webp?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1174,"url":"https:\/\/dialer.one\/index.php\/vicidial-error-code-expects-different-schema\/","url_meta":{"origin":1504,"position":5},"title":"How to &#8211; Fix the Vicidial error: Code Expects Different Schema","author":"carpenox","date":"October 18, 2020","format":false,"excerpt":"How to - Fix the Vicidial error: Code Expects Different Schema This is a pretty easy fix, \"Code Expects Different Schema\" occurs when you update your svn version but forget to update the db schema through mysql. The instructions are below. different schema After database dump restoration taken from older\u00a0Vicibox\u00a0to\u2026","rel":"","context":"With 1 comment","block_context":{"text":"With 1 comment","link":"https:\/\/dialer.one\/index.php\/vicidial-error-code-expects-different-schema\/#comments"},"img":{"alt_text":"different schema","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2020\/10\/dbschema.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2020\/10\/dbschema.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2020\/10\/dbschema.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/posts\/1504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/comments?post=1504"}],"version-history":[{"count":0,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/posts\/1504\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/media\/1505"}],"wp:attachment":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/media?parent=1504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/categories?post=1504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/tags?post=1504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}