LogWa

Author: llyyee

  • BMW 2011 328i maintainance record

    Partpricesourcedatenote
    Interstate AGM Battery H8 900CCA 95Ah 160RC$169Costco06-2024
    NGK 95712 Spark Plug $9 x6rockauto07-2024
    MANN C27114 cabin air filter $17.5rockauto07-2024
    Windshield Seal – Genuine BMW 51317061967$30fcp07-2024
    BMW Manual Transmission Drain/Fill Plug – Genuine BMW 23127602815$15fcp07-2024
    BMW 75W90 MTF-LT-3 Manual Transmission Fluid (1 Liter) – Genuine BMW 83222339221$39 x2fcp07-2024
    BMW Battery Mounting Screw – Genuine BMW 61217577620$9.2fcp07-2024
    75W90 Differential Fluid (1 Liter) – Genuine BMW 07512293972$28 x2fcp07-2024
    Magnetic Differential Drain/Fill Plug – CRP 33117525064$10fcp07-2024
    BMW Power Steering Reservoir Cap Seal – Genuine BMW 32411128333$8.7fcp07-2024

  • Asrock Deskmeet PSU Fan mod to Increase Case Ventilation

    ASRock DeskMeet is such a fun SFF PC to play with. It come with a ASRock B660-ITX motherboard with only 8 liter compact size and capable of tweak memory timing.

    The problem of such a small case is that it will become a hot box under load quickly and eventrually lead to throttling.

    The only way to fix this problem is create a negative pressure within the case. But there isn’t space to add a fan into such a tiny case, so my solution will be swap the direction of the fan to create negative pressure, also use the best fan I can get for the best “Static Pressure”.

    disassemble the case according to manual

    Rip off the fan grill by a plier to increse the static pressure also reduce wind noise

    Make sure the fan can suck the heat from the case

  • Add AV1 HEVC VP9 hardware decoder to Browser in Windows 11/10

    First and formost, everyone of us should feel shame about using Windows operating system. There are far better OS our there like Linux and let’s support free and open source as much as possible.

    Check if your GPU/CPU support hardware decode:

    Steps to add missing decoder and codec:

    1. Make sure “Movies and TV” app installed, otherwise please download and install from Microsoft https://apps.microsoft.com/detail/9wzdncrfj3p2?hl=en-us&gl=US
    2. Install “Media feature pack” from “Settings”, search keyword “Optional Features” and then toggle on “Media feature pack”
    3. Search and Install VP9, AV1 and HEVC codec from Windows Store. VP9 and AV1 are free. HEVC cost $1 USD but you don’t need it for Youtube
    4. check GPU tab in Windows “task manager” to see if video decoding works.

  • Setup fail2ban for MariaDB or Mysql running in Docker container

    Install fail2ban

    • Prevent hacker brute-force into server by public IP and public port
    • Run these command to install fail2ban
    sudo apt install fail2ban
sudo systemctl enable fail2ban --now
sudo systemctl status fail2ban
sudo fail2ban-client status
sudo fail2ban-client status sshd
sudo fail2ban-client status mysqld-auth

    Expose database logs from container to host machine disk

    • check existing logs in Docker container docker logs some-mariadb-container-name
    • map custom cnf folder to MariaDB/Mysql Docker volume according to https://hub.docker.com/_/mariadb
    • see a complete list of available mariadb config.cnf options, just run docker run -it --rm mariadb:latest --verbose --help
    • add this line to your docker-compose.yml or portainer volumes: - /home/ubuntu/mariadb/cnf-folder:/etc/mysql/conf.d
    [mariadb]
log-basename=master1
log-warning=2
expire-logs-days=30
    • log will wirte to disk at /home/ubuntu/mariadb-mysqldata/master1.err
    • sudo vi /home/ubuntu/mariadb-mysqldata/master1.err check running logs
    • restart mariadb container

    Add mariadb or mysql to fail2ban jail

    • sudo vi /etc/fail2ban/jail.local
    [mysqld-auth]
