LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 09-18-2011, 05:58 AM   #1
linuxFreshMan
Member
 
Registered: Nov 2009
Distribution: Ubuntu 9, RedHatLinux
Posts: 47

Rep: Reputation: 0
Unhappy Nagios3 facing difficulties in retrieving MySql DB status.. with these messages..


hi everybody.. am facing a bit of a tricky problem here.. its my nagios3 again it keeps showing me that my MySql DBMS is CRITICAL while i KNOW it is NOT.. and displaying these error messages :
1>
Code:
Access denied for user 'root'@'MY IP ADDRESS GOES HERE' (using password: NO)
and displaying this for another server (another MySql):
2>
Code:
Can't connect to MySQL server on 'MY.IP.ADDRESS.GOES HERE' (111)
the third one is :
3>
Code:
Host 'My IP ADDRESS GOES HERE' is not allowed to connect to this MySQL server
HELP PLEASE :-)

Last edited by linuxFreshMan; 09-18-2011 at 05:59 AM.
 
Old 09-18-2011, 10:10 PM   #2
kforbus
Member
 
Registered: Sep 2009
Location: Maryland
Distribution: Slackware
Posts: 68

Rep: Reputation: 29
Is this just something that started suddenly or have you always gotten these errors when trying to monitor a mysql instance on a (I'm assuming remote machine)? If it is, in fact, a remote machine, have you commented out the skip-networking line and added a bind-address=<your mysql server address> line to your my.cnf? Until that is done, your mysql server probably won't accept connections from remote machines. Just a thought.
 
Old 09-19-2011, 02:20 AM   #3
linuxFreshMan
Member
 
Registered: Nov 2009
Distribution: Ubuntu 9, RedHatLinux
Posts: 47

Original Poster
Rep: Reputation: 0
thanks for replying and yes i always had this errors.. and also yes Ive tried to do the bind-address thing but no use unfortunately.. one friend here told me to try to create a nagios user on MySql and grant it the proper rights and try that.. so i will try it.. i hope you keep following with me thanks again
 
Old 09-19-2011, 04:05 AM   #4
linuxFreshMan
Member
 
Registered: Nov 2009
Distribution: Ubuntu 9, RedHatLinux
Posts: 47

Original Poster
Rep: Reputation: 0
I've try the last one i told you but no use too
 
Old 09-19-2011, 11:22 PM   #5
kforbus
Member
 
Registered: Sep 2009
Location: Maryland
Distribution: Slackware
Posts: 68

Rep: Reputation: 29
When you tried creating the new database user, did you specify the host portion to be the IP of your nagios server that the connections will be coming from? Like:
Code:
GRANT ALL ON foo.* TO someuser@'192.168.1.10' IDENTIFIED BY 'SOME_PASSWORD';
where foo is replaced by the name of your database and 192.168.1.10 is replaced with your nagios server IP address.

For instance, if you're specifying in your nagios check that it should log into mysql using the root account, then you'd want to add root@'your nagios IP' to all your mysql databases.

Doing the above should at least help get rid of error #3 in your original post.

Let me know if you have any luck.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
I need troubleshooting help for Nagios3.2. SNMP CRITICAL for Port 1 status always? rahimrh Linux - Networking 3 04-12-2010 06:21 AM
How to get rid of this most often facing issue of collect2: ld returned 1 exit status kvijaik Linux - Newbie 2 11-01-2009 02:54 AM
LXer: OpenMoko already facing difficulties? LXer Syndicated Linux News 0 07-13-2007 12:31 AM
Retrieving boot messages ministre Linux - Software 3 01-14-2005 01:09 AM
fetchmail retrieving old messages sanjiv Linux - Software 3 09-15-2004 04:51 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 02:02 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration