04 Mar

Web page load speed monitoring with Munin

Here’s an example of the configuration:

[http_loadtime]
     env.target https://pydelion.com

Enabling:

ln -s /usr/share/munin/plugins/http_loadtime /etc/munin/plugins/http_loadtime

Test run:

[root@node1 ~]# sudo munin-run http_loadtime
loadtime.value 1.04
[root@node1 ~]#

Munin restart:

[root@node1 ~]# service  munin-node restart
Stopping Munin Node agents:                                [  OK  ]
Starting Munin Node:                                       [  OK  ]
[root@node1 ~]#

If you need external check you can use pingdom tools, for instance.

28 Feb

How to get number of registered users in WordPress databases (if you have a lot of databases)

Task

There are a lot of WordPress based websites (as well as not WordPress) databases on your box.  It’s necessary to get  number of registered users in WordPress databases only.

Solution

Collecting WordPress databases:

mysql -Bse " use information_schema; select TABLE_SCHEMA from TABLES where table_name like 'wp_users';" > wp_users.txt

Getting the numbers:

for i in $(cat wp_users.txt ) ; do echo -n $i " "; mysql -Bse "use $i ; select count(id) from wp_users " ; echo ; done | sort -rnk2 | less
27 Feb

ProFTPd server IP address binding on Centos 5.9

By default ProFTPd server on Centos 5.9 tries to resolve current hostname to get IP address to bind. So if it fails if you hostname doesn’t resolve. To make it listen the socket on your IP add this line to your configuration file:

DefaultAddress 192.168.1.1

It will do the trick. Just change it to your actual IP.

23 Feb

How to install Java on Fedora 18 box

[root@bender ~]# yum search openjdk
Loaded plugins: security, show-leaves
============================= N/S Matched: openjdk =============================
java-1.7.0-openjdk.i686 : OpenJDK Runtime Environment
java-1.7.0-openjdk.x86_64 : OpenJDK Runtime Environment
java-1.7.0-openjdk-demo.x86_64 : OpenJDK Demos
java-1.7.0-openjdk-devel.x86_64 : OpenJDK Development Environment
java-1.7.0-openjdk-javadoc.noarch : OpenJDK API Documentation
java-1.7.0-openjdk-src.x86_64 : OpenJDK Source Bundle
thermostat.x86_64 : A monitoring and serviceability tool for OpenJDK

Name and summary matches only, use "search all" for everything.
[root@bender ~]# yum install java-1.7.0-openjdk.x86_64

This is it.