Nagios Support Forum

This "mysql -u *~" still errors, but i think it does what its supposed to, and the rest works without error, so, yes, the issue seems to be resolved, if i find issue with these steps i will inquire of that separately, as it is a different issue than what i presented, and that part is resol...

Just more fyi-

I edited the syslog-ng and the logrotate, changed weekly to daily, added compression, and added the ~/var/archives/*, added to keep only 15 days worth, added /store and mysql...

And- Thanks btw for the help, i have downloaded the reference in your link, and bookmarked the parent site for future reference.

# whoami root -bash-4.1# cd /usr/local/nagiosxi/scripts/ -bash-4.1# service mysqld stop Stopping mysqld: [ OK ] -bash-4.1# mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_contactnotificationmethods' ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/my...

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/

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

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% /

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

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

abrist , Thank you for your time and efforts, I found the issue-- It was a faulty configuration between the keyboard and the chair- (ID10T-error) the '/usr' partition was full- so when changes were made and you tried to write the configs- it tried, then errored, and left the cgi not knowing what to ...