netdisco-users Digest, Vol 124, Issue 5

netdisco-users-request Thu, 13 Oct 2016 01:20:54 -0700

Send netdisco-users mailing list submissions to
        netdisco-users@lists.sourceforge.net


To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        netdisco-users-requ...@lists.sourceforge.net

You can reach the person managing the list at
        netdisco-users-ow...@lists.sourceforge.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."

Today's Topics:

   1. Re: No nodes displayed on some Switches (Jeroen van Ingen)

--- Begin Message ---

Hi Frank,

OK, so the switch with IP address 192.168.99.4 doesn't show any nodes.

Looking through the debug output, Netdisco sees several MAC addresseslearned by this switch, but all entries are pointing to ports whereanother switch is connected or pointing to the switch CPU.


- Port A1 has a neighbor with IP 192.168.99.101
- Port D21 has a neighbor with IP 192.168.99.153

- There are a few entries for MAC 00:08:83:cc:e9:00, probably one entryper VLAN, which I expect to be the base MAC of the switch: vendor00:08:83 is HP and port 0 on the switch points to the switch CPU.

During a macsuck, Netdisco will only store MAC-to-port mappings if theport appears to be an edge port, ie for ports without any neighboringswitches.

Could it be that switch 192.168.99.4 just doesn't have any edge ports,with a client directly connected? Is it used as a core or distributionswitch?



Regards,

Jeroen van Ingen
ICT Service Centre
University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands


On 10/12/2016 08:38 AM, Grote Frank wrote:

Hi,

I checked snmp communities and the faulty displayed switches use the same 
community as the others. When I do a macsuck in debug mode there is always the 
same kind of output on the ones not displaying any mac or ip information on 
connected nodes.

Here is a one from such a device:

Scroll down to the end oft he section beginning with [19500]:




netdisco@netdisco:~$ netdisco-do macsuck -d 192.168.99.4 -DIQ |more
SELECT me.version, me.installed
  FROM dbix_class_schema_versions me
WHERE 1 = 0
SELECT me.version
  FROM dbix_class_schema_versions me
ORDER BY installed DESC
  LIMIT '1'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '192.168.99.4' AND me.ip = '192.168.99.4'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, 
me.name, me.location, me.layers, me.ports, me.mac, me.serial, me.model, 
me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, 
me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, 
me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, to_char( 
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover, 'YYYY-MM-DD 
HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp 'epoch' + 
uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) 
::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '192.168.99.4'
[19500] 2016-10-12 06:26:32  info macsuck: started at Wed Oct 12 08:26:32 2016
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '192.168.99.4' AND me.ip = '192.168.99.4'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, 
me.name, me.location, me.layers, me.ports, me.mac, me.serial, me.model, 
me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, 
me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, 
me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, to_char( 
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover, 'YYYY-MM-DD 
HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp 'epoch' + 
uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) 
::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '192.168.99.4'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag
  FROM community me
WHERE me.ip = '192.168.99.4'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '192.168.99.4' AND me.ip = '192.168.99.4'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, 
me.name, me.location, me.layers, me.ports, me.mac, me.serial, me.model, 
me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, 
me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, 
me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, to_char( 
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover, 'YYYY-MM-DD 
HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp 'epoch' + 
uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) 
::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '192.168.99.4'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '192.168.99.4' AND me.ip = '192.168.99.4'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, 
me.name, me.location, me.layers, me.ports, me.mac, me.serial, me.model, 
me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, 
me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, 
me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, to_char( 
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover, 'YYYY-MM-DD 
HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp 'epoch' + 
uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) 
::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '192.168.99.4'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
  FROM device_ip me
