Nagios XI - Trap definitons limit

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
kandatih
Posts: 55
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Post by kandatih »

Attached the requested commands output. Thanks.
You do not have the required permissions to view the files attached to this post.
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios XI - Trap definitons limit

Post by tgriep »

That data looks correct. The only thing I see is the name of the MIB files are different from what was uploaded earlier in the post.
If the names don't match, that could be it.

To check that, run the following commands and post the output here.

Code: Select all

echo 'desc xi_mibs;' |mysql -t -u root -pnagiosxi nagiosxi
echo 'select * from xi_mibs;' |mysql -t -u root -pnagiosxi nagiosxi
Thanks.
Be sure to check out our Knowledgebase for helpful articles and solutions!
kandatih
Posts: 55
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Post by kandatih »

Thanks, Attached the log.
You do not have the required permissions to view the files attached to this post.
User avatar
tgriep
Madmin
Posts: 9177
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios XI - Trap definitons limit

Post by tgriep »

Thats it, the names of the files in the database don't match so that is why the numbers don't add up.

If you like, you can delete the entries by running the following as root.

Code: Select all

echo "DELETE FROM xi_cmp_trapdata WHERE trapdata_parent_mib_name = 'CPQHOST-MIB';" |mysql -u root -pnagiosxi nagiosxi
echo "DELETE FROM xi_cmp_trapdata WHERE trapdata_parent_mib_name = 'CPQRACK-MIB';" |mysql -u root -pnagiosxi nagiosxi
echo "DELETE FROM xi_mib WHERE mib_name = 'cpqhost';" |mysql -u root -pnagiosxi nagiosxi
echo "DELETE FROM xi_mib WHERE mib_name = 'cpqrack';" |mysql -u root -pnagiosxi nagiosxi
Then, go back to the Manage MIBs menu, click on the Blue Arrow pointing to the right to process them and see if the numbers add up.

If not, run these 2 command again and post the output.

Code: Select all

echo 'select trapdata_parent_mib_name from xi_cmp_trapdata;' |mysql -t -u root -pnagiosxi nagiosxi
echo 'select * from xi_mibs;' |mysql -t -u root -pnagiosxi nagiosxi
Be sure to check out our Knowledgebase for helpful articles and solutions!
kandatih
Posts: 55
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Post by kandatih »

Assume running delete query, will delete the respective mibs and associated trap definitions. Dont think the mib will be available(and wont have an option to click on process) in Manage MIBs page, is my understanding right?

If I understand it right the mib_name field in xi_mibs table should match with trapdata_parent_mib_name in trapdata_parent_mib_name table for the associated traps to work correctly. If this is right, we may need to delete the mibs and try to rename the mibs as below reload them
cpqrack.mib to CPQRACK-MIB.mib
cpqhost.mib to CPQHOST-MIB.mib
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Trap definitons limit

Post by cdienger »

A small change to the last two commands that were provided:

Code: Select all

echo "DELETE FROM xi_mibs WHERE mib_name = 'cpqhost';" |mysql -u root -pnagiosxi nagiosxi
echo "DELETE FROM xi_mibs WHERE mib_name = 'cpqrack';" |mysql -u root -pnagiosxi nagiosxi

Code: Select all

Assume running delete query, will delete the respective mibs and associated trap definitions. Dont think the mib will be available(and wont have an option to click on process) in Manage MIBs page, is my understanding right?
After running the SQL statements the web UI will still show the MIB files as it gets them from the filesystem. The upload timestamp, status, processed, and associated trap count will be available though until the files are reprocessed.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
kandatih
Posts: 55
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Post by kandatih »

Still dont see the trap definitions count. Attached the screenshots captured after running the delete query.
You do not have the required permissions to view the files attached to this post.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Trap definitons limit

Post by cdienger »

I see the problem. mib_name comes from the filename, but trapdata_parent_mib_name comes from the definition in the mib. For example:

Code: Select all

CPQRACK-MIB DEFINITIONS ::= BEGIN
To work around this, remove the entries from the db again, change the file names to cpqhost-MIB and cpqrack-MIB, and then import them.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Trap definitons limit

Post by cdienger »

This was fixed in 5.6.3 :)
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
kandatih
Posts: 55
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Post by kandatih »

Yep, changing the filename works, thanks a bunch both @cdienger & tgriep :D
Coming back to my initial question in this post..I understand there is no hard limit on the number of mibs or trap definitions we could add on a xi server. In case of alarm/trap flood, we would like to know how snmptt handles the traffic.Time taken to process a trap would be useful. Could you advise how to raise this a feature request.
Locked