Did you know LQ has a Linux Hardware Compatibility List?
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 06:42 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-28-2009 at 07: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 2449 Comments 0 rocket357 is offline

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

Posted 02-03-2009 at 08:44 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 06: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 4901 Comments 0 rocket357 is offline


All times are GMT -5. The time now is 04:50 AM.

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