Operation Cold House

Published on June 14, 2009

Status: My house is cold. I want to start playing with simple electronics before starting Operation Field, so have created Operation Cold House. This is just simply sticking a temperature sensor onto an Arduino, linking that up to my little home "server", and uploading ... Read more.

Fixing mysql warning message

Published on May 3, 2009

After restoring databases from one server to another I sometimes get this error on Ubuntu or Debian: error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' This makes a lot of sense, and the solution is pretty simple. If you look in: <pre ... Read more.

NetFlow into MySQL with flow-tools

Published on Dec. 21, 2008

I've been side-tracked on another little project, and keep coming back to NetFlow. For this project I'll need to access NetFlow data with Django, but this is a bit tricky. First, I'm sort of lazy when it comes to my own project; maybe not lazy, I just like taking ... Read more.

Integrating OSSEC with Cisco IOS

Published on Nov. 15, 2008

I rank OSSEC as one of my favorite pieces of open source software, and finally decided to play around with it more in my own free time. (Yup, I do this sort of stuff for fun). My goal was quite simple: send syslog packets from my Cisco to my "proxy" ... Read more.

Automated MySQL Backups

Published on Jan. 22, 2007

Historically I&#39;ve used the ever-so-popular AutoMySQLBackup script.&nbsp; While it seems to work just fine, I&#39;ve decided to give another solution a whirl.&nbsp; This solution, provided through Zmanda, seems to be less hackery and more enterprise.&nbsp; The instructions are very clear, and the backup test went as planned.&nbsp; Looks&nbsp; like ... Read more.

MySQL Compat

Published on Nov. 15, 2006

I've run into this error quite a few times, might as well toss blog entry about it: ERROR 1064 at line 17: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 7 One likely reason this comes about is because the data being ... Read more.

MySQL Replication

Published on Jan. 22, 2006

Whether you want to have a live copy to help distribute workload, or have a copy as a pseudo-hot-swapable backup like me, replicating your MySQL server is a must. While this isn't a foolproof solution (a DELETE/DROP command issues will replicate as well), it does help protect against data loss ... Read more.