DB connect error

[dmanem]

Hello,

I am having Database connection error when I try to open Nagios XI. I tried deleting the error and access logs but that has not cleared any space.

Thank you,
Deepika

[lcontreras]

Hi,

You have to look for for others files that you could delete, the problem is that you don't have space on disk, and for that reason mysql doesn't start. You have to make room on your server enough for mysql server could start.

[mguthrie]

This will give you all files larger than 32MB in the var directory:

Code: Select all

find /var/* -size +32768k

DO NOT delete something unless you know what it is

[dmanem]

Hello,

I ran the command you sent me and these are the entries that showed up. I think I can delete the mail logs and maybe notifications. I am not sure what else to delete.Please let me know.

Thank you,
Deepika Manem

[scottwilkerson]

Don't delete anything in /var/lib/mysql

That is the Mysql database files...

If this is a virtual machine you might want to look at this
http://library.nagios.com/library/produ ... -disk-size

[niebais]

It's quite possible that some logs in /var have filled up bigger than they should be. Usually a messages file gets too large or the apache httpd log files.

[dmanem]

Hello,

I have hard disk space of 64GiB but one of my partition /dev/sda2 has 9.90GiB. This is what NagiosXI is using and now this partition is full and I was trying to extend this partition to use the unallocated partition as well but it looks like the /dev/sda2 partition is locked.I am not sure how to unlock it. Attached is a screenshot that explains this. Any help would be appreciated.

Thank you,
Deepika Manem

[scottwilkerson]

Gparted doesn't manage Linux lvm partitions

As I outlined before, we have instructions on extending the drive here
http://library.nagios.com/library/produ ... -disk-size

[dmanem]

That worked.

Thank you,
Deepika Manem