WHERE me.alias = '192.168.99.4' AND me.ip = '192.168.99.4'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, 
me.name, me.location, me.layers, me.ports, me.mac, me.serial, me.model, 
me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, 
me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, 
me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, to_char( 
last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( last_discover, 'YYYY-MM-DD 
HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
      FROM age( now(  ), last_arpnip ) ), extract( epoch
      FROM age( now(  ), last_discover ) ), extract( epoch
      FROM age( now(  ), last_macsuck ) ), replace( age( timestamp 'epoch' + 
uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) 
::text, 'mon', 'month' )
  FROM device me
WHERE me.ip = '192.168.99.4'
[19500] 2016-10-12 06:26:32 debug [192.168.99.4] try_connect with ver: 2, class: 
SNMP::Info::Layer2::HP, comm: <hidden>
BEGIN WORK
COMMIT
BEGIN WORK
COMMIT
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag
  FROM community me
WHERE me.ip = '192.168.99.4'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, 
me.duplex, me.duplex_admin, me.speed, me.name, me.mac, me.mtu, me.stp, 
me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, 
me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange, 
neighbor_alias.ip, neighbor_alias.alias, neighbor_alias.subnet, 
neighbor_alias.port, neighbor_alias.dns, neighbor_alias.creation, device.ip, 
device.creation, device.dns, device.description, device.uptime, device.contact, 
device.name, device.location, device.layers, device.ports, device.mac, 
device.serial, device.model, device.ps1_type, device.ps2_type, 
device.ps1_status, device.ps2_status, device.fan, device.slots, device.vendor, 
device.os, device.os_ver, device.log, device.snmp_ver, device.snmp_comm, 
device.snmp_class, device.vtp_domain, device.last_discover, 
device.last_macsuck, device.last_arpnip
  FROM device_port me
  LEFT JOIN device_ip neighbor_alias
    ON neighbor_alias.ip = (
    SELECT devipsub.ip
      FROM device_ip devipsub
    WHERE alias = me.remote_ip
      LIMIT '1'
   )
  LEFT JOIN device device
    ON device.ip = neighbor_alias.ip
WHERE me.ip = '192.168.99.4'
SELECT me.mac, me.ip
  FROM device_port me
WHERE mac IS NOT NULL AND mac != '00:00:00:00:00:00'
GROUP BY mac, ip
SELECT me.mac, me.ip
  FROM device me
WHERE mac IS NOT NULL
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:25:61:0f:cf:28 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:d9 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:59 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:41 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 6c:3b:e5:9d:ae:c0 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:40 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 78:ac:c0:dc:3b:b1 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:3c - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:25:61:0e:45:18 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:a8:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:54 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:39 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck c8:cb:b8:62:48:80 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:43 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:e5 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck ac:16:2d:39:3f:49 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:d7 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:50:56:80:00:08 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck b4:39:d6:b1:df:c0 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck b4:39:d6:27:08:c0 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:24:a8:89:4c:ef - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 2c:44:fd:04:ed:c6 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:57 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck b4:39:d6:b2:56:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck b4:39:d6:b5:f5:66 - 
port D21 has neighbor 192.168.99.153 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:45 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:07:cc:19:40:c0 - 
port D21 has neighbor 192.168.99.153 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 78:ac:c0:dc:2b:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:55 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck c8:cb:b8:62:48:93 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:4e - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:07 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:d5 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:04:ea:5e:ab:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:17:a4:46:64:4c - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:4d - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] check_mac - VRRP mac 
[00:00:5e:00:01:01] - skipping
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:ef - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 6c:3b:e5:9d:3f:40 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck e8:39:35:6b:f4:97 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:5b - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:51 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:cd - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:24:1b - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:0f:61:0e:5e:cb - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck f0:92:1c:64:9e:ba - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 6c:3b:e5:9e:e1:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:24:17 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:04:ea:67:7d:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:dd - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:df - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:4f - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:3e - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:07:cc:19:40:c5 - 
port D21 has neighbor 192.168.99.153 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:c4:b7:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck b4:39:d6:27:57:40 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:db - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:3f - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:c1 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:04:ea:5e:8b:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 2c:41:38:db:63:57 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck e8:39:35:6b:f4:d5 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:3b - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:19:bb:c9:a3:64 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:e9 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:bd - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:e7 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:3d - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:24:a8:1d:05:28 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:44 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:49 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck d4:85:64:41:60:c5 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:4d - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck c0:91:34:5f:ab:80 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck c8:cb:b8:62:48:af - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:50 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 2c:41:38:db:63:76 - 
port D21 has neighbor 192.168.99.153 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] check_mac - VRRP mac 
[00:00:5e:00:01:c8] - skipping
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:04:ea:5e:ab:00 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:24:0b - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:53 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:14:e3 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:0d - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:b5:3d - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 00:08:83:cc:e9:00 - 
port 0 has no bp_index mapping - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 64:31:50:d3:24:13 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:52 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck b4:39:d6:27:d9:40 - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck 74:46:a0:8d:03:0f - 
port A1 has neighbor 192.168.99.101 - skipping.
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck - 0 updated 
forwarding table entries
[19500] 2016-10-12 06:26:33 debug  [192.168.99.4] macsuck - removed 0 fwd table 
entries to archive                           <-------- These to lines only 
appear in the ones not dieplaying nodes
BEGIN WORK
UPDATE device                                                                      
               <---------- Here it should start the UPDATE node section
  SET last_macsuck = to_timestamp( 1476253592.649042 )
