Posts

ASUS ac and ax WiFi Router - SFTP Setup, /opt/libexec/sftp-server: not found

Product: ASUS WiFi routers WiFi 6, 6E, 7 Overview For some reason, ASUS' WiFi 6, 6E and 7 routers are failing SFTP (ftp extension on top of ssh) in their OOTB firmware. I have their old WiFi 5 RT-AC66U and WiFi 6 TUF-AX4200.  The SFTP works in older router, but in newer WiFi 6 router, it is constantly giving following error Connected to 192.168.50.1 sh: /opt/libexec/sftp-server: not found FATAL ERROR: Received unexpected end-of-file from server Even using WinSCP to copy file, it will return access denied (false alarm) message. This blog post is to provides solution how to make this work Procedure Preparation Get a USB drive has usable space of larger than 1GB Format as NTFS, or FAT32 if it is exFAT, or Linux partition Install the USB drive into the router Login to ASUS WiFi router homepage You should land in "Network Map" screen showing Internet status, WiFi status, number of clients connected, and USB 3.0 Clicks on icon USB 3.0 to show its status You must see Media Serve...

TrueNAS - Immich Installation Issue

Product: Immich Related Product: TrueNAS Overview This post is regarding Immich installation in TrueNAS by using its build-in "Apps" menu. TrueNAS provides OOTB Immich application which can be installed. The installation used existing dataset, which has ACL and username configured.  This leads to subsequent Immich installation failed to create files within the datasets due to user permission issue Error Message Log file: /var/log/app_lifecycle.log Container ix-immich-pgvecto_upgrade-1 service "pgvecto_upgrade" didn't complete successfully: exit 1 Resolution Possible Cause #1: Dataset has ACL enabled.  Therefore Immich installer (Docker) failed to create new directories inside one of the dataset Resolution: 1. Edit the dataset 2. Edit Permission 3. Edit ACL 4. Removes ACL - Clicks on "Strip ACL" button at the end of the screen Possible Cause #2: Dataset has different UNIX user assigned, and not using ACL.  Therefore Immich installer (Docker) failed to c...

BMW 3 Series F30 Common Known Issues/Problems

Common Problems for BMW F30 3 Series Overview This post is covering common problems in BMW F30 3 series .  It is mainly focus in late F30 (face lifted LCI) gasoline engine of N20 , and B48 (hybrid).  Face lifted model year is 2016 - 2019. M3 will not be in this consideration. The LCI model is as old as 9 years now, so the common issues are highly reliable. Post-LCI model (2016 - 2019) is highly reliable than pre-LCI model.  So if you are looking for F30 , F31 , F34 , it is recommend to buy year 2016 onward. Common Problems/Issues Issue #1 Lower Control Arm - Front facing The rubber bushing in the front facing lower control arm (LCA) is a maintenance item just like any earlier BMW 3 series. For typical and regular owner, it will degrade slowly without any noise at the early failure.  Visual inspection is the only way to catch early failure.  There is no safety risk during early failure. Once you start hearing noise (metal hitting metal), this need to be immedi...

Car Paint Maintenance - Water Spot Removal, old Wax removal

Following are cheap products that available in household to keep the car paint protected. To remove water stain, uses acidic liquid Citrix acid Vinegar To removes oil, grease, or old wax, uses ammonia base liquid Windex - any glass or window cleaner To removes oil or wax, uses alcohol base liquid: rubbing alcohol - 85% or higher This helps to prepare the car paint, or car rims/wheels before apply another layer of wax or ceramic coating.

WiFi Data Capturing on 2 Channels - Beginner Guide

Product: Linux Commands: airodump-ng, iw Overview I do not like to use the airmon-ng command to change the WiFi device name to follow its original device name, which it is hard for me to remember, e.g. device name wlp0s12u1. So in this post, I will use "iw" utility (previously called iwlist, iwconfig) that bundled with Fedora 41, or RedHat RHEL 9, to configure the WiFi adapter in monitor mode with my preferred device name.  The benefits are: I can define my own device name, e.g. wlan0mon I can use pre-defined device name in script "iw" utility offers more information in the WiFi network adapter as well as LAN NIC USB device detection is more accurate It can shows device name of my USB WiFi dongle without additional typing It can creates additional logical device that other new users like, such as wifi1, capture2024 Procedure Login to Linux as root, or use one of the following su - sudo su - Find out the physical device ID using "iw dev" command It will dis...

Oracle ORA-0600 on 17090 - When login with wrong password

Product: Oracle Database 19c Symptom When login to Oracle database to a specific user with wrong password, instead of getting ORA-01017, it shown following error, and disconnected the session $ sqlplus tester1/****** SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 26 11:12:16 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. ERROR: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [],[], [], [], [] This only affecting 1 DB user, and not global Analysis Tested with several DB user, and found that only affecting 1 DB user account Checked alert.log file, and found the trc file that generated Following is the content of the trc file with additional failure detail: 2022-10-26T11:12:17.635430-07:00 Unified Audit record write to audit trail table failed due to ORA-1012. Writing the record to OS spillover file. Errors in file /dbf/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_527371.trc  (incident=97297): ORA-00600: internal error cod...

Windows 10: Converting MBT to GPT+EFI Partition Type

Image
Product: Windows 10 Command: mbt2gpt.exe Sharing my experience to convert my MBT boot partition that run Windows 10 to GPT with EFI boot. Let me list down the step I took for my ASUS Z97-A motherboard: Run "CMD" as administrator Determine the disk number diskpart - utility to query disk partition Ref: https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/diskpart list - list all disks select disk 0 - this is my boot disk, i.e. C: detail - show all partitions. Ensure the partition size match my C: and double confirm disk 0 is correct Boot into recovery mode Click Start >  Settings to bring up Windows Setting (Control Panel) Click Update & Security menu Click Recovery menu Convert disk 0 MBT partition to GPT for entire disk.  This will convert entire disk to GPT partition design.  It is not possible to only convert specific partition mbt2gpt /convert /disk:0 Example output MBR2GPT will now attempt to convert disk 0. If conversion i...