[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DECmcc user notes file. Does not replace IPMT. |
| Notice: | Use IPMT for problems. Newsletter location in note 6187 |
| Moderator: | TAEC::BEROUD |
|
| Created: | Mon Aug 21 1989 |
| Last Modified: | Wed Jun 04 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 6497 |
| Total number of notes: | 27359 |
5218.0. "Problems EXPORTing SNMP with mib extentions" by GADWAL::WOESTEMEYER (Why??...Why not!!!) Thu Jun 17 1993 13:01
Attached is a duplication of a customer problem/complaint concerning
exporting of SNMP vendor mib attributes. It appears to work from the
EXPORT command, but then exporting cannot be shown, deleted, or modified.
Using SQL on the RDB database would seem to indicate that no entity data
was exported.
The customer is getting annsey(sp?) about this as he wants to export
this type of data. I suspect the problem is due to the lenght of the
entity name but would like verification for my peace of mind. The customer
wants an elevation and does not feel an SPR is of a high enough priority.
Any in sites welcomed,
Steve
PS. DECmcc V1.3, EXP_FDDI mib compiled, DECconcentrator 500 V3.2.1
---------------------------------------------------------------------------
FTEST> submit/noti/noprint/keep/que=mcc$batch/params=(sys$login:fddi.rdb,60) -
_FTEST> sys$manager:mcc_exporter_background
Job MCC_EXPORTER_BACKGROUND (queue MCC$BATCH, entry 384) started on MCC$BATCH
FTEST> sh que/all/full mcc$batch
Batch queue MCC$BATCH, on KEROON::
/BASE_PRIORITY=4 /JOB_LIMIT=4 /OWNER=[SYSTEM] /PROTECTION=(S:E,O:D,G:R,W:W)
Jobname Username Entry Status
------- -------- ----- ------
MCC_EXPORTER_BACKGROUND
WOESTEMEYER 384 Executing
Submitted 17-JUN-1993 06:52 /KEEP /NOTIFY /PARAM=("SYS$LOGIN:FDDI.RDB","60")
/NOPRINT /PRIORITY=100
File: _KEROON$DKB100:[SYSCOMMON.SYSMGR]MCC_EXPORTER_BACKGROUND.COM;11
MCC> export snmp dc500-1 fddi snmpfddiport snmpfddiporttable (1,1) -
_MCC> end time=17-jun-1993:12:00,-
_MCC> export period = 00:30,-
_MCC> export target= sys$login:fddi.rdb
SNMP dc500-1 fddi snmpFddiPORT snmpFddiPORTTable (1,1)
AT 17-JUN-1993 06:59:18
Exporting started
MCC> sh export snmp dc500-1 fddi snmpfddiport snmpfddiporttable (1,1) -
_MCC> export target sys$login:fddi.rdb
SNMP dc500-1 fddi snmpFddiPORT snmpFddiPORTTable (1,1)
AT 17-JUN-1993 07:14:42
No exporting for the specified entity
MCC>
!!! run sql to see what we have
SQL> sho table
User tables in schema with filename sys$login:fddi.rdb
MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI
SQL> sh table MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI
Columns for table MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI:
Column Name Data Type Domain
----------- --------- ------
SNMP CHAR(255)
TIME_STAMP DATE
MCC_EXPORT_SEQUENCE CHAR(132)
MCC_EXPORT_SEQUENCE_NUMBER QUADWORD
MCC_EXPORT_POLL_STATUS QUADWORD
EXP_EXPORT_TIME DATE
TIME_IDENTIFIERS DATE
EXP_CVR_IDENTIFIERS QUADWORD
EXP_CVR1_IDENTIFIERS QUADWORD
TIME_STATUS DATE
EXP_CVR_STATUS QUADWORD
EXP_CVR1_STATUS QUADWORD
SNMPFDDIPORTPCMSTATE QUADWORD
SNMPFDDIPORTCONNECTSTATE QUADWORD
SNMPFDDIPORTCESTATE QUADWORD
TIME_COUNTERS DATE
EXP_CVR_COUNTERS QUADWORD
EXP_CVR1_COUNTERS QUADWORD
SNMPFDDIPORTLEMCTS QUADWORD
SNMPFDDIPORTLEMREJECTCTS QUADWORD
SNMPFDDIPORTLCTFAILCTS QUADWORD
COUNTERCREATIONTIME DATE
TIME_CHARACTERISTICS DATE
EXP_CVR_CHARACTERISTICS QUADWORD
EXP_CVR1_CHARACTERISTICS QUADWORD
SNMPFDDIPORTACTION QUADWORD
SNMPFDDIPORTCHIPSET CHAR(132)
SNMPFDDIPORTLERCONDITION QUADWORD
SNMPFDDIPORTPCWITHHOLD QUADWORD
SNMPFDDIPORTLERALARM INTEGER
SNMPFDDIPORTLERCUTOFF INTEGER
SNMPFDDIPORTLERESTIMATE INTEGER
SNMPFDDIPORTBSFLAG QUADWORD
SNMPFDDIPORTTBMAX QUADWORD
SNMPFDDIPORTMACLOOPTIME QUADWORD
SNMPFDDIPORTAVAILABLEPATHS INTEGER
SNMPFDDIPORTMACPLACEMENT QUADWORD
SNMPFDDIPORTPATHSREQUESTED INTEGER
SNMPFDDIPORTREMOTEMACINDICATED QUADWORD
SNMPFDDIPORTCONNECTIONPOLICIES INTEGER
SNMPFDDIPORTPCNEIGHBOR QUADWORD
SNMPFDDIPORTPCTYPE QUADWORD
SNMPFDDIPORTINDEX INTEGER
SNMPFDDIPORTSMTINDEX INTEGER
Table constraints for MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI:
No constraints found
Constraints referencing table MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI:
No constraints found
Indexes on table MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI:
No indexes found
Storage Map for table MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI:
No Storage Map found
Triggers on table MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI:
No triggers found
SQL> select snmp from MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI;
SNMP
dc500-1
>>
>>
>>
dc500-1
>>
>>
>>
2 rows selected
SQL> select time_stamp from MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI;
TIME_STAMP
17-JUN-1993 06:59:42.05
17-JUN-1993 07:29:37.26
2 rows selected
!!! the only none null values in the RDB file are
!!! SNMP
!!! TIME_STAMP
!!! MCC_EXPORT_SEQUENCE
!!! MCC_EXPORT_SEQUENCE_NUMBER
!!! MCC_EXPORT_POLL_STATUS
!!! TIME_IDENTIFIERS
!!! EXP_CVR_IDENTIFIERS
!!! EXP_CVR1_IDENTIFIERS
!!! the following example is an attempt to extract data via SQL for a
!!!particular attribute, snmpFddiPORTMACLoopTime, NULL is returned. Yet MCC
!!!Shows for the same attribute return valid information.
SQL> select snmpFddiPORTMACLoopTime from MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI;
SNMPFDDIPORTMACLOOPTIME
NULL
NULL
2 rows selected
MCC> sh snmp dc500-1 fddi snmpfddiport snmpfddiporttable (1,1) snmpFddiPORTMACLo
opTime
SNMP dc500-1 fddi snmpFddiPORT snmpFddiPORTTable (1,1)
AT 17-JUN-1993 08:27:24 Characteristics
snmpFddiPORTMACLoopTime = 2500000
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 5218.1 | try a full name | TOOK::SHMUYLOVICH | | Thu Jun 17 1993 19:20 | 36 |
|
Steve,
First of all, thanks for complete information of the problem. It helps a
lot. I think that your customer has two problems:
1. He/she is not able to do Show Export ( and all others Export commands);
2. RDB does not have data.
The first problem could be due to the inconsistency in the way how SNMP AM
returns out_entity in the SHOW ... All Ident and DIRECTORY commands.
The second one requires more detailed analyzes.
Unfortunately I'm out until next Monday.
What you can do now is to try the following:
1. Use the full name in the Export directive.
It should fix at least the first problem.
2. If it does not fix the problem #1 or it fixes #1 but does not fix #2,
please, provide the values for the following columns from RDB:
- MCC_EXPORT_POLL_STATUS
- EXP_CVR_IDENTIFIERS
- EXP_CVR1_IDENTIFIERS
3. The last question: What data type is used for snmpfddiporttable
identifier?
P.S. If full name does not fix the problem or it does but you would like
to have more explanations, please, wait until next week.
|
| 5218.2 | Full name does not help | GADWAL::WOESTEMEYER | Why??...Why not!!! | Mon Jun 21 1993 11:13 | 152 |
| Alex,
I was gone Friday myself. Anyway he it the info you wanted. I did not have
to bother the customer as I have no problem duplicating it.
Steve
--------------------------------------------------------------------------
>>>> 1) Exporting with full name still will not allow shows/modifies/deletes
show snmp dc500-1 all attri
!
!SNMP dc500-1
!AT 21-JUN-1993 07:52:06 All Attributes
!
! Address = 16.63.16.252
! Name = DC500-1
! Registered Name = KEROON_NS:.DC500-1
! ipReachability = up
! sysUpTime = 172756400
! CounterCreationTime = 1-JUN-1993 07:59:25.53
! sysDescr = "DECconcentrator 500, DEFCN 3.2"
! sysObjectID = "1.3.6.1.4.1.36.2.15.5.1"
! sysContact = -- Attribute Not Available
! sysName = -- Attribute Not Available
! sysLocation = -- Attribute Not Available
! sysServices = 9
! ifNumber = 1
! Read Community Name = ""
! Write Community Name = ""
! Location = -- Attribute Not Available
! Implementation Desc = -- Attribute Not Available
! Responsible Person = -- Attribute Not Available
! Phone Number = -- Attribute Not Available
! MAIL Account = -- Attribute Not Available
! Remarks = -- Attribute Not Available
! Text File = -- Attribute Not Available
!
!
!
export snmp DC500-1 fddi snmpfddiport snmpfddiporttable (1,1) end time=21-jun-1993:12:00,export period=00:30:00,export target=sys$login:fddi.rdb
!
!SNMP DC500-1 fddi snmpFddiPORT snmpFddiPORTTable (1,1)
!AT 21-JUN-1993 07:55:18
!
!Exporting started
!
!
show export snmp DC500-1 fddi snmpfddiport snmpfddiporttable (1,1) export target=sys$login:fddi.rdb
!
!SNMP DC500-1 fddi snmpFddiPORT snmpFddiPORTTable (1,1)
!AT 21-JUN-1993 07:56:57
!
!No exporting for the specified entity
!
>>>> 2) Requested Attributes from RDB
SQL> select mcc_export_poll_status, exp_cvr_identifiers,exp_cvr1_identifiers fro
m MCC_SNMP_FDDI_SNMPFDDI_SNMPFDDI;
MCC_EXPORT_POLL_STATUS EXP_CVR_IDENTIFIERS EXP_CVR1_IDENTIFIERS
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
1 1 1
10 rows selected
>>>> 3) Data type for snmpfddiporttable. Not really sure what you wanted
show dumped it all.
DAP> sho class snmp subclass fddi subclass snmpfddiport subclass snmpfddiporttab
le
Class (1) : SNMP
Subclass (2) : FDDI
Subclass (2) : SNMPFDDIPORT
-------> Subclass (2) : SNMPFDDIPORTTABLE
Definition (3) : PRESENTATION_NAME
Definition (3) : INSTANCE_REQUIRED
Definition (3) : DYNAMIC
Definition (3) : INSTANCE_DATATYPE
Attribute (5) : SNMPFDDIPORTSMTINDEX 1
Attribute (5) : SNMPFDDIPORTINDEX 2
Attribute (5) : SNMPFDDIPORTPCTYPE 3
Attribute (5) : SNMPFDDIPORTPCNEIGHBOR 4
Attribute (5) : SNMPFDDIPORTCONNECTIONPOLICIES 5
Attribute (5) : SNMPFDDIPORTREMOTEMACINDICATED 6
Attribute (5) : SNMPFDDIPORTCESTATE 7
Attribute (5) : SNMPFDDIPORTPATHSREQUESTED 8
Attribute (5) : SNMPFDDIPORTMACPLACEMENT 9
Attribute (5) : SNMPFDDIPORTAVAILABLEPATHS 10
Attribute (5) : SNMPFDDIPORTMACLOOPTIME 11
Attribute (5) : SNMPFDDIPORTTBMAX 12
Attribute (5) : SNMPFDDIPORTBSFLAG 13
Attribute (5) : SNMPFDDIPORTLCTFAILCTS 14
Attribute (5) : SNMPFDDIPORTLERESTIMATE 15
Attribute (5) : SNMPFDDIPORTLEMREJECTCTS 16
Attribute (5) : SNMPFDDIPORTLEMCTS 17
Attribute (5) : SNMPFDDIPORTLERCUTOFF 18
Attribute (5) : SNMPFDDIPORTLERALARM 19
Attribute (5) : SNMPFDDIPORTCONNECTSTATE 20
Attribute (5) : SNMPFDDIPORTPCMSTATE 21
Attribute (5) : SNMPFDDIPORTPCWITHHOLD 22
Attribute (5) : SNMPFDDIPORTLERCONDITION 23
Attribute (5) : SNMPFDDIPORTCHIPSET 24
Attribute (5) : SNMPFDDIPORTACTION 25
Attribute (5) : SNMPFDDIPORTTABLE_INDEX 26
Attribute (5) : COUNTERCREATIONTIME 65
Directive (6) : SHOW 1
Directive (6) : SET 2
Directive (6) : DIRECTORY 26
Directive (6) : REGISTER 29
Directive (6) : DEREGISTER 30
Directive (6) : ERASE 33
Attribute_Partition (11) : IDENTIFIERS 1
Attribute_Partition (11) : STATUS 2
Attribute_Partition (11) : COUNTERS 3
Attribute_Partition (11) : CHARACTERISTICS 4
DAP> sho Attribute_Partition IDENTIFIERS
Class (1) : SNMP
Subclass (2) : FDDI
Subclass (2) : SNMPFDDIPORT
Subclass (2) : SNMPFDDIPORTTABLE
---------> Attribute_Partition (11) : IDENTIFIERS
Definition (3) : PRESENTATION_NAME
Definition (3) : ATTRIBUTE_LIST
Definition (3) : ACCESS
DAP> show Definition PRESENTATION_NAME
Definition Name = PRESENTATION_NAME
Type = T Length = 11 Count = 1 Defined = TRUE Class = S
value[1] = "Identifiers"
DAP> show Definition ATTRIBUTE_LIST
Definition Name = ATTRIBUTE_LIST
Type = L Length = 4 Count = 1 Defined = TRUE Class = S
value[1] = 26
DAP> show Definition ACCESS
Definition Name = ACCESS
Type = BU Length = 1 Count = 1 Defined = TRUE Class = S
value[1] = 1
|
| 5218.3 | | TOOK::SHMUYLOVICH | | Tue Jun 22 1993 12:06 | 37 |
|
Steve,
Full name for your snmp is "KEROON_NS:.DC500-1" not dc500-1.
I still need more info from you. Please, do the following:
1. "show export snmp DKEROON_NS:.DC500-1 ...."
2. "show export snmp 16.63.16.252 ...".
3. If none of the above works, please , do
"export snmp DKEROON_NS:.DC500-1 ...."
and repeat #1 and #2.
4. "directory snmp DKEROON_NS:.DC500-1"
5. "directory snmp dc500-1"
6. "show snmp dc500-1 fddi snmpfddiport snmpfddiporttable (1,1) all attr"
7. please, provide the values for the following columns from RDB:
- EXP_CVR_STATUS;
- EXP_CVR1_STATUS;
- EXP_CVR_COUNTERS;
- EXP_CVR1_COUNTERS;
- EXP_CVR_CHARACTERISTICS;
- EXP_CVR1_CHARACTERISTICS.
You can send the result to me (TOOK::SHMUYLOVICH). In this case it
will be faster.
Sam
|
| 5218.4 | Solution???? | NMOSPD::SYSTEM | | Fri Mar 04 1994 10:02 | 7 |
|
Hi (Ciao!) There was one solution to this problem?
I'm supporting one customer with the same problem.
Many thanks in advance!
Andrea.
|