RE: [Nagios-db-devel] nagios-db

[Brett S. <bre...@hu...>]

I had the same question last week, tho it was for postgres.
What I did was to check out the latest inserter.c
Modify inserter.c to give the correct details for db login
	if(!(pgconn = PQconnectdb("host=I.P.a.d port=whatever
dbname=ultrasecret user=whatever")))
Make 
Copied the file inserter.o to nagios/bin
Chown to correct user
Modify nagios.cfg 
   	event_broker_options=-1
	broker_module=/usr/local/nagios/bin/inserter.o
Started database server
Created and configured db schema as follows
Order is important here.

1. Create your database.
2. Apply handlers.sql.
3. Apply schema.sql.
4. Apply types.sql
5. Apply SPs/*.
6. Apply views.sql.

This will be different for mysql but the readme in the database/mysql dir
will tell you exactly what you will need to build your db
Kill -HUP nagios -- all done

This was after much pain and angst, I think Ill have to write this up a
little better and submit it to the team.

Good luck and let us know how you made out.

Brett Stevens


-----Original Message-----
From: barry haycock [mailto:sat...@ya...] 
Sent: Thursday, March 24, 2005 1:27 PM
To: nag...@li...
Subject: [Nagios-db-devel] nagios-db


Hi, I have recently aquired nagios-db to plug into our
nagios (2.0b2) system. looking through the software
and this list there doesn't seem to be any docs to
configure it.

i have built the software for use with mysql and
compiled the src files. but how do i configure nagios
to work with nagios-db???

i have a number of years experience with nagios and
it's predececor netsaint so i am familar with the
config files.

any notes would help, I wouldn't mind submitting my
final notes as part of the documentation when i get
the system working.

Barry

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com


-------------------------------------------------------
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.
Register by 3/29 & save $300
http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
_______________________________________________
Nagios-db-devel mailing list Nag...@li...
https://lists.sourceforge.net/lists/listinfo/nagios-db-devel