Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - hmjvaline

#1
I'm sorry. I found that some interface names appear unknown not because of the hook script but because there is no appropriate snmp mib and agent installation. If the interface is only obtained through icmp and arp, it seems that only the unknown name can be obtained.
#2
In the attached file, I have attached normal and abnormal screenshots.

the normal interface display after I remove the script.

I only use the simplest snmp polling and agent. Before adding this script to the hook, 
interface name and description was normal without using any regular expressions.


#3
i use netxms server 4.4.2
after hook::CreateInterface add below script ,interface name and descript become unknown. why? 

if ($1->name ~= "(?i).*Teredo.*|.*isatap.*|.*Loopback.*|.*Bluetooth.*|Local Area Connection\* 12|Local Area Connection\* 11|Local Area Connection\* 9|Local Area Connection\* 8|Local Area Connection\* 2|6TO4 Adapter|sit0") {
  return false;
} else {
  return true;
}
#4
I use the latest windows X64 version of netxms 2.2.17 with the Microsoft sql server database.
I found that when using a string mixed with one-byte word and two-byte word to store the database,
the calculation length error will occur, causing the string to be Truncated.
I suspect that it may be that ms sql calculates the character length for varchar in a different way than other databases.
Nvarchar will treat both one-byte word and the two-byte word as one character, but the varchar data type will treat the ASCII word of one-byte  as a character, but the two-character word will be treated as two characters.

Is there any possibility to solve this problem?

Attached below is the SQL query I fetched using SQL PROFILER, select @p1 actully is stored = 'Sw-209-dlink總務' not 'Sw-209-dlink總務處',because the p1 is varchar(16)

declare @p1 int
set @p1=6981
exec sp_prepexec @p1 output,N'@P1 varchar(16),@P2 int,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int,@P8 int,@P9 int,@P10 varchar(9),@P11 int,@P12 varchar(9),@P13 varchar(1),@P14 int,@P15 int,@P16 varchar(9),@P17 varchar(9),@P18 int,@P19 int,@P20 varchar(37),@P21 varchar(37),@P22 int,@P23 varchar(1),@P24 varchar(1),@P25 varchar(1),@P26 varchar(1),@P27 bigint,@P28 int,@P29 int',N'UPDATE object_properties SET name=@P1,status=@P2,is_deleted=@P3,inherit_access_rights=@P4,last_modified=@P5,status_calc_alg=@P6,status_prop_alg=@P7,status_fixed_val=@P8,status_shift=@P9,status_translation=@P10,status_single_threshold=@P11,status_thresholds=@P12,comments=@P13,is_system=@P14,location_type=@P15,latitude=@P16,longitude=@P17,location_accuracy=@P18,location_timestamp=@P19,guid=@P20,image=@P21,submap_id=@P22,country=@P23,city=@P24,street_address=@P25,postcode=@P26,maint_event_id=@P27,state_before_maint=@P28 WHERE object_id=@P29','Sw-209-dlink總務處',2,0,1,1566991628,0,0,1,0,'01020304',75,'503C2814','',0,0,'0.000000','0.000000',0,0,'d025b358-fd3d-1d4d-9b5e-6337e2fd9fc1','00000000-0000-0000-0000-000000000000',0,'','','','',0,0,713
select @p1
#5
I USE NODE TOPOLOGY->SWITCH FORWARDING TABLE (MAC ADDRESS TABLE) FOR HP ARUBA SWITCH S2500 & S3500,

NetXMS:
Version: 2.2.16
Platform: Windows, 64-bit
Database: PostgreSQL

ALL ARUBA S2500 & S3500 SWITCH  is detected as GENERIC driver by NetXMS.

Problem:
Switchports that are in access mode in vlan 1, and ports that are in trunk mode and include vlan 1 in trunk vlans list are identified properly.
However, ports that do not include vlan 1 are shown as interface name "[ 0 ]" in the "Topology -> Switch forwarding database (MAC address table)" screen.
so i can't to know what peer node,problem screen is below


.1.3.6.1.2.1.17.1.4.1.2

.1.3.6.1.2.1.2.1.0

.1.3.6.1.2.1.2.2.1.1

.1.3.6.1.2.1.31.1.1.1.1

.1.3.6.1.2.1.2.2.1.2