Fusion - Web Accounts Disabled

[P201420]

Log Level is Error
/usr/local/nagiosfusion/var/log
was not bad - cleaned where I could.

------
before I saw your reply i was able to remove enough to log in via web
-
I removed all my fused server but one. probably did not need to do that but...

I did go to admin guide and found
Truncate Polled Data
Location /usr/local/nagiosfusion/scripts/truncate_polled.php
Usage ./truncate_polled.php

Use this script to empty all of the polled data from all remote servers. USE WITH CAUTION. The data that is lost is not recoverable.
----
250GB is huge - I dont have that big of an environment
----------
[root@ny17u3030 scripts]# ./truncate_polled.php
polled tables truncated!
[root@ny17u3030 scripts]# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/centos-root 254798528 2812140 241222896 2% /
devtmpfs 16373960 0 16373960 0% /dev
tmpfs 16385796 0 16385796 0% /dev/shm
tmpfs 16385796 11932 16373864 1% /run
tmpfs 16385796 0 16385796 0% /sys/fs/cgroup
/dev/sda1 999320 201204 729304 22% /boot
tmpfs 3277160 0 3277160 0% /run/user/1000
tmpfs 3277160 0 3277160 0% /run/user/0
[root@ny17u3030 scripts]#
--------------------------------------
100% to 2% in seconds
------
are they any purging parameters I Can look at to avoid this in the future?

[bheden]

I think for us to know what's happening, we need to find whatever files are filling up. Your mariadb log looked like you have general logging and tracing enabled. Can I see the output of

Code: Select all

ls -alh /var/log/mariadb

And then, what I normally do to find suspicious files is:

Code: Select all

du -h --max-depth=1 /

Which gives something similar to the following output:

Code: Select all

6.5G	/usr
4.0K	/cdrom
243M	/opt
600M	/lib
4.0K	/srv
27G	/

And then I would find the largest of those (in this case /usr) and I would run the same du -h --max-depth=1 against that directory. And then all the way down until I find the one that is most full.

Finding this can help us identify the issue, I believe.

[P201420]

[root@ny17u3030 scripts]# ls -alh /var/log/mariadb
total 52K
drwxr-x---. 2 mysql mysql 4.0K Feb 14 2019 .
drwxr-xr-x. 11 root root 4.0K Oct 22 14:16 ..
-rw-r-----. 1 mysql mysql 38K Oct 22 14:16 mariadb.log
[root@ny17u3030 scripts]#


I will keep an eye on files as you suggest

thanks

[lmiltchev]

Let us know if you have any further questions or it is OK to close this topic. Thank you!

[P201420]

well -
is there anything wrong with doing the following on regular basis?

Truncate Polled Data
Location /usr/local/nagiosfusion/scripts/truncate_polled.php
Usage ./truncate_polled.php

[lmiltchev]

It shouldn't be a problem if you don't mind wiping off the logs once in a while.

[P201420]

Thanks

Good to close