Apache Java RADIUS and RDBMS MIB

Started by Sumit Pandya, December 13, 2010, 03:34:51 PM

Previous topic - Next topic

Sumit Pandya

Find the attached archive containing MIB for well known agents viz Apache, JVM, RDBMS (Oracle, PostgreSQL, Informix, ...), and Remote Access Dial-In User Service.

A JVM exposes SNMP Agent just by adding "-Dcom.sun.management.snmp.port=9004 " to its command line. Ref http://download.oracle.com/javase/1.5.0/docs/guide/management/SNMP.html  This can be useful to monitor popular Tomcat, JBoss, WebLogic etc servers

An exhaustive Oracle guide for various MIBs (including attached public RDBMS-mib) provided on http://download.oracle.com/docs/html/A96672_01/toc.htm
PostgreSQL implements RDBMS-mib via "pgsnmpd" Ref http://pgfoundry.org/projects/pgsnmpd

Additionally you should also look to http://mod-apache-snmp.sourceforge.net/ for any missing part of attached Apache2 MIB.

RADIUS is IETF governed protocol. Attached 6 MIBs are from RFC 4668 to 4673

Default Ms SQLServer support could be good value addition into NetXMS. MIB Ref https://support.ipmonitor.com/mibs/MSSQLSERVER-MIB/raw.aspx

Victor Kirhenshtein

I have added these MIBs to standard MIB collection in NetXMS. There was few changes. Also, APACHE2-MIB cannot be compiled by current version of MIB compiler because of a bug. I have fixed this bug for 1.0.9.

Best regards,
Victor

shivpremani

Hi Victor,
We are trying to compile APACHE2-MIB on CentOS. Can we get NetXMS 1.0.9 server, as we couldn't find it on netxms.org.
Thanks
Shiv

Victor Kirhenshtein

Hi!

1.0.9 is not released yet. I'll publish it in a few days.

Best regards,
Victor

Sumit Pandya

#4
Dear All,
    I confess my mistake of immature analysis on Apache statics gathering. The mod-apache-snmp module, mentioned into originating thread, is having very poor architecture and now completely dead even. Further Apache has build-in status_module which shows performance over HTTP request.
    I came across many of web application which are having ability to generate statistics over HTTP request. This experience triggered me for a NetXMS HTTP DCI feature request. In my experience web-applications send statistics in either of below 2 methodologies
    1. Using HTTP X-Headers
    2. Sending statistics summary into response page
    In both the method, general practice is to send Statistical-Item: Value format. Apache status_module http://httpd.apache.org/docs/2.0/mod/mod_status.html ; uses 2nd approach and can be seen with URL http://www.example.com/server-status?auto

Requesting owner (Victor) to see how HTTP DCI can be made part of NetXMS. AFAIK, NetXMS HTTP Server is there so writing a client would be trivial for experts. Only brainstorming is accommodating HTTP parser for data extraction.
Same way of working is seen into Nginx (2nd widely used Open source Web Server) http://wiki.nginx.org/HttpStubStatusModule and Lighttpd (most popular HTTP for tiny devices) http://redmine.lighttpd.net/wiki/1/Docs:ModStatus

I'm leaveing analysis of IIS (2nd widely used WebServer Ref http://trends.builtwith.com/Web-Server/IIS-6) upto contributors. It seems that Microsoft provide some System Monitor (former Performance Monitor) tool ref http://technet.microsoft.com/en-us/library/bb727100.aspx and SNMP interface  as well Ref http://technet.microsoft.com/en-us/library/cc783841(WS.10).aspx