Search found 7 matches

by opservidores
Thu Jun 24, 2021 3:21 am
Forum: Nagios XI
Topic: Error inserting in table nagios_servicechecks
Replies: 5
Views: 304

Re: Error inserting in table nagios_servicechecks

Thank you, change made, everything working.
by opservidores
Sat Jun 19, 2021 8:18 am
Forum: Nagios XI
Topic: Error inserting in table nagios_servicechecks
Replies: 5
Views: 304

Re: Error inserting in table nagios_servicechecks

Change to int(20) didn't solve the error. The max value of a int column is 2147483647 ( https://dev.mysql.com/doc/refman/8.0/en/integer-types.html ). My auto increment column already had that number. Based on it, the solution is alter column to serial (or bigint), where the max value is 2^63-1. The ...
by opservidores
Sat Jun 19, 2021 7:45 am
Forum: Nagios XI
Topic: Error inserting in table nagios_servicechecks
Replies: 5
Views: 304

Re: Error inserting in table nagios_servicechecks

Thank you Saxx. I saw that solution on other post, with bigint. My question is : this change don't will be a problem in future upgrades?

Regards,
Rui
by opservidores
Fri Jun 18, 2021 9:34 am
Forum: Nagios XI
Topic: Error inserting in table nagios_servicechecks
Replies: 5
Views: 304

Error inserting in table nagios_servicechecks

Hello All, After upgrade to version 5.8.3, we got errors in /usr/local/nagios/var/archives/nagios-06-*-2021-00.log. Log files increase from 6 MB to 11GB. Run a checkDB, everything is fine. I inserted manually with command showed on logs and I got this error : MariaDB [nagios]> INSERT INTO nagios_ser...
by opservidores
Mon Oct 12, 2020 8:43 am
Forum: Nagios XI
Topic: MRTG after upgrade to 5.7.3
Replies: 5
Views: 330

Re: MRTG after upgrade to 5.7.3

Thanks for the information.
We will be checking the update of our OS.
by opservidores
Fri Oct 09, 2020 10:16 am
Forum: Nagios XI
Topic: MRTG after upgrade to 5.7.3
Replies: 5
Views: 330

Re: MRTG after upgrade to 5.7.3

What are the permissions on the lock and cache files? ll /var/lib/mrtg/mrtg.lock ll /var/lib/mrtg/mrtg.ok Remove these files when mrtg isn't running, set the user and group back in the cron job, and allow the files to be recreated, and see if that helps with the CPU issue. Hi, # ll /var/lib/mrtg/mr...
by opservidores
Thu Oct 08, 2020 10:27 am
Forum: Nagios XI
Topic: MRTG after upgrade to 5.7.3
Replies: 5
Views: 330

MRTG after upgrade to 5.7.3

Hello, In crontab, I have this line : # cat /etc/cron.d/mrtg */5 * * * * root LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg --lock-file /var/lib/mrtg/mrtg.lock --confcache-file /var/lib/mrtg/mrtg.ok --user=nagios --group=nagios After update to 5.7.3 mrtg file were launched each 5 minutes, and nev...