DB Connect Error [nagiosxi]: Database connection failed

[AcademyNag]

# 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/mysql.sock' (2)

[AcademyNag]

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

[AcademyNag]

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

[lmiltchev]

Is your issue resolved now?

[sreinhardt]

Cool, that should help a lot with space issues. As for the mysql login issues, I suppose I should have told you to stop mysql after running those two. So let me rephrase that:

Code: Select all

cd /usr/local/nagiosxi/scripts/

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'

service mysqld stop

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

service mysqld start
service postgresql restart
service nagios restart

[AcademyNag]

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 resolved, I have downloaded the documentation from the links provided from this support, so I can use it prior to posting if these issues arise again. And again- Thank you for all your Help- everyone.

Shawn Miller
Academy Sports + Outdoors
IT - Linux Systems Engineer

[slansing]

Great to hear! Let us know via a new thread if you run into issues, feel free to link the URL to this one for background.