Upgrade Notes 23.07-23.09
backup
Perform a database backup before starting the update!
Update Algorithm:
- Complete shutdown of all webitel services.
- Update Debian Linux and upgrade Webitel applications to v23.09.
- Installation of new Webitel applications v23.09.
- Database migration from Webitel v23.07 to v23.09.
- Restart of all services after updating to Webitel v23.09.
Full 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 consul \ freeswitch ngcp-rtpengine-daemon opensips grafana-server nginx
Updating Debian Linux and upgrading Webitel applications to v23.09. You will need to request access to the Webitel repositories from your manager.
WBTU=webitel_repo_user WBTP=webitel_repo_password wget --http-user=$WBTU --http-password=$WBTP -O /usr/share/keyrings/webitel-repo.gpg http://deb.webitel.com/webitel-repo.gpg echo "machine http://deb.webitel.com login $WBTU password $WBTP" > /etc/apt/auth.conf.d/webitel.conf echo "deb [signed-by=/usr/share/keyrings/webitel-repo.gpg] http://deb.webitel.com/debian `lsb_release -sc` main" > /etc/apt/sources.list.d/webitel.list echo "deb [signed-by=/usr/share/keyrings/webitel-repo.gpg] http://deb.webitel.com/debian `lsb_release -sc` 23.09-releases" >> /etc/apt/sources.list.d/webitel.list apt update && apt upgrade
Installation of new Webitel applications v23.09.
apt install webitel-crm webitel-logger cp /opt/webitel/etc/systemd/system/webitel-logger.service /etc/systemd/system/ systemctl enable webitel-logger
Database migration from Webitel v23.07 to v23.09.
su postgres cd ~ psql webitel -qxc "ALTER EXTENSION timescaledb UPDATE;" psql -1 -f /usr/share/postgresql/15/webitel/migration/23.07-23.09.sql webitel exit
Add a new "crm" section to the Nginx configuration file:
sed -i '/.*location \/flow-diagram.*/i location \/crm {\n\talias \/opt\/www\/crm;\n\ttry_files $uri $uri\/ \/index.html last;\n\texpires -1;\n}\n' /etc/nginx/sites-enabled/default nginx -t
Restart all services after updating to Webitel v23.09.
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