WHERE ip = '192.168.99.4'
COMMIT
[19500] 2016-10-12 06:26:33  info macsuck: finished at Wed Oct 12 08:26:33 2016
[19500] 2016-10-12 06:26:33  info macsuck: status done: Ended macsuck for 
192.168.99.4
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : 
.1.3.6.1.2.1.1.3.0
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.33
SNMP::Info::device_type() layers:01001110 id:11 sysDescr:"ProCurve J4850A Switch 
5304XL, revision E.11.21, ROM E.05.05 (/sw/code/build/alpmo(alp11))"
SNMP::Info::_validate_autoload_method(cd11_txrate) Unable to resolve method.
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr i_description : IF-MIB::ifDescr : .1.3.6.1.2.1.2.2.1.2
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort : 
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_attr dot1qVlanFdbId : Q-BRIDGE-MIB::dot1qVlanFdbId : 
.1.3.6.1.2.1.17.7.1.4.2.1.3
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex : 
.1.3.6.1.2.1.17.1.4.1.2









No an output of a good one, but only beginning with the macsuck section, the 
beginning is equal:


[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 5c:ca:1a:04:04:04 - 
port 26 has neighbor 192.168.99.29 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 00:02:e7:03:f9:fc - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 00:19:99:e7:b8:be - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 78:ac:c0:dc:2b:00 - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 10:0b:a9:38:ee:bc - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck c8:cb:b8:62:48:a8 - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 74:46:a0:8d:03:0d - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 7c:d3:0a:1a:d9:50 - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck 00:22:19:1c:7e:f9 - 
port 28 has neighbor 192.168.0.254 - skipping.
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 15 vlan 71 : 
2 nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node                                                                        
       <---------------------------------- here ist he update node section, 
which is missing obove
  SET active = false
WHERE active AND ( NOT( port = '15' AND switch = '192.168.99.22' ) ) AND mac = 
'30:18:cf:00:2b:a3' AND vlan = '71'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '30:18:cf:00:2b:a3' AND me.port = '15' AND me.switch = 
'192.168.99.22' AND me.vlan = '71' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '30:18:cf:00:2b:a3' AND port = '15' AND switch = '192.168.99.22' 
AND vlan = '71'
RELEASE SAVEPOINT savepoint_0
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '15' AND switch = '192.168.99.22' ) ) AND mac = 
'00:90:9e:9f:aa:33' AND vlan = '71'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:90:9e:9f:aa:33' AND me.port = '15' AND me.switch = 
'192.168.99.22' AND me.vlan = '71' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:90:9e:9f:aa:33' AND port = '15' AND switch = '192.168.99.22' 
AND vlan = '71'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 13 vlan 71 : 
1 nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '13' AND switch = '192.168.99.22' ) ) AND mac = 
'00:1e:c0:d5:e6:a0' AND vlan = '71'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:1e:c0:d5:e6:a0' AND me.port = '13' AND me.switch = 
'192.168.99.22' AND me.vlan = '71' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:1e:c0:d5:e6:a0' AND port = '13' AND switch = '192.168.99.22' 
AND vlan = '71'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 8 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '8' AND switch = '192.168.99.22' ) ) AND mac = 
'00:23:ae:8b:9d:ee' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:23:ae:8b:9d:ee' AND me.port = '8' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:23:ae:8b:9d:ee' AND port = '8' AND switch = '192.168.99.22' AND 
vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 20 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '20' AND switch = '192.168.99.22' ) ) AND mac = 
'00:00:74:da:01:d4' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:00:74:da:01:d4' AND me.port = '20' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:00:74:da:01:d4' AND port = '20' AND switch = '192.168.99.22' 
AND vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 5 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '5' AND switch = '192.168.99.22' ) ) AND mac = 
'f0:de:f1:ca:ac:46' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = 'f0:de:f1:ca:ac:46' AND me.port = '5' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = 'f0:de:f1:ca:ac:46' AND port = '5' AND switch = '192.168.99.22' AND 
vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 22 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '22' AND switch = '192.168.99.22' ) ) AND mac = 
'bc:30:5b:b4:83:4e' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = 'bc:30:5b:b4:83:4e' AND me.port = '22' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = 'bc:30:5b:b4:83:4e' AND port = '22' AND switch = '192.168.99.22' 
AND vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 12 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '12' AND switch = '192.168.99.22' ) ) AND mac = 
'00:26:73:41:b0:a7' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:26:73:41:b0:a7' AND me.port = '12' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:26:73:41:b0:a7' AND port = '12' AND switch = '192.168.99.22' 
AND vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 3 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '3' AND switch = '192.168.99.22' ) ) AND mac = 
'00:01:e6:aa:c2:88' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:01:e6:aa:c2:88' AND me.port = '3' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:01:e6:aa:c2:88' AND port = '3' AND switch = '192.168.99.22' AND 
vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 19 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '19' AND switch = '192.168.99.22' ) ) AND mac = 
'00:05:35:03:7e:28' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:05:35:03:7e:28' AND me.port = '19' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:05:35:03:7e:28' AND port = '19' AND switch = '192.168.99.22' 
AND vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 10 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '10' AND switch = '192.168.99.22' ) ) AND mac = 
'7c:d3:0a:1c:17:28' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '7c:d3:0a:1c:17:28' AND me.port = '10' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '7c:d3:0a:1c:17:28' AND port = '10' AND switch = '192.168.99.22' 
AND vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 1 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '1' AND switch = '192.168.99.22' ) ) AND mac = 
'00:24:7e:e1:b5:f8' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:24:7e:e1:b5:f8' AND me.port = '1' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:24:7e:e1:b5:f8' AND port = '1' AND switch = '192.168.99.22' AND 
vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 17 vlan 7 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '17' AND switch = '192.168.99.22' ) ) AND mac = 
'00:23:ae:8b:a0:3b' AND vlan = '7'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:23:ae:8b:a0:3b' AND me.port = '17' AND me.switch = 
'192.168.99.22' AND me.vlan = '7' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:23:ae:8b:a0:3b' AND port = '17' AND switch = '192.168.99.22' 
AND vlan = '7'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 4 vlan 40 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '4' AND switch = '192.168.99.22' ) ) AND mac = 
'00:17:c5:9b:b4:b9' AND vlan = '40'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:17:c5:9b:b4:b9' AND me.port = '4' AND me.switch = 
'192.168.99.22' AND me.vlan = '40' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:17:c5:9b:b4:b9' AND port = '4' AND switch = '192.168.99.22' AND 
vlan = '40'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 24 vlan 200 : 
1 nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '24' AND switch = '192.168.99.22' ) ) AND mac = 
'2c:59:e5:74:ef:1e' AND vlan = '200'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '2c:59:e5:74:ef:1e' AND me.port = '24' AND me.switch = 
'192.168.99.22' AND me.vlan = '200' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '2c:59:e5:74:ef:1e' AND port = '24' AND switch = '192.168.99.22' 
AND vlan = '200'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 9 vlan 2 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '9' AND switch = '192.168.99.22' ) ) AND mac = 
'00:05:35:05:9c:80' AND vlan = '2'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:05:35:05:9c:80' AND me.port = '9' AND me.switch = 
'192.168.99.22' AND me.vlan = '2' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:05:35:05:9c:80' AND port = '9' AND switch = '192.168.99.22' AND 
vlan = '2'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - port 25 vlan 2 : 1 
nodes
BEGIN WORK
COMMIT
BEGIN WORK
UPDATE node
  SET active = false
