An Easy Way To Delete All Tables From A MySQL Database - Introduction Sometimes you need to remove all the tables in a database.  For example, when you are installing or testing a web application.  There are GUI tools that can help but we are going to use the command line. Solution … Continue reading
My Favorite WordPress Plugins - Introduction This is a quick rundown of the plugins I like to use on my WordPress sites.  I do try my best not to install tons of plugins on my sites.  For the most part I use small lightweight plugins … Continue reading
HOWTO: Configure A UPS on Proxmox 5.x - Introduction Each of my proxmox servers has its own dedicated UPS.  My servers are low power and the UPS will keep them up for at least 2 hours.  I’m using a Cyberpower UPS connected via USB. This howto will use … Continue reading
Creating a MySQL or MariaDB Database and User for WordPress - Introduction These are just some quick notes on creating a mysql database and user.  This example shows how to set it up for WordPress. The Steps Just type the following lines.  Replace ‘dbname’, ‘username’ and ‘password’ with your values. mysql … Continue reading
Enable Opcache for PHP 7 and Up - Introduction If you are running PHP 7+ on a production server then you want to enable PHP’s opcache.  Your PHP applications will receive a well deserved speed boost. Configure PHP This configuration example is being done on Ubuntu 18.04.  Only … Continue reading
Ubuntu LTS 18.04 Base Server Setup Using Proxmox LXC Container - Introduction All of our servers will start with this install. This base server is based on Ubuntu 18.04 LTS Server.  This setup starts with a Proxmox LXC container instead of installing from an ISO.  I don’t explain much in the … Continue reading
Fix phpMyAdmin and PHP 7.2 Issues on Ubuntu 18.04 - Introduction The version of phpmyadmin for ubuntu doesn’t play nice with php 7.2.  The problems were fixed in newer versions of phpmyadmin. The Fix Just a few steps and things will be fixed. First visit and download the latest … Continue reading
HOWTO Virtual Mail Hosting on CentOS 6.x – Postfix MySQL Dovecot PostfixAdmin Amavisd-new Spamassassin Clamav - Introduction First things first. If you are a novice at linux I recommend that you should get help with setting this up. This is an advanced email server configuration. This configuration will allow you to serve multiple domains on one … Continue reading
HOWTO CentOS 6.x Virtual Web Hosting With Apache MYSQL and ProFTPD - Introduction There are many ways to do virtual websites under linux. The technique I am going to use is multiple domains on one ip address. I also didn’t want to use system users for the virtual hosts. So I decided … Continue reading
HOWTO CentOS 6.x Base Server Setup - Introduction All of our servers will start with this install. This base server is based on CentOS 6.x. There have been some changes since my 5.x howtos. Downloading the ISO Visit the CentOS website and download the minimum install ISO. … Continue reading
Howto Ubuntu 18.04 Setting up a DNS Server - Introduction DNS is a big player on the internet.  It gives us a way to assign names to all those IP addresses out there.  This howto is going to cover installing DNS and 3 configuration examples.  Keep in mind that … Continue reading
TIP: Disable Unattended Upgrades on Ubuntu 18.04 Server - Introduction When running a server automatic updates can be a dangerous affair.  When I setup my servers I disable this feature in Ubuntu. The Fix Edit /etc/apt/apt.conf.d/20auto-upgrades > sudo nano -w /etc/apt/apt.conf.d/20auto-upgrades Change the file to the follosing APT::Periodic::Update-Package-Lists "1"; … Continue reading
HOWTO Ubuntu 18.04 Setup An APT Caching server - Introduction When you are running a few Ubuntu servers you may want to think about setting up an APT caching server.  Installs and upgrades will go quicker.  You might save some bandwidth on your internet connection Setting Up The Base … Continue reading
HOWTO Ubuntu 18.04 Virtual Web Hosting With Apache, PHP, vsFTPD and Let’s Encrypt - Introduction The focus of this howto is for those users who need to host their own domains and maybe a few customer domains. This is not aimed at being used for mass web hosting. There are many ways to do … Continue reading
HOWTO Ubuntu 18.04 LTS Base Server Setup - Introduction All of our servers will start with this install. This base server is based on Ubuntu 18.04 LTS Server.  I don’t explain much in the howto so if you have a question leave a comment or use Google. Downloading … Continue reading
TIP: Working with Disk Images Under Linux - Introduction At times I need to work with disk images under linux.  Now I’m not talking about an image file that is a single partition. I’m talking about a disk image that represents a hard drive with an MBR and … Continue reading
TIP: Getting USB 3 to Work For a Windows 7 Guest Under Virtualbox - Introduction Virtualbox 5.x now offers USB 3.0 support.  However that doesn’t mean Windows 7 natively.  Windows 7 needs a third party driver to get things working.  But which driver? TIP Download the needed driver from Intel. … set-Family Install … Continue reading
TIP: Disable Author Pages in WordPress - Introduction In most WordPress websites the author pages functionality isn’t needed.   For search engines it can create unwanted duplicate links to your content. There are a few solutions to the problem.  A couple are:  get a plugin or create … Continue reading
Move MySQL or MariaDB Databases To A New Location - Introduction This quick TIP covers moving Mysql’s / MariaDB’s database storage to a different location.  This example was done on CentOS7. Moving the Databases First we need to stop mysql if it is running. Type the following: > service mysqld … Continue reading
Customizing a WordPress Theme By Creating a Child Theme - Introduction Sooner or later you will want to customize a theme that you are using.  You have up to 4 possibilities.  They range from easy to complex. First, many themes and the WordPress customizer provide many options for customizing a … Continue reading