ndoutils doesn't' write into Database

[ingenieria.itoc]

Hi Team

I have a problem with ndoutils , this doesn't write into DB , when I run the next command this don't show me the data:

echo 'select * from nagios.nagios_logentries;' | mysql -u ndoutils -p'mpv_mty'

But if I run the same command in an other nagios this work, but another credentials
Hi Team

I have a problem with ndoutils, when I run the next command this do not show me the data:

echo 'select * from nagios.nagios_logentries;' | mysql -u ndoutils -p'mpv_mty '

But if I run the command in an other nagios this work fine, but whit another credentials

I restarted service mysqld but this also working fine

I tried this:

[root @ MXAP-ITOCMPVMTY ~] # / usr / local / nagios / bin / ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
Could not bind socket: Address already in use

I do not find another information about this behavior.

Kind Regards

N.H

[dwasswa]

Hi @ingenieria.itoc,

Please run this command ps -ef and post the output.

Secondly, what do you mean by

But if I run the same command in an other nagios this work, but another credentials

Can you please PM or post your system profile.

Please follow the steps below on how to do that:

Step 1:Go to Admin >> System Profile

System_profile.PNG

Step 2: Click Download Profile and send it.

Download_system_profile.PNG

[ingenieria.itoc]

Thanks for answer me

In this case the problem is in Nagios Core , so I can't send you the profile how Nagios XI make it

And this is my ps -ef output:

