[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 ~]$ |