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...
Welcome to the Internet Helpdesk Them: We sent a validation link to [email protected]: That address is not valid, please help me change it to [email protected]: We sent a link to [email protected] Repeat
https://www.netmeister.org/blog/whois.html whois -h whois.cymru.com 2406:3400:31f:2ad0:b43d:7214:76c6:def0 AS | IP | AS Name 10143 | 2406:3400:31f:2ad0:b43d:7214:76c6:def0 | EXETEL-AS-AP Exetel Pty Ltd, AU
https://wiki.debian.org/msmtp <== msmtp setup mentions creating an encrypted password file But when you try the command you get an error gpg --encrypt --output=.msmtp-zoho.gpg [email protected] - <<END ThisIsMySeCrEtPassword END # output gpg: no...
If you get errors like this: 2025/06/24 21:34:30 [error] 17690#17690: *99132 FastCGI sent in stderr: "PHP message: PHP Warning: Constant WP_POST_REVISIONS already defined in /var/sites/example.com/public_html/wp-config.php on line 109" while reading response header...