Reducing Table Size of WooCommerce Scheduler Actions and Logs using phpMyadmin
The Scheduled Actions that sit in WooCommerce Action Scheduler can get bloated with thousands of actions piling up, just stuck in a failed, canceled, pending or complete state. This can result in very large database tables in particular wp_actionscheduler_actions and wp_actionscheduler_logs tables. Below find out how to reduce these WooCommerce tables. Since the states…
Read MoreSet Up Valet on macOS for Local WordPress Development
This is a guide on how to set up Laravel Valet on macOS for a WordPress local development environment. Using Valet as a WordPress local development solution has the main benefits of speed, being lightweight and using fewer configurations to go wrong than say a solution like Vagrant. There is a 2nd related article that…
Read MoreTweaking RunCloud Servers After Deployment
Here are some references for various fix ups or tweaks that I apply to servers with the RunCloud control panel. These are not all done inclusively, it depends on the need. Change root password The root password initially generated by your host provider might be on the weaker side always best to change and strengthen it.…
Read MoreTurn off SSH passwords in Ubuntu, connect via SSH keys only
Once you have a successful connection to your remote instance with SSH keys, it is better practice to disable SSH Password Authentication to mitigate further bruteforce password attempts, this coupled with a service like Fail2ban will further strengthen your Virtual instance. Remote into your VPS via SSH and open the SSH config file: nano /etc/ssh/sshd_config…
Read MoreInstall and configure Fail2ban for CloudPanel on Ubuntu 22.04
CloudPanel out of the box comes with an application to deal with brute force attacks on SSH, NGINX and WordPress, only SSH has a configuration, the app is called Fail2ban. Fail2ban is an app which bans access to your site from IP addresses which are trying to login to your services such as SSH on port…
Read MoreAdd Monit to monitor MariaDB or MySQL database on a CloudPanel instance on Ubuntu 22.04
Get up and running with Monit on Ubuntu 22.04 on CloudPanel. Monit can be used to monitor your MariaDB or MySQL database and restart it if it is stopped – the database may be stopped due to a lack of server resources, or maybe killed by the OOM-Killer process which occurs when there is a…
Read MoreSet up malware scanner LMD Maldet and ClamAV on a CloudPanel instance
How to set up a Maldet malware scanner with LMD Maldet and ClamAV on a CloudPanel server instance. One of the popular and open source malware scanners is an app called Linux Malware Detect and works well scanning any Linux web server, it keeps a daily updated database of known malware exploits from an updated…
Read MoreAdding 7G WAF Firewall for NGINX to CloudPanel
The 7G WAF firewall by Jeff Starr at Perishable Press is a great addition for server level WAF protection, here is a guide on how to add it to CloudPanel‘s NGINX stack. Download the 7G WAF NGNIX version Download the 7G WAF or from the origin page here. Extract the archive and find the 2…
Read MoreDisable default WordPress emails on WordPress, themes and plugin updates
The PHP constants below will disable the default WordPress emails on WordPress, themes and plugin updates. They should be added into your wp-config.php file. // Disable WordPress core update emails add_filter( ‘auto_core_update_send_email’, ‘__return_false’ ); // Disable WordPress plugin update emails add_filter( ‘auto_plugin_update_send_email’, ‘__return_false’ ); // Disable WordPress theme update emails add_filter( ‘auto_theme_update_send_email’, ‘__return_false’ );
Read MoreAdd a Swap Partition to a Ubuntu 22.04 instance
Below is a guide on how you can add a swap disk/partition to a Ubuntu 22.04 instance, I would recommend that you have a decent amount of hard disk space available to avoid constant use of the swap drive, a process called swapping. Generally a swap partition should be equal or half the amount of…
Read More