Page 1 of 1

DB Connect error

Posted: Tue Jul 23, 2013 2:06 am
by Frédéric GRANAT
Hi,
This morning I've got DB Connect error.

df -k gives :

Code: Select all

Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      29329476  27873624         0 100% /
/dev/sda1               101086     31684     64183  34% /boot
tmpfs                  1553548         0   1553548   0% /dev/shm
If I run du -ak | sort -nr | head -50 :

Code: Select all

27802462        .
18479516        ./var
14924052        ./var/cache
14801588        ./var/cache/logwatch
5775564 ./usr
3447828 ./usr/local
3092276 ./usr/local/nagios
2376680 ./var/log
2265108 ./usr/local/nagios/share
2252168 ./usr/local/nagios/share/perfdata
2172704 ./root
2099204 ./root/dead.letter
1162404 ./var/lib
1156036 ./usr/lib
812372  ./usr/local/nagios/var
786920  ./usr/local/nagios/var/archives
748056  ./usr/share
654724  ./var/cache/logwatch/logwatch.tu6QXprw
651920  ./var/cache/logwatch/logwatch.BLnN6Lwr
651048  ./home
650940  ./home/xadozuk
650904  ./home/xadozuk/client
635460  ./home/xadozuk/client/stage
630272  ./var/cache/logwatch/logwatch.XoN6ZZQM
601328  ./var/lib/pgsql
601280  ./var/lib/pgsql/data
586064  ./home/xadozuk/client/stage/Components
563560  ./var/log/messages.4
563560  ./var/cache/logwatch/logwatch.XoN6ZZQM/messages-archive
563560  ./var/cache/logwatch/logwatch.tu6QXprw/messages-archive
563560  ./var/cache/logwatch/logwatch.BLnN6Lwr/messages-archive
549800  ./var/cache/logwatch/logwatch.MuPbpZfg
480148  ./var/log/mysqld.log.rpmsave
434888  ./var/lib/mysql
402888  ./var/lib/mysql/nagios
379884  ./var/cache/logwatch/logwatch.qThKILD7
365504  ./var/log/mysqld.log
337432  ./var/lib/pgsql/data/base
303584  ./var/cache/logwatch/logwatch.FnGMad8J
302052  ./var/cache/logwatch/logwatch.RROqv8Bi
301764  ./var/cache/logwatch/logwatch.Kc07VSjg
301056  ./var/cache/logwatch/logwatch.yg88Rl1K
300896  ./var/cache/logwatch/logwatch.sgxX1KWo
298740  ./var/cache/logwatch/logwatch.PJ1LcGF9
297152  ./var/cache/logwatch/logwatch.MuPbpZfg/messages
296640  ./var/cache/logwatch/logwatch.RPtIcbU2
295968  ./var/cache/logwatch/logwatch.QCDamggX
292752  ./var/cache/logwatch/logwatch.wueYlovo
292608  ./var/cache/logwatch/logwatch.aNJZF6Uu
289208  ./var/cache/logwatch/logwatch.w776lI6g

Re: DB Connect error

Posted: Tue Jul 23, 2013 9:20 am
by slansing
When or where are you receiving this error, can you post an example? Until we have this information you can take a look at this thread as it is related:

http://support.nagios.com/forum/viewtop ... =16&t=8709

Re: DB Connect error

Posted: Tue Jul 23, 2013 9:22 am
by Frédéric GRANAT
Hi,
Error when trying to connect to Nagiosxi GUI.

Code: Select all

[root@nagiosxi ~]# service postgresql start
Starting postgresql service:                               [FAILED]
Rgds

Re: DB Connect error

Posted: Tue Jul 23, 2013 10:29 am
by lmiltchev
Try clearing some space by removing old log files, tmp files, etc.

Re: DB Connect error

Posted: Tue Jul 23, 2013 10:34 am
by Frédéric GRANAT
It seems that most of the space is occupied by /var/cache/logwatch
Is there a way to clean that directory.
Otherwise, please indicate which files/directories I could remove.

Frederic

Re: DB Connect error

Posted: Tue Jul 23, 2013 10:51 am
by lmiltchev
You can try:

Code: Select all

rm -rf /var/cache/logwatch/*
Then go to "/etc/logwatch/conf/logwatch.conf" and set "TmpDir" to "/tmp", so that the catch files would be automatically trimmed. If /etc/logwatch/conf/logwatch.conf is blank, you may need to copy the default file from /usr/share/logwatch/default.conf/logwatch.conf to /etc/logwatch/conf/logwatch.conf.

Hope this helps.

Re: DB Connect error

Posted: Wed Jul 24, 2013 1:58 am
by Frédéric GRANAT
Hi,
so that the catch files would be automatically trimmed
=> What do you mean

Apart from that : I cleaned logwatch and now nagiosxi is reachable.

Thanks

Re: DB Connect error

Posted: Wed Jul 24, 2013 9:37 am
by abrist
Frédéric GRANAT wrote:so that the catch files would be automatically trimmed
=> What do you mean
Files in /tmp are routinely trimmed (removed), especially if the root file system is running low on space.

Re: DB Connect error

Posted: Thu Jul 25, 2013 4:42 am
by Frédéric GRANAT
Hi,
Perfect, you can close the post.

Thank you very much.

Frederic