DB Connect Error [nagiosxi]: Database connection failed

[AcademyNag]

DB Connect Error [nagiosxi]: Database connection failed
is the message I get when I go to the full URL with 'nagiosxi', if I just go to the server without that I get a web interface that has a link- "Welcome
Click the link below to get started using Nagios XI." and that link takes me to the same blank page with the above error.
All was working fine, only changes made that I know of were that I put in a RSA key for the nagios user to be able to access other servers as needed.
Please help, my boss is working hard to get the Licences but its taking time.

[AcademyNag]

Found part of the problem,,, HDD full because of the following:
(from -"find / -type f -size +100M | xargs du -hs")
5.6G /store/backups/mysql/daily/nagios/nagios_2013-07-08_07h00m.Monday.sql
3.4G /var/lib/mysql/nagios/nagios_logentries.MYD
252M /var/lib/mysql/nagios/nagios_contactnotificationmethods.MYI
361M /var/lib/mysql/nagios/nagios_contactnotifications.MYI
313M /var/lib/mysql/nagios/nagios_contactnotificationmethods.MYD
150M /var/lib/mysql/nagios/nagios_logentries.MYI
278M /var/lib/mysql/nagios/nagios_contactnotifications.MYD
and others over 500M EACH that I've already deleted... Is there a reason this utility can eat up 20+ GB in a day?

[abrist]

That log entries table is GIGANTIC. I bet the event log in XI takes forever and a day to open up . . . You may have to wipe that table.

[slansing]

How large is your environment? Hosts/services/checks per hour?

Please share the output of:

Code: Select all

df -h

df -i

[sreinhardt]

If slansing's commands come back filled up, you might take a look at our resize vmware disks documentation.

[AcademyNag]

there are 547 Hosts, "547 total records"

# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_plapnag03e-lv_root
26G 11G 13G 46% /

# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/vg_plapnag03e-lv_root
1676080 91495 1584585 6% /

[AcademyNag]

Oh, and 2100 Services- (2100 total records)

And, there was a 3GB log in /usr/local/nagios/var/archives/ , and others there were between 300-600MB --- just fyi

[sreinhardt]

Let's trucate those large databases, repair them, and restart some services. Just so you know, the documentation this is coming from is here: http://assets.nagios.com/downloads/nagi ... tabase.pdf

Code: Select all

cd /usr/local/nagiosxi/scripts/
service mysqld stop

mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_contactnotificationmethods'
mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_contactnotifications'
mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_logentries'

./repairmysql.sh nagios
./repairmysql.sh nagiosql

service mysqld start
service postgresql restart
service nagios restart
service ndo2db restart
service httpd restart

Also I just read "and others over 500M EACH that I've already deleted" You are not deleting from the /var/lib/mysql/nagios/ directory correct?

[AcademyNag]

as root? or as nagios?

Also I just read "and others over 500M EACH that I've already deleted" You are not deleting from the /var/lib/mysql/nagios/ directory correct?

No- from /usr/local/nagios/var/archives/

[scottwilkerson]

as root