Archives for My Lazy and Forgetful Mind

Migrate vps to a new vps

Contents1 Tutorial: Clone a Disk Over SSH with Compression1.1 Prerequisites1.2 Command Overview1.3 Command Breakdown1.3.1 On the Source Machine:1.4 Steps to Execute1.5 Example1.5.1 Source Machine Command:1.5.2 Explanation:1.6 Notes1.7 Troubleshooting 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 […]

MikroTik PPPoE Bandwidth Management with RADIUS

Contents1 Step 1: Configure PPPoE2 Step 2: RADIUS Configuration3 Step 3: Mangle Rules Setup4 Step 4: Queue Tree Configuration5 Summary 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 […]

MikroTik Hotspot Bandwidth Management

Contents1 Hotspot Configuration2 Mangle Jump Rules3 Queue Tree Configuration3.1 Example Queue Tree Entry: 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 […]

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: Contents1 Step 1: Enable Slow Query Logging2 Explanation:3 Step 2: Restart MySQL Service4 Step 3: Verify the […]

How to pull new branch from github

To pull a new branch from GitHub, follow these steps using Git: Contents1 1. Fetch the new branch from the remote repository:2 2. List all branches (optional):3 3. Check out the new branch:4 4. Pull the latest changes from the new branch: 1. Fetch the new branch from the remote repository: Run the following command […]

Setting WDS Openwrt

Contents1 problems2 cara :3 Allow Luci accessed via [wan/bridged] MIKROTIK HOTSPOT 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 […]

Batch Rename Images Using Windows PowerShell

Contents1 .JPG to .jpg2 .png to .jpg .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 […]

SQL Injection Cheat Sheet

good reading to test our apps https://www.invicti.com/blog/web-security/sql-injection-cheat-sheet/

Setting Fiberhome hg6145d2 Bridge

Contents1 Setting Up FiberHome HG6145D2 as a Bridge with IndiHome Firmware1.1 Default Credentials1.2 Setup Steps Setting Up FiberHome HG6145D2 as a Bridge with IndiHome Firmware The FiberHome HG6145D2 modem with IndiHome firmware does not have a manual bridge mode setting. However, it can still be used as a bridge by default. When tested, DHCP did […]

HTTP Basic Authentication to secure phpMyAdmin

HTTP Authentication is a method of securing web resources by requiring users to provide valid credentials before accessing them. It operates at the HTTP protocol level and can be implemented using several authentication schemes. One common method for HTTP Authentication is Basic Authentication, which prompts users to enter their username and password in a dialog […]

VLAN OpenWRT as DHCP Server/client and Mikrotik as DHCP Server/client on a Single Ethernet Port

9 November 2021 / by akozan / 0 Comments

Why ?
I want to use OpenWRT on Orange Pi Zero, but OPiZ only have one ethernet port. So, how i can use that single port as dhcp server (to give internet), and dhcp client (to get internet).

Contents

1 Mikrotik Setting
- 1.1 Configure DHCP Server and vlan interface
- 1.2 Configure DHCP Client
2 OpenWRT Setting
- 2.1 DHCP Server
- 2.2 VLAN DHCP CLient
  - 2.2.1 Add Virtual Device
  - 2.2.2 Add Virtual Interface
3 Common Problem

Mikrotik Setting

Configure DHCP Server and vlan interface

Configure MIkrotik DHCP server as usual, for this notes sake, I configure dhcp server as :

interface : ether2
ip > addresses : 192.168.88.1/24
ip > fi > nat masquarade ether2
ip > route > dst-address = 192.168.88.0/24 gateway=ether2
Add vlan on interface, on some article ,vlan naming convention use ip third subnet as name, In this case, Mikrotik dhcp server ip is 192.168.[88].1 so vlan id is 88
```
/interface vlan
add name=vlan-88  interface=ether2  vlan-id=88
```

Configure DHCP Client

Configure mikrotik to accept lease ip from openwrt,

Interface : ether2
ip > addresses : 10.5.51.254 network 10.5.51.1 (ip dhcp server openwrt)
ip > route > dst-address=10.5.51.1 gateway=ether2
ip > route > dst-address=10.5.51.0/24 gateway=10.5.51.1 (to be able to ping from local)

OpenWRT Setting

DHCP Server

default dhcp server setting on lan or bridge interface should works, on this case I set bridge-lan interface using ip 10.5.51.1/24

VLAN DHCP CLient

CLI version source Openwrt DOCs

Add Virtual Device

notes below are using LUCI.

Network > interfaces > devices > add new
device type choose vlan (802.1q)
base device use eth0 (or any physical eth on device)
Vlan id 88 (as per this notes)
device name eth0.88 (or any of your choices)

Add Virtual Interface

Network > interfaces > interfaces > add new
Name VLAN88 (or any of your choices)
Protocol DHCP Static
Device : eth0.88

Save and restart openwrt device.

Common Problem

cant ping if using unmanaged switch, this is because unmanaged switch usually only has 1500 MTU, and VLAN add 4 more byte to 1504 making random error.