Nagios xi graphing issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
vuduops
Posts: 81
Joined: Wed Sep 07, 2016 1:34 pm

Re: Nagios xi graphing issue

Post by vuduops »

cat /etc/my.cnf can't find the my.cnf file.I tried running mysqld trying to but was unsuccessful to do so.

----> [[email protected] /]# find . -name my.cnf

Also when trying to run the query as root I see the below error.
---> [[email protected] /]# echo "show variables like 'max_connections';" | mysql -t -uroot -pnagiosxi
mysql: relocation error: mysql: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference

---> rpm -qa | grep mysql
[[email protected] /]# rpm -qa | grep mysql
php-mysql-5.3.3-48.el6_8.x86_64
mysql-5.1.73-7.el6.x86_64
mysql-server-5.1.73-7.el6.x86_64
[[email protected] /]# rpm -qa | grep mysql*
php-mysql-5.3.3-48.el6_8.x86_64
mysql-5.1.73-7.el6.x86_64
mysql-server-5.1.73-7.el6.x86_64

---> grep nag /etc/group
[[email protected] /]# grep nag /etc/group
nagios:x:499:apache,nagios
nagiocmd:x:7001:apache
nagcmd:x:7002:nagios,apache
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios xi graphing issue

Post by tgriep »

Something is not right with the MYSQL database, can you login as root to the XI server, run the following and post the output?

Code: Select all

service mysqld status
ps -ef --cols=300
service mysqld restart
tail -50 /var/log/mysqld.log
Thanks
Be sure to check out our Knowledgebase for helpful articles and solutions!
vuduops
Posts: 81
Joined: Wed Sep 07, 2016 1:34 pm

Re: Nagios xi graphing issue

Post by vuduops »

Code: Select all

