Thread: Nice, web-based SNMP-Frontend for pgsnmpd?
Hi I've just stumbled across pgsnmpd. It works quite well, though I haven't yet found a web-based monitoring software that works well with pgsnmpd. The problem is that pgsnmpd exportsa bunch of values _per_ database. (The output of snmpwalk looks something like PGSQL-MIB::pgsqlDbDatabase.1.1.3 = STRING: "postgres" PGSQL-MIB::pgsqlDbDatabase.1.1.4 = STRING: "template0" PGSQL-MIB::pgsqlDbDatabase.1.1.5 = STRING: "template1" PGSQL-MIB::pgsqlDbDatabase.1.2.3 = STRING: "postgres" PGSQL-MIB::pgsqlDbDatabase.1.2.4 = STRING: "postgres" PGSQL-MIB::pgsqlDbDatabase.1.2.5 = STRING: "postgres" PGSQL-MIB::pgsqlDbDatabase.1.3.3 = STRING: "UTF8" PGSQL-MIB::pgsqlDbDatabase.1.3.4 = STRING: "UTF8" PGSQL-MIB::pgsqlDbDatabase.1.3.5 = STRING: "UTF8" PGSQL-MIB::pgsqlDbDatabase.1.4.3 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.4.4 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.4.5 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.5.3 = INTEGER: 21263 PGSQL-MIB::pgsqlDbDatabase.1.5.4 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.5.5 = INTEGER: 17043 PGSQL-MIB::pgsqlDbDatabase.1.6.3 = INTEGER: 976 PGSQL-MIB::pgsqlDbDatabase.1.6.4 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.6.5 = INTEGER: 4 PGSQL-MIB::pgsqlDbDatabase.1.7.3 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.7.4 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.7.5 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.8.3 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.8.4 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.8.5 = INTEGER: 0 PGSQL-MIB::pgsqlDbDatabase.1.9.3 = STRING: "3720 kB" PGSQL-MIB::pgsqlDbDatabase.1.9.4 = STRING: "3760 kB" PGSQL-MIB::pgsqlDbDatabase.1.9.5 = STRING: "3720 kB" ) Most SNMP monitoring tools (like netmrg) allow you to define graphs for custom oid - but they don't allow me to say "Create a graph for every oid that matches a certain pattern". Therefor, I'd need to manually create one graph per database, which is tiresome... So - does anyone know a good webapplication that does snmp graphs? greetings, Florian Pflug
> I've just stumbled across pgsnmpd. It works quite well, > though I haven't yet found a web-based monitoring > software that works well with pgsnmpd. The problem is > that pgsnmpd exportsa bunch of values _per_ database. > > (The output of snmpwalk looks something like > PGSQL-MIB::pgsqlDbDatabase.1.1.3 = STRING: "postgres" > PGSQL-MIB::pgsqlDbDatabase.1.1.4 = STRING: "template0" .... > ) > > Most SNMP monitoring tools (like netmrg) allow you to > define graphs for custom oid - but they don't allow me > to say "Create a graph for every oid that matches a > certain pattern". Therefor, I'd need to manually create > one graph per database, which is tiresome... > > So - does anyone know a good webapplication that does > snmp graphs? cacti should let you do it. I've not done it myself, but when you tell it to graph disk space it let's you pick from all the partitions available. I just hooked it up with litespeed web server and it does the same thing letting me graph each of the configured virtual hosts. In both cases the scripts/templates were built by someone else so I don't can't tell you how to do it, but it can be done. -philip
Philip Hallstrom wrote: >> I've just stumbled across pgsnmpd. It works quite well, >> though I haven't yet found a web-based monitoring >> software that works well with pgsnmpd. The problem is >> that pgsnmpd exportsa bunch of values _per_ database. >> >> (The output of snmpwalk looks something like >> PGSQL-MIB::pgsqlDbDatabase.1.1.3 = STRING: "postgres" >> PGSQL-MIB::pgsqlDbDatabase.1.1.4 = STRING: "template0" > .... >> ) >> >> Most SNMP monitoring tools (like netmrg) allow you to >> define graphs for custom oid - but they don't allow me >> to say "Create a graph for every oid that matches a >> certain pattern". Therefor, I'd need to manually create >> one graph per database, which is tiresome... >> >> So - does anyone know a good webapplication that does >> snmp graphs? > > cacti should let you do it. I've not done it myself, but when you tell > it to graph disk space it let's you pick from all the partitions > available. I just hooked it up with litespeed web server and it does the > same thing letting me graph each of the configured virtual hosts. In > both cases the scripts/templates were built by someone else so I don't > can't tell you how to do it, but it can be done. I've stumbled over this myself minutes before I received your mail ;-) So far it looks good (certainly much better than netmrg), and it seems as if it at least support what I want semi-automatically. Still, I'd prefer a solution where new databases show up automatically - I'll see if I can get cacti to do that somehow. Thanks for the tip! greetings, Florian Pflug