How can I access the Nagios XI DB?

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
kenb
Posts: 6
Joined: Wed Apr 04, 2012 4:38 pm

How can I access the Nagios XI DB?

Post by kenb »

We updated some SNMP strings and shortly after a bunch of alerts which is expected. I've tried to update the .cfg files but they get overwritten soon afterwards. I'm assuming what I need to change resides in the Postgres database. Can anyone point me to the connection information for the nagios postgres db?
nagiosadmin42
Posts: 96
Joined: Sat Feb 11, 2012 2:16 pm

Re: How can I access the Nagios XI DB?

Post by nagiosadmin42 »

Our install is Nagios XI 2011R3.2, which uses mysql and the "nagiosql" database. The default password is "nagiosxi", so to access the database via the command line use: mysql -u root -p"nagiosxi" nagiosql
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: How can I access the Nagios XI DB?

Post by scottwilkerson »

nagiosadmin42 wrote:Our install is Nagios XI 2011R3.2, which uses mysql and the "nagiosql" database. The default password is "nagiosxi", so to access the database via the command line use: mysql -u root -p"nagiosxi" nagiosql
Thanks.

That would be correct. Be careful while directly accessing the database, it is very easy to break a whole system....
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked