hi team,
I have a plugin check process on my server.
when i run my plugin on command line, it show 30 rows alert, but in Nagios xi Web, show ab 7-8 rows only.
Dont know is there any limit on nagios xi show?
thank you
limit show alert on nagios xi?
-
sacom01
- Posts: 194
- Joined: Wed Dec 23, 2020 10:15 pm
limit show alert on nagios xi?
You do not have the required permissions to view the files attached to this post.
-
dchurch
- Posts: 858
- Joined: Wed Oct 07, 2020 12:46 pm
- Location: Yo mama
Re: limit show alert on nagios xi?
The database field holding the plugin output is constrained to a certain number of characters so it must truncate the output it holds onto. The reason is that Nagios xi takes and categorizes and archives output from plugins for auditing and reporting, often months after the fact. As such the database can get bogged down with inefficient queries if it holds onto more output than that.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
sacom01
- Posts: 194
- Joined: Wed Dec 23, 2020 10:15 pm
Re: limit show alert on nagios xi?
if so, the alert will not exact as it need.
How to fix for this case?
How to fix for this case?
-
dchurch
- Posts: 858
- Joined: Wed Oct 07, 2020 12:46 pm
- Location: Yo mama
Re: limit show alert on nagios xi?
Can you please run this command?
Then PM the resulting /tmp/nagios.sql.gz file?
Code: Select all
mysqldump -uroot -pnagiosxi nagios | gzip -9 >/tmp/nagios.sql.gzIf you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
sacom01
- Posts: 194
- Joined: Wed Dec 23, 2020 10:15 pm
Re: limit show alert on nagios xi?
sent you, pls check ib
-
dchurch
- Posts: 858
- Joined: Wed Oct 07, 2020 12:46 pm
- Location: Yo mama
Re: limit show alert on nagios xi?
What command is it that you're running to generate the 30 rows of alerts?
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
sacom01
- Posts: 194
- Joined: Wed Dec 23, 2020 10:15 pm
Re: limit show alert on nagios xi?
Run this on command. All arguments fixed inside the code.
You do not have the required permissions to view the files attached to this post.
-
dchurch
- Posts: 858
- Joined: Wed Oct 07, 2020 12:46 pm
- Location: Yo mama
Re: limit show alert on nagios xi?
For some reason the output column isn't a TEXT column, but a varchar(255) column.
Try running the following command:
Then re-run the service check from the web interface by clicking "Force an immediate check"
Try running the following command:
Code: Select all
mysql -uroot -pnagiosxi nagios <<'EOSQL'
alter table nagios_servicestatus modify output text NOT NULL;
alter table nagios_statehistory modify output text NOT NULL;
alter table nagios_systemcommands modify output text NOT NULL;
alter table nagios_eventhandlers modify output text NOT NULL;
alter table nagios_hostchecks modify output text NOT NULL;
alter table nagios_hoststatus modify output text NOT NULL;
alter table nagios_notifications modify output text NOT NULL;
alter table nagios_servicechecks modify output text NOT NULL;
alter table nagios_servicestatus modify output text NOT NULL;
alter table nagios_statehistory modify output text NOT NULL;
EOSQL
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
sacom01
- Posts: 194
- Joined: Wed Dec 23, 2020 10:15 pm
Re: limit show alert on nagios xi?
after run these commands and force check, it work, show all alert, bug only ONE time. After that it back as before, less than 10 rows. I tried some times but not work again.
-
dchurch
- Posts: 858
- Joined: Wed Oct 07, 2020 12:46 pm
- Location: Yo mama
Re: limit show alert on nagios xi?
In order to escalate this issue and take a deeper dive into what's causing this, I'd suggest you create a ticket so we can hopefully get this resolved ASAP.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.