Using SNMP with a Greenplum Database System
Post date: Oct 10, 2014 12:14:17 AM
[root@sachi gpadmin]# rpm -qa|grep net-snmp
net-snmp-5.5-49.0.2.el6_5.4.x86_64
net-snmp-libs-5.5-49.0.2.el6_5.4.x86_64
[root@sachi gpadmin]#
[root@sachi ~]# rpm -qa|grep net-snmp-utils
[root@sachi ~]# yum install net-snmp-utils
Loaded plugins: refresh-packagekit
adobe-linux-i386 | 951 B 00:00
adobe-linux-x86_64 | 951 B 00:00
chromium-el6 | 1.9 kB 00:00
google-chrome | 951 B 00:00
google-chrome/primary | 1.9 kB 00:00
google-chrome 3/3
google-chrome-32bit | 951 B 00:00
google-chrome-32bit/primary | 1.9 kB 00:00
google-chrome-32bit 3/3
google-chrome-64bit | 951 B 00:00
google-chrome-64bit/primary | 1.9 kB 00:00
google-chrome-64bit 3/3
gphd-admin-localrepo | 2.9 kB 00:00 ...
public_ol6_UEK_base | 1.2 kB 00:00
public_ol6_UEK_latest | 1.2 kB 00:00
public_ol6_latest | 1.4 kB 00:00
public_ol6_latest/primary | 41 MB 00:04
public_ol6_latest 26210/26210
rpmforge | 1.9 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package net-snmp-utils.x86_64 1:5.5-49.0.2.el6_5.4 will be installed
--> Processing Dependency: net-snmp-libs = 1:5.5-49.0.2.el6_5.4 for package: 1:net-snmp-utils-5.5-49.0.2.el6_5.4.x86_64
--> Running transaction check
---> Package net-snmp-libs.x86_64 1:5.5-49.0.1.el6 will be updated
--> Processing Dependency: net-snmp-libs = 1:5.5-49.0.1.el6 for package: 1:net-snmp-5.5-49.0.1.el6.x86_64
---> Package net-snmp-libs.x86_64 1:5.5-49.0.2.el6_5.4 will be an update
--> Running transaction check
---> Package net-snmp.x86_64 1:5.5-49.0.1.el6 will be updated
---> Package net-snmp.x86_64 1:5.5-49.0.2.el6_5.4 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
net-snmp-utils x86_64 1:5.5-49.0.2.el6_5.4 public_ol6_latest 174 k
Updating for dependencies:
net-snmp x86_64 1:5.5-49.0.2.el6_5.4 public_ol6_latest 306 k
net-snmp-libs x86_64 1:5.5-49.0.2.el6_5.4 public_ol6_latest 1.5 M
Transaction Summary
================================================================================
Install 1 Package(s)
Upgrade 2 Package(s)
Total download size: 2.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): net-snmp-5.5-49.0.2.el6_5.4.x86_64.rpm | 306 kB 00:00
(2/3): net-snmp-libs-5.5-49.0.2.el6_5.4.x86_64.rpm | 1.5 MB 00:00
(3/3): net-snmp-utils-5.5-49.0.2.el6_5.4.x86_64.rpm | 174 kB 00:00
--------------------------------------------------------------------------------
Total 2.1 MB/s | 2.0 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : 1:net-snmp-libs-5.5-49.0.2.el6_5.4.x86_64 1/5
/sbin/ldconfig: libraries libstdc++.so.6 and libstdc++.so.6.0.13 in directory /usr/lib have same soname but different type.
/sbin/ldconfig: /usr/lib/libstdc++.so.6 is not a symbolic link
Installing : 1:net-snmp-utils-5.5-49.0.2.el6_5.4.x86_64 2/5
Updating : 1:net-snmp-5.5-49.0.2.el6_5.4.x86_64 3/5
Cleanup : 1:net-snmp-5.5-49.0.1.el6.x86_64 4/5
Cleanup : 1:net-snmp-libs-5.5-49.0.1.el6.x86_64 5/5
Verifying : 1:net-snmp-libs-5.5-49.0.2.el6_5.4.x86_64 1/5
Verifying : 1:net-snmp-utils-5.5-49.0.2.el6_5.4.x86_64 2/5
Verifying : 1:net-snmp-5.5-49.0.2.el6_5.4.x86_64 3/5
Verifying : 1:net-snmp-libs-5.5-49.0.1.el6.x86_64 4/5
Verifying : 1:net-snmp-5.5-49.0.1.el6.x86_64 5/5
Installed:
net-snmp-utils.x86_64 1:5.5-49.0.2.el6_5.4
Dependency Updated:
net-snmp.x86_64 1:5.5-49.0.2.el6_5.4
net-snmp-libs.x86_64 1:5.5-49.0.2.el6_5.4
Complete!
[root@sachi ~]#
[root@sachi gpadmin]# rpm -qa|grep net-snmp
net-snmp-utils-5.5-49.0.2.el6_5.4.x86_64
net-snmp-5.5-49.0.2.el6_5.4.x86_64
net-snmp-libs-5.5-49.0.2.el6_5.4.x86_64
[root@sachi gpadmin]#
[root@sachi ~]# snmpwalk
No hostname specified.
USAGE: snmpwalk [OPTIONS] AGENT [OID]
Version: 5.5
Web: http://www.net-snmp.org/
Email: net-snmp-coders@lists.sourceforge.net
OPTIONS:
-h, --help display this help message
-H display configuration file directives understood
-v 1|2c|3 specifies SNMP version to use
-V, --version display package version number
SNMP Version 1 or 2c specific
-c COMMUNITY set the community string
SNMP Version 3 specific
-a PROTOCOL set authentication protocol (MD5|SHA)
-A PASSPHRASE set authentication protocol pass phrase
-e ENGINE-ID set security engine ID (e.g. 800000020109840301)
-E ENGINE-ID set context engine ID (e.g. 800000020109840301)
-l LEVEL set security level (noAuthNoPriv|authNoPriv|authPriv)
-n CONTEXT set context name (e.g. bridge1)
-u USER-NAME set security name (e.g. bert)
-x PROTOCOL set privacy protocol (DES|AES)
-X PASSPHRASE set privacy protocol pass phrase
-Z BOOTS,TIME set destination engine boots/time
General communication options
-r RETRIES set the number of retries
-t TIMEOUT set the request timeout (in seconds)
Debugging
-d dump input/output packets in hexadecimal
-D TOKEN[,...] turn on debugging output for the specified TOKENs
(ALL gives extremely verbose debugging output)
General options
-m MIB[:...] load given list of MIBs (ALL loads everything)
-M DIR[:...] look in given list of directories for MIBs
-P MIBOPTS Toggle various defaults controlling MIB parsing:
u: allow the use of underlines in MIB symbols
c: disallow the use of "--" to terminate comments
d: save the DESCRIPTIONs of the MIB objects
e: disable errors when MIB symbols conflict
w: enable warnings when MIB symbols conflict
W: enable detailed warnings when MIB symbols conflict
R: replace MIB symbols from latest module
-O OUTOPTS Toggle various defaults controlling output display:
0: print leading 0 for single-digit hex characters
a: print all strings in ascii format
b: do not break OID indexes down
e: print enums numerically
E: escape quotes in string indices
f: print full OIDs on output
n: print OIDs numerically
q: quick print for easier parsing
Q: quick print with equal-signs
s: print only last symbolic element of OID
S: print MIB module-id plus last element
t: print timeticks unparsed as numeric integers
T: print human-readable text along with hex strings
u: print OIDs using UCD-style prefix suppression
U: don't print units
v: print values only (not OID = value)
x: print all strings in hex format
X: extended index format
-I INOPTS Toggle various defaults controlling input parsing:
b: do best/regex matching to find a MIB node
h: don't apply DISPLAY-HINTs
r: do not check values for range/type legality
R: do random access to OID labels
u: top-level OIDs must have '.' prefix (UCD-style)
s SUFFIX: Append all textual OIDs with SUFFIX before parsing
S PREFIX: Prepend all textual OIDs with PREFIX before parsing
-L LOGOPTS Toggle various defaults controlling logging:
e: log to standard error
o: log to standard output
n: don't log at all
f file: log to the specified file
s facility: log to syslog (via the specified facility)
(variants)
[EON] pri: log to standard error, output or /dev/null for level 'pri' and above
[EON] p1-p2: log to standard error, output or /dev/null for levels 'p1' to 'p2'
[FS] pri token: log to file/syslog for level 'pri' and above
[FS] p1-p2 token: log to file/syslog for levels 'p1' to 'p2'
-C APPOPTS Set various application specific behaviours:
p: print the number of variables found
i: include given OID in the search range
I: don't include the given OID, even if no results are returned
c: do not check returned OIDs are increasing
t: Display wall-clock time to complete the request
E {OID}: End the walk at the specified OID
[root@sachi ~]# service snmpd status
snmpd (pid 26678) is running...
[root@sachi ~]# snmpwalk -v 1 -c public localhost .1.3.6.1.2.1.1.1.0
SNMPv2-MIB::sysDescr.0 = STRING: Linux sachi 2.6.32-100.34.1.el6uek.x86_64 #1 SMP Wed May 25 17:46:45 EDT 2011 x86_64
[root@sachi ~]#
[20:05 sachi@sachi ~] > su
Password:
[root@sachi sachi]# source $GPHOME/greenplum_path.sh
bash: /greenplum_path.sh: No such file or directory
[root@sachi sachi]# export GPHOME=/usr/local/greenplum-db/
[root@sachi sachi]# source $GPHOME/greenplum_path.sh
[root@sachi sachi]# ls -l /usr/share/snmp/mibs
[root@sachi sachi]# cp $GPHOME/share/postgresql/NETWORK-SERVICES-MIB.txt /usr/share/snmp/mibs
cp: overwrite `/usr/share/snmp/mibs/NETWORK-SERVICES-MIB.txt'? y
[root@sachi sachi]# cp $GPHOME/share/postgresql/GPDB-MIB.txt /usr/share/snmp/mibs
[root@sachi sachi]# cp $GPHOME/share/postgresql/RDBMS-MIB.txt /usr/share/snmp/mibs
[root@sachi sachi]# vi /etc/snmp/snmpd.conf
add line
master agentx
[21:49 sachi@sachi ~] > su - gpadmin
Password:
[gpadmin@sachi ~]$ psql -d postgres -f $GPHOME/share/postgresql/gpsnmpd.sql
psql:/usr/local/greenplum-db/./share/postgresql/gpsnmpd.sql:6: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "gpsnmpd_rdbmsdbtable_pkey" for table "gpsnmpd_rdbmsdbtable"
CREATE TABLE
psql:/usr/local/greenplum-db/./share/postgresql/gpsnmpd.sql:11: NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'vendor_name' as the Greenplum Database data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
[gpadmin@sachi ~]$