Download your favorite Linux distribution at LQ ISO.
Go Back > Blogs > Musings on technology, philosophy, and life in the corporate world
User Name


Hi. I'm a Unix Administrator, mathematics enthusiast, and amateur philosopher. This is where I rant about that which upsets me, laugh about that which amuses me, and jabber about that which holds my interest most: Unix.
Python Combine 1 part magic with 1 part alien technology.
Rating: 2 votes, 4.50 average.

Restraining the madness: Python + SSH + pymssql = happy DBA

Posted 10-28-2009 at 07:42 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-28-2009 at 08:19 PM by rocket357

I routinely get requests from management like "I need a list of the urls and the sizes of databases for our <product_name> sites!" This, I can tell you, is NOT something I want to figure out by hand (not with 300 production databases and a slew of training, demo, test, etc... databases as well). No, there is a better, more relaxed way...a way that includes plenty of time for me to check my e-mail, go get a cup of coffee, and chat with my co-workers...

A bit of architectural...
Posted in Python
Views 2490 Comments 0 rocket357 is offline

Remote management of Linux systems via Python and ssh (Part 2)

Posted 02-03-2009 at 09:44 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 07:50 PM by rocket357 (modified code)

My last blogpost on Python/SSH seemed to be popular, so here I am again with a more in-depth look at what can be accomplished with this pairing.

To recap, I manage 300 databases, some M$ SQL Server, some PostgreSQL. There are a ton of Apache/Linux machines on our network and quite a few "traffic cops" based on Linux and BSD (as well as a few Cisco machines) for routing external traffic to internal machines. Pretty standard stuff. The IT department has a director, a network...
Posted in Python
Views 4924 Comments 0 rocket357 is offline


All times are GMT -5. The time now is 08:33 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration