blog.masa23.jp

This is a note on setting up Zabbix 6.4. The configuration includes Zabbix + Nginx + php-fpm + PostgreSQL + TimescaleDB. Environment Version Ubuntu 22.04 Zabbix 6.4 PostgreSQL 15 Nginx 1.18.0 php-fpm 8.1.2 Register the Repository Download and install Zabbix # wget https://repo.zabbix.com/zabbix/6.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_6.4-1+ubuntu22.04_all.deb # dpkg -i zabbix-release_6.4-1+ubuntu22.04_all.deb # apt update Install Zabbix # apt install zabbix-server-pgsql zabbix-frontend-php php8.1-pgsql zabbix-nginx-conf zabbix-sql-scripts zabbix-agent Install PostgreSQL # apt install postgresql postgresql-contrib Add PostgreSQL Repository and Install # apt install software-properties-common gnupg postgresql-common apt-transport-https lsb-release wget # /usr/share/postgresql-common/pgdg/apt. …

Here are the notes on installing Metabase on Ubuntu 22.04 LTS. Install Java The Java Development Kit (JDK) is required. apt-get install -y default-jdk Create Metabase Installation Directory install -d /opt/metabase cd /opt/metabase Download Metabase Download the Metabase binary with the following command: wget https://downloads.metabase.com/v0.45.3/metabase.jar Create User and Group useradd metabase -d /opt/metabase chown -R metabase:metabase /opt/metabase Create systemd Service File Create a systemd service file with the following command: …

I got a Lenovo TAB6 (A101LV) and rooted it, so I’m leaving a note. Please do this at your own risk as there is a possibility of bricking the device. Also, since this is a personal note, detailed explanations are not provided. Enable USB Debugging “Settings” => “System” => “About tablet” => “Build number” Tap the build number 7 times to enable “Developer options”. “Settings” => “System” => “Developer options” => Enable “USB debugging”. …

The Busybox dmesg command lacks the -T option to convert and display timestamps, so I tried converting them with a one-liner. One-liner uptime=$(cut -d. -f1 /proc/uptime); dmesg | while read line; do time=$(echo $line | sed -e 's/^\[ *\([0-9]*\).*$/\1/g'); echo "[$(date -d @$(($(date +%s) - $uptime + $time)))] $(echo $line | cut -d ] -f 2 -)" ; done Brief Explanation /proc/uptime records the elapsed time since the system was started in seconds. …

This guide explains how to set up HTTPS SSL certificates on OpenWrt. Can it actually be configured from the WebUI?? For certificates with a short validity period, such as those from Let’s Encrypt, it might be a good idea to automate the process using a shell script and run it periodically with cron. Prerequisites Obtain an SSL certificate Enable HTTPS from the WebUI System -> Administration -> HTTP(S) Access Check the box for Redirect to HTTPS Convert SSL certificate and private key to DER format openssl x509 -in server. …

I created a provider that makes the lego command itself a DNS server to perform DNS-01 authentication when obtaining Let’s Encrypt SSL certificates using Lego. Introduction Lego is a command-line tool written in Go that acts as an ACME client to obtain SSL certificates from Let’s Encrypt and other certificate authorities. What did I do? Lego’s DNS-01 authentication supports various DNS providers, but for times when “there’s no DNS server with an API available! …

Here’s a note on adding Rspamd to an existing Postfix mail server. The server is running on Ubuntu 20.04. Install Redis Install via apt # apt install redis Check if it is running # systemctl status redis.service Ensure it shows active (running) Verify it is listening on port 6379 # ss -ltn | grep 6379 LISTEN 0 511 127.0.0.1:6379 0.0.0.0:* LISTEN 0 511 [::1]:6379 [::]:* If it is listening on 0. …

Before upgrading Mattermost, I restarted Mattermost and encountered a 404 Page Not Found issue. Here’s a note on the troubleshooting steps. Symptoms When accessing http://<mattermost-server>/, a 404 Page Not Found error is displayed. Cause I use nginx for caching in front of Mattermost, and I disabled gzip compression in nginx. However, I mistakenly set the WebserverMode to “disabled” instead of “uncompressed,” causing the web server to be disabled. The issue did not appear immediately after changing the setting; it only occurred after restarting Mattermost, making it difficult to identify the cause. …

Since Slack’s log retention period has been reduced to 90 days, making it harder to view past logs, I decided to implement Mattermost. Here’s a note on how I copied custom emojis (reactions) from Slack to Mattermost. Extracting Reactions from Slack Initially, I planned to extract the reactions using Slack’s API, but using the Chrome extension Slack Custom Emoji Manager made it very easy to download them. Install the Chrome extension and access https://. …

I wasn’t very familiar with this, so I did a brief research. To use RCTL in FreeBSD, a kernel with RACCT and RCTL enabled is required. The Generic kernel of FreeBSD 13.1 seems to have this enabled, so enable it in loader.conf. root@freebsd13:~ # grep -E 'RACCT|RCTL' /usr/src/sys/amd64/conf/GENERIC options RACCT # Resource accounting framework options RACCT_DEFAULT_TO_DISABLED # Set kern.racct.enable=0 by default options RCTL # Resource limits # echo "kern.racct.enable=1" >> /boot/loader. …