Nagios CCM Login question ...

[PhilG]

Hello:
We are running Nagios XI 2014R1.2.
I have created a Nagios XI user account that is spelled the same as my Active Directory, ex. firstname.lastname, and made that account an "Admin" "Authorization Level.
We have the Active Directory Authentication component installed and is working with no issues - I can login to our Nagios XI web GUI console with my Active Directory account.
I noted that when I tried to login to the "Nagios CCM Login" with my account (firstname.lastname) with either my Active Directory account or Nagios XI local user account password, I can not login to the CCM.
Is this by design that ONLY the Nagios Admin local account can login to the CCM?

[BanditBBS]

CCM uses different login credentials and does not sync with AD unfortunately.

[PhilG]

CCM uses different login credentials and does not sync with AD unfortunately.

So, do I have to provide the NagiosAdmin account and password to all my colleagues, or can I make it work so that they can login with their Nagios XI local account which was assigned with Admin Authorization Level, and if so, how, please?

[BanditBBS]

Login to the CCM. At the bottom is Config Managaer Admin. Then click on Manage Config Access. There you can add new IDs for access into CCM.

[PhilG]

Login to the CCM. At the bottom is Config Managaer Admin. Then click on Manage Config Access. There you can add new IDs for access into CCM.

Thank you.
I'm still on a huge learning curve with Nagios XI with having to pick this up on my own with no training, and things like that are not obvious, so I appreciate the help.

[PhilG]

I tried to add a new user for the Config Access and received the following error:
"Error while inserting data into the database:
Unknown column 'locale' in 'field list'
"
I tried creating my Active Directory account which uses firstname.lastname, then I tried creating an account with just my lastname, and both received the same error.

[lmiltchev]

Do you see the locale field in the "tbl_user" table?

Code: Select all

echo 'desc tbl_user;' | mysql -pnagiosxi nagiosql | grep locale

If it is missing, you can run:

Code: Select all

echo "ALTER TABLE tbl_user ADD COLUMN locale VARCHAR(6) DEFAULT 'en_EN';"|mysql -pnagiosxi nagiosql
service mysqld restart

[PhilG]

Do you see the locale field in the "tbl_user" table?

Code: Select all

echo 'desc tbl_user;' | mysql -pnagiosxi nagiosql | grep locale

If it is missing, you can run:

Code: Select all

echo "ALTER TABLE tbl_user ADD COLUMN locale VARCHAR(6) DEFAULT 'en_EN';"|mysql -pnagiosxi nagiosql
service mysqld restart

The first command just spit out your echo and ran for a few minutes, so I CTRL-D out of the process thinking that it was going into a loop.

With the help of our database admin, I ran a query at the MySQL prompt:
SELECT * FROM information_schema.columns WHERE table_schema = 'nagiosql' and column_name='locale';
which came up as an empty set.

I ran your two commands with success at the non-mysql prompt, reran our query in the mysql prompt and was successful:
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+----------------------
--+-------------------+---------------+--------------------+-----------------+-------------+------------+-------+---------------------------------+----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGT
H | NUMERIC_PRECISION | NUMERIC_SCALE | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT |
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+----------------------
--+-------------------+---------------+--------------------+-----------------+-------------+------------+-------+---------------------------------+----------------+
| NULL | nagiosql | tbl_user | locale | 11 | en_EN | YES | varchar | 6 | 1
8 | NULL | NULL | utf8 | utf8_general_ci | varchar(6) | | | select,insert,update,references | |
+---------------+--------------+------------+-------------+------------------+----------------+-------------+-----------+--------------------------+----------------------
--+-------------------+---------------+--------------------+-----------------+-------------+------------+-------+---------------------------------+----------------+
1 row in set (0.02 sec)



I went back into the Nagios XI web console, and added a new CCM config manager account and was successful.

Thank you for your assistance.

You may lock this post.