Page 1 of 1

Nagios CCM - Login creation / Nagios Audit Log

Posted: Tue Oct 28, 2014 3:58 am
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

Re: Nagios CCM - Login creation / Nagios Audit Log

Posted: Tue Oct 28, 2014 10:54 am
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.

Re: Nagios CCM - Login creation / Nagios Audit Log

Posted: Tue Oct 28, 2014 6:08 pm
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?

Re: Nagios CCM - Login creation / Nagios Audit Log

Posted: Wed Oct 29, 2014 12:48 pm
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.

Re: Nagios CCM - Login creation / Nagios Audit Log

Posted: Wed Oct 29, 2014 6:00 pm
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?

Re: Nagios CCM - Login creation / Nagios Audit Log

Posted: Thu Oct 30, 2014 9:12 am
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=>

Re: Nagios CCM - Login creation / Nagios Audit Log

Posted: Thu Oct 30, 2014 5:58 pm
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.