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