Nagios and MySQL

[Mark Weaver]

Ricardo Maraschini wrote:
> ----- "Mark Weaver" <mweaver at compinfosystems.com> escreveu:
>   
>> I was wondering if anyone has connected their standard Nagios
>> installation up to a MySQL backend?
>>     
>
> You can take a look to www.opmon.org
> We make available a configuration tool called OpCfg and an event broker(including performance data parse), so every information will be in a mysql db.
>
> Regarding to backup issue, you can run a rpm -ql <package name> to get gathered all Nagios instalation files and make a backup of them.
>
> HTH.
>
> -rm
>   
Hi Ricardo,

I've got OpCfg installed and I "think" it's working, and if I understand
things so far it's imported all my nagios settings including objects and
templates and such into the db. I can make changes, adjustments, etc...
with OpCfg and then I've got to export those changes or additions back
out to the Nagios config on disk. However it doesn't appear to be doing
that and I'm not sure why.

All Nagios configuration files for everything on the Nagios server is in
/etc/nagios and OpCfg appears to be aware of that. I've made /etc/nagios
and everything under that directory writable for nagios.apache, but when
I make changes such as create a workstation template and then add a host
made from that template the files aren't being written back to disk.

(Let me know if you need any more information.
The directory structure for Nagios configuration on disk looks like this:

/etc/nagios/:
cgi.cfg
command-plugins.cfg
global
htpasswd.users
nagios.cfg
ndo2db.cfg
ndomod.cfg
nrpe.cfg
nsca.cfg
objects
resource.cfg
send_nsca.cfg

/etc/nagios/global:
commands
contacts
templates

/etc/nagios/global/commands:
commands.cfg

/etc/nagios/global/contacts:
contactgroups.cfg
contacts.cfg

/etc/nagios/global/templates:
templates.cfg
timeperiods.cfg

/etc/nagios/objects:
commands.cfg
contacts.cfg
fma
kfsi
localhost.cfg
printer.cfg
pshare
switch.cfg
templates.cfg
timeperiods.cfg
windows.cfg

/etc/nagios/objects/fma:
Cmaloney-1-services.cfg
David-services.cfg
exchange-services.cfg
fma-contactgroups.cfg
fmadc01-services.cfg
fmaexch01-services.cfg
fma-hostgroups.cfg
fma-hosts.cfg
FMA-Mobile-services.cfg
fmaws1-services.cfg
fmaws2-services.cfg
fmaws3-services.cfg
fmaws4-services.cfg
fmaws5-services.cfg
Peter01-services.cfg

/etc/nagios/objects/kfsi:
application-services.cfg
citrix1-services.cfg
citrix2-services.cfg
frank-home-services.cfg
kelly-pdc-services.cfg
kfsi-hostgroups.cfg
kfsi-hosts.cfg
markweaver-pc.cfg
mxgw-services.cfg
old
sandbox-service.cfg

/etc/nagios/objects/kfsi/old:
carol.cfg.old
frankkelly.cfg.old
karen.cfg.old
markweaver-pc.cfg.old
printer.cfg.old
servicegroups.cfg.old
switch.cfg.old
tax1.cfg.old
windows.cfg.old
xerox.cfg.old

/etc/nagios/objects/pshare:
ps-contactgroups.cfg
ps-hostgroups.cfg
ps-hosts.cfg
receptionist-services.cfg
sbserver-services.cfg



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