| Warning |
|---|
|
Be sure to back up the database before upgrading the system! |
Update algorithm
- Complete stop of all Webitel services
- Upgrading Debian Linux and updating Webitel applications to v.23.05
- Database migration from PostgreSQL 14 to 15
- Database migration from Webitel v23.02 to v23.05
- Restarting all services after upgrading to Webitel v23.05
...
| Code Block |
|---|
|
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.05-releases" >> /etc/apt/sources.list.d/webitel.list
echo "deb https://deb.sipwise.com/spce/mr11.3.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 purge webitel-www
apt update && apt upgrade |
Миграция базы данных с версии Database migration from PostgreSQL 14 на to 15
| Code Block |
|---|
|
sudo -u postgres psql webitel -qxc "ALTER EXTENSION timescaledb UPDATE;"
apt install postgresql-15 webitel-postgresql-15 timescaledb-2-postgresql-15
timescaledb-tune --quiet --yes
systemctl stop postgresql
su postgres
cd /tmp
/usr/lib/postgresql/15/bin/pg_upgrade \
--old-datadir "/etc/postgresql/14/main" \
--new-datadir "/etc/postgresql/15/main" \
--old-bindir "/usr/lib/postgresql/14/bin" \
--new-bindir "/usr/lib/postgresql/15/bin"
exit |
Проверти конфигурационный файлы нового PostgreSQL. Только после проверки, можете приступать к удалению старой и запуску новой версии PostgreSQLYou need to check the configuration files of the new PostgreSQL. Only after check, you can delete the old version and start the new PostgreSQL version:
| Code Block |
|---|
|
apt purge postgresql-14 webitel-postgresql-14 timescaledb-2-postgresql-14
systemctl restart postgresql
sudo -u postgres /usr/lib/postgresql/15/bin/vacuumdb --all --analyze-in-stages |
Миграция базы данных с версии Database migration from Webitel v23.02 на to v23.05
| Code Block |
|---|
|
su postgres
cd ~
wget https://git.webitel.com/projects/WEP/repos/postgres/raw/migration/23.02-23.05.sql
psql webitel -f 23.02-23.05.sql
rm 23.02-23.05.sql
exit |
Обновите либо сведите конфигурационный файл Update or merge the nginx (если он был изменен вручнуюconfiguration file (if it was changed manually):
| Code Block |
|---|
|
apt install webitel-auth-app webitel-admin-app webitel-agent-workspace webitel-supervisor-workspace \
webitel-flow-diagram webitel-history webitel-audit-app webitel-web-widget
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 |
Перезапуск всех сервисов после обновления до Restarting all services after upgrading to Webitel v23.05
| Code Block |
|---|
|
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 |
...