Importing a MySQL database with a new name where the original still exists

So you want to export your MySQL database then import it on the same server with a new name.   I tried this several times and using the SOURCE command inside MySQL or just mysql -p < db.sql both resulted in the database re-importing over the original name.   To fix that run: sed -i […]

How to caption an image – HTML5

How do you caption an image in HTML? One way is using figure tags. Without them, you might use the following:   <img src=”image.jpg” align=”center” />   …to create this: So, you have an image using the above. How do you make it into an image with a caption? <figure> <img src=”image.jpg” align=”center”/> <figcaption><center>Caption goes […]

Installing Aegir 3 on Debian 8 Jessie/Ubuntu with Nginx

So, after a few failed attempts at installing the Aegir 3 Drupal control system we hit upon this “recipe” as what works for us currently on a fresh install of Debian 8 Jessie or Ubuntu 14.04. This assumes you are logged in as root. First, update and upgrade your system. apt-get update && apt-get upgrade […]

Proxmox KVM virtual machine: Cannot delete due to missing storage

Today we encountered a situation where a Proxmox system’s KVM virtual machine refused to delete after the storage volume that it’s virtual HDD resided on was lost; trying to delete the KVM from the web GUI resulted in the following error:   TASK ERROR: storage ‘proxmoxHDD’ does not exists   Attempting to delete it from […]

ZFS on Linux: How to find the arc stats (was arcstat.py)

This has now changed; run the following to find the adaptive read cache stats (ARC):   cat /proc/spl/kstat/zfs/arcstats   You can gleam some really useful information out of how your RAM is being utilised and what your required ARC size might be from the results – this may be a topic for a future post, […]

How to protect your CentOS server from the Shellshock exploit

Shellshock is quite a serious security hole found a couple of days ago in Bash; to check whether your CentOS server is vulnerable run the following in a terminal: env VAR='() { :;}; echo Shellshock vulnerable!’ bash -c “echo Bash Testing” If your system is vulnerable, you will see: Shellshock vulnerable! Bash testing If it […]

How to protect Debian from the Shellshock exploit

Shellshock is quite a serious security hole found a couple of days ago in Bash; to check whether your Debian server is vulnerable run the following in a terminal: env VAR='() { :;}; echo Shellshock vulnerable!‘ bash -c “echo Bash Testing” If your system is vulnerable, you will see: Shellshock vulnerable! Bash testing If it […]

How to protect Ubuntu against the Shellshock exploit

Shellshock is quite a serious security hole found a couple of days ago in Bash; to check whether your Ubuntu server is vulnerable run the following in a terminal:   env VAR='() { :;}; echo Shellshock vulnerable!‘ bash -c “echo Bash Testing”   If your system is vulnerable, you will see:   Shellshock vulnerable! Bash […]