Page 2 of 2

Re: Cannot Login to Nagios After DB repair

Posted: Fri Nov 14, 2014 3:45 pm
by cdrussell
i ran that and no joy. looks like the file system filled up.

Filesystem Size Used Avail Use% Mounted on
/dev/sda5 185G 54G 122G 31% /
tmpfs 4.2G 0 4.2G 0% /dev/shm
/dev/sda1 2.1G 59M 2.0G 3% /boot
/dev/sda2 21G 20G 0 100% /var


how can i decrease what /dev/sda5 is using and give some of that space to /dev/sda2

Re: Cannot Login to Nagios After DB repair

Posted: Fri Nov 14, 2014 3:50 pm
by cdrussell
also get this when running the commands, had to stop at this one:

bash-4.1$ postgres -D /var/lib/pgsql/data nagiosxi < /tmp/fix.sql
postgres: invalid argument: "nagiosxi"

Re: Cannot Login to Nagios After DB repair

Posted: Fri Nov 14, 2014 3:53 pm
by lmiltchev
You can run the following command to view the 10 largest files in "/var":

Code: Select all

du -a /var | sort -n -r | head -n 10
but you will need to make a judgement call on what to delete to make some space... Delete some old logs, etc...

Re: Cannot Login to Nagios After DB repair

Posted: Fri Nov 14, 2014 3:55 pm
by cdrussell
18991952 /var
11754816 /var/lib
11466984 /var/lib/mysql
11442420 /var/lib/mysql/nagios
8379360 /var/lib/mysql/nagios/nagios_logentries.MYD
6750564 /var/log
2141532 /var/lib/mysql/nagios/nagios_logentries.MYI
1948036 /var/log/mysqld.log
1923992 /var/log/messages
1492824 /var/log/messages-20141109

Re: Cannot Login to Nagios After DB repair

Posted: Fri Nov 14, 2014 4:58 pm
by cdrussell
i cleared the logs and was able to start the sql. it works now.

Do i need these:


8379360 /var/lib/mysql/nagios/nagios_logentries.MYD
2141532 /var/lib/mysql/nagios/nagios_logentries.MYI


Thanks for the support i appreciate it

Re: Cannot Login to Nagios After DB repair

Posted: Mon Nov 17, 2014 10:25 am
by slansing
You're going to want to keep them if you want to have reports and an audit log!