MySQL: Query to calculate database size.

So Guys, how do you calculate the size of your databases on db server using a simple & single query..
.
.
.
Well this thing is easily achievable by a simple query. For this you need to query information_schema, which will result you the database size and other information.

   SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size in GB" 
   FROM   information_schema.tables GROUP  BY table_schema;

:)

NSClient - ERROR: Could not get data for 5 perhaps we don't collect data this far back?

Error : NSClient - ERROR: Could not get data for 5 perhaps we don't collect data this far back? 
This is the error I received a notification from my monitoring tool Nagios for a host against CPU Usage, which is quite annoying to deal with. I made some research around it and finally got a solution to fix this issue.

Explanation: This issue is around the performance counter of the server. Somehow Nagios is not able to read those performance counter.

Managing Old logs on server using Windows batch script

Most of the time system administrators are dealing with old log files like backing up the old logs manually and removing the original logs. To reduce their headache, here we have a small script, which provides flexibility to manage those old logs in very handy manner. Administrators just need to set the variables in the script as per there requirement and let the script do the magic.

About the script: This script takes the backup of all the log files older then specified number of days and after backup, it automatically deletes the original files and spare the disk space. 
A job can be schedules either on daily or weekly basis to execute this script and manage old log files on the server.

Configuring James as Windows Service

We have gone through about James server in previous post. In this post, we'll see how we can configure Apache James as windows service.
After putting Apache James at specified location, you can start James using run.bat (location: apache-james3.0\bin\run.bat). Run.bat file will start the James server but will not configure it as windows service.

Linux: netstat command

netstat (network statistics) is a command used for monitoring network connections (incoming & outgoing) as well as viewing routing tables, interface statistics etc. netstat is available on all Unix-like Operating Systems and also available on Windows operating system.

Features:
a. Useful in terms of network troubleshooting (traffic, ports, network connections), networking statistics and performance measurement.
b. netstat is one of the most basic network service debugging tools, telling you what ports are open and whether any programs are listening on ports.
c. provide detailed information about how a computer is communicating with other computers or network devices.

Grant Users Access to your Outlook Calendar

Outlook Calendar -  a very powerful tool to manage your emails, appointments, meetings, calendars, notes, contacts etc. Everyone has used the Outlook product of Microsoft, which has really made our lives easy. We all know that we can schedule our appointments and send meeting invitations in Outlook calendar but today we are going to reveal another trick to grant user access to our calendar so that other person (having permission) can edit our calendar. You must open Microsoft Outlook to perform the steps below:

Error: Could not open command file ‘/usr/local/nagios/var/rw/nagios.cmd’ for update!

Error: Could not open command file ‘/usr/local/nagios/var/rw/nagios.cmd’ for update!,An error that comes up from time to time and is quite annoying to deal with, I found a way to fix the problem, it is not the best way, but it is simple and fast.