Author: LloydLeung

  • IoT and wifi system security

    Many people now have Amazon echo/dots / Google home / Apple HomePod, smart TVs, smart thermostats, etc… What happens if one of those get hacked? They’re already on your system? they’re authorized and allowed on your network… now what? That’s why you should have a WiFi network dedicated to IoT devices on a separate VLAN.…

  • Fast rsync in the year 2020

    TL;DR; rsync -aHAXxv –numeric-ids –delete –info=progress2 -e “ssh -T -c aes128-gcm@openssh.com -o Compression=no -x” <source> <target> options: a – archiveH – preserve hard-linksA – preserve ACLSX – preserve extend attributesx – don’t cross filesystem boundariesv – verbose–numeric-ids – don’t map uid/gid values by user/group name–delete – delete extraneous files from destination dirs–info=progress2 — show progression-e…

  • Teaching your kid how to ride a bike

    It’s been a while since I posted anything… Kids/family have taken up a lot of time. Dylan’s started to ride two wheels, learning about the Pedrin method was a little too easy to teach him. Dylan was in training wheels for a while and was ready, as he could ride a few meters without either…

  • Apache Vhost Macro / Variables

    [update: 2020-05-20] There does seem to be a conflict with Let’s Encrypt certbot. You’ll need to manually run updates. I’ll update once I figure it out, how to do it more automated. Looks like possible race condition for the ghost, and then the SSL… but since you’re defining them by macro’s it’s not so bad.…

  • Mac Docker PHP Xdebug and Api-platform and PHPStorm.

    Having trying to debug without xdebug felt like my hands were being tied behind my back. Took a while, but my friend Bart was able to help me get this up and running, after lots of trouble shooting. The way it seems, api-platform sets docker up in distinct containers: client db admin php api cache-proxy…

  • Mac OSx High Sierra Homebrew switching between PHP@7.2 and PHP@5.6

    Homebrew recently deprecated the repo https://github.com/Homebrew/homebrew-php as of March 31st, 2018. So, how do you install PHP@5.6, and/or PHP@7.2 (or @7.0, or @7.1, these are untested, but I assume will work). I work on some legacy sites, that require switching between the versions.   So, lets run through this… I’m going to assume you cleaned…

  • Autel maxitpms pad on a mac? Yes, and no.

    Can you run Autel MaxiTPMS Pad on a mac? Directly, no. Through virtual box, yes. Install virtualbox and Oracle VM VirtualBox Extension Pack, both from: https://www.virtualbox.org/wiki/Downloads Download the windows 10 trial image/iso/dmdk/ovf, which is free, from Microsoft. linke: https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/ After you’ve unzipped the image Double click the ovf to launch it with virtualbox. Ensure you add USB…

  • Automation…

    Controllers: Raspberry PI for the logic. it’ll have it’s own 802.11n USB adapter   Project Ideas: The promise, is to use an ESP8266, to control a bunch of relays.  Using the Raspberry PI for logic control. DIY 1 plug relay – HRV control. Check to see (via the NEST) if the humidity is high or…

  • rsync target permissions and ownership

    Add these flags, to set the target permissions, and ownership –chmod=a+rwx,g+rwx,o-wx –chown=OWNER:GROUP the chmod is 774.    

  • Excel date to unix time integer or unix time to excel date.

    FROM unix to excel date. [plain]=CELL/(60*60*24)+"1/1/1970"[/plain] From excel date to unix time. [text]=(CELL-"1970-01-01")*60*60*24[/text]   where “CELL” is your excel cell you’re trying to handle. CELL can also be replaced with the NOW() function.