Vicidial - Upgrade AGC OR Web Front

This how to was used when upgrading vicidial db to a new version by restoring and upgrading and older database onto the new server which uses the upgraded version of the web front and database.

# http://hemantsharma221.blogspot.co.za/2012/07/vicidial-svn-trunk-upgrade.html
# check out the latest astguiclient here
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk agc

# run this on your (older) asterisk db to get current version to upgrade from
# either on the new server with the newly imported database which was based on the old server's export
# or on the old server itself.
# to find your starting version (1411)
select db_schema_version from system_settings;
1411

# find the version you need to upgrade to on the new server (1469)

cat /etc/astguiclient.conf | grep -i ExpectedDBSchema
ExpectedDBSchema => 1469

# OR using the gui in the new version:

# (vicidial->admin->system settings) on the new server
# look for the "DB Schema Version:" There will be an error message "Expected DB Version 1469"

# make sure your version exists in the upgrade_2.12.sql file or search other sql files e.g. 1469 latest (2016-11-10)
grep -ri db_schema_version *.sql | grep 1469

# cp /usr/local/src/agc/extras/upgrade_2.12.sql /usr/local/src/agc/extras/upgrade_1411_1469.sql
# delete all before the last update to set version to 1411 including the update for 1411, it's already there
# delete all after the last update to set version to 1469
# import the new sql file to upgrade your system on the new server (containing the old dump)
mysql -uroot -p asterisk < /usr/local/src/agc/extras/upgrade_1411_1469.sql

# check your version after the import
select db_schema_version from system_settings;
1469