Nagios XI - Trap definitons limit

This board serves as an open discussion and support collaboration point for Nagios XI. NOTE: Nagios XI customers should use the Customer Support forum to obtain expedited support.

Re: Nagios XI - Trap definitons limit

Postby kandatih » Sun Jun 16, 2019 5:39 pm

Attached the requested commands output. Thanks.
Attachments
traplog.txt
(10.81 KiB) Downloaded 41 times
kandatih
 
Posts: 51
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Postby tgriep » Mon Jun 17, 2019 8:27 am

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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
tgriep
Madmin
 
Posts: 8077
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios XI - Trap definitons limit

Postby kandatih » Mon Jun 17, 2019 2:35 pm

Thanks, Attached the log.
Attachments
traplog1.txt
(9.16 KiB) Downloaded 40 times
kandatih
 
Posts: 51
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Postby tgriep » Mon Jun 17, 2019 3:31 pm

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
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
tgriep
Madmin
 
Posts: 8077
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios XI - Trap definitons limit

Postby kandatih » Mon Jun 17, 2019 10:01 pm

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
kandatih
 
Posts: 51
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Postby cdienger » Tue Jun 18, 2019 3:18 pm

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.
User avatar
cdienger
Support Tech
 
Posts: 3307
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Trap definitons limit

Postby kandatih » Tue Jun 18, 2019 10:24 pm

Still dont see the trap definitions count. Attached the screenshots captured after running the delete query.
Attachments
LogAfterDeleteQuery.docx
(96.71 KiB) Downloaded 9 times
kandatih
 
Posts: 51
Joined: Thu Mar 28, 2019 7:51 pm

Re: Nagios XI - Trap definitons limit

Postby cdienger » Wed Jun 19, 2019 3:06 pm

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: 3307
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Trap definitons limit

Postby cdienger » Wed Jun 19, 2019 3:17 pm

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.
User avatar
cdienger
Support Tech
 
Posts: 3307
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Trap definitons limit

Postby kandatih » Wed Jun 19, 2019 3:35 pm

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.
kandatih
 
Posts: 51
Joined: Thu Mar 28, 2019 7:51 pm

PreviousNext

Return to Nagios XI

Who is online

Users browsing this forum: No registered users and 17 guests