Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Aug 15 21:46:49 ip-10-0-8-150 systemd: Stopping Stores data from Nagios in a database...
Aug 15 21:46:49 ip-10-0-8-150 systemd: Starting Stores data from Nagios in a database...
Aug 15 21:46:49 ip-10-0-8-150 systemd: Failed to read PID from file /var/run/ndoutils/ndo2db.pid: Invalid argument
Aug 15 21:46:49 ip-10-0-8-150 systemd: Started Stores data from Nagios in a database.
This all looked typical as long as you have the correct DB name and user/pass setup. The only other thing that could be suspect would be if your system couldn't find your mysql.sock file and then you would want to uncomment this line and specify the correct path
[root@ip-10-0-8-150 nagios]# systemctl status ndo2db
● ndo2db.service - Stores data from Nagios in a database
Loaded: loaded (/usr/lib/systemd/system/ndo2db.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2017-08-16 20:19:17 UTC; 1min 3s ago
Docs: http://www.nagios.org/documentation
Process: 7789 ExecStart=/usr/sbin/ndo2db -c /etc/nagios/ndo2db.cfg (code=exited, status=0/SUCCESS)
Main PID: 7791 (ndo2db)
CGroup: /system.slice/ndo2db.service
├─7791 /usr/sbin/ndo2db -c /etc/nagios/ndo2db.cfg
├─7793 /usr/sbin/ndo2db -c /etc/nagios/ndo2db.cfg
└─7794 /usr/sbin/ndo2db -c /etc/nagios/ndo2db.cfg
Aug 16 20:19:17 ip-10-0-8-150.ec2.eys.internal systemd[1]: Starting Stores data from Nagios in a database...
Aug 16 20:19:17 ip-10-0-8-150.ec2.eys.internal systemd[1]: Failed to read PID from file /var/run/ndoutils/ndo2db.pid: Invalid argument
Aug 16 20:19:17 ip-10-0-8-150.ec2.eys.internal systemd[1]: Started Stores data from Nagios in a database.
Aug 16 20:19:38 ip-10-0-8-150.ec2.eys.internal ndo2db[7793]: Successfully connected to MySQL database
Aug 16 20:19:38 ip-10-0-8-150.ec2.eys.internal ndo2db[7794]: Successfully connected to MySQL database
but it doesn't make any sense that there is nothing in that log.
You did change the debug_level to be 1 right?
Yes... I changed it two times..., first to generate the ndo2db.log file and after for no generate it again, so now it has a 0 value...., about the connection, I said before credentials were correctly added since I opened this ticket.