Monthly Archives: August 2024

zabbix proxy sqlite


wget https://repo.zabbix.com/zabbix/7.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_7.0-2+ubuntu24.04_all.deb
dpkg -i zabbix-release_7.0-2+ubuntu24.04_all.deb
apt update

apt install zabbix-proxy-sqlite3 zabbix-sql-scripts
mkdir /var/lib/sqlite

sqlite3 /var/lib/sqlite/zabbix.db < /usr/share/zabbix-sql-scripts/sqlite3/proxy.sql 

chown -R zabbix:zabbix /var/lib/sqlite
cat /etc/zabbix/zabbix_proxy.conf | grep ^DBName
DBName=/var/lib/sqlite/zabbix.db

/etc/init.d/zabbix-proxy start

[InnoDB] Tablespace 1, name ‘sys/sys_config’, file ‘./sys/sys_config.ibd’ is missing!

su - mysql -s /bin/bash
mysqld_safe --upgrade=MINIMAL --skip-grant-tables --skip-networking

mysql> DROP DATABASE sys;
ERROR 3679 (HY000): Schema directory './sys/' does not exist

mkdir /var/lib/mysql/sys
chown mysql:mysql /var/lib/mysql/sys

mysql> drop database sys;
Query OK, 101 rows affected (0.03 sec)

upgrade postgres 15 -> 16

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg

apt update
apt install postgresql-16

pg_dropcluster --stop 16 main
pg_upgradecluster --method=upgrade --link 15 main

pg_lsclusters

15 main 5433 down postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
16 main 5432 online postgres /var/lib/postgresql/16/main /var/log/postgresql/postgresql-16-main.log