HI,
i got following error when i logged into NagiosXI GUI
but when i checked the database i can see all the tables in NagiosXI database.
MariaDB [nagiosxi]> show tables;
+---------------------+
| Tables_in_nagiosxi |
+---------------------+
| xi_auditlog |
| xi_auth_tokens |
| xi_cmp_trapdata |
| xi_cmp_trapdata_log |
| xi_commands |
| xi_eventqueue |
| xi_events |
| xi_incidents |
| xi_meta |
| xi_options |
| xi_sessions |
| xi_sysstat |
| xi_usermeta |
| xi_users |
+---------------------+
14 rows in set (0.00 sec)
Any help will be appreciated.
Thanks.
NagiosXI Database error
NagiosXI Database error
You do not have the required permissions to view the files attached to this post.
Re: NagiosXI Database error
I suspect that the issue is that Nagios XI cannot connect to the database for some reason and that is why it is generating that error.
Check the Apache error logs in the /var/log/httpd folder to see if you can find an error when XI is trying to access the nagiosxi database.
If you find max_connection errors, follow this KB article to fix it else post the errors here.
https://support.nagios.com/kb/article/n ... s-513.html
It could be that the servers hard drive it full so check that by running the following as root.
Or that a process is stuck running on the server and is stopping connections to the database.
Run this as root and post it here.
The simplest way to stop them is to just reboot the server.
Check the Apache error logs in the /var/log/httpd folder to see if you can find an error when XI is trying to access the nagiosxi database.
If you find max_connection errors, follow this KB article to fix it else post the errors here.
https://support.nagios.com/kb/article/n ... s-513.html
It could be that the servers hard drive it full so check that by running the following as root.
Code: Select all
df -h
df -iRun this as root and post it here.
Code: Select all
ps -ef --cols=300Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: NagiosXI Database error
Here are the results of what you asked.tgriep wrote:I suspect that the issue is that Nagios XI cannot connect to the database for some reason and that is why it is generating that error.
Check the Apache error logs in the /var/log/httpd folder to see if you can find an error when XI is trying to access the nagiosxi database.
If you find max_connection errors, follow this KB article to fix it else post the errors here.
https://support.nagios.com/kb/article/n ... s-513.html
It could be that the servers hard drive it full so check that by running the following as root.Or that a process is stuck running on the server and is stopping connections to the database.Code: Select all
df -h df -i
Run this as root and post it here.The simplest way to stop them is to just reboot the server.Code: Select all
ps -ef --cols=300
Code: Select all
#df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/sysvg-lv_root 25G 81M 25G 1% /
devtmpfs 3.9G 0 3.9G 0% /dev
none 3.9G 0 3.9G 0% /dev/shm
tmpfs 3.9G 476K 3.9G 1% /run
tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
/dev/mapper/sysvg-lv_usr 10G 4.0G 6.1G 40% /usr
/dev/mapper/sysvg-lv_var 8.0G 1.1G 6.9G 14% /var
/dev/mapper/sysvg-lv_opt 25G 1.2G 24G 5% /opt
/dev/mapper/sysvg-lv_mysql 150G 2.4G 148G 2% /var/lib/mysql
/dev/mapper/sysvg-lv_log 30G 1.5G 29G 5% /var/log
/dev/mapper/sysvg-lv_home 10G 33M 10G 1% /home
/dev/mapper/sysvg-lv_journal 8.0G 457M 7.6G 6% /var/log/journal
/dev/vda1 509M 196M 314M 39% /boot
/dev/mapper/sysvg-lv_tmp 15G 41M 15G 1% /tmp
/dev/mapper/sysvg-lv_audit 8.0G 258M 7.8G 4% /var/log/audit
Code: Select all
# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/sysvg-lv_root 12800000 3071 12796929 1% /
devtmpfs 998313 425 997888 1% /dev
none 1000796 1 1000795 1% /dev/shm
tmpfs 1000796 607 1000189 1% /run
tmpfs 1000796 16 1000780 1% /sys/fs/cgroup
/dev/mapper/sysvg-lv_usr 5242880 72209 5170671 2% /usr
/dev/mapper/sysvg-lv_var 4194304 3963 4190341 1% /var
/dev/mapper/sysvg-lv_opt 12800000 5149 12794851 1% /opt
/dev/mapper/sysvg-lv_mysql 78643200 400 78642800 1% /var/lib/mysql
/dev/mapper/sysvg-lv_log 15728640 188 15728452 1% /var/log
/dev/mapper/sysvg-lv_home 5242880 122 5242758 1% /home
/dev/mapper/sysvg-lv_journal 4194304 28 4194276 1% /var/log/journal
/dev/vda1 262144 336 261808 1% /boot
/dev/mapper/sysvg-lv_tmp 7864320 86 7864234 1% /tmp
/dev/mapper/sysvg-lv_audit 4194304 7 4194297 1% /var/log/auditCode: Select all
# ps -ef --cols=300
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 2018 ? 00:00:48 /usr/lib/systemd/systemd --switched-root --system --deserialize 21
root 2 0 0 2018 ? 00:00:00 [kthreadd]
root 3 2 0 2018 ? 00:00:11 [ksoftirqd/0]
root 5 2 0 2018 ? 00:00:00 [kworker/0:0H]
root 7 2 0 2018 ? 00:00:11 [migration/0]
root 8 2 0 2018 ? 00:00:00 [rcu_bh]
root 9 2 0 2018 ? 00:03:43 [rcu_sched]
root 10 2 0 2018 ? 00:00:14 [watchdog/0]
root 11 2 0 2018 ? 00:00:12 [watchdog/1]
root 12 2 0 2018 ? 00:00:12 [migration/1]
root 13 2 0 2018 ? 00:00:09 [ksoftirqd/1]
root 15 2 0 2018 ? 00:00:00 [kworker/1:0H]
root 17 2 0 2018 ? 00:00:00 [kdevtmpfs]
root 18 2 0 2018 ? 00:00:00 [netns]
root 19 2 0 2018 ? 00:00:02 [khungtaskd]
root 20 2 0 2018 ? 00:00:00 [writeback]
root 21 2 0 2018 ? 00:00:00 [kintegrityd]
root 22 2 0 2018 ? 00:00:00 [bioset]
root 23 2 0 2018 ? 00:00:00 [kblockd]
root 24 2 0 2018 ? 00:00:00 [md]
root 31 2 0 2018 ? 00:00:06 [kswapd0]
root 32 2 0 2018 ? 00:00:00 [ksmd]
root 33 2 0 2018 ? 00:00:11 [khugepaged]
root 34 2 0 2018 ? 00:00:00 [fsnotify_mark]
root 35 2 0 2018 ? 00:00:00 [crypto]
root 43 2 0 2018 ? 00:00:00 [kthrotld]
root 45 2 0 2018 ? 00:00:00 [kmpath_rdacd]
root 46 2 0 2018 ? 00:00:00 [kpsmoused]
root 65 2 0 2018 ? 00:00:00 [deferwq]
root 98 2 0 2018 ? 00:00:03 [kauditd]
root 244 2 0 2018 ? 00:00:00 [ata_sff]
root 260 2 0 2018 ? 00:00:00 [scsi_eh_0]
root 261 2 0 2018 ? 00:00:00 [scsi_tmf_0]
root 262 2 0 2018 ? 00:00:00 [scsi_eh_1]
root 263 2 0 2018 ? 00:00:00 [scsi_tmf_1]
root 267 2 0 2018 ? 00:00:00 [ttm_swap]
root 268 2 0 2018 ? 00:00:00 [qxl_gc]
root 275 2 0 2018 ? 00:00:00 [virtscsi-scan]
root 278 2 0 2018 ? 00:00:00 [scsi_eh_2]
root 279 2 0 2018 ? 00:00:00 [scsi_tmf_2]
root 365 2 0 2018 ? 00:00:00 [kdmflush]
root 366 2 0 2018 ? 00:00:00 [bioset]
root 375 2 0 2018 ? 00:00:00 [kdmflush]
root 376 2 0 2018 ? 00:00:00 [bioset]
root 385 2 0 2018 ? 00:00:00 [kdmflush]
root 386 2 0 2018 ? 00:00:00 [bioset]
root 400 2 0 2018 ? 00:00:00 [xfsalloc]
root 401 2 0 2018 ? 00:00:00 [xfs_mru_cache]
root 402 2 0 2018 ? 00:00:00 [xfs-buf/dm-0]
root 403 2 0 2018 ? 00:00:00 [xfs-data/dm-0]
root 404 2 0 2018 ? 00:00:00 [xfs-conv/dm-0]
root 405 2 0 2018 ? 00:00:00 [xfs-cil/dm-0]
root 406 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 407 2 0 2018 ? 00:00:00 [xfs-log/dm-0]
root 408 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 409 2 0 2018 ? 00:06:30 [xfsaild/dm-0]
root 431 2 0 2018 ? 00:00:00 [xfs-buf/dm-2]
root 432 2 0 2018 ? 00:00:00 [xfs-data/dm-2]
root 433 2 0 2018 ? 00:00:00 [xfs-conv/dm-2]
root 434 2 0 2018 ? 00:00:00 [xfs-cil/dm-2]
root 435 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 436 2 0 2018 ? 00:00:00 [xfs-log/dm-2]
root 437 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 438 2 0 2018 ? 00:00:37 [xfsaild/dm-2]
root 472 1 0 2018 ? 00:02:05 /usr/lib/systemd/systemd-journald
root 490 2 0 2018 ? 00:01:17 [kworker/0:1H]
root 497 1 0 2018 ? 00:00:00 /usr/sbin/lvmetad -f
root 503 2 0 2018 ? 00:00:00 [rpciod]
root 504 1 0 2018 ? 00:00:00 /usr/lib/systemd/systemd-udevd
root 530 2 0 2018 ? 00:00:00 [vballoon]
root 588 2 0 2018 ? 00:00:00 [xfs-buf/vda1]
root 589 2 0 2018 ? 00:00:00 [xfs-data/vda1]
root 590 2 0 2018 ? 00:00:00 [xfs-conv/vda1]
root 591 2 0 2018 ? 00:00:00 [xfs-cil/vda1]
root 592 2 0 2018 ? 00:00:00 [xfs-reclaim/vda]
root 593 2 0 2018 ? 00:00:00 [xfs-log/vda1]
root 594 2 0 2018 ? 00:00:00 [xfs-eofblocks/v]
root 595 2 0 2018 ? 00:00:00 [xfsaild/vda1]
root 602 2 0 2018 ? 00:00:27 [kworker/1:1H]
root 603 2 0 2018 ? 00:00:00 [kdmflush]
root 604 2 0 2018 ? 00:00:00 [bioset]
root 606 2 0 2018 ? 00:00:00 [kdmflush]
root 607 2 0 2018 ? 00:00:00 [bioset]
root 608 2 0 2018 ? 00:00:00 [kdmflush]
root 609 2 0 2018 ? 00:00:00 [bioset]
root 611 2 0 2018 ? 00:00:00 [kdmflush]
root 612 2 0 2018 ? 00:00:00 [bioset]
root 613 2 0 2018 ? 00:00:00 [kdmflush]
root 616 2 0 2018 ? 00:00:00 [bioset]
root 621 2 0 2018 ? 00:00:00 [kdmflush]
root 623 2 0 2018 ? 00:00:00 [bioset]
root 625 2 0 2018 ? 00:00:00 [kdmflush]
root 626 2 0 2018 ? 00:00:00 [bioset]
root 628 2 0 2018 ? 00:00:00 [kdmflush]
root 629 2 0 2018 ? 00:00:00 [bioset]
root 641 2 0 2018 ? 00:00:00 [xfs-buf/dm-3]
root 642 2 0 2018 ? 00:00:00 [xfs-data/dm-3]
root 643 2 0 2018 ? 00:00:00 [xfs-conv/dm-3]
root 644 2 0 2018 ? 00:00:00 [xfs-cil/dm-3]
root 645 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 646 2 0 2018 ? 00:00:00 [xfs-log/dm-3]
root 647 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 648 2 0 2018 ? 00:03:17 [xfsaild/dm-3]
root 652 2 0 2018 ? 00:00:00 [xfs-buf/dm-4]
root 653 2 0 2018 ? 00:00:00 [xfs-data/dm-4]
root 654 2 0 2018 ? 00:00:00 [xfs-conv/dm-4]
root 655 2 0 2018 ? 00:00:00 [xfs-cil/dm-4]
root 656 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 657 2 0 2018 ? 00:00:00 [xfs-log/dm-4]
root 658 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 659 2 0 2018 ? 00:00:05 [xfsaild/dm-4]
root 661 2 0 2018 ? 00:00:00 [xfs-buf/dm-7]
root 662 2 0 2018 ? 00:00:00 [xfs-data/dm-7]
root 663 2 0 2018 ? 00:00:00 [xfs-conv/dm-7]
root 664 2 0 2018 ? 00:00:00 [xfs-cil/dm-7]
root 665 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 666 2 0 2018 ? 00:00:00 [xfs-log/dm-7]
root 667 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 668 2 0 2018 ? 00:00:34 [xfsaild/dm-7]
root 671 2 0 2018 ? 00:00:00 [xfs-buf/dm-8]
root 672 2 0 2018 ? 00:00:00 [xfs-data/dm-8]
root 673 2 0 2018 ? 00:00:00 [xfs-conv/dm-8]
root 674 2 0 2018 ? 00:00:00 [xfs-cil/dm-8]
root 675 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 676 2 0 2018 ? 00:00:00 [xfs-log/dm-8]
root 677 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 678 2 0 2018 ? 00:00:00 [xfsaild/dm-8]
root 685 2 0 2018 ? 00:00:00 [xfs-buf/dm-6]
root 686 2 0 2018 ? 00:00:00 [xfs-data/dm-6]
root 687 2 0 2018 ? 00:00:00 [xfs-conv/dm-6]
root 688 2 0 2018 ? 00:00:00 [xfs-cil/dm-6]
root 689 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 690 2 0 2018 ? 00:00:00 [xfs-log/dm-6]
root 691 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 692 2 0 2018 ? 00:05:30 [xfsaild/dm-6]
root 694 2 0 2018 ? 00:00:00 [xfs-buf/dm-10]
root 695 2 0 2018 ? 00:00:00 [xfs-data/dm-10]
root 696 2 0 2018 ? 00:00:00 [xfs-conv/dm-10]
root 697 2 0 2018 ? 00:00:00 [xfs-cil/dm-10]
root 698 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 699 2 0 2018 ? 00:00:00 [xfs-log/dm-10]
root 700 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 701 2 0 2018 ? 00:06:17 [xfsaild/dm-10]
root 708 2 0 2018 ? 00:00:00 [xfs-buf/dm-5]
root 709 2 0 2018 ? 00:00:00 [xfs-data/dm-5]
root 710 2 0 2018 ? 00:00:00 [xfs-conv/dm-5]
root 711 2 0 2018 ? 00:00:00 [xfs-cil/dm-5]
root 712 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 713 2 0 2018 ? 00:00:00 [xfs-log/dm-5]
root 714 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 715 2 0 2018 ? 00:00:00 [xfs-buf/dm-9]
root 716 2 0 2018 ? 00:00:00 [xfs-data/dm-9]
root 717 2 0 2018 ? 00:00:00 [xfs-conv/dm-9]
root 718 2 0 2018 ? 00:00:00 [xfs-cil/dm-9]
root 719 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 720 2 0 2018 ? 00:00:00 [xfs-log/dm-9]
root 721 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 722 2 0 2018 ? 00:03:27 [xfsaild/dm-5]
root 723 2 0 2018 ? 00:01:46 [xfsaild/dm-9]
root 743 1 0 2018 ? 00:00:18 /sbin/auditd -n
root 773 1 0 2018 ? 00:07:29 /usr/sbin/irqbalance --foreground
root 777 1 0 2018 ? 00:32:13 /sbin/rngd -f
root 778 1 0 2018 ? 00:00:00 /usr/sbin/smartd -n -q never
libstor+ 779 1 0 2018 ? 00:00:08 /usr/bin/lsmd -d
root 781 1 0 2018 ? 00:00:05 /usr/lib/systemd/systemd-logind
root 783 1 0 2018 ? 00:00:00 /usr/sbin/abrtd -d -s
root 785 1 0 2018 ? 00:00:02 /usr/bin/abrt-watch-log -F BUG: WARNING: at WARNING: CPU: INFO: possible recursive locking detected ernel BUG at list_del corruption list_add corruption do_IRQ: stack overflow: ear stack overflow (cur: eneral protection fault nable to handle kernel oub
root 786 1 0 2018 ? 00:00:00 /usr/bin/qemu-ga --method=virtio-serial --path=/dev/virtio-ports/org.qemu.guest_agent.0 --blacklist=guest-file-open,guest-file-close,guest-file-read,guest-file-write,guest-file-seek,guest-file-flush,guest-exec,guest-exec-status -F/etc/qemu-ga/fsfreeze-
dbus 788 1 0 2018 ? 00:00:15 /bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
root 796 1 0 2018 ? 00:00:04 /usr/sbin/gssproxy -D
polkitd 809 1 0 2018 ? 00:00:05 /usr/lib/polkit-1/polkitd --no-debug
root 828 1 0 2018 ? 00:00:09 /usr/sbin/crond -n
root 829 1 0 2018 ? 00:00:00 /usr/sbin/atd -f
ovirtag+ 832 1 0 2018 ? 03:24:47 /usr/bin/python /usr/share/ovirt-guest-agent/ovirt-guest-agent.py
root 834 1 0 2018 ? 00:00:00 /usr/sbin/spice-vdagentd
chrony 844 1 0 2018 ? 00:00:02 /usr/sbin/chronyd -4
root 983 1 0 2018 tty1 00:00:00 /sbin/agetty --noclear tty1 linux
root 1041 1 0 2018 ? 00:00:24 /usr/sbin/rsyslogd -n
root 1042 1 0 2018 ? 00:04:36 /usr/bin/python -Es /usr/sbin/tuned -l -P
root 1044 1 0 2018 ? 00:00:00 /usr/bin/rhsmcertd
root 1045 1 0 2018 ? 00:00:03 /usr/sbin/sshd -D
root 1047 1 0 2018 ? 00:03:31 /usr/bin/ruby /usr/bin/puppet agent --no-daemonize
root 1080 1 0 2018 ? 00:00:00 rhnsd
root 1089 1 0 2018 ? 00:00:44 /usr/sbin/automount --pid-file /run/autofs.pid
root 1111 1 0 2018 ? 00:02:08 sendmail: accepting connections
s527649 1123 1 0 2018 ? 00:00:00 /etc/bgs/SD/bgssd.exe -d /etc/bgs/SD -s
smmsp 1138 1 0 2018 ? 00:00:00 sendmail: Queue runner@01:00:00 for /var/spool/clientmqueue
root 1142 1 0 2018 ? 00:00:36 /usr/openv/netbackup/bin/vnetd -standalone
root 1162 1 0 2018 ? 00:00:37 /usr/openv/netbackup/bin/bpcd -standalone
rpcuser 2480 1 0 2018 ? 00:00:00 /usr/sbin/rpc.statd --no-notify
rpc 2482 1 0 2018 ? 00:00:05 /sbin/rpcbind -w
root 2489 2 0 2018 ? 00:00:00 [nfsiod]
root 3989 1 0 2018 ? 00:23:02 /opt/McAfee/auditengine/bin/auditmanager
root 4249 1 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 4256 4249 0 2018 ? 00:01:11 /opt/McAfee/cma/bin/cma
root 4257 4256 0 2018 ? 00:00:39 /opt/McAfee/cma/bin/cma
root 4258 4256 0 2018 ? 00:02:22 /opt/McAfee/cma/bin/cma
root 4259 4256 0 2018 ? 00:01:26 /opt/McAfee/cma/bin/cma
root 4260 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 4261 4256 0 2018 ? 00:00:29 /opt/McAfee/cma/bin/cma
root 4262 4256 0 2018 ? 00:00:28 /opt/McAfee/cma/bin/cma
root 4263 4256 0 2018 ? 00:00:03 /opt/McAfee/cma/bin/cma
root 4264 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 4265 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 4266 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 4267 4256 0 2018 ? 00:10:10 /opt/McAfee/cma/bin/cma
root 4268 4256 0 2018 ? 00:00:26 /opt/McAfee/cma/bin/cma
root 4271 4256 0 2018 ? 00:00:34 /opt/McAfee/cma/bin/cma
root 4272 4256 0 2018 ? 00:00:13 /opt/McAfee/cma/bin/cma
root 4274 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 4657 4256 0 2018 ? 02:34:45 /opt/McAfee/cma/bin/cma
mysql 9254 1 0 2018 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
root 9406 2 0 2018 ? 00:00:00 [kdmflush]
root 9407 2 0 2018 ? 00:00:00 [bioset]
root 9477 2 0 2018 ? 00:00:00 [xfs-buf/dm-11]
root 9478 2 0 2018 ? 00:00:00 [xfs-data/dm-11]
root 9479 2 0 2018 ? 00:00:00 [xfs-conv/dm-11]
root 9480 2 0 2018 ? 00:00:00 [xfs-cil/dm-11]
root 9481 2 0 2018 ? 00:00:00 [xfs-reclaim/dm-]
root 9482 2 0 2018 ? 00:00:00 [xfs-log/dm-11]
root 9483 2 0 2018 ? 00:00:00 [xfs-eofblocks/d]
root 9484 2 0 2018 ? 00:00:00 [xfsaild/dm-11]
mysql 9545 9254 0 2018 ? 00:31:57 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock --port=3306
root 15555 2 0 13:06 ? 00:00:00 [kworker/0:0]
root 15684 2 0 13:06 ? 00:00:00 [kworker/1:2]
root 17561 2 0 13:33 ? 00:00:00 [kworker/0:5]
root 17670 2 0 13:34 ? 00:00:00 [kworker/u64:1]
root 18258 2 0 13:41 ? 00:00:00 [kworker/0:4]
root 18392 2 0 13:44 ? 00:00:00 [kworker/u64:2]
root 18568 2 0 13:47 ? 00:00:00 [kworker/0:1]
root 18633 2 0 13:48 ? 00:00:00 [kworker/0:2]
root 18745 24063 0 13:49 pts/1 00:00:00 ps -ef --cols=300
nagios 23693 1 0 2018 ? 00:00:18 /usr/local/nagios/bin/nrpe -c /usr/local/nagios/etc/nrpe.cfg -f
root 23991 1045 0 08:21 ? 00:00:00 sshd: u147734 [priv]
u147734 23995 23991 0 08:21 ? 00:00:00 sshd: u147734@pts/1
u147734 24002 23995 0 08:21 pts/1 00:00:00 -bash
root 24058 24002 0 08:21 pts/1 00:00:00 /bin/su -
root 24063 24058 0 08:21 pts/1 00:00:00 -bash
root 27082 1045 0 08:53 ? 00:00:00 sshd: u271869 [priv]
u271869 27086 27082 0 08:53 ? 00:00:00 sshd: u271869@pts/2
u271869 27087 27086 0 08:53 pts/2 00:00:00 -bash
root 27801 2 0 09:02 ? 00:00:00 [lockd]
root 28222 27087 0 09:06 pts/2 00:00:00 /bin/su -
root 28227 28222 0 09:06 pts/2 00:00:00 -bash
root 30937 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 30939 4256 0 2018 ? 00:00:00 /opt/McAfee/cma/bin/cma
root 31132 1045 0 09:40 ? 00:00:00 sshd: u271869 [priv]
u271869 31136 31132 0 09:40 ? 00:00:00 sshd: u271869@pts/3
u271869 31137 31136 0 09:40 pts/3 00:00:00 -bash
root 31190 31137 0 09:40 pts/3 00:00:00 /bin/su -
root 31373 31190 0 09:40 pts/3 00:00:00 -bash
root 31783 1 0 2018 ? 00:03:53 /opt/CA/AccessControl/bin/seosd
root 31785 1 0 2018 ? 00:00:41 /opt/CA/AccessControl/bin/seagent SEOSD
root 31795 1 0 2018 ? 00:02:33 /opt/CA/AccessControl/bin/seoswd AGENT
root 31806 1 0 2018 ? 00:00:10 /opt/CA/AccessControl/bin/serevu
root 32143 1 0 2018 ? 00:02:13 /opt/CA/AccessControlShared/bin/ReportAgent
root 32511 2 0 04:00 ? 00:00:00 [kworker/1:0]The error will pop-up for a few seconds and then be normal after some time. only 2 users faces the problem remaining users doesn't have any issues of this type.
Thanks.
Last edited by tgriep on Wed Jan 02, 2019 2:45 pm, edited 1 time in total.
Reason: Added Code Wraps around large output.
Reason: Added Code Wraps around large output.
Re: NagiosXI Database error
Is your MYSQL database that the Nagios XI server is using to store it's data offloaded to a remote server?
The ps -ef output you posted does not show the Nagios process running so I guess that it is the MYSQL server, correct?
If so, can you run the following command on the MYSQL server and post it here?
Did you check the Apache log files on the Nagios server in this folder for any errors?
Did you implement the max_connection changes outlined in this article that I posted earlier?
https://support.nagios.com/kb/article/n ... s-513.html
The ps -ef output you posted does not show the Nagios process running so I guess that it is the MYSQL server, correct?
If so, can you run the following command on the MYSQL server and post it here?
Code: Select all
tail -100 /var/log/mariadb/mariadb.logCode: Select all
/var/log/httpdhttps://support.nagios.com/kb/article/n ... s-513.html
Be sure to check out our Knowledgebase for helpful articles and solutions!