Nagios Support Forum

I tried the last few steps agains starting from teh sub components install. The import went well till i got this error

RESETTING PERMS
/usr/local/nagiosxi/nom/checkpoints/nagioscore /home/nagiosxi/nagiosxi/basedir/scripts
tar: Removing leading `/' from member names
/home/nagiosxi/nagiosxi/basedir/scripts
ERROR: Unable to login to NagiosQL on 'localhost' - exiting. If you have a proxy configured, this may be the cause of the problem.

Thank You for yuour help thus far

Lets start back from the beginning. You should not have to modify the install scripts, and doing so creates an install that we cannot support. We've tested repeatedly on clean Redhat installs that are registered with the RHN, and the install scripts should execute without issue. I suggest starting fresh and first verifying the following things:

Can you successfully complete the following: or does it error out and stop. If it does, then you either have an issue with your network or RHN registration, in which case you need to resolve that before proceeding with any installation scripts. Our scripts require the full use of yum to execute.

No issues with yum update
The changes i made were mostly related to $PATH

I think /sbin or related /sbin should be added to the instructions ...

i am going to try and remove and start all over again. as indicated the issue what went wrong but i can start all services and even connect to database manaully.

Hi

I installed it all over and i seem to have a different error

SQL: SQL Error [nagiosxi] : Table 'nagiosql.xi_users' doesn't exist


So its a progress from the last time. i can log on but i believe the install or loading of some tables failed

thansk

That table is located in the postgres DB. Let me check the install scripts and see what I can find, and I may have you run a few scripts again and send us the output. I'll repost shortly.

Hi

Thanks for the time on this...i got a new box today, i installed and it works fine...now i need to read more about plugins. I already have the clients agents configured for a nagios core on another server..is there a way to get them to start talking to nagioxi rather...as noted i am yet to read on admin stuff

Thanks for the time on this...i got a new box today, i installed and it works fine...

Awesome!

Yeah if you've already got the agents setup that shouldn't be too hard. You'll just need to add you XI server's IP to the list of allowed hosts on your remote clients, and you could import the configs from your Core server.

The Admin manual might be handy for both setting up the agents and importing configs from a Core install.
http://assets.nagios.com/downloads/nagi ... .php#linux

Hi

Hopefully you can help with this request. I am still reading more about the administrative parts. I am yet to find a document which has all the start, stop etc, of the entire services. I can do that via a modified version of the ./F_startXXXXXX script. Anyway if you have an administrative guide please send it to me. I saw one on your website but it is not detailed enough.

With our nagios core I was able to change the pager number based on the on call rotation via a combination of sql and UNIX scripting. I believe this is possible also with nagiosxi but this time via mysql database. Please can you help locate the absolute table that holds the records for the pager number for a particular contact? I will then find a way to update that based on our on call rotation every morning.

Based on the little I know I think the steps will be

1. Update the table in the database
2. Export the records to nagios core
3. Restart all services (I think)

Thanks

http://assets.nagios.com/downloads/nagi ... nistrator/
http://library.nagios.com/library/produ ... mentation/

The above site are what we have for current documentation on XI so far. A lot of our documentation is produced from user needs and requests, so if there's something you need more detail on let us know and we'll put it on our TODO list.

I'll be honest in that I haven't come across a setup like what you're doing yet for the pager, but here are some pointers that will hopefully set you in the right direction for what you need.

XI user and contact management should primarily be setup through the XI->Admin Manage Users page, and users should set up their notification settings and such through the Configure->My Account settings page. See the Doc on "Users and Contacts" in the Admin manual if you're going to specify more advanced settings for contacts.

The xi-host/service-notification-handler command MUST be used for all users to receive notifications, however you can add additional notification commands to the list, and I would recommend this because I don't think the xi-host/service-notification-handler uses the $CONTACTPAGER$ macro. (Most users use the settings for mobile carriers/devices through the XI interface).

I think you might be able to set up the contact scenario you're talking about by creating a contact group, and then specifying the appropriate timeperiods and number for each user, but you may have to play with it to see if that will work.

Hopefully that was more helpful than confusing, let us know if you need more detail.

Well thanks for the input..

what i need is the manul scripts to flush database contacts.cfg to teh nagios core. i mean the command line.

i have now been able to to update the contact table in mysql with pager number. this is usefull as we will not have to maintain who is on call from nagios. in case someone switch with me, all they have to do is to update one place and all our monitoring tools, including nagios can find the urrent pager number.


I use this simple scipt to do that


pager_number=`cat /usr/local/nagios/dba_scripts/Curr_pager_number`
contacts_file=/usr/local/nagios/etc/contacts.cfg
Current_pager=`cat $contacts_file |grep 'XXXXXX.XXXXX.org'|awk '{print $2}'`
#
#
#--------------------------------------------
if [ ${pager_number} = ${Current_pager} ];then
exit
else
echo " Replacing On call Dba Pager Number "
#
echo "update tbl_contact set pager='${pager_number}' where contact_name='DBAPAGER'" > insert_curr_pnumber_mysql.sql
mysql nagiosql -u root -pXXXXXXX < insert_curr_pnumber_mysql.sql
fi
~


Okay now i need to find flush these enteries in to nagios core contacts.cfg

Thanks