Configure WireGuard L3 Routing + NAT on Debian Linux

Preface The company I work for uses a DrayTek router model that does not support WireGuard. By running WireGuard on a Debian VM instead, we gain: Performance decoupled from router hardware: the VM can scale (CPU/RAM/NIC), giving better crypto throughput. Clean, flexible routing: send only specific subnets (e.g., 192.168.0.0/24, 192.168.10.0/24) through the tunnel—no extra client-side commands. Keep personal internet as-is: regular web traffic does not exit via the company gateway, so external sites don’t see the company IP and your browsing isn’t slowed by the office uplink. Broad client compatibility: easy setup on Windows/macOS/Linux and mobile. Goal: Let external Windows... To read more, click here

Blocking Outbound SMB Connections from Internal PCs — DrayTek Vigor2925 Case Study

Background Recently, multiple internal workstations were found repeatedly initiating SMB (445 / 139 / NetBIOS) connections to various public IP addresses. Because the company policy only allows internal SMB access to a designated NAS server, this activity was deemed abnormal and suggested potential malware infection or misbehavior. In addition to the security concern, the excessive outbound SMB traffic also caused noticeable network performance degradation. Users reported that many websites became slow to load or failed to open entirely. Firewall inspection revealed that the abnormal SMB traffic was consuming significant bandwidth and disrupting WAN load-balancing behavior. Investigation and Malware Removal Upon... To read more, click here

The Lazy Dev’s Guide to Bulk Insert: Efficiently Sync Data from Access MDB to SQL Server

Background The target computer system is outdated, running Windows Server 2003 (which is essentially Windows XP), and the latest framework it can support is .NET Framework 4.0.3. The goal is to create a headless application that executes automatically upon startup and provides simple file-based outputs, allowing easy access for other legacy programming languages. Prerequisites You need to install the following NuGet packages in Visual Studio. The choice of packages may depend on your specific needs. (For details on how to install NuGet packages, please refer to online documentation.) CommandLineParser [v2.9.1] NLog [v5.4.0] Dapper [v1.50.2] DataBooster.SqlServer [v1.8.4] Additionally, since we want... To read more, click here

How to Fix the Black Screen Issue When Switching to Desktop Mode on Steam Deck

When you encounter a black screen while attempting to switch to Desktop Mode on your Steam Deck, it can be frustrating. However, there is a simple solution to help resolve this issue. Here is a step-by-step guide to solve the problem: Solution Switch Accounts: First, log in to a new Steam account through the game interface. Use this new account to switch to Desktop Mode. If the switch is successful, delete all files (excluding folders) located at Home/.local/share/kscreen and Home/.local/share/kscreen/outputs. For safety, you may choose to cut and back up these files to another location before deleting them from the... To read more, click here

Windows IIS 8 Website Unexpected 403.3 Authentication Error

layout: post title: Mysterious 403.3 Authentication Error on Windows IIS 8 Website date: 2021-09-15 11:49 +8 description: Adjusting folder permissions on Windows. toc: false share: true comments: true tags: IIS Windows Note This article provides a solution for Windows IIS 8 and later versions. Problem Check Create a new website and create a simple helloWorld.html file. If it's in a subdirectory, remember to convert it to a "Web Application." Grant the folder permissions to "Everyone" with "Full Control." If this solves the problem, then it is confirmed to be a permissions issue. Main Solution In wwwroot or the root directory... To read more, click here