[[email protected] ~]# service mysqld status
mysqld is stopped
[[email protected] ~]# ps -ef --cols=300
UID        PID  PPID  C STIME TTY          TIME CMD
root         1     0  0 Sep25 ?        00:00:04 /sbin/init
root         2     0  0 Sep25 ?        00:00:00 [kthreadd]
root         3     2  0 Sep25 ?        00:00:15 [migration/0]
root         4     2  0 Sep25 ?        00:00:02 [ksoftirqd/0]
root         5     2  0 Sep25 ?        00:00:00 [stopper/0]
root         6     2  0 Sep25 ?        00:00:00 [watchdog/0]
root         7     2  0 Sep25 ?        00:00:12 [migration/1]
root         8     2  0 Sep25 ?        00:00:00 [stopper/1]
root         9     2  0 Sep25 ?        00:00:02 [ksoftirqd/1]
root        10     2  0 Sep25 ?        00:00:00 [watchdog/1]
root        11     2  0 Sep25 ?        00:00:14 [migration/2]
root        12     2  0 Sep25 ?        00:00:00 [stopper/2]
root        13     2  0 Sep25 ?        00:00:02 [ksoftirqd/2]
root        14     2  0 Sep25 ?        00:00:00 [watchdog/2]
root        15     2  0 Sep25 ?        00:00:13 [migration/3]
root        16     2  0 Sep25 ?        00:00:00 [stopper/3]
root        17     2  0 Sep25 ?        00:00:03 [ksoftirqd/3]
root        18     2  0 Sep25 ?        00:00:00 [watchdog/3]
root        19     2  0 Sep25 ?        00:00:12 [migration/4]
root        20     2  0 Sep25 ?        00:00:00 [stopper/4]
root        21     2  0 Sep25 ?        00:00:03 [ksoftirqd/4]
root        22     2  0 Sep25 ?        00:00:00 [watchdog/4]
root        23     2  0 Sep25 ?        00:00:15 [migration/5]
root        24     2  0 Sep25 ?        00:00:00 [stopper/5]
root        25     2  0 Sep25 ?        00:00:02 [ksoftirqd/5]
root        26     2  0 Sep25 ?        00:00:00 [watchdog/5]
root        27     2  0 Sep25 ?        00:00:12 [events/0]
root        28     2  0 Sep25 ?        00:00:14 [events/1]
root        29     2  0 Sep25 ?        00:00:14 [events/2]
root        30     2  0 Sep25 ?        00:00:28 [events/3]
root        31     2  0 Sep25 ?        00:00:16 [events/4]
root        32     2  0 Sep25 ?        00:00:26 [events/5]
root        33     2  0 Sep25 ?        00:00:00 [events/0]
root        34     2  0 Sep25 ?        00:00:00 [events/1]
root        35     2  0 Sep25 ?        00:00:00 [events/2]
root        36     2  0 Sep25 ?        00:00:00 [events/3]
root        37     2  0 Sep25 ?        00:00:00 [events/4]
root        38     2  0 Sep25 ?        00:00:00 [events/5]
root        39     2  0 Sep25 ?        00:00:00 [events_long/0]
root        40     2  0 Sep25 ?        00:00:00 [events_long/1]
root        41     2  0 Sep25 ?        00:00:00 [events_long/2]
root        42     2  0 Sep25 ?        00:00:00 [events_long/3]
root        43     2  0 Sep25 ?        00:00:00 [events_long/4]
root        44     2  0 Sep25 ?        00:00:00 [events_long/5]
root        45     2  0 Sep25 ?        00:00:00 [events_power_ef]
root        46     2  0 Sep25 ?        00:00:00 [events_power_ef]
root        47     2  0 Sep25 ?        00:00:00 [events_power_ef]
root        48     2  0 Sep25 ?        00:00:00 [events_power_ef]
root        49     2  0 Sep25 ?        00:00:00 [events_power_ef]
root        50     2  0 Sep25 ?        00:00:00 [events_power_ef]
root        51     2  0 Sep25 ?        00:00:00 [cgroup]
root        52     2  0 Sep25 ?        00:00:00 [khelper]
root        53     2  0 Sep25 ?        00:00:00 [netns]
root        54     2  0 Sep25 ?        00:00:00 [async/mgr]
root        55     2  0 Sep25 ?        00:00:00 [pm]
root        56     2  0 Sep25 ?        00:00:01 [sync_supers]
root        57     2  0 Sep25 ?        00:00:01 [bdi-default]
root        58     2  0 Sep25 ?        00:00:00 [kintegrityd/0]
root        59     2  0 Sep25 ?        00:00:00 [kintegrityd/1]
root        60     2  0 Sep25 ?        00:00:00 [kintegrityd/2]
root        61     2  0 Sep25 ?        00:00:00 [kintegrityd/3]
root        62     2  0 Sep25 ?        00:00:00 [kintegrityd/4]
root        63     2  0 Sep25 ?        00:00:00 [kintegrityd/5]
root        64     2  0 Sep25 ?        00:00:00 [kblockd/0]
root        65     2  0 Sep25 ?        00:00:00 [kblockd/1]
root        66     2  0 Sep25 ?        00:00:00 [kblockd/2]
root        67     2  0 Sep25 ?        00:00:00 [kblockd/3]
root        68     2  0 Sep25 ?        00:00:37 [kblockd/4]
root        69     2  0 Sep25 ?        00:00:00 [kblockd/5]
root        70     2  0 Sep25 ?        00:00:00 [kacpid]
root        71     2  0 Sep25 ?        00:00:00 [kacpi_notify]
root        72     2  0 Sep25 ?        00:00:00 [kacpi_hotplug]
root        73     2  0 Sep25 ?        00:00:00 [ata_aux]
root        74     2  0 Sep25 ?        00:00:00 [ata_sff/0]
root        75     2  0 Sep25 ?        00:00:00 [ata_sff/1]
root        76     2  0 Sep25 ?        00:00:00 [ata_sff/2]
root        77     2  0 Sep25 ?        00:00:00 [ata_sff/3]
root        78     2  0 Sep25 ?        00:00:00 [ata_sff/4]
root        79     2  0 Sep25 ?        00:00:00 [ata_sff/5]
root        80     2  0 Sep25 ?        00:00:00 [ksuspend_usbd]
root        81     2  0 Sep25 ?        00:00:00 [khubd]
root        82     2  0 Sep25 ?        00:00:00 [kseriod]
root        83     2  0 Sep25 ?        00:00:00 [md/0]
root        84     2  0 Sep25 ?        00:00:00 [md/1]
root        85     2  0 Sep25 ?        00:00:00 [md/2]
root        86     2  0 Sep25 ?        00:00:00 [md/3]
root        87     2  0 Sep25 ?        00:00:00 [md/4]
root        88     2  0 Sep25 ?        00:00:00 [md/5]
root        89     2  0 Sep25 ?        00:00:00 [md_misc/0]
root        90     2  0 Sep25 ?        00:00:00 [md_misc/1]
root        91     2  0 Sep25 ?        00:00:00 [md_misc/2]
root        92     2  0 Sep25 ?        00:00:00 [md_misc/3]
root        93     2  0 Sep25 ?        00:00:00 [md_misc/4]
root        94     2  0 Sep25 ?        00:00:00 [md_misc/5]
root        95     2  0 Sep25 ?        00:00:00 [linkwatch]
root        96     2  0 Sep25 ?        00:00:00 [khungtaskd]
root        97     2  0 Sep25 ?        00:00:00 [kswapd0]
root        98     2  0 Sep25 ?        00:00:00 [ksmd]
root        99     2  0 Sep25 ?        00:00:08 [khugepaged]
root       100     2  0 Sep25 ?        00:00:00 [aio/0]
root       101     2  0 Sep25 ?        00:00:00 [aio/1]
root       102     2  0 Sep25 ?        00:00:00 [aio/2]
root       103     2  0 Sep25 ?        00:00:00 [aio/3]
root       104     2  0 Sep25 ?        00:00:00 [aio/4]
root       105     2  0 Sep25 ?        00:00:00 [aio/5]
root       106     2  0 Sep25 ?        00:00:00 [crypto/0]
root       107     2  0 Sep25 ?        00:00:00 [crypto/1]
root       108     2  0 Sep25 ?        00:00:00 [crypto/2]
root       109     2  0 Sep25 ?        00:00:00 [crypto/3]
root       110     2  0 Sep25 ?        00:00:00 [crypto/4]
root       111     2  0 Sep25 ?        00:00:00 [crypto/5]
root       118     2  0 Sep25 ?        00:00:00 [kthrotld/0]
root       119     2  0 Sep25 ?        00:00:00 [kthrotld/1]
root       120     2  0 Sep25 ?        00:00:00 [kthrotld/2]
root       121     2  0 Sep25 ?        00:00:00 [kthrotld/3]
root       122     2  0 Sep25 ?        00:00:00 [kthrotld/4]
root       123     2  0 Sep25 ?        00:00:00 [kthrotld/5]
root       125     2  0 Sep25 ?        00:00:00 [kpsmoused]
root       126     2  0 Sep25 ?        00:00:00 [usbhid_resumer]
root       127     2  0 Sep25 ?        00:00:00 [deferwq]
root       160     2  0 Sep25 ?        00:00:00 [kdmremove]
root       161     2  0 Sep25 ?        00:00:00 [kstriped]
root       355     2  0 Sep25 ?        00:00:00 [scsi_eh_0]
root       356     2  0 Sep25 ?        00:00:00 [scsi_eh_1]
root       476     2  0 Sep25 ?        00:00:00 [virtio-blk]
root       506     2  0 Sep25 ?        00:00:05 [kdmflush]
root       508     2  0 Sep25 ?        00:00:00 [kdmflush]
root       574     2  0 Sep25 ?        00:00:43 [jbd2/dm-0-8]
root       575     2  0 Sep25 ?        00:00:00 [ext4-dio-unwrit]
root       659     1  0 Sep25 ?        00:00:00 /sbin/udevd -d
root       833     2  0 Sep25 ?        00:00:00 [virtio-net]
root       852     2  0 Sep25 ?        00:00:00 [vballoon]
root      1083     2  0 Sep25 ?        00:00:00 [jbd2/vda1-8]
root      1084     2  0 Sep25 ?        00:00:00 [ext4-dio-unwrit]
root      1095     2  0 Sep25 ?        00:00:15 [flush-253:0]
root      1124     2  0 Sep25 ?        00:00:14 [kauditd]
root      1127     1  0 Sep25 ?        00:00:00 /bin/sh /usr/lib/daemontools-0.76/bin/svscanboot
root      1136  1127  0 Sep25 ?        00:00:05 /usr/lib/daemontools-0.76/bin/svscan /service
root      1137  1127  0 Sep25 ?        00:00:00 /usr/lib/daemontools-0.76/bin/readproctitle service errors: ................................................................................................................................................................................................
root      1372     1  0 Sep25 ?        00:00:40 auditd
root      1394     1  0 Sep25 ?        00:02:51 /sbin/rsyslogd -i /var/run/syslogd.pid -c 5
root      1429     1  0 Sep25 ?        00:00:12 irqbalance --pid=/var/run/irqbalance.pid
dbus      1467     1  0 Sep25 ?        00:00:00 dbus-daemon --system
root      1505     1  0 Sep25 ?        00:00:00 /usr/sbin/acpid
root      1620     1  0 Sep25 ?        00:00:00 /usr/sbin/sshd
root      1631     1  0 Sep25 ?        00:00:03 xinetd -stayalive -pidfile /var/run/xinetd.pid
ntp       1659     1  0 Sep25 ?        00:00:22 ntpd -u ntp:ntp -p /var/run/ntpd.pid -g -x
root      1842     1  0 Sep25 ?        00:05:42 /usr/sbin/haveged -w 1024 -v 1
exim      1859     1  0 Sep25 ?        00:00:02 /usr/sbin/exim -bd -q1h
hobbit    1904     1  0 Sep25 ?        00:00:05 /usr/lib/hobbit/client/bin/hobbitlaunch --config=/usr/lib/hobbit/client/etc/clientlaunch.cfg --log=/usr/lib/hobbit/client/logs/clientlaunch.log --pidfile=/usr/lib/hobbit/client/logs/clientlaunch.nagios1.devmlp.marquee.net.pid
root      2391     1  0 Sep25 ?        00:00:20 crond
vvond     2424     1  0 Sep25 ?        00:34:05 splunkd -p 8089 start
vvond     2437  2424  0 Sep25 ?        00:00:00 [splunkd pid=2424] splunkd -p 8089 start [process-runner]
nagios    2662     1  0 Sep25 ?        00:00:06 /usr/local/nagios/bin/npcd -d -f /usr/local/nagios/etc/pnp/npcd.cfg
root      2687     1  0 Sep25 ?        00:00:00 /usr/sbin/atd
ajaxterm  2761     1  0 Sep25 ?        00:01:46 python /usr/share/ajaxterm/ajaxterm.py --daemon --port=8022 --uid=ajaxterm
root      2773     1  0 Sep25 ?        00:00:00 /bin/sh /usr/lib/daemontools-0.76/bin/svscanboot
root      2778  2773  0 Sep25 ?        00:00:05 /usr/lib/daemontools-0.76/bin/svscan /service
root      2779  2773  0 Sep25 ?        00:00:00 /usr/lib/daemontools-0.76/bin/readproctitle service errors: ................................................................................................................................................................................................
root      3224     1  0 Sep25 tty1     00:00:00 /sbin/mingetty /dev/tty1
root      3228     1  0 Sep25 tty2     00:00:00 /sbin/mingetty /dev/tty2
root      3230     1  0 Sep25 tty3     00:00:00 /sbin/mingetty /dev/tty3
root      3232     1  0 Sep25 tty4     00:00:00 /sbin/mingetty /dev/tty4
root      3235     1  0 Sep25 tty5     00:00:00 /sbin/mingetty /dev/tty5
root      3236     1  0 Sep25 ttyS0    00:00:00 /sbin/agetty /dev/ttyS0 115200 vt100-nav
root      3241     1  0 Sep25 tty6     00:00:00 /sbin/mingetty /dev/tty6
root      3246   659  0 Sep25 ?        00:00:00 /sbin/udevd -d
root      3247   659  0 Sep25 ?        00:00:00 /sbin/udevd -d
hobbit   14391     1  0 18:58 ?        00:00:00 sh -c vmstat 300 2 1>/usr/lib/hobbit/client/tmp/hobbit_vmstat.nagios1.devmlp.marquee.net.14368 2>&1; mv /usr/lib/hobbit/client/tmp/hobbit_vmstat.nagios1.devmlp.marquee.net.14368 /usr/lib/hobbit/client/tmp/hobbit_vmstat.nagios1.devmlp.marquee.net
hobbit   14393 14391  0 18:58 ?        00:00:00 vmstat 300 2
root     14821  1620  0 18:58 ?        00:00:00 sshd: skaratalapu [priv]
5011     14823 14821  0 18:58 ?        00:00:00 sshd: skaratalapu@pts/0
5011     14824 14823  0 18:58 pts/0    00:00:00 -bash
root     14863 14824  0 18:58 pts/0    00:00:00 sudo su -
root     14883 14863  0 18:58 pts/0    00:00:00 su -
root     14884 14883  0 18:58 pts/0    00:00:00 -bash
root     14917  2391  0 18:59 ?        00:00:00 CROND
root     14924 14917  0 18:59 ?        00:00:00 /bin/sh -c for i in 0 1; do bash -lc "/vvond/bin/checkConn.py" & sleep 30; done
root     14928 14924  0 18:59 ?        00:00:00 sleep 30
nagios   15054 15481  0 18:59 ?        00:00:00 /usr/local/nagios/libexec/check_nrpe -H 10.230.49.220 -t 30 -c check_iostat
nagios   15067 15484  0 18:59 ?        00:00:00 /usr/local/nagios/libexec/check_icmp -H 10.230.61.121 -w 3000.0 80  -c 5000.0 100  -p 5
nagios   15095 15486  0 18:59 ?        00:00:00 /usr/local/nagios/libexec/check_nrpe -H 10.230.54.222 -t 30 -c check_smtp
root     15103 14884  0 18:59 pts/0    00:00:00 ps -ef --cols=300
nagios   15407     1  0 Sep29 ?        00:00:03 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
nagios   15476     1  0 Sep29 ?        00:18:44 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios   15478 15476  0 Sep29 ?        00:00:48 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15479 15476  0 Sep29 ?        00:00:48 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15480 15476  0 Sep29 ?        00:00:49 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15481 15476  0 Sep29 ?        00:00:48 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15482 15476  0 Sep29 ?        00:00:49 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15483 15476  0 Sep29 ?        00:00:48 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15484 15476  0 Sep29 ?        00:00:49 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15485 15476  0 Sep29 ?        00:00:48 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15486 15476  0 Sep29 ?        00:00:48 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios   15496 15476  0 Sep29 ?        00:00:08 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
apache   19987 32292  0 Sep27 ?        00:00:08 /usr/sbin/httpd
apache   27827 32292  0 Sep27 ?        00:00:08 /usr/sbin/httpd
apache   27879 32292  0 Sep27 ?        00:00:08 /usr/sbin/httpd
apache   28112 32292  0 Sep27 ?        00:00:08 /usr/sbin/httpd
apache   28119 32292  0 Sep27 ?        00:00:09 /usr/sbin/httpd
apache   28120 32292  0 Sep27 ?        00:00:08 /usr/sbin/httpd
root     32292     1  0 Sep25 ?        00:00:13 /usr/sbin/httpd
apache   32300 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32301 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32302 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32303 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32304 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32305 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32306 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
apache   32307 32292  0 Sep25 ?        00:00:12 /usr/sbin/httpd
[[email protected] ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
[[email protected] ~]# tail -50 /var/log/mysqld.log
160923 17:50:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160923 17:50:52  InnoDB: Initializing buffer pool, size = 8.0M
160923 17:50:52  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160923 17:50:52  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160923 17:50:52  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
160923 17:50:52  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160923 17:50:53  InnoDB: Started; log sequence number 0 0
160923 17:50:53 [Note] Event Scheduler: Loaded 0 events
160923 17:50:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160923 17:57:53 [Note] /usr/libexec/mysqld: Normal shutdown

160923 17:57:53 [Note] Event Scheduler: Purging the queue. 0 events
160923 17:57:55  InnoDB: Starting shutdown...
160923 17:58:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160923 17:58:36  InnoDB: Initializing buffer pool, size = 8.0M
160923 17:58:36  InnoDB: Completed initialization of buffer pool
160923 17:58:37  InnoDB: Started; log sequence number 0 44233
160923 17:58:37 [Note] Event Scheduler: Loaded 0 events
160923 17:58:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160924 14:50:54 [Note] /usr/libexec/mysqld: Normal shutdown

160924 14:50:54 [Note] Event Scheduler: Purging the queue. 0 events
160924 14:50:56  InnoDB: Starting shutdown...
160924 14:50:57  InnoDB: Shutdown completed; log sequence number 0 44233
160924 14:50:57 [Note] /usr/libexec/mysqld: Shutdown complete

160924 14:50:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[[email protected] ~]# date
Fri Sep 30 19:00:10 GMT 2016
Last edited by lgroschen on Fri Sep 30, 2016 2:14 pm, edited 1 time in total.
Reason: added codeblock
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios xi graphing issue

Post by tgriep »

There is not any errors in the mysql log which is strange. Can you run this and post the output?

Code: Select all

service mysqld restart
tail -50 /var/log/messages
ls -l /etc
Thanks
Be sure to check out our Knowledgebase for helpful articles and solutions!
vuduops
Posts: 81
Joined: Wed Sep 07, 2016 1:34 pm

Re: Nagios xi graphing issue

Post by vuduops »

Code: Select all

[[email protected] ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]


[[email protected] ~]# tail -50 /var/log/messages
Sep 30 19:10:46 nagios1 nagios: Warning: Return code of 255 for check of service 'cpu' on host 'fullsearch1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:46 nagios1 nagios: Warning: Return code of 255 for check of service 'cpu' on host 'ftest1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:47 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'ftest2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:47 nagios1 nagios: Warning: Return code of 255 for check of service 'entropy' on host 'ftest4.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:48 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'cs1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:48 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'jiradb1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:49 nagios1 nagios: Warning: Return code of 255 for check of service 'nagios' on host 'jira2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:49 nagios1 nagios: Warning: Return code of 255 for check of service 'zombie process' on host 'cisdb5.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:50 nagios1 nagios: ndomod: Successfully reconnected to data sink!  176 items lost, 5000 queued items to flush.
Sep 30 19:10:50 nagios1 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sep 30 19:10:50 nagios1 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sep 30 19:10:50 nagios1 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sep 30 19:10:50 nagios1 nagios: ndomod: Error writing to data sink!  Some output may get lost.  4832 queued items to flush.
Sep 30 19:10:50 nagios1 nagios: Warning: Return code of 255 for check of service 'zombie process' on host 'fullsearch1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:52 nagios1 nagios: Warning: Return code of 255 for check of service 'zombie process' on host 'repo1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:54 nagios1 nagios: Warning: Return code of 255 for check of service 'mail' on host 'secwwwvirthost2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:54 nagios1 nagios: Warning: Return code of 255 for check of service 'mail' on host 'it1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:54 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'promocode3.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:55 nagios1 nagios: Warning: Return code of 255 for check of service 'cpu' on host 'startup2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:55 nagios1 nagios: Warning: Return code of 255 for check of service 'mail' on host 'jiradb1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:56 nagios1 nagios: Warning: Return code of 255 for check of service 'hobbit' on host 'dirvault1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:56 nagios1 nagios: Warning: Return code of 255 for check of service 'hobbit' on host 'ls2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:57 nagios1 nagios: Warning: Return code of 255 for check of service 'users' on host 'gigaencoder2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:57 nagios1 nagios: Warning: Return code of 255 for check of service 'entropy' on host 'jiradb2.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:58 nagios1 nagios: Warning: Return code of 255 for check of service 'mail' on host 'dirapp1-preprod.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:59 nagios1 nagios: Warning: Return code of 255 for check of service 'cpu' on host 'dirapp1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:59 nagios1 nagios: Warning: Return code of 255 for check of service 'nagios' on host 'jira1.devmlp.marquee.net' was out of bounds.
Sep 30 19:10:59 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'mainvirthost1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:00 nagios1 nagios: Warning: Return code of 255 for check of service 'nagios' on host 'virthost1-c2.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:00 nagios1 nagios: Warning: Return code of 255 for check of service 'hobbit' on host 'www1-beta1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:01 nagios1 nagios: Warning: Return code of 255 for check of service 'zombie process' on host 'mainvirthost1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:02 nagios1 nagios: Warning: Return code of 255 for check of service 'nagios' on host 'secwwwvirthost2.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:02 nagios1 nagios: Warning: Return code of 255 for check of service 'total processes' on host 'mainvirthost1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:02 nagios1 nagios: SERVICE NOTIFICATION: nagiosadmin;loges1.devmlp.marquee.net;tps;UNKNOWN;xi_service_notification_handler;NRPE: Unable to read output
Sep 30 19:11:04 nagios1 nagios: Warning: Return code of 255 for check of service 'nagios' on host 'mainvirthost2.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:06 nagios1 nagios: ndomod: Successfully reconnected to data sink!  46 items lost, 5000 queued items to flush.
Sep 30 19:11:06 nagios1 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sep 30 19:11:06 nagios1 ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sep 30 19:11:06 nagios1 nagios: ndomod: Error writing to data sink!  Some output may get lost.  4823 queued items to flush.
Sep 30 19:11:06 nagios1 nagios: Warning: Return code of 255 for check of service 'entropy' on host 'vvsim4.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:06 nagios1 nagios: Warning: Return code of 255 for check of service 'tps' on host 'jumphost1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:07 nagios1 nagios: Warning: Return code of 255 for check of service 'mail' on host 'mainvirthost1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:08 nagios1 nagios: Warning: Return code of 255 for check of service 'nagios' on host 'jumphost1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:08 nagios1 nagios: Warning: Return code of 255 for check of service 'tps' on host 'ls1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:08 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'vvsim1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:09 nagios1 nagios: Warning: Return code of 255 for check of service 'ssh' on host 'jira2.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:09 nagios1 nagios: Warning: Return code of 255 for check of service 'disk' on host 'ls1.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:09 nagios1 nagios: Warning: Return code of 255 for check of service 'mail' on host 'virthost3-c2.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:10 nagios1 nagios: Warning: Return code of 255 for check of service 'total processes' on host 'mainvirthost3.devmlp.marquee.net' was out of bounds.
Sep 30 19:11:11 nagios1 nagios: Warning: Return code of 255 for check of service 'cpu' on host 'vvsim3.devmlp.marquee.net' was out of bounds.
[[email protected] ~]# ls -l /etc
total 1668
drwxr-xr-x. 95 root   root     4096 Sep 25 03:52 ./
dr-xr-xr-x. 25 root   root     4096 Sep 25 03:52 ../
drwxr-xr-x.  4 root   root     4096 Sep 23 17:44 acpi/
-rw-r--r--.  1 root   root       44 Sep 25 03:52 adjtime
-r--r--r--.  1 root   root     1524 Sep 23 17:45 aliases
-rw-r--r--.  1 root   root    12288 Sep 23 17:45 aliases.db
drwxr-xr-x.  2 root   root     4096 Sep 23 17:44 alsa/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 alternatives/
-rw-------.  1 root   root      541 Aug 23 18:36 anacrontab
-rw-r--r--.  1 root   root      148 Jan 12  2016 asound.conf
-rw-r--r--.  1 root   root        1 Feb 19  2015 at.deny
drwxr-x---.  3 root   root     4096 Sep 23 17:44 audisp/
drwxr-x---.  3 root   root     4096 Sep 23 17:44 audit/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 bash_completion.d/
-rw-r--r--.  1 root   root     2870 Sep 23 17:45 bashrc
drwxr-xr-x.  2 root   root     4096 Sep 23 17:58 blkid/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 bonobo-activation/
-rw-r--r--.  1 root   root       27 May 18 19:47 centos-release
drwxr-xr-x.  2 root   root     4096 May 10 21:18 chkconfig.d/
drwxr-xr-x.  5 root   root     4096 Sep 23 17:49 ConsoleKit/
drwxr-xr-x.  2 root   root     4096 Sep 25 07:50 cron.d/
drwxr-xr-x.  2 root   root     4096 Sep 27  2011 cron.daily/
-rw-------.  1 root   root        0 Aug 23 18:36 cron.deny
drwxr-xr-x.  2 root   root     4096 Sep 25 07:50 cron.hourly/
drwxr-xr-x.  2 root   root     4096 Sep 27  2011 cron.monthly/
-r--r--r--.  1 root   root      259 Sep 23 18:01 crontab
-r--r--r--.  1 root   root      259 Sep 23 17:45 crontab.rpmsave
drwxr-xr-x.  2 root   root     4096 Sep 27  2011 cron.weekly/
-rw-r--r--.  1 root   root        0 Sep 23 17:42 crypttab
-rw-r--r--.  1 root   root     1602 Oct  2  2013 csh.cshrc
-rw-r--r--.  1 root   root      794 Oct  2  2013 csh.login
drwxr-xr-x.  4 root   root     4096 Sep 23 17:44 dbus-1/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:44 default/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:43 depmod.d/
drwxr-x---.  3 root   root     4096 Sep 23 17:43 dhcp/
-rw-r--r--.  1 root   root     4439 Apr 12 07:56 DIR_COLORS
-rw-r--r--.  1 root   root     5139 Apr 12 07:56 DIR_COLORS.256color
-rw-r--r--.  1 root   root     4113 Apr 12 07:56 DIR_COLORS.lightbgcolor
-rw-r--r--.  1 root   root      519 May 12 04:32 dracut.conf
drwxr-xr-x.  2 root   root     4096 May 12 04:32 dracut.conf.d/
-rw-r--r--.  1 root   root        0 Oct  2  2013 environment
-rw-r--r--.  1 root   root       28 May 10  2012 ethers
drwxr-xr-x.  2 root   mail     4096 Sep 23 17:49 exim/
-rw-r--r--.  1 root   root        0 Jan 12  2010 exports
lrwxrwxrwx.  1 root   root       56 Sep 23 17:43 favicon.png -> /usr/share/icons/hicolor/16x16/apps/system-logo-icon.png
-rw-r--r--.  1 root   root       64 Oct  2  2013 filesystems
drwxr-xr-x.  4 root   root     4096 Nov 11  2010 fonts/
-rw-r--r--.  1 root   root     1094 Feb 27  2012 freetds.conf
-rw-r--r--.  1 root   root      769 Sep 23 17:42 fstab
-rw-r--r--.  1 root   root        0 May 10 13:16 gai.conf
drwxr-xr-x.  7 root   root     4096 Sep 23 17:49 gconf/
drwxr-xr-x.  2 root   root     4096 Oct 24  2013 gcrypt/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:49 gnome-vfs-2.0/
drwxr-xr-x.  2 root   root     4096 Jun 30  2014 gnupg/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:48 grid-security/
-rw-r--r--.  1 root   root      780 Sep 23 17:53 group
-rw-r--r--.  1 root   root      764 Sep 23 17:50 group-
lrwxrwxrwx.  1 root   root       22 Sep 23 17:45 grub.conf -> ../boot/grub/grub.conf
----------.  1 root   root      636 Sep 23 17:53 gshadow
----------.  1 root   root      623 Sep 23 17:50 gshadow-
-rw-r--r--.  1 root   root      801 Jul 19  2011 gssapi_mech.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 gtk-2.0/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:44 hobbit/
-rw-r--r--.  1 root   root        9 Oct  2  2013 host.conf
-rw-r--r--.  1 root   root    20212 Sep 23 17:45 hosts
-rw-r--r--.  1 root   root      370 Jan 12  2010 hosts.allow
-rw-r--r--.  1 root   root      460 Jan 12  2010 hosts.deny
drwxr-xr-x.  4 root   root     4096 Sep 23 17:48 httpd/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 init/
-rw-r--r--.  1 root   root        0 May 10 21:13 init.conf
lrwxrwxrwx.  1 root   root       11 Sep 23 17:43 init.d -> rc.d/init.d/
-rw-r--r--.  1 root   root      884 Jul 12 16:40 inittab
-rw-r--r--.  1 root   root      942 Jan 12  2010 inputrc
drwxr-xr-x.  2 root   root     4096 Sep 23 17:43 iproute2/
-rw-r--r--.  1 root   root       47 May 18 19:47 issue
-rw-r--r--.  1 root   root       46 May 18 19:47 issue.net
-rw-r--r--.  1 root   root    36969 Sep 23  2011 jwhois.conf
drwxr-xr-x.  3 root   root     4096 Sep 23 17:49 kde/
drwxr-xr-x.  4 root   root     4096 Sep 23 17:44 kdump-adv-conf/
-rw-r--r--.  1 root   root     8120 Sep 23 17:44 kdump.conf
-rw-r--r--.  1 root   root      449 Mar  8  2016 krb5.conf
-rw-r--r--.  1 root   root     1128 May 10 23:36 kshrc
-rw-r--r--   1 root   root    50567 Sep 23 20:22 ld.so.cache
-rw-r--r--.  1 root   root       28 Jul 24  2013 ld.so.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 20:22 ld.so.conf.d/
-rw-r--r--.  1 root   root     3534 Feb 17  2009 lftp.conf
-rw-r-----.  1 root   root      191 Dec 18  2015 libaudit.conf
-rw-r--r--.  1 root   root     2293 Jul 25  2015 libuser.conf
-rw-r--r--.  1 root   root      370 Feb 27  2012 locales.conf
-rw-r--r--.  1 root   root      118 Sep 23 17:45 localtime
-rw-r--r--.  1 root   root     1816 Feb  9  2016 login.defs
-rw-r--r--.  1 root   root      662 Aug 29  2007 logrotate.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 17:54 logrotate.d/
drwxr-xr-x.  6 root   root     4096 Sep 23 17:46 lvm/
-rw-r--r--.  1 root   root      111 May 10 21:02 magic
-rw-r--r--.  1 root   root      272 Nov 17  2009 mailcap
-rw-r--r--.  1 root   root     1909 Dec 16  2014 mail.rc
drwxr-xr-x.  2 root   root     4096 Sep 23 17:43 makedev.d/
-rw-r--r--.  1 root   root     4940 Feb 22  2013 man.config
-rw-r--r--.  1 root   root    43591 Sep 23  2011 mime.types
-rw-r--r--.  1 root   root      827 Jul 24  2015 mke2fs.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 17:44 modprobe.d/
-r--r--r--.  1 root   root       92 Sep 23 17:45 motd
drwxrwxr-x.  4 apache nagios   4096 Sep 23 17:54 mrtg/
-rw-r--r--   1 root   root      233 Sep 25 03:52 mtab
drwsrwsr-x.  3 apache nagios   4096 Sep 23 17:53 nagiosql/
-rw-r--r--.  1 root   root     7846 Nov 12  2010 nanorc
-rw-r--r--.  1 root   root      767 Nov 30  2009 netconfig
drwxr-xr-x.  3 root   root     4096 Apr 12 09:14 NetworkManager/
-rw-r--r--.  1 root   root       58 Jul 12 16:40 networks
-rw-r--r--.  1 root   root     1688 May  4  2010 nsswitch.conf
drwxr-xr-x.  3 root   root     4096 Sep 23 17:46 ntp/
-r--r--r--.  1 root   root     2157 Sep 23 17:45 ntp.conf
-rw-r--r--.  1 root   root        0 Jul 10  2014 odbc.ini
-rw-r--r--.  1 root   root      575 Jul 10  2014 odbcinst.ini
drwxrwxr-x.  3 apache nagios   4096 Sep 23 17:55 openldap/
drwxr-xr-x.  2 root   root     4096 Sep 23  2011 opt/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 pam.d/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:48 pango/
-rw-r--r--.  1 root   root     5332 Sep 23 17:53 passwd
-rw-r--r--.  1 root   root     5265 Sep 23 17:49 passwd-
drwxr-xr-x.  2 root   root     4096 Sep 23 17:43 pcmcia/
drwxr-xr-x.  2 root   root     4096 May 10 22:42 pear/
-rw-r--r--.  1 root   root      946 May 10 22:42 pear.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 17:50 php.d/
-rw-r--r--.  1 root   root    69100 Sep 23 17:54 php.ini
-rw-r--r--.  1 root   root     2872 Aug 21  2010 pinforc
drwxr-xr-x.  3 root   root     4096 Sep 23 17:43 pkcs11/
drwxr-xr-x.  9 root   root     4096 Sep 23 17:43 pki/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:43 plymouth/
drwxr-xr-x.  5 root   root     4096 Sep 23 17:42 pm/
drwxr-xr-x.  5 root   root     4096 Sep 23 17:49 polkit-1/
-rw-r--r--.  1 root   root      219 Feb 27  2012 pool.conf
drwxr-xr-x.  2 root   root     4096 Aug 21  2010 popt.d/
drwxr-xr-x.  2 root   root     4096 Sep 23 18:01 postfix/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:46 ppp/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:46 prelink.conf.d/
-rw-r--r--.  1 root   root      233 Jan 12  2010 printcap
-rw-r--r--.  1 root   root     1796 Oct  2  2013 profile
drwxr-xr-x.  2 root   root     4096 Sep 23 17:46 profile.d/
-rw-r--r--.  1 root   root     6455 Jan 12  2010 protocols
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 pulse/
-rw-------.  1 root   root        0 Sep 23 17:43 .pwd.lock
-rw-r--r--.  1 root   root     6459 May 19  2010 qstat.cfg
-rw-r--r--.  1 root   root      220 Oct 13  2008 quotagrpadmins
-rw-r--r--.  1 root   root      259 Jul 23  2015 quotatab
drwxr-xr-x.  2 root   root     4096 Sep 23 17:48 radiusclient-ng/
lrwxrwxrwx.  1 root   root        7 Sep 23 17:46 rc -> rc.d/rc*
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc0.d -> rc.d/rc0.d/
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc1.d -> rc.d/rc1.d/
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc2.d -> rc.d/rc2.d/
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc3.d -> rc.d/rc3.d/
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc4.d -> rc.d/rc4.d/
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc5.d -> rc.d/rc5.d/
lrwxrwxrwx.  1 root   root       10 Sep 23 17:46 rc6.d -> rc.d/rc6.d/
drwxr-xr-x. 10 root   root     4096 Sep 23 17:46 rc.d/
lrwxrwxrwx.  1 root   root       13 Sep 23 17:46 rc.local -> rc.d/rc.local*
lrwxrwxrwx.  1 root   root       15 Sep 23 17:46 rc.sysinit -> rc.d/rc.sysinit*
drwxr-xr-x.  2 root   root     4096 Sep 23 17:44 rdma/
lrwxrwxrwx.  1 root   root       14 Sep 23 17:43 redhat-release -> centos-release
-r--r--r--.  1 root   root       94 Sep 23 17:45 resolv.conf
-rw-r--r--.  1 root   root     1615 May  4  2010 rpc
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 rpm/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 rpmdevtools/
-rw-r--r--.  1 root   root     2875 Dec 10  2014 rsyslog.conf
drwxr-xr-x.  2 root   root     4096 Dec 17  2014 rsyslog.d/
-rw-r--r--.  1 root   root      930 Jul 12 16:40 rwtab
drwxr-xr-x.  2 root   root     4096 Jul 12 16:40 rwtab.d/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:48 samba/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:48 sasl2/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:44 scl/
-rw-r--r--.  1 root   root     6682 May 10 18:41 screenrc
-rw-------.  1 root   root      128 Sep 23 17:58 securetty
drwxr-xr-x.  6 root   root     4096 Sep 23 17:48 security/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:43 selinux/
-rw-r--r--.  1 root   root     6845 Sep 25  2012 sensors3.conf
-rw-r--r--.  1 root   root   641090 Sep 23 17:50 services
-rw-r--r--.  1 root   root      216 May 10 22:57 sestatus.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 17:44 setuptool.d/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:49 sgml/
----------   1 root   root     4858 Sep 23 22:07 shadow
----------.  1 root   root     4852 Sep 23 17:53 shadow-
-rw-r--r--.  1 root   root       70 Sep 23 17:48 shells
drwxr-xr-x.  3 root   root     4096 Sep 23 17:49 skel/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:48 snmp/
-rw-r--r--.  1 root   root      256 May 11 20:21 sos.conf
drwxr-xr-x.  3 root   root     4096 Sep 23 17:49 sound/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:46 ssh/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:43 ssl/
-rw-r--r--.  1 root   root      212 Jul 12 16:40 statetab
drwxr-xr-x.  2 root   root     4096 Jul 12 16:40 statetab.d/
drwxr-xr-x.  2 root   root     4096 Aug 17  2015 subversion/
-rw-r-----.  1 root   root     1786 Sep 25  2012 sudo.conf
-r--r-----.  1 root   root     4833 Sep 23 18:00 sudoers
drwxr-x---.  2 root   root     4096 May 10 23:13 sudoers.d/
-rw-r-----.  1 root   root     3181 Mar  1  2016 sudo-ldap.conf
drwxr-xr-x.  8 root   root     4096 Sep 23 17:49 sysconfig/
-rw-r--r--.  1 root   root     1288 Sep 23 17:53 sysctl.conf
drwxr-xr-x.  2 root   root     4096 Jul 12 16:40 sysctl.d/
lrwxrwxrwx.  1 root   root       14 Sep 23 17:43 system-release -> centos-release
-rw-r--r--.  1 root   root       25 May 18 19:47 system-release-cpe
drwxr-xr-x.  2 root   root     4096 Mar 16  2015 terminfo/
drwxr-xr-x.  4 root   root     4096 Sep 23 17:46 udev/
-rw-r--r--.  1 root   root     1982 Mar 31  2015 vimrc
-rw-r--r--.  1 root   root     1982 Mar 31  2015 virc
-rw-r--r--.  1 root   root     3008 Jul 23  2015 warnquota.conf
-rw-r--r--.  1 root   root     4479 Jan 12  2016 wgetrc
drwxr-xr-x.  5 root   root     4096 Sep 23 17:49 X11/
drwxr-xr-x.  3 root   root     4096 Sep 23 17:42 xdg/
-rw-------.  1 root   root     1001 May 10 18:36 xinetd.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 17:53 xinetd.d/
drwxr-xr-x.  2 root   root     4096 Sep 23 17:49 xml/
drwxr-xr-x.  5 root   root     4096 Sep 23 17:46 yum/
-rw-r--r--.  1 root   root      969 Jul 12 16:45 yum.conf
drwxr-xr-x.  2 root   root     4096 Sep 23 18:01 yum.repos.d/
Last edited by lgroschen on Fri Sep 30, 2016 2:14 pm, edited 1 time in total.
Reason: add codeblocks
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios xi graphing issue

Post by tgriep »

Thanks for the output. It looks like the MYSQL main configuration file is missing and that is why it is not starting up.
Create this file

Code: Select all

/etc/my.cnf
and add the contents below to that file.

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
sql_mode=NO_ENGINE_SUBSTITUTION

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Save the file and start the mysql daemon by running

Code: Select all

service mysqld start
Then to see if it is running, run this.

Code: Select all

service mysqld status
Try that and post if this fixes the issue for you.
Be sure to check out our Knowledgebase for helpful articles and solutions!
vuduops
Posts: 81
Joined: Wed Sep 07, 2016 1:34 pm

Re: Nagios xi graphing issue

Post by vuduops »

Starting mysql failed and I see the below error in the mysqld log, after adding the my.cnf

[[email protected] ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
sql_mode=NO_ENGINE_SUBSTITUTION

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[[email protected] ~]#


160924 14:50:57 [Note] /usr/libexec/mysqld: Shutdown complete

160924 14:50:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161003 20:22:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161003 20:22:13 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
161003 20:22:13 InnoDB: Initializing buffer pool, size = 8.0M
161003 20:22:13 InnoDB: Completed initialization of buffer pool
161003 20:22:13 InnoDB: Started; log sequence number 0 44233
161003 20:22:13 [ERROR] Aborting

161003 20:22:13 InnoDB: Starting shutdown...
161003 20:22:18 InnoDB: Shutdown completed; log sequence number 0 44233
161003 20:22:18 [Note]
161003 20:22:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

-Krishna
^C
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Nagios xi graphing issue

Post by tgriep »

Try reinstalling the following packages to see if that missing file is restored.
Login as root, and run the following

Code: Select all

yum reinstall mysql-libs
yum reinstall mysql-community-common
After they are reinstalled see if the mysql database starts.
Be sure to check out our Knowledgebase for helpful articles and solutions!
vuduops
Posts: 81
Joined: Wed Sep 07, 2016 1:34 pm

Re: Nagios xi graphing issue

Post by vuduops »

Thanks looks like it was mysql package conflict. I was able to a fresh install and I am able to access the UI. But I still donot see the graphs. I have not even added any services other than the local host checks.

I have included the screen shot as an attachment for your reference.

Uploaded the screen shot...

Thanks
Srikrishna
You do not have the required permissions to view the files attached to this post.
Last edited by vuduops on Mon Oct 03, 2016 6:46 pm, edited 1 time in total.
User avatar
Box293
Too Basu
Posts: 5126
Joined: Sun Feb 07, 2010 10:55 pm
Location: Deniliquin, Australia
Contact:

Re: Nagios xi graphing issue

Post by Box293 »

Screen shot is missing
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked