Upgrade Notes 22.07-22.09

backup

Be sure to back up the database before upgrading the system!

Update algorithm

Complete stop of all Webitel services
Database migration from Webitel v22.07 to v22.09
Upgrading Debian Linux and updating Webitel applications to v22.09
Restarting all services after upgrading to Webitel v22.09

Complete stop of all Webitel services

systemctl stop webitel-api webitel-app webitel-uac messages-bot messages-srv \
  engine call_center storage flow_manager \
  freeswitch ngcp-rtpengine-daemon opensips nginx

Database migration from Webitel v22.07 to v22.09

su postgres
cd ~
wget https://git.webitel.com/projects/WEP/repos/postgres/raw/migration/22.07-22.09.sql
psql webitel -f 22.07-22.09.sql
rm 22.07-22.09.sql cc_vacuum.sql
crontab -r
wget https://git.webitel.com/projects/WEP/repos/postgres/raw/database_helper.sql
echo "4 4     * * *   psql webitel < ~/database_helper.sql" | crontab -
exit

Upgrading Debian Linux and updating Webitel applications to v22.09

sed -i 's/22.07-releases/22.09-releases/g;' /etc/apt/sources.list.d/*.list

apt update 
apt upgrade

Restarting all services after upgrading to Webitel v22.09

systemctl restart consul
systemctl restart postgresql
systemctl restart rabbitmq-server

su postgres
psql webitel -c "ALTER EXTENSION cc_sql UPDATE TO '1.1';"
exit

systemctl restart webitel-app webitel-uac webitel-api \
  messages-srv flow_manager messages-bot \
  engine call_center storage freeswitch ngcp-rtpengine-daemon

Update or merge the OpenSIPS configuration file (if it was changed manually), and nginx:

curl https://git.webitel.com/projects/WEP/repos/opensips/raw/opensips.cfg \
    -o /etc/opensips/opensips.cfg
systemctl restart opensips

curl https://git.webitel.com/projects/WEP/repos/nginx/raw/default \
 -o /etc/nginx/sites-available/default.orig
vimdiff /etc/nginx/sites-enabled/default /etc/nginx/sites-available/default.orig
nginx -t
systemctl restart nginx