Problem Getting the APAN Link to Appear in Nag ios

[jeff vier]

On Fri, 2004-04-02 at 14:59, Kaplan, Andrew H. wrote:
> When I ran the command you mentioned: /usr/bin/mysql -u nagios -p apa123 -D

(you probably shouldn't email hundreds of people your db password :))

> nagios, I first got an 1049 error
> that stated the apa123 database was unknown.

Well, THAT is weird.  the -p is the password.

>  When I ran the same command minus
> the -p option, I got the 1045
> error saying access was denied. Finally I ran the command with only the -D
> option and I got the 1045 error again.

well, you have to have the -p, most likely (if not, that's bad in
itself!)

Is your MySQL database running on that same server, then?  If not, add a
'-h <hostname-or-IP>'.

I know it doesn't make a difference, but what the heck - try running it
without spaces after the option flags.  So, '/usr/bin/mysql -unagios
-papa123 -Dnagios'


> I did a check through Webmin on the nagios sql user and I confirmed the user has
> access from the localhost and has
> all permissions. I chose localhost when I set the permissions up initially due
> to the fact that was the only way I
> could get the apanconf-sql utility to be able to write to the database. What
> next?

Well, this is apparently either an sql.conf issue, or an issue with your
MySQL db itself.

other things to try:  open up permissions for the nagios user in MySQL
(let the user connect from all hosts).  Maybe somehow it's being seen
from its primary interface instead of "localhost" (if that's even
possible).
Also - you wouldn't happen to be running MySQL on a non-standard port,
would you?

> -----Original Message-----
> From: jeff vier [mailto:jeff.vier at tradingtechnologies.com]
> Sent: Friday, April 02, 2004 2:39 PM
> To: Kaplan, Andrew H.
> Cc: Nagios-Users (E-mail)
> Subject: RE: [Nagios-users] Problem Getting the APAN Link to Appear in
> Nag ios
> 
> 
> On Fri, 2004-04-02 at 12:58, Kaplan, Andrew H. wrote:
> > I ran the rrdtool fetch command with the appropriate syntax, and I am
> > getting a bunch of "nan"s. It
> > appears, according to what you said, that the values are not being
> > collected. How do I correct this?
> 
> Notably, you will get *some*, but they shouldn't be *all* "nan"
> 
> First thing, what are the permissions on your rrd directory?
> mine is 770 and owned by nagios:nagios
> the rrds themselves are 660 with the same ownership.
> 
> Second, can you log into your MySQL db using the command in sql.conf?
> The last var in that file (SQLCOMM=...") is the command.



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null