How can I access the Nagios XI DB?
How can I access the Nagios XI DB?
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?
-
- Posts: 96
- Joined: Sat Feb 11, 2012 2:16 pm
Re: How can I access the Nagios XI DB?
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
-
- 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?
Thanks.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
That would be correct. Be careful while directly accessing the database, it is very easy to break a whole system....