Installing latest mariadb (v.11) on ubuntu 22.04/24.04

Overview The MariaDB version in the default Ubuntu repository is not the latest one. To see the default version, you can use the following commands: apt show mariadb-server Output: Package: mariadb-server Version: 1:10.6.18-0ubuntu0.22.04.1 Priority: optional Section: universe/database Source: mariadb-10.6 Origin: Ubuntu As you can see, the default MariaDB version on Ubuntu 20.04 is the version 10, however the latest one is version 11. In order to install the latest one, you need to add MariaDB APT repository first before installing...

September 23, 2024 · 7 min · by Chisqi

OpenLDAP Docker

Overview Running OpenLDAP in a Docker container is a straightforward process that can help you manage your LDAP server efficiently. On this article, I would like to share how to run the OpenLDAP for centralize authentication in a docker. What’s OpenLDAP OpenLDAP is an open-source implementation of the Lightweight Directory Access Protocol (LDAP). It provides a directory service that can be used for managing and accessing distributed directory information services over an Internet Protocol (IP) network....

May 23, 2024 · 6 min · by Chisqi

Enabling PSK encryption between Zabbix server and Agent

Overview Zabbix supports Certificate-based and pre-shared key-based encryption to encrypt the communication between the server and host agent. This article describes the necessary steps to enable a Pre-shared (PSK) encryption for securing the comunication between the Zabbix agent and Zabbix server: Configuration steps The key point of using the PSK is, the server and the agent need to use the same key to make them able to communicate. Therefore, we will need to set the PSK on both server and the host agent....

February 3, 2024 · 2 min · by Chisqi

Monitoring Mikrotik and Linux servers with Grafana, Prometheus and Node Exporter

Overview Grafana is a powerful open-source platform for monitoring and observability, enabling users to visualize and analyze data from various sources in real-time. On this guide, I’ll show you how to deploy Grafana on docker stack to monitor the Mikrotik devices (using SNMP), and monitoring the Linux and Windows Server. Sample Mikrotik Linux Server - Node Exporter Environment Networking and VLan VlanID Subnet 101 10.10.101.0/24 102 10.10.102.0/24 Server Environment ServerName IPAddress Notes doc01 10....

August 23, 2023 · 4 min · by Chisqi

Mariadb replication ERROR 1201 (HY000): Could not initialize master info structure

Overview You got Mariadb replication ERROR 1201 (HY000): Could not initialize master info structure for ''; when running start-slave after the migration. Steps: Check the Current Master Binary Log Position Login to master server, and run the following: docker exec mariadb-master show-status Replication Mode: master [mysql] *************************** 1. row *************************** [mysql] File: mysqld-bin.xx [mysql] Position: xx [mysql] Binlog_Do_DB: [mysql] Binlog_Ignore_DB: ############### Connections ############### Reset and Reconfigure Replication On the slave server, stop the slave: STOP SLAVE; Reset the replication....

July 3, 2023 · 1 min · by Chisqi

Mariadb Replication docker - Error Got fatal error 1236

Overview The error message Got fatal error 1236 from master when reading data from binary log: typically indicates that the replication slave is trying to read from a position in the master’s binary log that doesn’t exist. The detailed error is as follow: [mysql] Last_IO_Errno: 1236 [mysql] Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysqld-bin....

June 23, 2023 · 2 min · by Chisqi

Amlogic ARM-Based Single Board Computer duplicate MAC Address

Overview There’s annoying bug on cheap Amlogic ARM-Based Single Board Computer running Armbian with Debian 11 version. I recently instaling multiple devices with single image Armbian (Debian 11). Once the process completed, all devices were unable to connect to the network due to the MAC duplicate. The originial MAC Address was gone, and instead, it generated new MAC address on each devices lead to MAC duplicatation. Because all devices were using same MAC Addresses, the network connection was rejected by the router or firewall....

June 16, 2023 · 2 min · by Chisqi

Backup Docker Offline

Docker Offline backup docker image save -o images.tar image1 [image2 ...] This will back up the docker as .tar image. Restore Docker - Offline Load the backup docker image load -i backup.tar Rerun the image into a container docker run

May 23, 2023 · 1 min · by Chisqi

Mariadb Replication on Docker

Introduction MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. It was created by the original developers of MySQL after concerns over the acquisition of MySQL by Oracle Corporation. MariaDB replication MariaDB replication is a process that allows you to create and maintain a copy of a database on another server, which is known as a replica. Replication in MariaDB can be useful for various purposes, including load balancing, high availability, and backup....

May 23, 2023 · 5 min · by Chisqi

Updating/Upgrading Wazuh Services Component

Overview Updating and upgrading Wazuh Components are crucial to keep the software updated for better CVE vulnerability detections, bug fixes, and features. Here are the procedures to upgrade the Wazuh Component for standalone setup. Read the following before proceeding the upgrade: This procedures are for Wazuh Standalone setup only with CentOS Operating system. If you are using another OS, or using Wazuh cluster setup, there are multiple steps needs to be completed, follow the Officeial Upgrade Guidance for the details....

May 23, 2023 · 2 min · by Chisqi