Databse Error

[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.

[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

[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.

[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.

[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

[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

[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 ~]#

[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.

[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

[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.

Code: Select all

service mysqld restart

Wait a few minutes and see if you can login to the XU GUI.