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

[Ben <be...@si...>]

Wow, I didn't realize people would find it so challenging. Then again, 
I guess I did write it, so maybe I'm not an average user.

I'm currently making (what I hope will be) a massive performance 
improvement for the postgres inserter, and once I'm satisfied with that 
work, I'll make some actual documentation.

On Mar 23, 2005, at 6:38 PM, Brett Stevens wrote:

> 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
>
>
> -------------------------------------------------------
> 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