Page 2 of 2
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 12:02 pm
by nagwindmon
PM sent with requested info
Thanks!
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 12:21 pm
by tgriep
The error when downloading the system profile is a permission issue or a missing / changed setting in the /etc/sudoers file. Take a look at this KB article to see if that fixed that issue.
https://support.nagios.com/kb/article/n ... ailed.html
Can you post or pm me the following file?
Code: Select all
/usr/local/nagiosxi/html/config.inc.php
As well as the output from this command run as root?
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 12:39 pm
by nagwindmon
downloading the system profile issue has been resolved, System file has been pm'd
2 other pieces of info requested please see attached
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 1:01 pm
by tgriep
Your Nagios XI server is using the Postgres database so you woulld have to use this command to set the API key. Replace 1234567890 with the key you want to use.
Code: Select all
echo 'UPDATE xi_users SET backend_ticket = '123456780' WHERE user_id = 18;' | psql nagiosxi nagiosxi
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 1:15 pm
by nagwindmon
well, good know, that worked!
So for NagiosXI ver 5.x.x and up would you suggest to convert from PostgreSQL to MySQL going forward?
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 1:22 pm
by dwhitfield
Converting will be a painful process. If you want to just note in tickets/forum threads that you have postgres for the XI database that would be helpful. It's one of the reasons we ask for the full profile but when we check that we're mostly looking at /usr/local/nagiosxi/html/config.inc.php for determining postgres usage (running processes also useful). If mention your system has been upgraded from 2014, that will also be a clue.
That all said, are we ready to lock this up?
Re: Set API key for NagosXI
Posted: Fri May 26, 2017 1:28 pm
by nagwindmon
Got it, Yes we're ready to lock it, as always appreciated your help guys!!