ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
Update root password MySQL
ValidatorException: PKIX path building failed
When using self-signed certificates you might come across the following error: > "javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target" To solve…
Redirect HTTP to HTTPS cPanel
There are a couple of ways to ensure that all non-secure connections (HTTP) are forced to use a secure connection (HTTPS). The simplest of which is to go the root…
Install fail2ban Ubuntu 18.04
If you're struggling to install fail2ban and being notified that the package cannot be found, you simply need to enable the universe repository and update the package list. sudo add-apt-repository…
Lightning plugin not compatible with Thunderbird 60 SOLVED
For some reason compatibility issues arise with the latest version of Thunderbird and the Lightning calendar plugin. To resolve this you can follow these steps: Uninstall the Lightning add-on Exit…
Setup Traefik with Consul ACL in Docker
Start by going to your home directory: cd ~ Next, spin up the Consul Docker container with the following command: docker run -d -v $PWD/consul/data/:/consul/data/ -v $PWD/consul/config/:/consul/config/ -e 'CONSUL_LOCAL_CONFIG={"skip_leave_on_interrupt": true,…
Fix Unms is starting issue – Redis
You might receive this message after upgrading UNMS. To resolve, simply run the following 3 commands: sudo ~unms/app/unms-cli stop sudo ~unms/app/unms-cli fix-redis-aof sudo ~unms/app/unms-cli start
1:1 NAT Ubiquiti Edgerouter
Assuming you have a static IP you'd like to map to an internal IP with all the ports open, then you'd need a 1:1 NAT. This is straightforward to setup…
Delete files older than x many days Ubuntu Terminal
To delete files older than 'x' many days, you can execute the following command in the terminal: find /path/to/ -type f -mtime +7 -name '*.zip' -execdir rm — '{}' ;…
WooCommerce only show "completed" orders in reports
By default WooCommerce reports consider "on hold", "processing", and "completed" statuses as successful sales in the reports. I personally think only the "completed" status should be considered as a successful…









