IT Tips

Access

Blog History

Convert Unix Time to a Date Time Stamp

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...

read more

Encrypting the Raspberry Pi WiFi Pass

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"...

read more

View a remote Raspberry Pi Screen locally

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...

read more

Open Source Web Hosting Control Panels

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...

read more