Upgrade Notes 22.12-23.02

backup

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

Update algorithm

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

Upgrading Debian Linux and updating Webitel applications to v23.02

sed -i 's/22.12-releases/23.02-releases/g;' /etc/apt/sources.list.d/*.list
echo "deb https://deb.sipwise.com/spce/mr11.2.1 bullseye main" > /etc/apt/sources.list.d/rtpengine.list
wget https://deb.sipwise.com/spce/ngcp-keyring-latest.deb && \
    sudo dpkg -i ngcp-keyring-latest.deb && \
    rm ngcp-keyring-latest.deb

apt update 
apt upgrade

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 grafana-server nginx

Database migration from Webitel v22.12 to v23.02

systemctl restart postgresql
su postgres
cd ~
wget https://git.webitel.com/projects/WEP/repos/postgres/raw/migration/22.12-23.02.sql
psql webitel -f 22.12-23.02.sql
rm 22.12-23.02.sql
exit

Restarting all services after upgrading to Webitel v23.02

systemctl restart consul
systemctl restart postgresql
systemctl restart rabbitmq-server

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