Cannot Login to Nagios After DB repair

[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

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

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

[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

[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

[slansing]

You're going to want to keep them if you want to have reports and an audit log!