WHERE active AND ( NOT( port = '25' AND switch = '192.168.99.22' ) ) AND mac = 
'00:c0:3d:06:fe:cc' AND vlan = '2'
SELECT me.mac, me.switch, me.port, me.active, me.oui, me.time_first, 
me.time_recent, me.time_last, me.vlan
  FROM node me
WHERE me.mac = '00:c0:3d:06:fe:cc' AND me.port = '25' AND me.switch = 
'192.168.99.22' AND me.vlan = '2' FOR UPDATE
SAVEPOINT savepoint_0
UPDATE node
  SET active = true, time_last = to_timestamp( 1476254024.499059 )
WHERE mac = '00:c0:3d:06:fe:cc' AND port = '25' AND switch = '192.168.99.22' 
AND vlan = '2'
RELEASE SAVEPOINT savepoint_0
COMMIT
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - 17 updated 
forwarding table entries
[19527] 2016-10-12 06:33:45 debug  [192.168.99.22] macsuck - removed 0 fwd 
table entries to archive
BEGIN WORK
UPDATE device
  SET last_macsuck = to_timestamp( 1476254024.499059 )
WHERE ip = '192.168.99.22'
COMMIT
[19527] 2016-10-12 06:33:45  info macsuck: finished at Wed Oct 12 08:33:45 2016
[19527] 2016-10-12 06:33:45  info macsuck: status done: Ended macsuck for 
192.168.99.22
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : 
.1.3.6.1.2.1.1.3.0
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.33
SNMP::Info::device_type() layers:01001010 id:11 sysDescr:"ProCurve J9085A Switch 
2610-24, revision R.11.72, ROM R.10.06 (/sw/code/build/nemo(R_ndx))"
SNMP::Info::_validate_autoload_method(cd11_txrate) Unable to resolve method.
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr i_description : IF-MIB::ifDescr : .1.3.6.1.2.1.2.2.1.2
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort : 
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_attr dot1qVlanFdbId : Q-BRIDGE-MIB::dot1qVlanFdbId : 
.1.3.6.1.2.1.17.7.1.4.2.1.3
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex : 
.1.3.6.1.2.1.17.1.4.1.2












