Nagios Support Forum

My mistake when i created the profile zip, that's why you have a different IP indeed, but of course on my earlier tries it was matching and the behavior was the same (in that case the web part is correctly pointing to the new database). I'll try again with all cleanup commands you mentioned (well, w...

Hello Ssax,

I've sent you a PM with the profile attached.

As expected unfortunately increasing the packet size didn't change anything.

Is there a possibility that we could have somewhere else on the web part a cache which could cause problems like that ?

Thanks,
Best regards,
Yann Pingot

I've updated ndo2db.cfg as we've rollbacked to NDO2 like is said in my first post. I've indeed set the sql_mode in the cnf as modifying the parameter through the CLI is not persistent. max_allowed_packet has been set to 256M as our current DB instance, are you sure increasing it to the double would ...

Hello Jeffrey, Unfortunately it didn't change anything so i had to rollback again, the UI is still completely unusable, but the core + ndo2db seems to be working fine as it was sending alarms and the ipcs queue unstacking. The way it works appears to be some kind of timeout, but we can access databa...

Hello, Considering our old version of MySQL running on a RHEL 6, we want to upgrade our offloaded database as a try to improve our overall performances as we have recurrent issues with ipcs queues filling up. A MariaDB 10.5 (latest version) has been installed on a RHEL 7.7, all 3 databases dumped an...

Hi tgriep , I have already done a mysqlcheck a while ago, still i've done another run and all tables are OK. Unfortunately the problem still remains, and the error is : ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes Regarding Gearman do you have an ETA for an NDO3 updat...

Hello tgriep , As expected modifying 'name1' et 'name2' columns to the varchar(1023) didn't pass either, there are the same found in the update script. The other ones passed, but errors in the log file are still the same. According to the NDO logs in nagios.log, the 'long_output' column is also faul...

Here you go tgriep , just FYI our database if offloaded : +-------------------------------+--------------+-----------------+------+-----+---------------------+----------------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Commen...

Hi @swolf, I've passed again each sql script, i have an error with the first one (upgrade-from-2.1.3.sql), maybe this is the cause since it's trying to push a VARCHAR(1023), this script halts : Enter password: INFO: Column already exists. INFO: Column already exists. ERROR 1071 (42000) at line 146: ...

Hello, We've also upgraded NagiosXI to the 5.7.1 in our test environment and gearman is not working anymore either. I've tried compiling the latest version just to be sure, the module seems to be loaded fine but checks are not handled (hostgroups based). As mentioned i've tried to load ndo before bu...