Technology Insights

Use Nagios To Check Process Size And Provide Alerts Based on Process Megabyte Size

Nagios is an awesome open source application that provides a way to monitor pretty much anything that you can think of on your network. There are tons of plugins written for Nagios that will monitor anything from PostgreSQL database size to the number of users logged into a server. Today I needed to start monitoring the size of a Ruby process that has been growing out of hand so the below is what I came up with being the best solution. Follow the directions below to deploy a Perl script that will use SNMP to retrieve Linux server process size.

Technology Insights

Stopping nagios: kill: usage: kill [-s sigspec | -n signum | -sigspec] pid | jobspec … or kill -l [sigspec]

When attempting to stop or restart Nagios on CentOS I was receiving the below error. This has been an issue for me for quite some time however I was to lazy to even put a patch in place and always just would kill the Nagios processes by hand. Tonight I was modifying some Nagios configuration files and got enoyed enough that I first attempted to upgrade Nagios to the latest available on the rpmforge repo and when the problem still existed I decided to figure out a solution.

Technology Insights

MySQL Command To Update Just The Matching Part Of A Column

Earlier I set up a development WordPress site that mirrored a live WordPress installation. To do this I dumped the entire WordPress database using mysqldump and then imported it into a new database with mysql. Among other things that needed to be changed I needed to update any links that referenced the live site’s URL with the development site’s URL. Below I provide the command to make such an update to only a matching portion of a column in row located in a MySQL database.

Technology Insights

Disable All WordPress Plugins From MySQL CLI Or PhpMyAdmin

I was creating a mirror copy of one of my WordPress installations recently and needed a way to disable all plugins. During the process of creating the development WordPress mirror there were issues so I needed to disable all WordPress plugins via MySQL since at the time I could not login to the WordPress admin. Below I will describe listing all of the active plugins with one MySQL command and then disabling all of the plugins with another MySQL command.