Australia and the US - Best Buddies...

  

So I watched President Obama's speech today and amongst all the stuff about the US taking a greater presence and influence in APAC I noticed that "protecting Intellectual Property" one of the points.

Read more…

Comments

Federate or Die!

  

So here's how the Social Networking space has cycled for the last decade: you inevitably piss off your users, who then move to another network that then gains critical mass.

Read more…

Comments

The Haiku Social Desktop (and Buddycloud)

  

KDE is trying, Gnome is trying. Haiku is already half way there without really trying, though you have to look a bit closer to find what they have done at all.

Read more…

Comments

Remember Linux Counter?

  

Linux counter has been revamped!

Read more…

Comments

Encrypted Backup to Amazon S3

  

The following is a guide on how to do encrypted backups to Amazon S3.

Read more…

Comments

The HDCP Master Key

  

The HDCP Master Key, because I'm a rebel.

Read more…

Comments

Keeping MySQL Optimised

  

The following is a guide on how to keep databases in MySQL optimised.

Like a hard disk drive running a file-system such as FAT32, MySQL gets a bit fragmented during use. Databases that only have data inserted and read searially do not need optimisation run on the tables often. However, databases that are used in a transactional fashion need table optimisation performed regularly. You can write a script to manually run the MySQL "optimise" command iterating through a list of tables or you can simply use the "mysqlcheck" utility provided with MySQL (at least on Linux anyway).

The best way perform automatic optimisation is to create a Cron job. This one runs 11PM every Sunday and optimises every database on the MySQL server.

0 23 * * 0 mysqlcheck -u[your MySQL user] -o -A -p[your password here]

According to the mysqlcheck man page:

mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE So as you would guess this utility also has options to automatically check the validity of tables and repair them.

Comments

Root Login Detector

  

Getting an email alert when an account is logged in is really simple to set up.

To add a login detector to an account just append the following to the end of the user's (usually root) ~/.bash_profile and you can have an email alert sent to the desired address.

echo 'ALERT - Root Shell Access on:' `date` `who` | mail -s "Alert: Root Access from `who | awk '{print $6}'`" alerts@example.com

Comments

SSH Tunnel VPN Alternative

  

This is not a proper SSH VPN as described at http://www.debian-administration.org/articles/539 But if you are in the situation where you cannot use TUN/TAP modules such as on a Virtuozzo/OpenVZ based VPS and the hosting provider refuses to enable those modules for you then this is a way to be able to link back to internal services.

We will use SSH, SSH Keys for password-less authentication and AutoSSH to achieve a poor mans' (but secure!) VPN.

Read more…

Comments

How IPTables Work with libVirt

  

I saw this on a mailing list, and I thought it'd be great to keep and share.

Read more…

Comments

Contents © 2015 Daniel Devine - Nikola Powered - Flattr Me! Flattr this