[Nagios-users] nagios with mysql
Hi I am using Nagios since 2004 with all the configuration in the text files. Now, Id like using mysql DB. I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB. Regards Marco Borsani Unix and Monitoring Sysadmin Technical Operations Dpt. tel: +39 010 4310115 fax: +39 02 30130311 cell: +39 329 5953944 ITnet Srl Società con socio unico Direzione e Coordinamento di WIND TELECOM S.p.A. -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with mysql
You can find out about it when reading on NDO http://exchange.nagios.org/directory/Addons/Database-Backends/NDOUtils/details Marco Borsani wrote: Hi I am using Nagios since 2004 with all the configuration in the text files. Now, I’d like using mysql DB. I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB. Regards Marco Borsani *Unix and Monitoring Sysadmin* *Technical Operations Dpt.* tel: +39 010 4310115 fax: +39 02 30130311 cell: +39 329 5953944 ITnet Srl Società con socio unico Direzione e Coordinamento di WIND TELECOM S.p.A. -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Nagios-users mailing list Nagios-users@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 -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with mysql
Myst use NagioSQL and it will import tour magios files into a MySQL DB. Moreover, it will give you a web interface to configura Nagios. NagioSQL will be the backend for the upcoming Nagios official configuration tool. Ciao, Giorgio Il giorno 21/apr/2011, alle ore 09:32, Marco Borsani m.bors...@it.net ha scritto: Hi I am using Nagios since 2004 with all the configuration in the text files. Now, I’d like using mysql DB. I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB. Regards Marco Borsani Unix and Monitoring Sysadmin Technical Operations Dpt. tel: +39 010 4310115 fax: +39 02 30130311 cell: +39 329 5953944 ITnet Srl Società con socio unico Direzione e Coordinamento di WIND TELECOM S.p.A. -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Nagios-users mailing list Nagios-users@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 -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with mysql
On 21 Apr 2011, at 08:32, Marco Borsani wrote: I am using Nagios since 2004 with all the configuration in the text files. Now, I’d like using mysql DB. I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB. If you create your own DB to hold all the relationships and information to create the nagios configuration files, you'll end up with Opsview (http://opsview.com) We model the data in the proper way (http://labs.opsview.com/2011/04/managing-security-permissions-for-large-teams-in-opsview/) and then we generate the nagios configuration files appropriately, with distributed monitoring thrown in for free. NagiosQL is mapping the Nagios configuration files into a sql database, which is okay, but try running queries to tell you what you want to know and you'll end up replicating Nagios' configuration algorithms to get the data you need. While our demo site doesn't give you access to the mysql db, I'd recommend you download our latest VM and poke around the DB structures. There's an import script so if you supply your Nagios object.dat file, we'll do a good job at importing your information into Opsview's DB. We've got users that now run DB queries against opsview to give them asset lists. We've got other users that have asset lists external to Opsview, but use the REST API (http://docs.opsview.com/doku.php?id=opsview-community:restapi) to update Opsview. All this is much easier by abstracting the Nagios specific information away. Ton -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with mysql
Hi, it seems a bit beyond his needs :-) Then, from your words it seems that in Opsview you attached a CMDB to Nagios. Is it so? Could be interesting, lots. Giorgio quota chi=Ton Voon On 21 Apr 2011, at 08:32, Marco Borsani wrote: I am using Nagios since 2004 with all the configuration in the text files. Now, Id like using mysql DB. I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB. If you create your own DB to hold all the relationships and information to create the nagios configuration files, you'll end up with Opsview (http://opsview.com) We model the data in the proper way (http://labs.opsview.com/2011/04/managing-security-permissions-for-large-teams-in-opsview/) and then we generate the nagios configuration files appropriately, with distributed monitoring thrown in for free. NagiosQL is mapping the Nagios configuration files into a sql database, which is okay, but try running queries to tell you what you want to know and you'll end up replicating Nagios' configuration algorithms to get the data you need. While our demo site doesn't give you access to the mysql db, I'd recommend you download our latest VM and poke around the DB structures. There's an import script so if you supply your Nagios object.dat file, we'll do a good job at importing your information into Opsview's DB. We've got users that now run DB queries against opsview to give them asset lists. We've got other users that have asset lists external to Opsview, but use the REST API (http://docs.opsview.com/doku.php?id=opsview-community:restapi) to update Opsview. All this is much easier by abstracting the Nagios specific information away. Ton -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev___ Nagios-users mailing list Nagios-users@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 -- Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios and mysql
Thiery, how does your ndomod.cfg and ndo2db.cfg looks like? Thanks On Sat, May 9, 2009 at 6:37 PM, Thierry Granier th.gran...@free.fr wrote: Hello i have installed NDOutils and i can run ndo2db-3x but i have this message in the log: ndomod: Error writing to data sink! Some output may get lost. 3996 queued items to flush. The database nagios is empty Thanks for your help Thierry -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Nagios-users mailing list Nagios-users@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 -- Cordially, Shadhin Rahman -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com___ Nagios-users mailing list Nagios-users@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
[Nagios-users] nagios and mysql
Hello i have installed NDOutils and i can run ndo2db-3x but i have this message in the log: ndomod: Error writing to data sink! Some output may get lost. 3996 queued items to flush. The database nagios is empty Thanks for your help Thierry -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com___ Nagios-users mailing list Nagios-users@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
[Nagios-users] Nagios-users] nagios and mysql and NDOutils
Hello i have installed NDOutils and i can run ndo2db-3x but i have this message in the log: ndomod: Error writing to data sink! Some output may get lost. 3996 queued items to flush. The database nagios is empty Thanks for your help Thierry -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios-users] nagios and mysql and NDOutils
ndomod (broker) can't write data on unix socket. Verify if ndo2db created a unix socket in your system. # netstat -anp |grep ndo.sock unix 2 [ ACC ] STREAM LISTENING 14049966 25009/ndo2db-3x /var/nagios/rw/ndo.sock unix 3 [ ] STREAM CONNECTED 14050152 30032/ndo2db-3x /var/nagios/rw/ndo.sock Send us your ndo2db config values. On Fri, May 8, 2009 at 6:35 PM, Thierry Granier th.gran...@free.fr wrote: Hello i have installed NDOutils and i can run ndo2db-3x but i have this message in the log: ndomod: Error writing to data sink! Some output may get lost. 3996 queued items to flush. The database nagios is empty Thanks for your help Thierry -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Nagios-users mailing list Nagios-users@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 -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
Hi Mark, Allways use the list for your questions. - Mark Weaver mwea...@compinfosystems.com escreveu: Now the nagios configuration exists both on disk in the flat files and within the database that was created. Which then does nagios respond to when new hosts are created and put into play? The ones in the database or the ones on disk or both? Nagios remains under plain configuration files. The opcfg is a configuration utility. On the first installation, you must run an import, thus all original configuration files are imported to mysql database. From this time you must use opcfg to make your new configurations, so you can enjoy a bunch of features. After you proceed with your new configuration using opcfg, you run an export at opcfg interface, so the plain files are updated with new mysql configuration and nagios process is restarted. You can use our mailing list at http://www.opmon.org/get-involved to more details. -rm -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
- Mark Weaver mwea...@compinfosystems.com escreveu: 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. Exactly. 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. Are you doing an export at the end of the process? Are there error messages at apache log files related to export process? I think we can move our discussion to opmon.org mailing list. There we have a group of developers that can help you with this configuration. http://www.opmon.org/get-involved -rm -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
Ricardo Maraschini wrote: - Mark Weaver mwea...@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@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
Re: [Nagios-users] Nagios and MySQL
Ricardo Maraschini wrote: - Mark Weaver mwea...@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@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
Re: [Nagios-users] Nagios and MySQL
Mark Weaver wrote: Hi List, I was wondering if anyone has connected their standard Nagios installation up to a MySQL backend? I'm looking at this from a purely disaster recovery aspect. It's easy enough to backup the configuration, but the data is another matter. Why you would want to move data from flat files to a database for disaster recovery purposes is beyond me. Care to explain? My current Nagios installation is version 3 installed on a CentOS 4.7 server. The installation was done via Yum from the rpmforge repo. Much cleaner install than compiling the tarballs and much easier to manage. Yes, I could archive all the installation paths, but because they were installed via the RPM method things are spread out all over the file system. It would be real nice if I had all the data contained within a MySQL backend. That way if I had to restore should my Nag server die or suffer some horrible fate it could be a matter of reinstalling the packages, restoring the /etc/nagios directory where all the configs live, restore the database and I'm of again. This should work reasonably well: tar czf nagios-backup-$(date +%Y-%m-%d.%T).tar.gz $(rpm -ql nagios) I've looked at a few suggested Nagios front ends including Centreon and they turned out to be bad experiences. Mostly due to the fact that being a Nagios noobie I didn't know what the hell the front was doing. The worst of it though was the way those front ends kept over-writing my configuration files in favor of it's own. Made a real mess of things and after the third reinstallation of Nagios on my sandbox I decided they weren't worth the effort or the misery. (Centreon and NagiosQL) Groundworks is out of the question because as soon as it was installed and running it disabled my current instance of MySQL in favor of it's own. Not such a big deal as at the time it was on my sandbox machine, but had that been a production machine where I've got web applications running I'd have been seriously pissed! Funny that... Groundworks didn't mention anything about that rather rude behavior. No, I'd much rather be able to connect a standard Nagios install to a MySQL backend and use everything else as is. What particular data is it you want to put in the database? We have plenty of scripts, eventbrokers and programs written specifically to gather Nagios data and put it in a database. If you use our webconfiguration tool, it will overwrite your configuration files when you click save, but that's sort of expected behaviour, I guess. Still, I think you're going about this the wrong way if you only want it for backup reasons. -- Andreas Ericsson andreas.erics...@op5.se OP5 AB www.op5.se Tel: +46 8-230225 Fax: +46 8-230231 Considering the successes of the wars on alcohol, poverty, drugs and terror, I think we should give some serious thought to declaring war on peace. -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
- Mark Weaver mwea...@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 -- ___ Nagios-users mailing list Nagios-users@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
[Nagios-users] Nagios and MySQL
Hi List, I was wondering if anyone has connected their standard Nagios installation up to a MySQL backend? I'm looking at this from a purely disaster recovery aspect. It's easy enough to backup the configuration, but the data is another matter. My current Nagios installation is version 3 installed on a CentOS 4.7server. The installation was done via Yum from the rpmforge repo. Much cleaner install than compiling the tarballs and much easier to manage. Yes, I could archive all the installation paths, but because they were installed via the RPM method things are spread out all over the file system. It would be real nice if I had all the data contained within a MySQL backend. That way if I had to restore should my Nag server die or suffer some horrible fate it could be a matter of reinstalling the packages, restoring the /etc/nagios directory where all the configs live, restore the database and I'm of again. I've looked at a few suggested Nagios front ends including Centreon and they turned out to be bad experiences. Mostly due to the fact that being a Nagios noobie I didn't know what the hell the front was doing. The worst of it though was the way those front ends kept over-writing my configuration files in favor of it's own. Made a real mess of things and after the third reinstallation of Nagios on my sandbox I decided they weren't worth the effort or the misery. (Centreon and NagiosQL) Groundworks is out of the question because as soon as it was installed and running it disabled my current instance of MySQL in favor of it's own. Not such a big deal as at the time it was on my sandbox machine, but had that been a production machine where I've got web applications running I'd have been seriously pissed! Funny that... Groundworks didn't mention anything about that rather rude behavior. No, I'd much rather be able to connect a standard Nagios install to a MySQL backend and use everything else as is. thanks, -- Mark Weaver Computer Information Systems Services, Inc. 400 Bridge St., STE 4 New Cumberland, Pa. 17070 mwea...@compinfosystems.com (717) 512-9718 -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
2009/3/25 Mark Weaver mwea...@compinfosystems.com: Hi List, I was wondering if anyone has connected their standard Nagios installation up to a MySQL backend? Yes, NDOUtils. I'm looking at this from a purely disaster recovery aspect. It's easy enough to backup the configuration, but the data is another matter. Why? In a standard configuration, the data is a bunch of files which can be backed-up using tar or whatever your favourite backup utility is. My current Nagios installation is version 3 installed on a CentOS 4.7 server. The installation was done via Yum from the rpmforge repo. Much cleaner install than compiling the tarballs and much easier to manage. Yes, I could archive all the installation paths, but because they were installed via the RPM method things are spread out all over the file system. If you had installed from source tarball, then most of your Nagios install would be under /usr/local/nagios/ . It would be real nice if I had all the data contained within a MySQL backend. That way if I had to restore should my Nag server die or suffer some horrible fate it could be a matter of reinstalling the packages, restoring the /etc/nagios directory where all the configs live, restore the database and I'm off again. The install from tarball isn't so onerous, and you'll find that Nagios then isn't spread all over the place but is mostly found under /usr/loca/nagios/ . I've looked at a few suggested Nagios front ends including Centreon and they turned out to be bad experiences. Mostly due to the fact that being a Nagios noobie I didn't know what the hell the front was doing. I'm sorry Mark, but installing from repositories using yum is pretty much the same. If you want to see how things work and have a truly standard install, you need to install Nagios from the source tarballs. Believe me, I started off installing Nagios using yum on Fedora a while back and soon got bitten on the bum when I found the repository had Nagios compiled with embedded perl enabled but the plugins I was using wouldn't work with that. In a truly standard Nagios install (if there is such a thing), the configs are under /usr/local/nagios/etc not /etc/nagios . These things become important when you start looking at installing some of the really neat addons for Nagios like pnp4nagios graphing, NExSM status map, NagVis dashboards and so on. -- ___ Nagios-users mailing list Nagios-users@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
[Nagios-users] Nagios and MySQL
Hi! Could MySQL be used in Nagios3? What is stored in the MySQL database? Thank you very much! Bye. -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
HI, read this: http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf 2008/12/29 shacky shack...@gmail.com: Hi! Could MySQL be used in Nagios3? What is stored in the MySQL database? Thank you very much! Bye. -- ___ Nagios-users mailing list Nagios-users@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 -- André O Moura http://andrem.wordpress.com -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
read this: http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf Thank you very much. Specifying that I'm using a single Nagios installation (I don't have multiple Nagios servers), what are the advantages in using NDOUtils and MySQL to store the configurations? If I use NDOUtils, will I still be able to configure Nagios in files (/etc/nagios/*.cfg files) or I will have to write all the configuration directly in the MySQL db? -- ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and MySQL
On Dec 29, 2008, at 7:03 AM, shacky wrote: read this: http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf Thank you very much. Specifying that I'm using a single Nagios installation (I don't have multiple Nagios servers), what are the advantages in using NDOUtils and MySQL to store the configurations? NDOUtils doesn't store nagios configuration, just the check and process data. It's an 'output-only' target for nagios. If I use NDOUtils, will I still be able to configure Nagios in files (/etc/nagios/*.cfg files) or I will have to write all the configuration directly in the MySQL db? You will still need to use cfg files. Nagios is not capable of reading config files from DB. If that's what you're looking for, there are addons (differing for different versions of nagios) that allow you to manage configs in a DB then output them in a format that nagios understands. http://www.nagiosexchange.org should help you locate them. -- Marc -- ___ Nagios-users mailing list Nagios-users@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
[Nagios-users] Nagios and Mysql?
Hi, how can I compiled nagios (vers 3.X+) with support mysql ( I know mysql has been included in Nagios version 1.4X, but today??)? Thanks and best regards, Ladislav Havlík - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and Mysql?
-Original Message- From: [EMAIL PROTECTED] [mailto:nagios-users- [EMAIL PROTECTED] On Behalf Of LadislavHavlik Sent: Wednesday, February 20, 2008 7:49 AM To: nagios-users@lists.sourceforge.net Subject: [Nagios-users] Nagios and Mysql? Hi, how can I compiled nagios (vers 3.X+) with support mysql ( I know mysql has been included in Nagios version 1.4X, but today??)? Database support has been moved to external modules and isn't quite the same as the 1.x version. You're looking for NDOUtils on the nagios download page. -- Marc - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios and Mysql?
-Original Message- From: LadislavHavlik [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 20, 2008 8:59 AM To: Marc Powell Subject: Re: [Nagios-users] Nagios and Mysql? Database support has been moved to external modules and isn't quite the same as the 1.x version. You're looking for NDOUtils on the nagios download page. Please do you know cause for this separation? - Because it was difficult and time-consuming for Ethan to maintain/test the integrated database code - It wasn't flexible at all - Ethan could only support databases he had direct access to and knowledge about. - The new method allows anyone to create a module to do pretty much whatever they want with the data via the Event Broker interface. -- Marc - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with Mysql
Hi Patrick I upgraded mysql on my system yesterday. New version is - mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using readline 5.0 But now I am getting below error message DBI connect('database=nagios;host=localhost','nagiosuser',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at ./installdb line 41 How can I resolve this problem? Which version of Mysql should I use? Thanks - LK -Original Message- From: Morris, Patrick [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 6:35 AM To: Lokesh Khanna Cc: nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] nagios with Mysql -Original Message- From: [EMAIL PROTECTED] [mailto:nagios-users- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 10:05 PM To: Morris, Patrick Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql I have dropped nagios DB which I created and trying to re create again. When I execute installdb script for tables creation, I get below error DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51. ** Creating tables for version 1.4b4 Using mysql.sql for installation... ERROR 1064 at line 19: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='Current and historical host and service acknowledgements'' at line 15 Installation from mysql.sql failed at ./installdb line 59. What version of MySQL are you building it with? I'd have to be a pretty old version not to support the ENINE=MyISAM option. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with Mysql
Look in the documentation for OLD PASSWORD - you can fix this error by updating the access password using an old style password. Mark Law Thomson Global Technology Infrastructure (TGTI) (734) 913-3775 Phone (734) 260-5740 Cell (734) 913- 3500 Fax [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 05, 2007 4:23 PM To: [EMAIL PROTECTED] Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql Hi Patrick I upgraded mysql on my system yesterday. New version is - mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using readline 5.0 But now I am getting below error message DBI connect('database=nagios;host=localhost','nagiosuser',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at ./installdb line 41 How can I resolve this problem? Which version of Mysql should I use? Thanks - LK -Original Message- From: Morris, Patrick [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 6:35 AM To: Lokesh Khanna Cc: nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] nagios with Mysql -Original Message- From: [EMAIL PROTECTED] [mailto:nagios-users- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 10:05 PM To: Morris, Patrick Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql I have dropped nagios DB which I created and trying to re create again. When I execute installdb script for tables creation, I get below error DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51. ** Creating tables for version 1.4b4 Using mysql.sql for installation... ERROR 1064 at line 19: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='Current and historical host and service acknowledgements'' at line 15 Installation from mysql.sql failed at ./installdb line 59. What version of MySQL are you building it with? I'd have to be a pretty old version not to support the ENINE=MyISAM option. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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 DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with Mysql
Thanks. I am able to fix that. But now I get below error DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51. ** Creating tables for version 1.4b4 Using mysql.sql for installation... ** Updating table nagios_dbversion Done! How can I fix it now? Is it just a warning message or an error ? Thanks - LK -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 05, 2007 10:28 PM To: Lokesh Khanna; [EMAIL PROTECTED] Cc: nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] nagios with Mysql Look in the documentation for OLD PASSWORD - you can fix this error by updating the access password using an old style password. Mark Law Thomson Global Technology Infrastructure (TGTI) (734) 913-3775 Phone (734) 260-5740 Cell (734) 913- 3500 Fax [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 05, 2007 4:23 PM To: [EMAIL PROTECTED] Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql Hi Patrick I upgraded mysql on my system yesterday. New version is - mysql Ver 14.12 Distrib 5.0.41, for pc-linux-gnu (i686) using readline 5.0 But now I am getting below error message DBI connect('database=nagios;host=localhost','nagiosuser',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at ./installdb line 41 How can I resolve this problem? Which version of Mysql should I use? Thanks - LK -Original Message- From: Morris, Patrick [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 6:35 AM To: Lokesh Khanna Cc: nagios-users@lists.sourceforge.net Subject: RE: [Nagios-users] nagios with Mysql -Original Message- From: [EMAIL PROTECTED] [mailto:nagios-users- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 10:05 PM To: Morris, Patrick Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql I have dropped nagios DB which I created and trying to re create again. When I execute installdb script for tables creation, I get below error DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51. ** Creating tables for version 1.4b4 Using mysql.sql for installation... ERROR 1064 at line 19: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='Current and historical host and service acknowledgements'' at line 15 Installation from mysql.sql failed at ./installdb line 59. What version of MySQL are you building it with? I'd have to be a pretty old version not to support the ENINE=MyISAM option. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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 DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with Mysql
Hi lokesh.khanna! On Tue, 03 Jul 2007, [EMAIL PROTECTED] wrote: I get below things in mysqld.lo Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at At the risk of stating the obvious, it sounds like your problem, and the fix for it, are described in that error message. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with Mysql
Hi I have dropped nagios DB which I created and trying to re create again. When I execute installdb script for tables creation, I get below error DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51. ** Creating tables for version 1.4b4 Using mysql.sql for installation... ERROR 1064 at line 19: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='Current and historical host and service acknowledgements'' at line 15 Installation from mysql.sql failed at ./installdb line 59. If I remove 'ENGINE=MyISAM COMMENT='Current and historical host and service acknowledgements from mysql.sql file, then I get no error and tables get created. This is what I did earlier. I am not a DB person, so pl help me in understanding what is wrong. As per my current my.cnf , I have below mentioned values there [EMAIL PROTECTED] db]# cat /etc/my.cnf [mysqld] skip-innodb datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks - LK -Original Message- From: Patrick Morris [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 10:49 PM To: Lokesh Khanna Cc: [EMAIL PROTECTED]; nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql Hi lokesh.khanna! On Tue, 03 Jul 2007, [EMAIL PROTECTED] wrote: I get below things in mysqld.lo Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at At the risk of stating the obvious, it sounds like your problem, and the fix for it, are described in that error message. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] nagios with Mysql
-Original Message- From: [EMAIL PROTECTED] [mailto:nagios-users- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 10:05 PM To: Morris, Patrick Cc: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] nagios with Mysql I have dropped nagios DB which I created and trying to re create again. When I execute installdb script for tables creation, I get below error DBD::mysql::db do failed: Table 'nagios.nagios_dbversion' doesn't exist at ./installdb line 51. ** Creating tables for version 1.4b4 Using mysql.sql for installation... ERROR 1064 at line 19: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='Current and historical host and service acknowledgements'' at line 15 Installation from mysql.sql failed at ./installdb line 59. What version of MySQL are you building it with? I'd have to be a pretty old version not to support the ENINE=MyISAM option. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Nagios-users mailing list Nagios-users@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
[Nagios-users] Nagios with MySQL??
Hello, Is it true that Nagios 2.* doesn't support MySQL anymore? I would like to set up Nagios and have it store its status and possibly it's configuration in a database (and read its config from the database). Is this still possible, or can anyone recommand a plugin or add-on which works pretty good? Thanks in advance! -Jeffrey --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Nagios-users mailing list Nagios-users@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
RE: [Nagios-users] Nagios with MySQL??
Jeffery, I'm using the eventbroker that Marc spoke of, which very well. For the configuration, you can look at NagiosQL. If you like writing in PHP, you *could* write your own interface, which depending on your PHP skills and needs could be as complicated or as easy as you like. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, May 19, 2006 9:58 AM To: Nagios Users Mailinglist Subject: [Nagios-users] Nagios with MySQL?? Hello, Is it true that Nagios 2.* doesn't support MySQL anymore? I would like to set up Nagios and have it store its status and possibly it's configuration in a database (and read its config from the database). Is this still possible, or can anyone recommand a plugin or add-on which works pretty good? Thanks in advance! -Jeffrey --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Nagios-users mailing list Nagios-users@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 --- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid0709bid3057dat1642 ___ Nagios-users mailing list Nagios-users@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
Re: [Nagios-users] Nagios-db mysql module not working UPDATE
hi, here is a patch to the current CVS revision of nagios-db for postgres. This patch does: * correct a bug on startup concerning neb_register_callback command change * add some logging messages to help debugging * correct a small typo in handling options (see offset bugs in option parsing http://sourceforge.net/mailarchive/message.php?msg_id=12557459 ) * modified neb initialisation so that 'processStart' is called when Nagios starts and not when we have a NEBCALLBACK_TIMED_EVENT_DATA . The problem was that processStart() was called berfore the nagios configuration was loaded and therefor processStart() did not have configuration data available. File is available here: http://www.barbich.net/websvn/wsvn/nagios/nagios/patches/nagios-db/inserter.c.patch?op=filerev=0sc=0 Good luck. Seb.B On 11/24/05, Mohr James [EMAIL PROTECTED] wrote: I realized that I was actually compiling it against Nagios2.0b3. So I fixed the Makefile like this: gcc -g -O2 -Wall -o inserter.o inserter.c -shared -I/opt/INSTALL/nagios/nagios-2.0b5/include/ -I/usr/include/mysql -lmysqlclient -fPICThis gave me several messages like this:inserter.c: In function `loadconfig': inserter.c:345: warning: passing arg 3 of `neb_register_callback' makes integer from pointer without a castinserter.c:345: error: too few arguments to function `neb_register_callback'There were only three arguments passed to neb_register_callback, although per nebmods.c it should be expecting 4:int neb_register_callback(int callback_type, void *mod_handle, int priority, int (*callback_func)(int,void *)){So I changed inserter.c accordingly: neb_register_callback(NEBCALLBACK_TIMED_EVENT_DATA,loadconfig, 0, loadconfig); neb_register_callback(NEBCALLBACK_HOST_STATUS_DATA,processStatus, 0, processStatus); neb_register_callback(NEBCALLBACK_SERVICE_STATUS_DATA,processStatus, 0, processStatus); neb_register_callback(NEBCALLBACK_HOST_CHECK_DATA,processCheck, 0, processCheck); neb_register_callback(NEBCALLBACK_SERVICE_CHECK_DATA,processCheck, 0, processCheck);In all honesty, I have no idea if this change is correct. It *looks* right, but I am obviously not sure. Any help would be appreaciated. Regards,Jim Mohr-Ursprüngliche Nachricht-Von: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] Im Auftrag von Mohr JamesGesendet: Donnerstag, 24. November 2005 20:31An: Nagios-users@lists.sourceforge.net Betreff: [Nagios-users] Nagios-db mysql module not workingHi All!I have Nagios 2.0b5, nagios-db 0.91 and MySQL 4.1.15, including MySQL-MAX 4.1.15. When Nagios starts I see the module is loaded(nagios-db: inserter locked into db) and the appropriate message when nagios shuts down. However, nothing is getting loaded into the database, and I do not see any error messages in /var/log/messages. I have changed inserted.c to reflect the user/password of the database(nagios/nagios) and I can log inusing the mysql command and insert data directly into the tables. I have also tried changing the values (i.e .nagios2/nagios) in the nebmodule_init function and it reports the errornagios-db: inserter failed to connect to db. This convinces be that at least I am connecting to the database and the username/password are correct. The nagios.cfg has this:event_broker_options=-1broker_module=/opt/INSTALL/nagios-db-0.91/neb/mysql/inserter.oAnd the path is correct.Near the top of the loadconfig function I added this: write_to_logs_and_console(Inside ofloadconfig,NSLOG_INFO_MESSAGE,TRUE);As well as in a couple of other places.My assumption is that it should write an entry to /var/log/messages when this function is called. Perhaps the function is being called, but this line is not writing to where I expect. It seems that other than the init/deinit functions, nothing else is getting called. I loaded another NEB module that has this:snprintf(temp_buffer,sizeof(temp_buffer)-1,EVENT: %d MESSAGE:%s,event_type,tmp_service-plugin_output);write_to_all_logs(temp_buffer,NSLOG_INFO_MESSAGE); These messages are getting writting to the /var/log/messages.I am at a loss as to where to look next. Any help is greatly appreaciated.Regards,Jim Mohr--- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems?Stop!Download the new AJAX search engine that makes searching your log files as easy as surfing theweb.DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=ick___Nagios-users mailing list Nagios-users@lists.sourceforge.nethttps://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: Splunk Inc. Do you grep through log files for problems?Stop!Download the new AJAX search engine that makessearching your log files as easy as surfing
[Nagios-users] nagios and MySQL
I downloaded the nagios-db plugin for nagios-2. But there's no install instructions ! I can create the database but unsure of how to install the event processing routines. Is there install instruction or a howto ?? CraigW --- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_id=7628alloc_id=16845op=click ___ Nagios-users mailing list Nagios-users@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