engUpgrade Notes 24.08-24.10

Before the update begins

Ensure to back up the database prior to starting the update!

Update Algorithm

Complete shutdown of all Webitel services
Update Webitel applications to v24.08
Migrate the database from Webitel v24.08 to v24.10
Restart all services after updating to Webitel v24.10

Complete shutdown of all Webitel services:

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

Update Webitel applications to v24.10.

sed -i 's/24.08-releases/24.10-releases/g' /etc/apt/sources.list.d/*

apt update
apt upgrade

Database migration from Webitel v24.08 to v24.10.

su postgres
cd ~
psql webitel -qxc "ALTER DATABASE webitel SET timescaledb.restoring='on';"
psql -1 -f /usr/share/postgresql/15/webitel/migration/24.08-24.10.sql webitel
psql webitel -qxc "ALTER DATABASE webitel RESET timescaledb.restoring;"
exit

Clear old packages:

apt --purge autoremove

Restart all services after updating to Webitel v24.10.

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 webitel-logger \
  freeswitch ngcp-rtpengine-daemon opensips grafana-server nginx