enabled   = true
port      = 58968
filter    = mysqld-auth
logpath   = /home/ubuntu/mariadb-mysqldata/master1.err
findtime  = 3600
maxretry  = 2
bantime   = 86400
    • restart service sudo systemctl restart fail2ban.service
    • sudo fail2ban-client status
    • sudo fail2ban-client status mysqld-auth

  • Root Hisense A5 with latest firmware and Magisk

    Download firmware package

    thank you user cherub from coolapk making this root package!

    http://cherub.lanzout.com/ioaX601iynuh with passcode gir4

    Above package include:

    • Magisk v24.3
    • QPST installer with driver
    • Root files for Hisense firmware L1657.6.12.01.00
    • Original files for Hisense firmware L1657.6.12.01.00
    • in case anyone want to unbricking or recover to factory condition.

    Root process

    • install QPST
    • install Magisk-v24.3.apk on the phone
    • enable developer option, enable usb-debugging
    • run Enter_EDL.bat to entering into EDL-mode AKA 9008 mode
    • open QFIL, load files from Modified_IMG folder and make sure select emmc storage type. (please check .png file for reference)
    • Reboot the phone and open Magisk

    Unbrick or recovery to stock condition

    • uninstall Magisk modules
    • flash everything in Original_IMG folder include boot and vmeta partition.
    • reboot the phone and uninstall Magisk.

    WARNING

    Google drive backup of HisenseA5_Root_12.01.00.7z flash package https://drive.google.com/file/d/1UmSWsLt51XyXaAjgAB5Cflf5ErcHxE0-/view?usp=sharing

    keep vision_musicPlayer and vision_vpnDialog

  • Microsoft AI TTS engine turn any book to Audible for free

    Download Android TTS app

    • Download the latest release from https://github.com/ag2s20150909/TTS
    • replace system default TTS with above engine

    Open books in 3rd party app

    • Moon+ reader pro (paid)or Legado https://github.com/gedoor/legado (free)
    • Set TTS engine to system TTS
    • viola! Turn any book to "Audible" for free

  • Migrate to Obsidian from Onenote and sync to Github

    migrate from OneNote

    convert OneNote to markdown script:

    https://github.com/theohbrothers/ConvertOneNote2MarkDown

    need OneNote desktop and office word installed. Run script with default sample config file is enough.

    cleanup, run search/replace regex on .md file:

    delete all image ALT(Evernote read text from image and store them in ALT tag)

    search !\[.+\]\(..\/media\/

    replace ![](../media/

    delete image width/height

    \)\{width\=.+\"\}

    delete multiple lines

    search ^[\r\n]{2} and replace it with single line repeatedly

    Sync desktop vault to Github and browse note from mobile by Github app

    • Create private repo

    • Upload local ssh key to Github

    • Run git command in Obsidian vault folder: I am not a fan of Obsidian 3rd party plugin, so I run push/pull command manually to gain more control.

    git init
git remote add (Please follow instruction from Github)
git add .
git commit -m "initial commit"
git push origin main
    • Install Github official app from mobile store. (Browsing notes from Obsidian official app with several GB of vault is not pleasant)

    Use "web-clipper" browser plugin to save web page to github repo

    • Download web-clipper plugin from https://github.com/webclipper/web-clipper

    • Setup Github account in web-clipper settings. Connect your Obsidian repo to web-clipper via Github token

    • Save any web page from web-clipper

    • run git pull command so that you can see it in Obsidian desktop app.

  • Hisense A5 root, debloat & unbrick

    Unbrick or Factory rest back to firmware 6.09.06

    I personally prefer older/cleaner/lighter firmware so I won’t demonstrate with the newer version of ROM.

    Unbrick

    Download stock 6.09.06.00 boot, recovery, and vbmeta partition image.

    Entering EDL-Mode https://forum.xda-developers.com/t/hisense-a5-how-to-enter-hardware-edl-mode.4103929/. (Optional: purchase EDL cable. search keyword 9008 cable, qualcomm cable, xiaomi 9008, mi 9008 on aliexpress or taobao)

    flash boot, recovery, and vbmeta partitions. following guide ([Tutorial] How to use QFIL to flash to a single partition on Qualcomm) https://forum.hovatek.com/thread-31476.html

    Restore to factory settings

    6.09.06.00 rom download https://drive.google.com/open?id=1JBzsFrtGtIXLYTPTMA2cc9spp_dxF_WX

    Flash above rom in TF-mode https://forum.xda-developers.com/t/hisense-a5-root-gapps-customizer-r05-06-10-04-00.4097951/post-82575517

    Root & Magisk

    Follow instruction https://www.chinahandys.net/hisense-a5-playstore-guide-english/ but do not install Google suite/playstore for better privacy and less memory usage. Install apkpure and f-droid instead of google family spyware.

    Download Magisk v23.0 install apk from the official release page https://github.com/topjohnwu/Magisk/releases and install it. Don’t install version higher than v23. Launch it and confirm the “Requires Additional Setup” box with “Ok”. DO NOT upgrade Magisk further otherwise can potentially brick the phone. DO NOT update Magisk within Magisk, otherwise can destroy the boot partition.

    Debloat & Cleanup

    Install De-bloater in Magisk or Total Commander with root permision. Follow JLowe’s instruction https://forum.xda-developers.com/t/hisense-a5-info-thread.4101945/post-82795057 

    in system/app are only:
/system/app/CertInstaller         don't remove
/system/app/CtRoamingSettings        don't remove / freeze & use only if roaming
/system/app/Eink_Settings        don't remove / Settings Clearview per App!!!
/system/app/ExtShared            don't remove
/system/app/HardwareDetection        don't remove
/system/app/NetworkSelect        don't remove 
/system/app/QtiTelephonyService      don't remove
/system/app/SimSettings          don't remove
/system/app/Vision_AutoRunManager    don't remove    
/system/app/Vision_Bluetooth        don't remove
/system/app/Vision_CalendarProvider    don't remove
/system/app/Vision_WifiDetector        don't remove
/system/app/WeatherWidget         don't remove / just freeze / navigation bar flickering! com.hmct.clock.systemwidget
/system/app/WebViewGoogle         don't remove

in system/priv-app are only:
BlockedNumberProvider
CallEnhancement
CalllogBackup
/system/priv-app/CarrierConfig                 don't remove
/system/priv-app/com.qualcomm.location            don't remove   / GPS
/system/priv-app/DefaultContainerService        don't remove
EinkLauncher
/system/priv-app/ExtServices                   don't remove
/system/priv-app/ExternalStorageProvider        don't remove
/system/priv-app/FusedLocation                 don't remove /GPS
/system/priv-app/InputDevices                  don't remove
/system/priv-app/MmsService                    don't remove
/system/priv-app/MtpDocumentsProvider            don't remove  / MTP
/system/priv-app/ProxyHandler                  don't remove
/system/priv-app/QcomMediaProvider            don't remove 
/system/priv-app/SettingsIntelligence            don't remove / settings needed
/system/priv-app/SettingsProvider            don't remove
/system/priv-app/Shell                         don't remove
/system/priv-app/StatementService            don't remove
/system/priv-app/StorageManager             don't remove
/system/priv-app/TelephonyProvider            don't remove
/system/priv-app/TeleService                   don't remove
Calendar
/system/priv-app/Vision_CallSettings            don't remove
Camera
Common
Contacts
/system/priv-app/Vision_ContactsProvider        don't remove
Dailer
/system/priv-app/Vision_DocumentsUI            don't remove
/system/priv-app/Vision_DownloadProvider        don't remove just freeze
/system/priv-app/Vision_DownloadProviderUi        don't remove
Firewall
Launcher
Mms
/system/priv-app/Vision_MmsProvider            don't remove
MusicPlayer
/system/priv-app/Vision_NetworkSetting            don't remove
/system/priv-app/Vision_PackageInstaller        don't remove
/system/priv-app/Vision_PermissionManager        don't remove
/system/priv-app/Vision_RecentsService            don't remove
/system/priv-app/Vision_ScreenOffGesture        don't remove
/system/priv-app/Vision_Settings            don't remove
Sos
/system/priv-app/Vision_SystemUI            don't remove
/system/priv-app/Vision_Telecom             don't remove
ToolsForSystemUI
touchPalContacts
VpnDialogs

    Apps installed:

    Duckduckgo, FeedMe, Conversations, Magisk, Termux, Ice Box, F-Droid, Solid Explorer AdAway, De-Bloater, AFWall+, bunch of SimpleMobileTools apps

    Reference:

    https://forum.xda-developers.com/t/hisense-a5-info-thread.4101945/