[root@MXAP-ITOCMPVMTY ~]# ps -ef
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 Sep22 ? 00:00:38 /sbin/init
root 2 0 0 Sep22 ? 00:00:00 [kthreadd]
root 3 2 0 Sep22 ? 00:24:33 [migration/0]
root 4 2 0 Sep22 ? 00:01:07 [ksoftirqd/0]
root 5 2 0 Sep22 ? 00:00:00 [stopper/0]
root 6 2 0 Sep22 ? 00:01:31 [watchdog/0]
root 7 2 0 Sep22 ? 00:27:14 [migration/1]
root 8 2 0 Sep22 ? 00:00:00 [stopper/1]
root 9 2 0 Sep22 ? 00:01:38 [ksoftirqd/1]
root 10 2 0 Sep22 ? 00:01:16 [watchdog/1]
root 11 2 0 Sep22 ? 00:26:35 [migration/2]
root 12 2 0 Sep22 ? 00:00:00 [stopper/2]
root 13 2 0 Sep22 ? 00:01:19 [ksoftirqd/2]
root 14 2 0 Sep22 ? 00:01:16 [watchdog/2]
root 15 2 0 Sep22 ? 00:26:00 [migration/3]
root 16 2 0 Sep22 ? 00:00:00 [stopper/3]
root 17 2 0 Sep22 ? 00:01:16 [ksoftirqd/3]
root 18 2 0 Sep22 ? 00:01:09 [watchdog/3]
root 19 2 0 Sep22 ? 00:10:07 [events/0]
root 20 2 0 Sep22 ? 00:11:21 [events/1]
root 21 2 0 Sep22 ? 00:09:12 [events/2]
root 22 2 0 Sep22 ? 00:11:28 [events/3]
root 23 2 0 Sep22 ? 00:00:00 [events/0]
root 24 2 0 Sep22 ? 00:00:00 [events/1]
root 25 2 0 Sep22 ? 00:00:00 [events/2]
root 26 2 0 Sep22 ? 00:00:00 [events/3]
root 27 2 0 Sep22 ? 00:00:00 [events_long/0]
root 28 2 0 Sep22 ? 00:00:00 [events_long/1]
root 29 2 0 Sep22 ? 00:00:00 [events_long/2]
root 30 2 0 Sep22 ? 00:00:00 [events_long/3]
root 31 2 0 Sep22 ? 00:00:00 [events_power_ef]
root 32 2 0 Sep22 ? 00:00:00 [events_power_ef]
root 33 2 0 Sep22 ? 00:00:00 [events_power_ef]
root 34 2 0 Sep22 ? 00:00:00 [events_power_ef]
root 35 2 0 Sep22 ? 00:00:00 [cgroup]
root 36 2 0 Sep22 ? 00:00:00 [khelper]
root 37 2 0 Sep22 ? 00:00:00 [netns]
root 38 2 0 Sep22 ? 00:00:00 [async/mgr]
root 39 2 0 Sep22 ? 00:00:00 [pm]
root 40 2 0 Sep22 ? 00:00:46 [sync_supers]
root 41 2 0 Sep22 ? 00:00:06 [bdi-default]
root 42 2 0 Sep22 ? 00:00:00 [kintegrityd/0]
root 43 2 0 Sep22 ? 00:00:00 [kintegrityd/1]
root 44 2 0 Sep22 ? 00:00:00 [kintegrityd/2]
root 45 2 0 Sep22 ? 00:00:00 [kintegrityd/3]
root 46 2 0 Sep22 ? 02:26:03 [kblockd/0]
root 47 2 0 Sep22 ? 02:52:52 [kblockd/1]
root 48 2 0 Sep22 ? 02:28:24 [kblockd/2]
root 49 2 0 Sep22 ? 02:23:40 [kblockd/3]
root 50 2 0 Sep22 ? 00:00:00 [kacpid]
root 51 2 0 Sep22 ? 00:00:00 [kacpi_notify]
root 52 2 0 Sep22 ? 00:00:00 [kacpi_hotplug]
root 53 2 0 Sep22 ? 00:00:00 [ata_aux]
root 54 2 0 Sep22 ? 00:00:00 [ata_sff/0]
root 55 2 0 Sep22 ? 00:00:00 [ata_sff/1]
root 56 2 0 Sep22 ? 00:00:00 [ata_sff/2]
root 57 2 0 Sep22 ? 00:00:00 [ata_sff/3]
root 58 2 0 Sep22 ? 00:00:00 [ksuspend_usbd]
root 59 2 0 Sep22 ? 00:00:00 [khubd]
root 60 2 0 Sep22 ? 00:00:00 [kseriod]
root 61 2 0 Sep22 ? 00:00:00 [md/0]
root 62 2 0 Sep22 ? 00:00:00 [md/1]
root 63 2 0 Sep22 ? 00:00:00 [md/2]
root 64 2 0 Sep22 ? 00:00:00 [md/3]
root 65 2 0 Sep22 ? 00:00:00 [md_misc/0]
root 66 2 0 Sep22 ? 00:00:00 [md_misc/1]
root 67 2 0 Sep22 ? 00:00:00 [md_misc/2]
root 68 2 0 Sep22 ? 00:00:00 [md_misc/3]
root 69 2 0 Sep22 ? 00:00:00 [linkwatch]
root 72 2 0 Sep22 ? 00:00:04 [khungtaskd]
root 73 2 0 Sep22 ? 00:00:19 [kswapd0]
root 74 2 0 Sep22 ? 00:00:00 [ksmd]
root 75 2 0 Sep22 ? 00:00:39 [khugepaged]
root 76 2 0 Sep22 ? 00:00:00 [aio/0]
root 77 2 0 Sep22 ? 00:00:00 [aio/1]
root 78 2 0 Sep22 ? 00:00:00 [aio/2]
root 79 2 0 Sep22 ? 00:00:00 [aio/3]
root 80 2 0 Sep22 ? 00:00:00 [crypto/0]
root 81 2 0 Sep22 ? 00:00:00 [crypto/1]
root 82 2 0 Sep22 ? 00:00:00 [crypto/2]
root 83 2 0 Sep22 ? 00:00:00 [crypto/3]
root 90 2 0 Sep22 ? 00:00:00 [kthrotld/0]
root 91 2 0 Sep22 ? 00:00:00 [kthrotld/1]
root 92 2 0 Sep22 ? 00:00:00 [kthrotld/2]
root 93 2 0 Sep22 ? 00:00:00 [kthrotld/3]
root 94 2 0 Sep22 ? 00:00:00 [pciehpd]
root 96 2 0 Sep22 ? 00:00:00 [kpsmoused]
root 97 2 0 Sep22 ? 00:00:00 [usbhid_resumer]
root 98 2 0 Sep22 ? 00:00:00 [deferwq]
root 131 2 0 Sep22 ? 00:00:00 [kdmremove]
root 132 2 0 Sep22 ? 00:00:00 [kstriped]
root 167 2 0 Sep22 ? 00:00:00 [ttm_swap]
root 326 2 0 Sep22 ? 00:00:00 [scsi_eh_0]
root 327 2 0 Sep22 ? 00:00:00 [scsi_eh_1]
root 337 2 0 Sep22 ? 00:00:00 [scsi_eh_2]
root 338 2 0 Sep22 ? 00:00:00 [vmw_pvscsi_wq_2]
root 410 2 0 Sep22 ? 00:00:00 [scsi_eh_3]
root 411 2 0 Sep22 ? 00:00:00 [scsi_eh_4]
root 412 2 0 Sep22 ? 00:00:00 [scsi_eh_5]
root 413 2 0 Sep22 ? 00:00:00 [scsi_eh_6]
root 414 2 0 Sep22 ? 00:00:00 [scsi_eh_7]
root 415 2 0 Sep22 ? 00:00:00 [scsi_eh_8]
root 416 2 0 Sep22 ? 00:00:00 [scsi_eh_9]
root 417 2 0 Sep22 ? 00:00:00 [scsi_eh_10]
root 418 2 0 Sep22 ? 00:00:00 [scsi_eh_11]
root 419 2 0 Sep22 ? 00:00:00 [scsi_eh_12]
root 420 2 0 Sep22 ? 00:00:00 [scsi_eh_13]
root 421 2 0 Sep22 ? 00:00:00 [scsi_eh_14]
root 422 2 0 Sep22 ? 00:00:00 [scsi_eh_15]
root 423 2 0 Sep22 ? 00:00:00 [scsi_eh_16]
root 424 2 0 Sep22 ? 00:00:00 [scsi_eh_17]
root 425 2 0 Sep22 ? 00:00:00 [scsi_eh_18]
root 426 2 0 Sep22 ? 00:00:00 [scsi_eh_19]
root 427 2 0 Sep22 ? 00:00:00 [scsi_eh_20]
root 428 2 0 Sep22 ? 00:00:00 [scsi_eh_21]
root 429 2 0 Sep22 ? 00:00:00 [scsi_eh_22]
root 430 2 0 Sep22 ? 00:00:00 [scsi_eh_23]
root 431 2 0 Sep22 ? 00:00:00 [scsi_eh_24]
root 432 2 0 Sep22 ? 00:00:00 [scsi_eh_25]
root 433 2 0 Sep22 ? 00:00:00 [scsi_eh_26]
root 434 2 0 Sep22 ? 00:00:00 [scsi_eh_27]
root 435 2 0 Sep22 ? 00:00:00 [scsi_eh_28]
root 436 2 0 Sep22 ? 00:00:00 [scsi_eh_29]
root 437 2 0 Sep22 ? 00:00:00 [scsi_eh_30]
root 438 2 0 Sep22 ? 00:00:00 [scsi_eh_31]
root 439 2 0 Sep22 ? 00:00:00 [scsi_eh_32]
root 508 2 0 Sep22 ? 00:00:00 [kdmflush]
root 510 2 0 Sep22 ? 00:00:00 [kdmflush]
root 576 2 0 Sep22 ? 02:05:40 [jbd2/dm-0-8]
root 577 2 0 Sep22 ? 00:00:00 [ext4-dio-unwrit]
root 675 1 0 Sep22 ? 00:00:00 /sbin/udevd -d
root 851 2 0 Sep22 ? 00:03:46 [vmmemctl]
root 1029 675 0 Sep22 ? 00:00:00 /sbin/udevd -d
root 1062 2 0 Sep22 ? 00:00:00 [jbd2/sda1-8]
root 1063 2 0 Sep22 ? 00:00:00 [ext4-dio-unwrit]
root 1107 2 0 Sep22 ? 00:01:36 [kauditd]
root 1166 2 0 Sep22 ? 00:00:00 [ib_addr]
root 1171 2 0 Sep22 ? 00:00:00 [infiniband/0]
root 1172 2 0 Sep22 ? 00:00:00 [infiniband/1]
root 1173 2 0 Sep22 ? 00:00:00 [infiniband/2]
root 1174 2 0 Sep22 ? 00:00:00 [infiniband/3]
root 1183 2 0 Sep22 ? 00:00:00 [ib_mcast]
root 1188 2 0 Sep22 ? 00:00:00 [iw_cm_wq]
root 1193 2 0 Sep22 ? 00:00:00 [ib_cm/0]
root 1194 2 0 Sep22 ? 00:00:00 [ib_cm/1]
root 1195 2 0 Sep22 ? 00:00:00 [ib_cm/2]
root 1196 2 0 Sep22 ? 00:00:00 [ib_cm/3]
root 1201 2 0 Sep22 ? 00:00:00 [rdma_cm]
root 1206 675 0 Sep22 ? 00:00:00 /sbin/udevd -d
root 1223 2 0 Sep22 ? 00:00:00 [ipoib_flush]
root 1383 2 3 Sep22 ? 1-13:38:13 [flush-253:0]
root 1472 1 0 Nov07 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --use
nagios 1522 1 0 Sep22 ? 00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
root 1531 1 0 Sep22 ? 00:04:24 auditd
root 1565 1 0 Sep22 ? 00:05:22 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5
mysql 1591 1472 0 Nov07 ? 00:00:24 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --so
root 1599 1 0 Sep22 ? 00:04:02 irqbalance --pid=/var/run/irqbalance.pid
rpc 1617 1 0 Sep22 ? 00:00:10 rpcbind
rpcuser 1639 1 0 Sep22 ? 00:00:00 rpc.statd
dbus 1673 1 0 Sep22 ? 00:00:00 dbus-daemon --system
root 1694 1 0 Sep22 ? 00:00:07 cupsd -C /etc/cups/cupsd.conf
root 1726 1 0 Sep22 ? 00:00:00 /usr/sbin/acpid
68 1738 1 0 Sep22 ? 00:00:47 hald
root 1739 1738 0 Sep22 ? 00:00:00 hald-runner
root 1772 1739 0 Sep22 ? 00:00:00 hald-addon-input: Listening on /dev/input/event2 /dev/input/event0
68 1784 1739 0 Sep22 ? 00:00:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket
root 1808 1 0 Sep22 ? 00:01:16 automount --pid-file /var/run/autofs.pid
root 1928 1 0 Sep22 ? 00:00:00 /usr/sbin/mcelog --daemon
root 1945 1 0 Sep22 ? 00:03:09 /usr/sbin/sshd
root 1956 1 0 Sep22 ? 00:00:53 xinetd -stayalive -pidfile /var/run/xinetd.pid
root 2201 1 0 Sep22 ? 00:00:23 /usr/libexec/postfix/master
postfix 2214 2201 0 Sep22 ? 00:00:09 qmgr -l -t fifo -u
root 2215 1 0 Sep22 ? 00:00:38 /usr/sbin/abrtd
root 2242 1 0 Sep22 ? 00:00:11 crond
root 2257 1 0 Sep22 ? 00:00:00 /usr/sbin/atd
root 2273 1 0 Sep22 ? 00:00:01 /usr/sbin/certmonger -S -p /var/run/certmonger.pid
nagios 2357 1 0 Sep22 ? 00:08:14 /usr/local/pnp4nagios/bin/npcd -d -f /usr/local/pnp4nagios/etc/npcd.cfg
root 2369 1 0 Sep22 tty1 00:00:00 /sbin/mingetty /dev/tty1
root 2371 1 0 Sep22 tty2 00:00:00 /sbin/mingetty /dev/tty2
root 2373 1 0 Sep22 tty3 00:00:00 /sbin/mingetty /dev/tty3
root 2375 1 0 Sep22 tty4 00:00:00 /sbin/mingetty /dev/tty4
root 2377 1 0 Sep22 tty5 00:00:00 /sbin/mingetty /dev/tty5
root 2379 1 0 Sep22 tty6 00:00:00 /sbin/mingetty /dev/tty6
apache 4466 18444 0 Nov07 ? 00:00:01 /usr/sbin/httpd
apache 7040 18444 0 12:17 ? 00:00:00 /usr/sbin/httpd
apache 8757 18444 0 Nov07 ? 00:00:01 /usr/sbin/httpd
apache 11104 18444 0 Nov07 ? 00:00:01 /usr/sbin/httpd
apache 11314 18444 0 Nov07 ? 00:00:01 /usr/sbin/httpd
apache 13000 18444 0 00:18 ? 00:00:00 /usr/sbin/httpd
root 14732 1 0 Oct03 ? 00:12:10 /usr/sbin/snmpd -LS0-6d -Lf /dev/null -p /var/run/snmpd.pid
apache 17012 18444 0 Nov07 ? 00:00:01 /usr/sbin/httpd
nagios 18280 1 0 Oct28 ? 02:41:55 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios 18288 18280 0 Oct28 ? 00:02:12 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
root 18444 1 0 Oct28 ? 00:01:18 /usr/sbin/httpd
nagios 18828 18280 0 Oct30 ? 00:00:00 [nagios] <defunct>
nagios 19445 18280 0 Oct30 ? 00:21:49 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 19446 18280 0 Oct30 ? 00:21:28 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 19447 18280 0 Oct30 ? 00:21:50 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 19448 18280 0 Oct30 ? 00:21:42 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 19449 18280 0 Oct30 ? 00:21:51 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 19450 18280 0 Oct30 ? 00:21:46 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
apache 19461 18444 0 01:56 ? 00:00:00 /usr/sbin/httpd
root 22034 1956 0 15:55 ? 00:00:00 in.telnetd
ntp 26383 1 0 Nov06 ? 00:00:00 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g
root 26816 1956 0 15:32 ? 00:00:00 in.telnetd
postfix 28933 2201 0 15:58 ? 00:00:00 pickup -l -t fifo -u
nagios 30517 19447 0 16:58 ? 00:00:00 /usr/local/nagios/libexec/check_http -H http://www.reconstruccion.cdmx.gob.mx http://www.reconstruccion.cdmx.gob.mx -t 60
root 30916 1956 0 16:09 ? 00:00:00 in.telnetd: c80-217-12-143.bredband.comhem.se
root 31452 30916 0 16:09 ? 00:00:00 [login] <defunct>
nagios 32339 19448 0 16:59 ? 00:00:00 /usr/local/nagios/libexec/check_http -H http://www.firmadigital.gob.mx http://www.firmadigital.gob.mx -t 60
nagios 32412 19446 0 16:59 ? 00:00:00 /usr/local/nagios/libexec/check_http -H xhbg.tv xhbg.tv -t 60
root 32439 1945 2 16:59 ? 00:00:00 sshd: root@pts/3
root 32443 32439 0 16:59 pts/3 00:00:00 -bash
root 32476 32443 0 16:59 pts/3 00:00:00 ps -ef
[root@MXAP-ITOCMPVMTY ~]#

Regards

[kyang]

Hi @ingenieria.itoc,

Thanks for sending us this information, but before we go on.

Just to be sure, you are using two different servers? One is Nagios Core and the other is Nagios XI? (Do they use the same IP address/hostname or a different?)

It seems like you don't have a support plan for Nagios Core, but for Nagios XI.

I can move this to the general forum for Nagios Core if you would like. If you did want Nagios Core support you could contact our Sales department at [email protected] or by phone.

[ingenieria.itoc]

Hi Kyang

I fix it this problem

In this message was my problem

Could not bind socket: Address already in use

I killed the process
delete this file : rm /usr/local/nagios/var/ndo.sock
start the service: /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg

Thats It all.

I have only one server XI, I maked a mistake when wrote in this forum if you want , you will move this post to another forum

Regards

[kyang]

Sounds good! Glad you found the issue. I'll move it into XI.

Did you have any more questions or are you okay if we close this thread?

[ingenieria.itoc]

You can move it please

thanks so much

[kyang]

Yes, I have moved it into XI.

I will be closing this thread since you have resolved it.

If you have any more questions, feel free to create another thread!

Thank you for using the Nagios Support Forum!