Fork me on GitHub




Simple Diagrams of MySQL Schema

Jess Robinson’s SQL-Translator CPAN module translates and parses SQL statements. The SQLfairy project has some nice binaries that, among other things, use GraphViz or GD to draw pseudo-ER diagrams from SQL CREATE statements. Drawing a diagram of an SQL schema is as easy as sqlt-diagram --db=MySQL ...

more ...


Using wireshark to capture packets from a remote host

I spend a fair amount of my time debugging network and service problems on a few racks of Linux servers. Of course, they’re located in a data center (yes, just downstairs, but still not quite as comfortable as my office), and they’re all command-line only - no sense in ...

more ...


Vyatta VC5 - Snort alerts to syslog

I’m running a Vyatta vyatta router at home - in my opinion it’s pretty near “enterprise grade”, and I’m running the Community/Core (read: no-cost and almost all Free) on commodity hardware with great performance. Granted, I’m still on the older version (5 as opposed to the ...

more ...