Page 1 of 3
Nagios XI Core Config Manager DB Password
Posted: Sun Apr 10, 2011 5:55 pm
by mtkaschools
Hello,
Does anyone know what the password would be for the 'nagiosql' user to connect to the database? I'm attempting to setup NagVis.
Thanks,
Aaron
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 9:17 am
by rdedon
By default this would be n@gweb until otherwise edited.
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 12:00 pm
by mtkaschools
What are the table prefix names? When setting up nagvis, I keep getting a message that apparently indicates it's not 'nagios_'. What should I use for the prefix?
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 12:23 pm
by mguthrie
The table breakdown crashcourse is listed below:
ndoutils utils (status info): database "nagios". Tables are all prepended with "nagios_"
NagiosQL table (config info): database "nagiosql". Tables are prepended with "tbl_"
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 12:31 pm
by mtkaschools
hmm, I have 'tbl_' as the prefix, but it still doesn't connect. Here's what I have in my config file.
; hostname for NDO-db
;dbhost="localhost"
; portname for NDO-db
;dbport=3306
; database name for NDO-db
;dbname="nagios"
; username for NDO-db
;dbuser="root"
; password for NDO-db
;dbpass=""
; prefix for tables in NDO-db
dbprefix="tbl_"
; instance name for tables in NDO-db
;dbinstancename="default"
; maximum delay of the NDO Database in seconds
;maxtimewithoutupdate=180
; path to the cgi-bin of this backend
;htmlcgi="/nagios/cgi-bin"
dbhost="localhost"
dbport=3306
dbname="nagiosql"
dbuser="nagiosql"
dbpass="n@gweb"
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 1:39 pm
by mguthrie
I should have thought of this earlier, but we have a document and an installer script for integrating NagVis with an XI install. This would be the super easy way to get you set up.
http://library.nagios.com/library/produ ... -nagios-xi
If you're preferring to use the very latest NagVis and do it manually, I think the problem is that you're accessing the nagiosql database, not the ndoutils database. Here's probably what you need (bear in mind I've usually just used our script to set it up in the past).
Code: Select all
; hostname for NDO-db
dbhost="localhost"
; portname for NDO-db
dbport=3306
; database name for NDO-db
dbname="nagios"
; username for NDO-db
dbuser="root"
; password for NDO-db
dbpass="nagiosxi"
; prefix for tables in NDO-db
dbprefix="tbl_"
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 2:17 pm
by mtkaschools
Hmm, even with those settings, I still get a message indicating it doesn't know what to do with tbl_. I've attached a screen shot of the configuration window.
Re: Nagios XI Core Config Manager DB Password
Posted: Mon Apr 11, 2011 3:02 pm
by mguthrie
I would try removing the table prefix and see what that does.
If that doesn't work, I would use our installer script in the above doc, which handles all of the necessary configuration for an XI install.
Re: Nagios XI Core Config Manager DB Password
Posted: Tue Apr 12, 2011 9:47 am
by tonyyarusso
Yeah, NagVis works with the 'nagios' database (from NDOUtils, with a nagios_ prefix), not the 'nagiosql' one. I've now also updated the script mguthrie linked to to fetch NagVis 1.5.8.
Re: Nagios XI Core Config Manager DB Password
Posted: Fri Apr 15, 2011 7:22 am
by mtkaschools
if I install nagvis this way, I end up getting a login prompt; where the only username and password it accepts is one I had previously setup in NagiosXI. Is it possible to get the configuration I would need to put into Nagvis to access the 'nagios' database?