Mit freundlichen Grüßen / Best regards



Frank Grote

Systemmanagement




Teekanne GmbH & Co. KG

Telefon:
+49 211 5085 538
Telefax:
+49 211 5085 497
Mobil:
+49 171 5598102
eMail:
frank.gr...@teekanne.de

www.teekanne.de

TEEKANNE GmbH & Co. KG Sitz: Düsseldorf, Registergericht: Düsseldorf HRA 16976
Persönlich haftender Gesellschafter: TEEKANNE Holding GmbH, Sitz: Düsseldorf, 
Registergericht: Düsseldorf HRB 732
Geschäftsführer: Reinhold Schlensok
Kevelaerer Straße 21-23, 40549 Düsseldorf, Deutschland
Telefon: +49 211 5085 0, Telefax: +49 211 5048 139








________________________________

Hinweis:
Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte Informationen 
enthalten. Sollten Sie nicht der richtige Adressat sein oder diese E-Mail 
irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und 
loeschen diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe 
dieser E-Mail ist nicht gestattet. Wir haben diese E-Mail vor dem Versenden auf 
Virenfreiheit geprueft. Eine Haftung fuer Schaeden durch Virenbefall schliessen 
wir aus.

Advice:
This e-mail may contain confidential and/or privileged information. If you are 
not the intended recipient (or have received this e-mail in error) please 
notify the sender immediately and delete this e-mail. Any unauthorized copying, 
disclosure or distribution of the material in this e-mail is strictly 
forbidden. This e-mail was checked for known viruses before sending therefore 
we assume no liability.

________________________________

Bitte denken Sie an die Auswirkungen auf die Umwelt, bevor Sie diese Email 
und/oder die Anhaenge ausdrucken.
Please consider the impact on the environment before printing this e-mail 
and/or the attachment(s).

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users

netdisco-users Digest, Vol 124, Issue 5

Reply via email to