Yearly Archives: 2014

How to install MariaDB on Ubuntu

Here is the best link to the installation procedures that is available. https://downloads.mariadb.org/mariadb/repositories/#mirror=aarnet_pty_ltd

Posted in Linux, MariaDB, MySQL

Adding user to an existing group

I’ve always needed this quick snippet when adding users to existing groups. Here it is. usermod -a -G groupName userName

Posted in Linux Tagged with: , ,

How to create swap memory for your Linux server

Firstly we’d confirm how much memory you have on your server: free -m There’s no definitive rule when it comes to how much swap is enough, but try somewhere between 1-2 times the amount of physical RAM your server has.

Posted in Linux Tagged with: ,

UFW Allow access to IP on a specific port

In order to allow a specific IP address to access a specific port on your server protected with UFW, issue the following command: ufw allow from [ipAddress] proto [tcp|udp] to any port [port] To delete this rule issue the following

Posted in Security Tagged with: , , ,

MySQL to CSV command line

Sometimes I need to dump the contents of a query out to a CSV file for reporting. Here’s the best method I’ve found thus far to do this on the command line. mysql –user=wibble –password wobble -B -e “select *

Posted in MySQL Tagged with: , ,

How to install GD on Ubuntu

This little tidbit is a life saver! sudo apt-get install libgd2-xpm-dev

Posted in Linux Tagged with:

SSH into machine without password

Being a sys admin I’m constantly logging in and out of machines to perform actions and maintaining a list of passwords, let alone being able to access those passwords for a two second job is a pain in the ass

Posted in IT Tagged with: , , , , ,

Self Signed SSL Certificate

When it comes to creating a SSL cert for testing, the best way is to roll your own. Follow these instructions and you’ll have your CRT file in no time. openssl genrsa -des3 -out website.key¬†2048 openssl req -new -key website.key

Posted in IT Tagged with: , , , , ,

Hello world! Again!

I’m in the process of updating my website and will be bringing across my old content when I get a chance. Thanks to everyone for your support!

Posted in Uncategorized Tagged with: