Page 1 of 4
Databse Error
Posted: Tue Jun 20, 2017 8:31 am
by sandeepatil
Error on Web:
"A database connection error has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB:
/usr/local/nagiosxi/scripts/repair_databases.sh"
After repairing DB using above command, issue not resolved. Same message displayed.
Re: Databse Error
Posted: Tue Jun 20, 2017 10:22 am
by dwhitfield
First off, what's the output of the following? Please note that you will need to remove the "#" before each command line for the commands to work.
# df -i
# df -h
It's possible you are out of space.
Please run through
https://assets.nagios.com/downloads/nag ... tabase.pdf and report any errors. If you stop at any point, please know at which point you stop. You already ran the script, so just skip that.
Regarding the instructions below, if you do not have killall, you can install it via the following command:
# yum install psmisc
If psmisc is not in your repos, then instead you can check to make sure nagios is not running with
# ps -aef | grep nagios
If that document does not resolve your issue, please run the following commands in order and report any errors. You ***must*** use mariadb instead of mysqld in the commands below, ***if*** you have mariadb.
# service nagios stop
# service ndo2db stop
# service mysqld stop
# service crond stop
# service httpd stop
# killall -9 nagios
# killall -9 ndo2db
# rm -rf /usr/local/nagios/var/rw/nagios.cmd
# rm -rf /usr/local/nagios/var/nagios.lock
# rm -f /usr/local/nagios/var/ndo.sock
# rm -f /usr/local/nagios/var/ndo2db.lock
# rm -f /usr/local/nagiosxi/var/reconfigure_nagios.lock
# for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
# service ndo2db start
# service nagios start
# service mysqld start
# service crond start
# service httpd start
Re: Databse Error
Posted: Tue Jun 20, 2017 10:53 am
by sandeepatil
Out Put of "df -h" and "df -I"
Code: Select all
[root@nodea ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 50G 8.4G 42G 17% /
devtmpfs 878M 0 878M 0% /dev
tmpfs 893M 84K 893M 1% /dev/shm
tmpfs 893M 97M 796M 11% /run
tmpfs 893M 0 893M 0% /sys/fs/cgroup
/dev/mapper/centos-home 51G 37M 51G 1% /home
/dev/sda1 497M 313M 184M 63% /boot
tmpfs 179M 16K 179M 1% /run/user/42
tmpfs 179M 0 179M 0% /run/user/0
[root@nodea ~]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/centos-root 52428800 432776 51996024 1% /
devtmpfs 224694 427 224267 1% /dev
tmpfs 228570 6 228564 1% /dev/shm
tmpfs 228570 609 227961 1% /run
tmpfs 228570 13 228557 1% /sys/fs/cgroup
/dev/mapper/centos-home 53108736 226 53108510 1% /home
/dev/sda1 512000 356 511644 1% /boot
tmpfs 228570 17 228553 1% /run/user/42
tmpfs 228570 1 228569 1% /run/user/0
[root@nodea ~]#
Also done,
Code: Select all
[root@nodea ~]# service nagios stop
Stopping nagios (via systemctl): [ OK ]
You have mail in /var/spool/mail/root
[root@nodea ~]# service ndo2db stop
Stopping ndo2db (via systemctl): [ OK ]
[root@nodea ~]# systemctl stop mariadb.service
[root@nodea ~]# systemctl stop httpd.service
[root@nodea ~]# systemctl stop crond.service
[root@nodea ~]# killall -9 nagios
nagios: no process found
[root@nodea ~]# killall -9 ndo2db
ndo2db: no process found
[root@nodea ~]# rm -rf /usr/local/nagios/var/rw/nagios.cmd
[root@nodea ~]# rm -rf /usr/local/nagios/var/nagios.lock
[root@nodea ~]# rm -f /usr/local/nagios/var/ndo.sock
[root@nodea ~]# rm -f /usr/local/nagios/var/ndo2db.lock
[root@nodea ~]# rm -f /usr/local/nagiosxi/var/reconfigure_nagios.lock
[root@nodea ~]# for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
[root@nodea ~]# service ndo2db start
Starting ndo2db (via systemctl): [ OK ]
[root@nodea ~]# service nagios start
Starting nagios (via systemctl): [ OK ]
[root@nodea ~]# systemctl start mariadb.service
[root@nodea ~]# systemctl start httpd.service
[root@nodea ~]# systemctl start crond.service
[root@nodea ~]#
Done the below instruction, no error found,
[quote
Please run through
https://assets.nagios.com/downloads/nag ... tabase.pdf and report any errors. If you stop at any point, please know at which point you stop. You already ran the script, so just skip that.
[/quote]
Issue romance same.
Re: Databse Error
Posted: Tue Jun 20, 2017 10:58 am
by dwhitfield
Can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.
After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.
Re: Databse Error
Posted: Tue Jun 20, 2017 11:17 am
by sandeepatil
Unable to login in Nagios XI through web console, on web console showing only below error,
Databse Error
A database connection error has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB:
/usr/local/nagiosxi/scripts/repair_databases.sh
Re: Databse Error
Posted: Tue Jun 20, 2017 4:41 pm
by tgriep
To repair the database, login to the nagios server as root, and run the following command.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Try running it again and see if you can login to the server.
If you still cannot login, then it could be a Postgress database error and to verify that, run the following as root and post the output.
Code: Select all
grep dbtype /usr/local/nagiosxi/html/config.inc.php
Re: Databse Error
Posted: Wed Jun 21, 2017 5:09 am
by sandeepatil
Was tried this "/usr/local/nagiosxi/scripts/repair_databases.sh" command 4 to 5 times, issue remains same.
Please find requested out put,
Code: Select all
[root@nodea ~]# grep dbtype /usr/local/nagiosxi/html/config.inc.php
$cfg['dbtype'] = ''; // this setting is no longer used - use settings below
"dbtype" => 'mysql',
"dbtype" => 'mysql',
"dbtype" => 'mysql',
You have new mail in /var/spool/mail/root
[root@nodea ~]#
Re: Databse Error
Posted: Wed Jun 21, 2017 10:51 am
by tgriep
Can you run the following commands as root on the Nagios server and post the output so we can review it?
Code: Select all
chage -l nagios
ipcs -q
ps -ef --cols=300
tail -50 /var/log/mysqld.log
Thanks.
Re: Databse Error
Posted: Wed Jun 21, 2017 11:08 am
by sandeepatil
1] chage -l nagios
Code: Select all
[root@nodea ~]# chage -l nagios
Last password change : Aug 31, 2016
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : 0
Maximum number of days between password change : 99999
Number of days of warning before password expires : 7
[root@nodea ~]#
2] ipcs -q
Code: Select all
[root@nodea ~]# ipcs -q
------ Message Queues --------
key msqid owner perms used-bytes messages
You have new mail in /var/spool/mail/root
[root@nodea ~]#
3] ps -ef --cols=300
Code: Select all
[root@nodea ~]# ps -ef --cols=300
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 Jun20 ? 00:03:44 /usr/lib/systemd/systemd --switched-root --system --deserialize 21
root 2 0 0 Jun20 ? 00:00:00 [kthreadd]
root 3 2 0 Jun20 ? 00:00:00 [ksoftirqd/0]
root 7 2 0 Jun20 ? 00:00:02 [migration/0]
root 8 2 0 Jun20 ? 00:00:00 [rcu_bh]
root 9 2 0 Jun20 ? 00:00:00 [rcuob/0]
root 10 2 0 Jun20 ? 00:00:00 [rcuob/1]
root 11 2 0 Jun20 ? 00:00:00 [rcuob/2]
root 12 2 0 Jun20 ? 00:00:00 [rcuob/3]
root 13 2 0 Jun20 ? 00:01:26 [rcu_sched]
root 14 2 0 Jun20 ? 00:00:44 [rcuos/0]
root 15 2 0 Jun20 ? 00:00:43 [rcuos/1]
root 16 2 0 Jun20 ? 00:00:00 [rcuos/2]
root 17 2 0 Jun20 ? 00:00:00 [rcuos/3]
root 18 2 0 Jun20 ? 00:00:00 [watchdog/0]
root 19 2 0 Jun20 ? 00:00:00 [watchdog/1]
root 20 2 0 Jun20 ? 00:00:02 [migration/1]
root 21 2 0 Jun20 ? 00:00:00 [ksoftirqd/1]
root 24 2 0 Jun20 ? 00:00:00 [khelper]
root 25 2 0 Jun20 ? 00:00:00 [kdevtmpfs]
root 26 2 0 Jun20 ? 00:00:00 [netns]
root 27 2 0 Jun20 ? 00:00:00 [perf]
root 28 2 0 Jun20 ? 00:00:00 [writeback]
root 29 2 0 Jun20 ? 00:00:00 [kintegrityd]
root 30 2 0 Jun20 ? 00:00:00 [bioset]
root 31 2 0 Jun20 ? 00:00:00 [kblockd]
root 32 2 0 Jun20 ? 00:00:00 [md]
root 38 2 0 Jun20 ? 00:00:00 [khungtaskd]
root 39 2 0 Jun20 ? 00:00:00 [kswapd0]
root 40 2 0 Jun20 ? 00:00:00 [ksmd]
root 41 2 0 Jun20 ? 00:00:03 [khugepaged]
root 42 2 0 Jun20 ? 00:00:13 [fsnotify_mark]
root 43 2 0 Jun20 ? 00:00:00 [crypto]
root 51 2 0 Jun20 ? 00:00:00 [kthrotld]
root 54 2 0 Jun20 ? 00:00:00 [kmpath_rdacd]
root 55 2 0 Jun20 ? 00:00:00 [kpsmoused]
root 57 2 0 Jun20 ? 00:00:00 [ipv6_addrconf]
root 76 2 0 Jun20 ? 00:00:00 [deferwq]
root 109 2 0 Jun20 ? 00:00:05 [kauditd]
root 278 2 0 Jun20 ? 00:00:00 [ata_sff]
root 279 2 0 Jun20 ? 00:00:00 [events_power_ef]
root 295 2 0 Jun20 ? 00:00:00 [scsi_eh_0]
root 296 2 0 Jun20 ? 00:00:00 [scsi_tmf_0]
root 297 2 0 Jun20 ? 00:00:00 [scsi_eh_1]
root 298 2 0 Jun20 ? 00:00:00 [scsi_tmf_1]
root 301 2 0 Jun20 ? 00:00:00 [scsi_eh_2]
root 302 2 0 Jun20 ? 00:00:00 [scsi_tmf_2]
root 303 2 0 Jun20 ? 00:00:00 [scsi_eh_3]
root 304 2 0 Jun20 ? 00:00:00 [scsi_tmf_3]
root 312 2 0 Jun20 ? 00:00:00 [scsi_eh_4]
root 314 2 0 Jun20 ? 00:00:00 [scsi_tmf_4]
root 315 2 0 Jun20 ? 00:00:00 [scsi_eh_5]
root 316 2 0 Jun20 ? 00:00:00 [scsi_tmf_5]
root 328 2 0 Jun20 ? 00:00:00 [kworker/0:1H]
root 408 2 0 Jun20 ? 00:00:00 [kdmflush]
root 409 2 0 Jun20 ? 00:00:00 [bioset]
root 416 2 0 Jun20 ? 00:00:00 [kdmflush]
root 417 2 0 Jun20 ? 00:00:00 [bioset]
root 434 2 0 Jun20 ? 00:00:00 [xfsalloc]
root 435 2 0 Jun20 ? 00:00:00 [xfs_mru_cache]
root 436 2 0 Jun20 ? 00:00:00 [xfs-buf/dm-1]
root 437 2 0 Jun20 ? 00:00:00 [xfs-data/dm-1]
root 438 2 0 Jun20 ? 00:00:00 [xfs-conv/dm-1]
root 439 2 0 Jun20 ? 00:00:00 [xfs-cil/dm-1]
root 440 2 0 Jun20 ? 00:00:00 [xfs-reclaim/dm-]
root 441 2 0 Jun20 ? 00:00:00 [xfs-log/dm-1]
root 442 2 0 Jun20 ? 00:00:00 [xfs-eofblocks/d]
root 443 2 0 Jun20 ? 00:00:43 [xfsaild/dm-1]
root 534 1 0 Jun20 ? 00:02:12 /usr/lib/systemd/systemd-journald
root 551 2 0 Jun20 ? 00:00:00 [rpciod]
root 557 1 0 Jun20 ? 00:00:00 /usr/sbin/lvmetad -f
root 558 1 0 Jun20 ? 00:00:00 /usr/lib/systemd/systemd-udevd
root 568 2 0 Jun20 ? 00:00:00 [kmpathd]
root 569 2 0 Jun20 ? 00:00:00 [kmpath_handlerd]
root 577 1 0 Jun20 ? 00:00:05 /sbin/multipathd
root 600 2 0 Jun20 ? 00:00:00 [irq/32-mei_me]
root 635 2 0 Jun20 ? 00:00:00 [kdmflush]
root 637 2 0 Jun20 ? 00:00:00 [bioset]
root 648 2 0 Jun20 ? 00:00:00 [xfs-buf/sda1]
root 649 2 0 Jun20 ? 00:00:00 [xfs-data/sda1]
root 650 2 0 Jun20 ? 00:00:00 [xfs-conv/sda1]
root 651 2 0 Jun20 ? 00:00:00 [xfs-cil/sda1]
root 652 2 0 Jun20 ? 00:00:00 [xfs-reclaim/sda]
root 653 2 0 Jun20 ? 00:00:00 [xfs-log/sda1]
root 654 2 0 Jun20 ? 00:00:00 [xfs-eofblocks/s]
root 655 2 0 Jun20 ? 00:00:00 [xfsaild/sda1]
root 670 2 0 Jun20 ? 00:00:00 [xfs-buf/dm-2]
root 671 2 0 Jun20 ? 00:00:00 [xfs-data/dm-2]
root 672 2 0 Jun20 ? 00:00:00 [xfs-conv/dm-2]
root 673 2 0 Jun20 ? 00:00:00 [xfs-cil/dm-2]
root 674 2 0 Jun20 ? 00:00:00 [xfs-reclaim/dm-]
root 675 2 0 Jun20 ? 00:00:00 [xfs-log/dm-2]
root 676 2 0 Jun20 ? 00:00:00 [xfs-eofblocks/d]
root 677 2 0 Jun20 ? 00:00:00 [xfsaild/dm-2]
root 693 1 0 Jun20 ? 00:00:24 /sbin/auditd -n
root 697 693 0 Jun20 ? 00:00:12 /sbin/audispd
root 698 697 0 Jun20 ? 00:00:07 /usr/sbin/sedispatch
root 717 1 0 Jun20 ? 00:00:00 /usr/sbin/alsactl -s -n 19 -c -E ALSA_CONFIG_PATH=/etc/alsa/alsactl.conf --initfile=/lib/alsa/init/00main rdaemon
rtkit 718 1 0 Jun20 ? 00:00:01 /usr/libexec/rtkit-daemon
root 720 1 0 Jun20 ? 00:00:00 /usr/sbin/smartd -n -q never
root 723 1 0 Jun20 ? 00:00:17 /usr/sbin/irqbalance --foreground
avahi 724 1 0 Jun20 ? 00:00:13 avahi-daemon: running [nodea.local]
root 725 1 0 Jun20 ? 00:00:22 /usr/libexec/accounts-daemon
root 727 1 0 Jun20 ? 00:00:59 /usr/sbin/rsyslogd -n
dbus 731 1 0 Jun20 ? 00:07:55 /bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
root 733 1 0 Jun20 ? 00:00:00 /usr/sbin/gssproxy -D
chrony 735 1 0 Jun20 ? 00:00:00 /usr/sbin/chronyd
rpc 736 1 0 Jun20 ? 00:00:00 /sbin/rpcbind -w
avahi 750 724 0 Jun20 ? 00:00:00 avahi-daemon: chroot helper
root 753 1 0 Jun20 ? 00:00:00 /usr/sbin/ModemManager
root 758 1 0 Jun20 ? 00:02:02 /usr/lib/systemd/systemd-logind
root 761 1 0 Jun20 ? 00:00:00 /usr/sbin/abrtd -d -s
root 763 1 0 Jun20 ? 00:00:00 /usr/bin/abrt-watch-log -F Backtrace /var/log/Xorg.0.log -- /usr/bin/abrt-dump-xorg -xD
root 765 1 0 Jun20 ? 00:00:03 /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
libstor+ 766 1 0 Jun20 ? 00:00:00 /usr/bin/lsmd -d
root 775 1 0 Jun20 ? 00:03:36 /usr/sbin/NetworkManager --no-daemon
root 780 1 0 Jun20 ? 00:00:05 /bin/bash /usr/sbin/ksmtuned
polkitd 789 1 0 Jun20 ? 00:29:47 /usr/lib/polkit-1/polkitd --no-debug
root 810 1 0 Jun20 ? 00:00:00 /usr/sbin/wpa_supplicant -u -f /var/log/wpa_supplicant.log -c /etc/wpa_supplicant/wpa_supplicant.conf -u -f /var/log/wpa_supplicant.log -P /var/run/wpa_supplicant.pid
root 1023 1 0 Jun20 ? 00:00:00 /usr/sbin/xrdp-sesman --nodaemon
root 1024 1 0 Jun20 ? 00:00:00 /usr/sbin/xrdp --nodaemon
root 1026 1 0 Jun20 ? 00:00:00 /usr/sbin/sshd -D
root 1032 1 0 Jun20 ? 00:00:18 /usr/bin/python -Es /usr/sbin/tuned -l -P
nagios 1036 1 0 Jun20 ? 00:00:02 /usr/local/nagios/bin/npcd -d -f /usr/local/nagios/etc/pnp/npcd.cfg
root 1037 1 0 Jun20 ? 00:00:00 /usr/sbin/xinetd -stayalive -pidfile /var/run/xinetd.pid
root 1044 1 0 Jun20 ? 00:00:00 /usr/sbin/libvirtd
root 1050 1 0 Jun20 ? 00:00:00 /usr/sbin/atd -f
root 1052 1 0 Jun20 ? 00:00:00 /usr/sbin/gdm
root 1165 1052 0 Jun20 tty1 00:00:01 /usr/bin/Xorg :0 -background none -noreset -audit 4 -verbose -auth /run/gdm/auth-for-gdm-Mj9wl0/database -seat seat0 -nolisten tcp vt1
postfix 2152 2301 0 02:00 ? 00:00:00 local -t unix
ajaxterm 2184 1 0 Jun20 ? 00:00:45 python /usr/share/ajaxterm/ajaxterm.py --daemon --port=8022 --uid=ajaxterm
root 2247 1052 0 Jun20 ? 00:02:15 gdm-session-worker [pam/gdm-launch-environment]
root 2301 1 0 Jun20 ? 00:00:07 /usr/libexec/postfix/master -w
gdm 2302 2247 0 Jun20 ? 00:00:51 /usr/bin/gnome-session --autostart /usr/share/gdm/greeter/autostart
postfix 2304 2301 0 Jun20 ? 00:00:16 qmgr -l -t unix -u
gdm 2307 1 0 Jun20 ? 00:00:00 /usr/bin/dbus-launch --exit-with-session /usr/bin/gnome-session --autostart /usr/share/gdm/greeter/autostart
gdm 2308 1 0 Jun20 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 4 --print-address 6 --session
gdm 2350 1 0 Jun20 ? 00:00:00 /usr/libexec/at-spi-bus-launcher
gdm 2357 2350 0 Jun20 ? 00:00:00 /bin/dbus-daemon --config-file=/etc/at-spi2/accessibility.conf --nofork --print-address 3
gdm 2360 1 0 Jun20 ? 00:00:00 /usr/libexec/at-spi2-registryd --use-gnome-session
gdm 2412 2302 0 Jun20 ? 00:00:26 /usr/libexec/gnome-settings-daemon
root 2424 1 0 Jun20 ? 00:00:35 /usr/libexec/upowerd
gdm 2451 1 0 Jun20 ? 00:00:00 /usr/libexec/gvfsd
gdm 2504 1 0 Jun20 ? 00:00:00 /usr/libexec/gvfsd-fuse /run/user/42/gvfs -f -o big_writes
root 2508 2 0 02:01 ? 00:00:00 [kworker/1:0]
nobody 2568 1 0 Jun20 ? 00:00:00 /sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --leasefile-ro --dhcp-script=/usr/libexec/libvirt_leaseshelper
root 2569 2568 0 Jun20 ? 00:00:00 /sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --leasefile-ro --dhcp-script=/usr/libexec/libvirt_leaseshelper
gdm 2576 2302 0 Jun20 ? 00:07:00 gnome-shell --mode=gdm
colord 2580 1 0 Jun20 ? 00:00:00 /usr/libexec/colord
gdm 2647 1 0 Jun20 ? 00:00:00 /usr/bin/pulseaudio --start --log-target=syslog
gdm 2677 1 0 Jun20 ? 00:00:00 /usr/libexec/dconf-service
gdm 2692 2576 0 Jun20 ? 00:00:02 ibus-daemon --xim --panel disable
gdm 2697 2692 0 Jun20 ? 00:00:00 /usr/libexec/ibus-dconf
gdm 2699 1 0 Jun20 ? 00:00:00 /usr/libexec/ibus-x11 --kill-daemon
gdm 2710 1 0 Jun20 ? 00:01:01 /usr/libexec/mission-control-5
gdm 2712 1 0 Jun20 ? 00:00:00 /usr/libexec/caribou
root 2717 1 0 Jun20 ? 00:00:37 /usr/libexec/packagekitd
gdm 2723 1 0 Jun20 ? 00:00:00 /usr/libexec/goa-daemon
gdm 2745 1 0 Jun20 ? 00:00:31 /usr/libexec/gvfs-udisks2-volume-monitor
root 2756 1 0 Jun20 ? 00:01:02 /usr/lib/udisks2/udisksd --no-debug
gdm 2768 1 0 Jun20 ? 00:00:06 /usr/libexec/goa-identity-service
gdm 2776 1 0 Jun20 ? 00:00:00 /usr/libexec/gvfs-afc-volume-monitor
gdm 2781 1 0 Jun20 ? 00:00:00 /usr/libexec/gvfs-mtp-volume-monitor
gdm 2792 1 0 Jun20 ? 00:00:00 /usr/libexec/gvfs-goa-volume-monitor
gdm 2796 1 0 Jun20 ? 00:00:00 /usr/libexec/gvfs-gphoto2-volume-monitor
gdm 2817 2692 0 Jun20 ? 00:00:00 /usr/libexec/ibus-engine-simple
root 3241 2 0 Jun20 ? 00:00:08 [kworker/0:2H]
root 3353 2 0 Jun20 ? 00:00:04 [kworker/1:2H]
apache 4131 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 4133 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 4134 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
mysql 4594 1 0 Jun21 ? 00:02:05 /usr/libexec/mysqld --basedir=/usr
root 4981 1 0 Jun21 ? 00:00:03 /usr/sbin/httpd -DFOREGROUND
apache 5000 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5001 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5003 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5004 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5005 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5006 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5008 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
apache 5009 4981 0 Jun21 ? 00:00:00 /usr/sbin/httpd -DFOREGROUND
root 5104 1 0 Jun21 ? 00:00:07 /usr/sbin/crond -n
postfix 6476 2301 0 02:14 ? 00:00:00 local -t unix
postfix 7664 2301 0 02:18 ? 00:00:00 trivial-rewrite -n rewrite -t unix -u
nagios 8349 1 0 Jun21 ? 00:00:00 /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg -f
nagios 8503 1 0 Jun21 ? 00:00:11 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
nagios 8505 8503 0 Jun21 ? 00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 8506 8503 0 Jun21 ? 00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 8507 8503 0 Jun21 ? 00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 8508 8503 0 Jun21 ? 00:00:00 /usr/local/nagios/bin/nagios --worker /usr/local/nagios/var/rw/nagios.qh
nagios 8569 8503 0 Jun21 ? 00:00:00 /usr/local/nagios/bin/nagios -d /usr/local/nagios/etc/nagios.cfg
postfix 8854 2301 0 02:22 ? 00:00:00 cleanup -z -t unix -u
root 10307 2 0 02:27 ? 00:00:00 [kworker/u8:1]
root 10753 2 0 02:28 ? 00:00:00 [kworker/0:3]
postfix 11212 2301 0 02:30 ? 00:00:00 cleanup -z -t unix -u
postfix 11214 2301 0 02:30 ? 00:00:00 cleanup -z -t unix -u
root 11346 2 0 Jun21 ? 00:00:04 [kworker/1:0H]
postfix 11508 2301 0 02:31 ? 00:00:00 bounce -z -t unix -u
postfix 12119 2301 0 02:33 ? 00:00:00 bounce -z -t unix -u
postfix 12122 2301 0 02:33 ? 00:00:00 bounce -z -t unix -u
root 12731 2 0 02:35 ? 00:00:00 [kworker/u8:2]
postfix 12732 2301 0 02:35 ? 00:00:00 local -t unix
root 13022 2 0 02:36 ? 00:00:00 [kworker/0:0]
postfix 13026 2301 0 02:36 ? 00:00:00 pickup -l -t unix -u
root 13130 2 0 02:36 ? 00:00:00 [kworker/0:1]
root 13137 2 0 02:36 ? 00:00:00 [kworker/1:3]
root 14665 2 0 02:41 ? 00:00:00 [kworker/1:2]
postfix 14889 2301 0 02:42 ? 00:00:00 local -t unix
root 15004 2 0 02:42 ? 00:00:00 [kworker/0:2]
root 15586 1026 0 02:44 ? 00:00:00 sshd: root@pts/0
root 15590 15586 0 02:44 pts/0 00:00:00 -bash
root 15982 2 0 02:45 ? 00:00:00 [kworker/1:1H]
root 16383 780 0 02:46 ? 00:00:00 sleep 60
root 16389 15590 0 02:46 pts/0 00:00:00 ps -ef --cols=300
4] tail -50 /var/log/mysqld.log
No such file or directory
Re: Databse Error
Posted: Wed Jun 21, 2017 11:35 am
by tgriep
Is the MYSQL database server offloaded to a remote server?
If so, the mysqld.log file would be on that server.
If the mysql server is not offloaded, then it is not running correctly on the server and that is the cause of the error.
To restart it, run the following as root.
Wait a few minutes and see if you can login to the XU GUI.