"Official" upgrade instructions ?

[xoy74]

I have a silly request, which I haven't found an answer for. I am looking for some kind of "official" upgrade instructions.
Currently I have a setup with one DB server, one web server and 3 Asterisk servers. All were installed in 2022 from the ViciBox_v10.x86_64-10.0.1-md.iso. The Admin page shows
VERSION: 2.14-853a
BUILD: 220328-1420
I am not asking for handholding, just for any pointers to the proper documentation.
Thank you !

[carpenox]

for a simple SVN update you can use these instructions: https://dialer.one/index.php/how-to-upd ... ubversion/

If you would like to upgrade the server OS's from 15.3 to 15.6, thats antoher story,

[williamconley]

BEFORE you start: Full backup of the database, the web files, and the configuration files. Preferably using the /usr/share/astguiclient/ADMIN_backup.pl script with the ftp option to push the backup off the server (just in case).

1) Note for reference your DB_schema and SVN version from admin->system settings and /etc/astguiclient.conf (these should agree with each other).

https://xx.xx.xx.xx/vicidial/admin.php? ... 1111111111

SVN Version: XXXX
DB Schema Version: XXXX

Code: Select all

grep ExpectedDBSchema /etc/astguiclient.conf -n

ExpectedDBSchema => XXXX

2) change directory into your svn folder of the original install and check the svn revision present

Code: Select all

cd /usr/src/astguiclient/trunk; svn info

Code: Select all

Revision: XXXX

* Should match previous. If it doesn't consider stopping if you're not sure what you're doing.

3) Upgrade your server's repository to the latest SVN revision

Code: Select all

cd /usr/src/astguiclient/trunk; svn up

4) Familiarize yourself with the upgrade document!

Code: Select all

cd /usr/src/astguiclient/trunk; cat UPGRADE

5) Advice:

Advice A: in the .sql files you are expected to upgrade with: Delete all the lines that have already been executed due to your present db schema.

EG: If you are at ExpectedDBSchema => 1662, delete all lines previous to this one in /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql:

Code: Select all

UPDATE system_settings SET db_schema_version='1662',db_schema_update_date=NOW() where db_schema_version < 1662;

Perhaps copy it to upgrade_2.14X.sql before making changes.

Advice B: Record any manual changes to any .conf files you have made directly, such as "/etc/asterisk/sip.conf" => "externip = ????". Perhaps by saving a copy of the files themselves for reference.

Code: Select all

perl install.pl --help

I highly recommend you invoke the --copy_sample_conf_files option. Sometimes there are changes that make this a necessity, sometimes there are not. If you've made "unrecorded/unremembered" changes to any .conf files, this is a good time to test everything and find out ... so you can record those changes.

6) The UPGRADE document is the actual instructions, of course.

But running "perl install.pl" in the folder "/usr/src/astguiclient/trunk/" and answering the questions is how the upgrade works.

[xoy74]

Thank you so much for the detailed instructions and suggestions.
I managed to do the upgrade but I must have done something wrong when I followed the advise #5 (skipping the schema updates lower than my current schema) and all the campaign settings showed blank after the upgrade. Thankfully I was able to restore the database and apply the unaltered db update script and everything looked OK after.

[williamconley]

Thank you so much for the detailed instructions and suggestions.
I managed to do the upgrade but I must have done something wrong when I followed the advise #5 (skipping the schema updates lower than my current schema) and all the campaign settings showed blank after the upgrade. Thankfully I was able to restore the database and apply the unaltered db update script and everything looked OK after.

Excellent postback. Odd, of course, as we've never experienced that ... but still good it worked out well for you and you solved it all on your own with the backup.

[carpenox]

did you try my suggestion xoy?

[xoy74]

did you try my suggestion xoy?

Hi. I actually used a mix of instructions, so thank you both for replying. And I made my own document that I can reference in the future, because I will forget for sure .