Extended Data problems under MySQL using Nagio s 1.2 CGI Interface
APMI QUIDILLA, Antonino P. Jr.
Jon.Quidilla at ayalaport.com
Thu May 27 01:56:14 CEST 2004
Have anyone tried to monitor their BGP sessions using nagios? Please help!
jon
-----Original Message-----
From: Misao [mailto:misaochankun at speakeasy.net]
Sent: Thursday, May 27, 2004 7:38 AM
To: 'Jason Branscum'; nagios-users at lists.sourceforge.net
Subject: RE: [Nagios-users] Extended Data problems under MySQL using Nagios
1.2 CGI Interface
This sounds like the problem I had with extended info.
Apparently, you have to specifically put a switch for entedned info(whether
it be database or file based) in the ./configure itself. This should then
let it read your extinfo after you install the new Nagios.
Also, I use nagiosmap.pl to set up my 2D map, but I have yet to find a nice
program for 3d map.
-----Original Message-----
From: nagios-users-admin at lists.sourceforge.net
[mailto:nagios-users-admin at lists.sourceforge.net] On Behalf Of Jason
Branscum
Sent: Wednesday, May 26, 2004 5:06 PM
To: nagios-users at lists.sourceforge.net
Subject: [Nagios-users] Extended Data problems under MySQL using Nagios 1.2
CGI Interface
>> Tried to send this message from my exchange mailbox.. of course it
>> got
rejected ;) Lets try this again using my normal mailbox.
Hey All,
Been using Nagios for a while, it sure beats the tail off of WhatsUp..
in fact, I liked it so much that I showed it off to a friend. Within a week
he migrated off of his WhatsUp monitoring and went to Nagios, however, he
has a cool feature which I lack. On his 2d Status and 3d Status page, he
has neat lil icons for each of his hosts; I on the other hand do not other
than the defaults. We're both running Version 1.2, however I use the MySQL
backend (compiled with -xdata) whereas he uses the file based version.
Both my cgi.cfg and resource.cfg have the following:
xeddb_host=localhost
xeddb_port=3306
xeddb_database=nagios
xeddb_username=nagios
xeddb_password=heyb00b00
And other MySQL tables have populated rows.. so I know my SQL connection is
valid.
And for reference, here is a dump of my extended data table in mysql
CREATE TABLE `hostextinfo` (
`host_name` varchar(75) NOT NULL default '',
`notes_url` varchar(128) NOT NULL default '',
`icon_image` varchar(32) NOT NULL default '',
`vrml_image` varchar(32) NOT NULL default '',
`gd2_icon_image` varchar(32) NOT NULL default '',
`icon_image_alt` varchar(128) NOT NULL default '',
`x_2d` int(11) NOT NULL default '-1',
`y_2d` int(11) NOT NULL default '-1',
`x_3d` double(16,4) NOT NULL default '-1.0000',
`y_3d` double(16,4) NOT NULL default '-1.0000',
`z_3d` double(16,4) NOT NULL default '-1.0000',
`have_2d_coords` tinyint(4) NOT NULL default '0',
`have_3d_coords` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO `hostextinfo` VALUES ('lump', '', 'freebsd40.gif',
'freebsd40.gif', 'freebsd40.gd2', 'FreeBSD', -1, -1, '-1.0000', '-1.0000',
'-1.0000', 0, 0); INSERT INTO `hostextinfo` VALUES ('fb1.tylr', '',
'firebox.gif', 'firebox.gif', 'firebox.gd2', 'Watchguard Firebox', -1, -1,
'-1.0000', '-1.0000', '-1.0000', 0, 0);
And here are the hosts as referred to above:
define host{
use notify
host_name lump
alias Lump (FreeBSD)
address 192.168.70.26
check_command check-host-alive
max_check_attempts 10
notification_interval 120
notification_period 24x7
notification_options d,u,r
}
define host{
use notify
host_name fb1.tylr
alias Tyler, TX - Firebox
parents sw01.tylr
address 192.168.70.7
check_command check-host-alive
max_check_attempts 10
notification_interval 120
notification_period 24x7
notification_options d,u,r
}
I checked, the images referred to above do exist in my logos directory.
I've kill -9'ed and restarted every time I've made a change which has not
helped either. I'm stumped.. I even tried reverting to a file version for
extended host info and restarted Nagios.. no luck.. I think it doesn't work
because I compiled using SQL and it won't even try a file. I'm stumped
here, read the FAQ and 4 weeks worth of majordomo mailing list archives..
I've got nothing.. Any help would rock the casbah! I think I've been very
detailed as to my problem.. if you need any more clues/details, just mail me
direct, I'm on the digest version of the mailer.
One other thing completely unrelated; is there a way to design these
displays with a GUI that will spit out cords so that my maps look pretty?
Even my 3d map really only uses a 2d plane, it would be neat to see objects
spread out on the third plane.
Jason
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest
thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&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
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest
thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&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
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&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
More information about the Users
mailing list