I have PE, but there is not DB Log, only observium log. The device being queried is our MSE, so there is a lot of debug. I have filtered it using "./poller.php -d -m ports -h svs-za-jhb-ne-mse-001 | grep ANC -C 7”. Please let me know if I should attach
a link to the full log output?
____________________________________________________________________________________________
ifAlias.825 = ANC CPE1 Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391�
ifAlias.826 = ANC Voice Interfaces | VRF:ANC-VRF | Vlan 402
--
)
SQL[UPDATE `ports-state` set `poll_time` ='1435762473',`poll_period` ='92',`ifInOctets` ='0',`ifInOctets_rate` ='0',`ifInOctets_delta` ='0',`ifOutOctets` ='0',`ifOutOctets_rate` ='0',`ifOutOctets_delta` ='0',`ifInErrors` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta`
='0',`ifOutErrors` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='0',`ifInUcastPkts_rate` ='0',`ifInUcastPkts_delta` ='0',`ifOutUcastPkts` ='0',`ifOutUcastPkts_rate` ='0',`ifOutUcastPkts_delta` ='0',`ifInOctets_perc` ='0',`ifOutOctets_perc`
='0',`ifOctets_rate` ='0',`ifUcastPkts_rate` ='0',`ifErrors_rate` ='0' WHERE `port_id` = '212']
RUNTIME[0.00018406s]
STATE updated rows=1
Port ge-1/0/1.1557(825) replacing with 64-bit...
dot3Duplex, VLAN == [ifAlias] ANC CPE1 Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391 -> ANC CPE1 Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391�
SQL[INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('3','213','port',NOW(),'6','Interface changed: [ifAlias] ANC CPE1 Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391 -> ANC CPE1
Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391�')]
RUNTIME[0.00248504s]
ANC CPE1 Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391�
ifInOctets (2915 B) 31.684782608696 Bps 92 secs
ifOutOctets (3695 B) 40.163043478261 Bps 92 secs
ifInErrors (0 B) 0 Bps 92 secs
--
[ifHighSpeed] => 1000
[ifInOctets_perc] => 0
[ifOutOctets_perc] => 0
[rx_ave_pktsize] => 97.166666666667
[tx_ave_pktsize] => 102.63888888889
)
SQL[UPDATE `ports` set `ifAlias` ='ANC CPE1 Interface | VRF:ANC-VRF | Vlan 1557 | CircuitNo:027JOHA1802009901391�' WHERE `port_id` = '213']
RUNTIME[0.00193810s]
PORT updated rows=0
SQL[UPDATE `ports-state` set `poll_time` ='1435762473',`poll_period` ='92',`ifInOctets` ='12301672444',`ifInOctets_rate` ='31.684782608696',`ifInOctets_delta` ='2915',`ifOutOctets` ='12268494827',`ifOutOctets_rate` ='40.163043478261',`ifOutOctets_delta`
='3695',`ifInErrors` ='0',`ifInErrors_rate` ='0',`ifInErrors_delta` ='0',`ifOutErrors` ='0',`ifOutErrors_rate` ='0',`ifOutErrors_delta` ='0',`ifInUcastPkts` ='196488829',`ifInUcastPkts_rate` ='0.32608695652174',`ifInUcastPkts_delta` ='30',`ifOutUcastPkts`
='195492343',`ifOutUcastPkts_rate` ='0.39130434782609',`ifOutUcastPkts_delta` ='36',`ifInOctets_perc` ='0',`ifOutOctets_perc` ='0',`ifOctets_rate` ='71.847826086957',`ifUcastPkts_rate` ='0.71739130434783',`ifErrors_rate` ='0' WHERE `port_id` = '213']
RUNTIME[0.00014615s]
STATE updated rows=1
Port ge-1/0/0.402(826) replacing with 64-bit...
dot3Duplex, VLAN == ANC Voice Interfaces | VRF:ANC-VRF | Vlan 402
ifInOctets (521 B) 5.6630434782609 Bps 92 secs
ifOutOctets (591 B) 6.4239130434783 Bps 92 secs
ifInErrors (0 B) 0 Bps 92 secs