Nagios CCM - Login creation / Nagios Audit Log

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Nagios CCM - Login creation / Nagios Audit Log

Post by rajasegar »

Nagios XI 2014R1.2

1) Can you please advice how to create login for Nagios CCM?
We want to create individual ID for the admins.

2) How do we export Nagios audit logs in syslog format to a central syslog server?

Thanks
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Nagios CCM - Login creation / Nagios Audit Log

Post by lmiltchev »

1) Can you please advice how to create login for Nagios CCM?
We want to create individual ID for the admins.
Admin->Manage System Config->Separate CCM Login = checked->Update Settings
CCM->Config Manager Admin->Manage Config Access->Add New
2) How do we export Nagios audit logs in syslog format to a central syslog server?
I can certainly see a value in this. I will be posting an internal feature request for adding this functionality to Nagios XI.
Be sure to check out our Knowledgebase for helpful articles and solutions!
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Nagios CCM - Login creation / Nagios Audit Log

Post by rajasegar »

lmiltchev wrote:
1) Can you please advice how to create login for Nagios CCM?
We want to create individual ID for the admins.
Admin->Manage System Config->Separate CCM Login = checked->Update Settings
CCM->Config Manager Admin->Manage Config Access->Add New
2) How do we export Nagios audit logs in syslog format to a central syslog server?
I can certainly see a value in this. I will be posting an internal feature request for adding this functionality to Nagios XI.
Thanks. In the meantime where do I find the audit log in the server? Any particular file?
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Nagios CCM - Login creation / Nagios Audit Log

Post by lmiltchev »

Thanks. In the meantime where do I find the audit log in the server? Any particular file?
It's not in a file - it's in PostgresQL database. That's why it's not easy to send it to a "central log server". I already posted a feature request (TASK ID 4297) about adding this functionality.
Be sure to check out our Knowledgebase for helpful articles and solutions!
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Nagios CCM - Login creation / Nagios Audit Log

Post by rajasegar »

lmiltchev wrote:
Thanks. In the meantime where do I find the audit log in the server? Any particular file?
It's not in a file - it's in PostgresQL database. That's why it's not easy to send it to a "central log server". I already posted a feature request (TASK ID 4297) about adding this functionality.
Ok. Which table in PostgresQL then?
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Nagios CCM - Login creation / Nagios Audit Log

Post by tmcdonald »

xi_auditlog:

Code: Select all

nagiosxi=> \d xi_auditlog;
                                          Table "public.xi_auditlog"
   Column    |            Type             |                             Modifiers
-------------+-----------------------------+-------------------------------------------------------------------
 auditlog_id | integer                     | not null default nextval('xi_auditlog_auditlog_id_seq'::regclass)
 log_time    | timestamp without time zone |
 source      | text                        |
 user        | text                        |
 type        | integer                     |
 message     | text                        |
 ip_address  | text                        |
Indexes:
    "xi_auditlog_pkey" PRIMARY KEY, btree (auditlog_id)
    "xi_auditlog_ip_address" btree (ip_address)
    "xi_auditlog_log_time" btree (log_time)
    "xi_auditlog_source" btree (source)
    "xi_auditlog_type" btree (type)
    "xi_auditlog_user" btree ("user")

nagiosxi=>
Former Nagios employee
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Nagios CCM - Login creation / Nagios Audit Log

Post by rajasegar »

tmcdonald wrote:xi_auditlog:

Code: Select all

nagiosxi=> \d xi_auditlog;
                                          Table "public.xi_auditlog"
   Column    |            Type             |                             Modifiers
-------------+-----------------------------+-------------------------------------------------------------------
 auditlog_id | integer                     | not null default nextval('xi_auditlog_auditlog_id_seq'::regclass)
 log_time    | timestamp without time zone |
 source      | text                        |
 user        | text                        |
 type        | integer                     |
 message     | text                        |
 ip_address  | text                        |
Indexes:
    "xi_auditlog_pkey" PRIMARY KEY, btree (auditlog_id)
    "xi_auditlog_ip_address" btree (ip_address)
    "xi_auditlog_log_time" btree (log_time)
    "xi_auditlog_source" btree (source)
    "xi_auditlog_type" btree (type)
    "xi_auditlog_user" btree ("user")

nagiosxi=>
Thanks, please close this case.
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
Locked