AKZN Notes

Archives for My Lazy and Forgetful Mind

Archives

Tutorial Installasi dan Koneksi Printer POS58 serta Drawer

Cara Install POS58 Install Driver POS58 Unduh driver dari Google Drive. Instal driver sesuai petunjuk instalasi bawaan file. Koneksikan Printer Thermal ke PC (Bluetooth – Windows 10) Nyalakan Bluetooth pada printer dan PC. Pasangkan perangkat dengan memilih RPP02N. Pilih opsi Bluetooth (bukan "Wireless Display"). Gunakan password pairing: 0000. Cek Port Koneksi di Device Manager Buka […]

Import Database into XAMPP MYSQL via Windows Shell / Command Prompt

Import Database into XAMPP MySQL via Windows Shell / Command Prompt When working with MySQL in XAMPP, importing a database via the command prompt is a quick and efficient option. This tutorial explains how to use the Windows Shell to import a database into XAMPP MySQL. Prerequisites XAMPP Installed: Ensure XAMPP is installed on your […]

VNC Armbian Server Setup

https://forum.armbian.com/topic/10330-remote-desktop-with-x11vnc/ With this you can control your Linux desktop from any other PC/SBC. I use lightdm as display manager. If you use another display manager, change the line After=lightdm.service with your display manager. To Install sudo apt install x11vnc To create a password file x11vnc -storepasswd The service script : /lib/systemd/system/x11vnc.service [Unit] Description="x11vnc" Requires=display-manager.service After=lightdm.service […]

Migrate vps to a new vps

Tutorial: Clone a Disk Over SSH with Compression This guide explains how to clone a disk (/dev/sda) from a source machine to a destination machine over SSH using dd and gzip for compression. Prerequisites Source Machine: Ensure dd, gzip, and ssh are installed. Destination Machine: Ensure gzip and ssh are installed. Network Setup: Both machines […]

MikroTik PPPoE Bandwidth Management with RADIUS

Step 1: Configure PPPoE Basic PPPoE Setup: Set up your PPPoE server as you normally would. Ensure that you have configured the necessary interfaces and settings. Step 2: RADIUS Configuration Add RADIUS Attributes: In your RADIUS server, add the reply attribute Mikrotik-Address-List. This attribute will automatically add the IP address of the client logging in […]

MikroTik Hotspot Bandwidth Management

Hotspot Configuration Basic Settings: Configure the hotspot settings as usual. RADIUS Configuration (if applicable): In the server profile, enable the "Use RADIUS" option. Create a user profile and specify values in incoming[up]/outgoing-mark[down], such as packet-mark-download. This will dynamically add a packet mark in Mangle. Mikrotik-Group Attribute: If your RADIUS server uses the "Mikrotik-Group" attribute, ensure […]

how to log mysql query that has long time to execute

To log slow-running MySQL queries, you can enable the Slow Query Log feature in MySQL. This log will record all queries that take longer than a specified amount of time to execute. Here’s how to set it up: Step 1: Enable Slow Query Logging To enable slow query logging, you need to modify the MySQL […]

How to pull new branch from github

To pull a new branch from GitHub, follow these steps using Git: 1. Fetch the new branch from the remote repository: Run the following command to fetch all branches from the remote repository. This will not switch to the branch yet, but it will download the branch references. git fetch origin 2. List all branches […]

Setting WDS Openwrt

problems saat ubah network interface lan, perubahan subnet kadang bikin harus reboot dulu baru kedetek cara : set firewall zone to lan set wireless > edit > interface or something, from wwan to lan Allow Luci accessed via [wan/bridged] MIKROTIK HOTSPOT i add bracket [wan] to point out that i want to access luci via […]

Batch Rename Images Using Windows PowerShell

.JPG to .jpg To rename all .JPG files to .jpg in a directory using PowerShell, follow these steps: Open PowerShell. Navigate to the folder containing the .JPG files using the cd command. Run the following command: Get-ChildItem -Filter *.JPG | Rename-Item -NewName { $_.Name.ToLower() } This command will find all files with the .JPG extension […]