Technical Posts

A MySQL database field with times similar to '1752463231.455827' How to query the time and show it as '2025-07-14 17:22:28.911723' -- set timezone SET time_zone='Australia/Melbourne'; USE mydb; SELECT created_on, from_unixtime(created_on) as event_melb_time FROM...

Search for a specific package on packagist from the composer command line Here are some options to narrow down the search for a package. If your composer.json has custom vcs repos composer show -a will list thos # show everything composer show -a # show everything...

By default raspi-config adds an unencrypted WiFi password to the wpa_supplicant.conf file. To remove it do the following: # get root sudo su - # change to the wpa_supplicant dir cd /etc/wpa_supplicant # append a hashed Wifi password block wpa_passphrase "YOURSSID"...

Installed VNC using rasp-config => Interface options => VNC Wanted to avoid having port 5900 listening on the local subnet (0.0.0.0:5900) but only available if I SSH to the box and connect via SSH tunnel # create /etc/vnc/config.d/vncserver-x11 # contents localhost=1...

I have a Raspberry Pi that shows a clock on its screen. It is over an hours drive away How do I display a remote X screen locally on my computer? VPN to the remote site SSH to the Pi ssh -l username ip_of_pi -L 5973:localhost:5900 # in ~/.ssh/config Host p0 mahclock0...

Just trying some control panels So far: https://www.cloudpanel.io The installation script asks few questions but I was happy with all the defaults This one I really liked the simplicity and the nginx file editor window Was very easy to add a site and get running with...