Search found 13 matches
- 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: 1531
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...
- 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: 1531
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...
- Tue Feb 05, 2019 8:23 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
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...
- Fri Jan 11, 2019 7:12 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
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...
- Wed Dec 19, 2018 2:23 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
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...
- Tue Dec 18, 2018 5:42 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
Re: MariaDB displaying special characters in Nagios DB
Sorry for the delay. I've sent you a pm.ssax wrote:Please PM me these files:
Code: Select all
/usr/local/nagios/var/objects.cache /usr/local/nagios/var/status.dat
- Tue Dec 11, 2018 2:39 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
Re: MariaDB displaying special characters in Nagios DB
I've sent you a pmssax 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
- Fri Dec 07, 2018 3:58 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
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 ------ ...
- Thu Dec 06, 2018 12:45 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
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...
- Wed Dec 05, 2018 1:03 am
- Forum: Open Source Nagios Projects
- Topic: MariaDB displaying special characters in Nagios DB
- Replies: 22
- Views: 47639
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...