Search found 13 matches

by DonGately
Fri Jan 08, 2021 2:52 am
Forum: Open Source Nagios Projects
Topic: mysql_error: 'Out of range value for column 'servicecheck_id
Replies: 1
Views: 1508

Re: mysql_error: 'Out of range value for column 'servicechec

I have an update regarding my little problem. It is not quite solved yet - I would say - but at least nagios_servicechecks table is being populated with data again. For now I changed the datatype of servicecheck_id from INT to BIGINT after my other approaches didn't do nothing. First I tried rebuild...
by DonGately
Mon Dec 28, 2020 4:30 am
Forum: Open Source Nagios Projects
Topic: mysql_error: 'Out of range value for column 'servicecheck_id
Replies: 1
Views: 1508

mysql_error: 'Out of range value for column 'servicecheck_id

Hello, first of all I'd like to wish you happy holidays :) I'm opening this thread, because I have a problem with the nagios mariadb database, to be more specific with the servicecheck_id column in the nagios_servicechecks table. I get following error messages: "mysql_error: 'Out of range value...
by DonGately
Tue Feb 05, 2019 8:23 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

That is good news that so far, it is working with the updated NDOUTILS. Let us know the outcome of the production server after the upgrade to NDOUTILS 2.1.3. I have repeated the same procedure I described in my previous post in my production environment and it worked there as well. Thank you all fo...
by DonGately
Fri Jan 11, 2019 7:12 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

One question, you said that the test environment is showing the same issue, are both the Production server and the test server pointing to the same MYSQL server and the same tables? Can you verify that they are not? I can verify for shure, that they are not writing to the same MariaDB server / tabl...
by DonGately
Wed Dec 19, 2018 2:23 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

Everything looks proper. Did you try recompiling NDO2DB? This really looks like a memory issue or a some type of corruption issue. Can you try upgrading to NDO2DB version 2.1.3? I can't try recompiling it, because I have installed it via yum on Red Hat Enterprise Linux. That's also the newest versi...
by DonGately
Tue Dec 18, 2018 5:42 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

ssax wrote:Please PM me these files:

Code: Select all

/usr/local/nagios/var/objects.cache
/usr/local/nagios/var/status.dat
Sorry for the delay. I've sent you a pm.
by DonGately
Tue Dec 11, 2018 2:39 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

ssax wrote:Nothing is standing out as an issue.

Please run this command and PM me the resulting /tmp/GARBLEDDUMP.sql file:

Code: Select all

mysqldump -uroot -pROOTMYSQLPASS --add-drop-database nagios nagios_objects > /tmp/GARBLEDDUMP.sql
I've sent you a pm :)
by DonGately
Fri Dec 07, 2018 3:58 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

Hello there and thank you for your reply. Here are the outputs you requested ps aux | grep nagios.cfg nagios 10063 3.3 0.2 57576 26384 ? Ss 06:28 3:10 /usr/sbin/nagios -d /etc/nagios/nagios.cfg nagios 10197 0.0 0.2 57308 24564 ? S 06:28 0:00 /usr/sbin/nagios -d /etc/nagios/nagios.cfg ipcs -q ------ ...
by DonGately
Thu Dec 06, 2018 12:45 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

Hey, thank you for your reply again. Here you go ndo2db.cfg: ##################################################################### # NDO2DB DAEMON CONFIG FILE # # Last Modified: 01-02-2009 ##################################################################### # LOCK FILE # This is the lockfile that N...
by DonGately
Wed Dec 05, 2018 1:03 am
Forum: Open Source Nagios Projects
Topic: MariaDB displaying special characters in Nagios DB
Replies: 22
Views: 27031

Re: MariaDB displaying special characters in Nagios DB

Did anything change recently? Like did you upgrade Core or NDO2DB, run yum updates, etc? Are you doing updates to the DB through PHPMyAdmin or interacting directly with the nagios DB through a script or another automated process that could be doing it? I did run yum update on both machines some tim...