xargs apt-get changelog < /var/run/reboot-required.pkgs
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
nodejs serve directory
npx http-server -o /path/to/static/content
locust
An open source load testing tool.
Define user behaviour with Python code, and swarm your system with millions of simultaneous users