VMware Cloud Community
escapem2
Enthusiast
Enthusiast

Monitor VDP usage using Nagios

hi guys

We monitor everything using Nagios.

So we have several VDP 5.5 and there is a tab named Reports where VDP indicates the backup usage and you know that when 80% or more VDP can get in troubles....

USage.png

Monitoring the filesystems /data01, /data02, /data03 won't accomplish the same....I already tried creating some correlation between the % reported in the Reports Tab and the df -h command space....but the thing is

when you delete Backups or when you reduce the retention policy, Reports Tab says % usage has decreased but I don't see that using the df  -h linux command

So my question is there a way to get that  % from Reports Tab anywhere in the VDP Appliance config files or something ?

thanks a lot

appliance.png

Reply
0 Kudos
1 Reply
LeslieBNS9
Enthusiast
Enthusiast

I think Nagios can do a PostGres SQL query. If so what you can do is open the Postgres database on the VDP server up and run this query...

SELECT MAX(utilization) as percentage FROM v_node_space WHERE date_time = (SELECT MAX(date_time) FROM v_node_space);

To open up the postgres database you'll need to do the following...

1. Enable Remote SSH Login (Optional, but it makes my life easier)

   

vi /etc/ssh/sshd_config

permitRootLogin yes <--- Line 142 change to yes

service sshd restart

2. Edit postgressql.conf

vi /data01/avamar/var/mc/server_data/postgres/data/postgresql.conf

listen_addresses='*' <--- uncomment line 56 and change localhost to *

vi /data01/avamar/var/mc/server_data/postgres/data/pg_hba.conf

host        all        all        0.0.0.0/0        trust <-- comment out line 69 and add a new line with this

3. Edit the firewall.base

vi /etc/firewall.base

# enable remote access to postgress db service

# add these lines to the bottom of the firewall.base file

iptables -I INPUT 1 -p tcp --dport 5555 -j ACCEPT

iptables -I INPUT 1 -p tcp --dport 5558 -j ACCEPT

4. Reboot the VDP appliance

5. You can now run the following query to find any backups that failed.

Postgres Username: viewuser

Postgres Password: viewuser

Database: mcdb

Query: SELECT MAX(utilization) as percentage FROM v_node_space WHERE date_time = (SELECT MAX(date_time) FROM v_node_space);