Nagios XI - Trap definitons limit
Re: Nagios XI - Trap definitons limit
Attached the requested commands output. Thanks.
You do not have the required permissions to view the files attached to this post.
Re: Nagios XI - Trap definitons limit
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.
Thanks.
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
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Nagios XI - Trap definitons limit
Thanks, Attached the log.
You do not have the required permissions to view the files attached to this post.
Re: Nagios XI - Trap definitons limit
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.
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.
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
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!
Re: Nagios XI - Trap definitons limit
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
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
Re: Nagios XI - Trap definitons limit
A small change to the last two commands that were provided:
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.
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?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Nagios XI - Trap definitons limit
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.
Re: Nagios XI - Trap definitons limit
I see the problem. mib_name comes from the filename, but trapdata_parent_mib_name comes from the definition in the mib. For example:
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.
Code: Select all
CPQRACK-MIB DEFINITIONS ::= BEGIN
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Nagios XI - Trap definitons limit
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.
Re: Nagios XI - Trap definitons limit
Yep, changing the filename works, thanks a bunch both @cdienger & tgriep
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.
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.