Software :: Monitoring Local Host MySQL In Nagios?
Jan 6, 2010
I am using nagios to monitor a local host and a remote host in a vmware, where both the machines working in CentOS. Now i need to monitor MySQL in my local host so that i should know whether MySQL is up and running. I came across some plugins like
check_MySQL_health
check_MySQL_status
check_MySQL_stat.
While i was trying to install check_MySQL_health, i cant get clear description about the installation and i got stuck with that.
View 2 Replies
ADVERTISEMENT
Jul 9, 2011
Error: Cannot open log file '/usr/local/nagios/var/archives/nagios-07-08-2011-00.log' for reading!
View 2 Replies
View Related
May 27, 2011
I want to monitor RDS (mysql database of EC2) using Nagios. In command line ( I am able to do it but I dont know how to feed it in nagios . On nagios server if I execute the following command , I am able to fetch the information of database (RDS)
Nagios_server #/usr/local/nagios/libexec/check_mysqld.pl -p<password> -f -u <username> -A uptime,threads_connected,slow_queries,open_tables -H <hostname> -q 'SHOW STATUS'
output :- MYSQL 5.1.50 OK | uptime=344783 threads_connected=672 slow_queries=0 open_tables=64
Note :- Here the host name is public dns name (x.y.z.amazon.com) .We cant ping to this host.With mysql command , we can log in and work on databases.
View 5 Replies
View Related
Jul 20, 2010
I have been running a webserver for a time now. And for fun I thought I would use Nagios for monitoring it. But the installation instruction says install this on webserver01 and that on webserver02. I only have one server and want to monitor it remotely from a simple browser. Is this possible or does Nagios need at least two separate servers? Can't it just run it on my one server?
View 1 Replies
View Related
Feb 28, 2011
The communication between nagios and nrpe agent in the monitored host, can be without SSL? The problem is that I have 2 different versions of debian running on the machines and there are problems related to the libssl-dev package!
View 11 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Sep 1, 2010
In my network Nagios server running on Ubuntu server and working fine. I am able to monitor servers in local network through plugin and SNMP. Now I want to monitor some servers which are located remote location(network) and they haven't real IP(all are behind route/firewall). I can allocate real IP to nagios server if require. How can I monitor those servers?
View 7 Replies
View Related
Oct 28, 2010
out to install groundwork monitoring tool as a frontend for nagios
View 1 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
Jun 15, 2011
I installed Nagios following the Quick Install method from the Nagios.org web site but now I would like to add and monitor another host.I don�t find a way , I have for example replaced the ip number of the localhost(127.0.0.1 localhost.cfg) for another ip number and I am able to monitor another computer that way. But then I no longer MONITOR the localhost unless I replace the ip number in the localhost.cfg file. what I would like to do is to monitor both or more computers.
View 4 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Dec 6, 2010
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 6 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Jan 14, 2011
Yesterday i install nagios, after that i can successfully monitor my local machine disk usage and its services, but now i want to monitor remote host, but have no idea how to do this , i also google alot but not getting resource full explanation.so please guys tell me how can i monitor the remote host using nagios..
View 54 Replies
View Related
Feb 15, 2010
We are using Nagios Server for different sites say India,US,Germany. All of them are in their respective groups. Now how do i create web access to 3 of them, so that they can monitor only their server? Say, India shouls be able to see and monitor only India group, US guys should able to monitor only US servers. And they not be anle to access other group.
View 1 Replies
View Related
Mar 2, 2011
i have some problem with nagios adding remots hosts in localhost.cfg (/etc/nagios/objects/localhost.cfg) file in that i am able to only one remote host if i add one more host in that file i got below error #/usr/sbin/nagios -v /etc/nagios/nagios.cfg
Nagios Core 3.2.3
Copyright (c) 2009-2010 Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 10-03-2010
License: GPL
[Code]...
View 7 Replies
View Related
Apr 2, 2010
Since a week or 2 Nagios is constantly marking hosts (servers mainly but also a few Serial-over-IP converters) down for anything up to a few minutes. Typically, all services stay in OK status. Looking closer at a host in such state, it's status information is
CRITICAL - Packet Filtered (<IP address of host in question>)
in soft state. Sometimes services are in critical state with the host in OK status. Almost always the status information is "No route to host". Further checking shows no problems. Rarely this state lasts longer than one check interval. This started after a link was down, putting, correctly, all hosts and services on red for being unreachable. The link problems were solved within a few hours but Nagios only showed this after 2 reboots. Since then the problems has lessened in frequency gradually, from 5 to 10 of the 34 hosts being reported down at any given moment (the same for the 150-ish services monitored) to where I am now, 1 to 5 problem statuses (counting both hosts and services) and the occasional 'all green' screen. A week ago, when the problems were going a week already, Nagios updated from 3.2.0 to 3.2.1. This showed no apparent improvement.
Still, the Host Groups screen is not stable. A read or yellow status initially signified a problem to be looked at, right now it is likely a false alarm to will go away. Whenever the "packet filtered" or "no route to host" is followed up by a ping test, no problems, not even with the slightest delay or packt loss are found.
View 5 Replies
View Related
Nov 15, 2010
I have installed nagios successfully also able to monitor windows hosts. but not able to monitor linux hosts. i have follow below procedure, installation part and evertything was ok.but still i am not able to see linux host under nagios. i followed below url for monitor linux hosts on nagios.URL...
View 3 Replies
View Related
Mar 17, 2010
I have a Linux host connected via LAN to Internet. No proxy or squid is used on the host and outgoing traffic to Internet is not limited. I have several local users on this box. Recently bandwidth statistics on the switch/router showed increase in the Internet traffic from this host. How do I monitor the traffic utilization per local user on Linux host? I want to be able to monitor the amount of traffic per port and per user, like user alice downloaded 20GB today via port 22, and so on. Do not offer to use Squid, this is not just web traffic I want to monirot but all amount of incoming/outgoing traffic per user per port.
View 3 Replies
View Related
May 2, 2011
I'm looking for commandline monitoring tool for mysql and only thing I can find is mtop. Unfortunately, mtop's development halted back in 2004. Can someone suggest an alternative? or is there such thing?
View 2 Replies
View Related
Apr 7, 2010
Trying to monitor mysql 5.0.77 with nagios 3.2.1 under CentOS 5.4. Everything with nagios has been running without a hitch for me, however, when I added the following to /etc/nagios/objects/localhost.cfg to try to monitor mysql, I get an error that reads "Running configuration check... CONFIG ERROR! Restart aborted. Check your Nagios configuration."
define service{
use local-service
host_name localhost
service_description MYSQL
check_command check_mysql
notifications_enabled 1
}
This is pretty much what I added to monitor other things on the server such as ftp and smtp, just switched out check_smtp with check_mysql, etc.
View 2 Replies
View Related
Mar 11, 2010
I've got an apache server running several virtual hosts. I have them separated by domain name, and they all come into the same IP address. I'm looking for a way to monitor the bandwidth that they use. The only feature that I'm really looking for is a breakdown of which domain is dishing out how much bandwidth.
blocks.com got three visitors this month. And spent 200kb in serving them.
emus.net got fifteen. And spent 1mb in serving them.
reverse.org got 4000. and spent 400mb in serving them.What I would like to see is a report, could be a web page could be a file. Ideally with graphs. Showing:
1.
2.....
3[400mb worth of dots]
1-blocks.com
2-emus.net
3-reverse.org
I don't need it to show me how many visitors or from where or anything like that. I am just looking for a side by side comparison of how much bandwidth each domain is using.Is there some application for this or something. Everything that I've found has been for information on a single site (awstat and friends can show me information for multiple sites, but as far as I know it won't show me information comparing them) I haven't found anything for nagios, but perhaps there is something out there for it, or a sneaky way to make a nice plugin that would do this.
View 2 Replies
View Related
Jan 6, 2010
Is this possible that a process running on a remote-host only inform nagios when some thing is wrong. Rather then nagios-monitoring-server checking through NRPE every so often. Reason is I want to add too many alerts in the application. And I don't want a whole list of ok messages.
View 1 Replies
View Related
Jul 7, 2011
I believe that I need to disable the host check, I'm checking a public FTP service and ping is disabled on that FTP host. This is resulting in Nagios reporting the host as down, but the service shows as OK.
Is there any way to disable the host check?
View 1 Replies
View Related
Nov 22, 2010
I'm trying to setup my test nagios to check the disk space of another linux box. I've got it setup and checking. But to my surprise, it was checking the nagios server's local disk space instead of the remote linux.
Here is my services.cfg.
define service{
use basic-service
name disk-space
check_command check_local_disk!20%!10%! /
[Code].....
View 10 Replies
View Related
Dec 3, 2010
I am using MySQL version 5.1.47 (64bit) on Centos 5.5 in production environment. I am exploring option to monitor MySQL though SNMP traps. Can anybody please let me know if there is any open source SNMP tool that can be used for MySQL monitoring?
View 4 Replies
View Related
Dec 27, 2009
I have a CentOS 5.4 nas box that I want to monitor.
I believe I can setup mdadm to mail me when there are issues by addin the following line to /etc/mdadm.cong Quote:MAILADDR root
View 1 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Sep 29, 2010
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
View 3 Replies
View Related
May 31, 2011
I am having difficulty sending files from a remote machine to local one using
Code:
scp
. It is working the other way however. local > remote. I am using the verbose options
[code]....
View 3 Replies
View Related
