Nagios Support Forum

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

By default this would be n@gweb until otherwise edited.

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?

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

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"

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

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.

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.

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.

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?