Page 1 of 1

DB connect error

Posted: Fri Oct 12, 2012 2:57 pm
by 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

Re: DB connect error

Posted: Fri Oct 12, 2012 3:02 pm
by 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.

Re: DB connect error

Posted: Fri Oct 12, 2012 3:15 pm
by 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 ;)

Re: DB connect error

Posted: Fri Oct 12, 2012 3:36 pm
by 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

Re: DB connect error

Posted: Sat Oct 13, 2012 9:52 am
by 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

Re: DB connect error

Posted: Tue Oct 16, 2012 1:17 am
by 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.

Re: DB connect error

Posted: Tue Oct 16, 2012 2:46 pm
by 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

Re: DB connect error

Posted: Tue Oct 16, 2012 3:47 pm
by 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

Re: DB connect error

Posted: Wed Oct 17, 2012 9:42 am
by dmanem
That worked.

Thank you,
Deepika Manem