{"action":"created","issue":{"url":"https://api.github.com/repos/librenms/librenms/issues/2581","labels_url":"https://api.github.com/repos/librenms/librenms/issues/2581/labels{/name}","comments_url":"https://api.github.com/repos/librenms/librenms/issues/2581/comments","events_url":"https://api.github.com/repos/librenms/librenms/issues/2581/events","html_url":"https://github.com/librenms/librenms/issues/2581","id":121085991,"number":2581,"title":"LLDP issues with switch","user":{"login":"djtecha","id":3084627,"avatar_url":"https://avatars.githubusercontent.com/u/3084627?v=3","gravatar_id":"","url":"https://api.github.com/users/djtecha","html_url":"https://github.com/djtecha","followers_url":"https://api.github.com/users/djtecha/followers","following_url":"https://api.github.com/users/djtecha/following{/other_user}","gists_url":"https://api.github.com/users/djtecha/gists{/gist_id}","starred_url":"https://api.github.com/users/djtecha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/djtecha/subscriptions","organizations_url":"https://api.github.com/users/djtecha/orgs","repos_url":"https://api.github.com/users/djtecha/repos","events_url":"https://api.github.com/users/djtecha/events{/privacy}","received_events_url":"https://api.github.com/users/djtecha/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-12-08T19:57:11Z","updated_at":"2015-12-09T17:31:42Z","closed_at":null,"body":"So I'm trying to get lldp working to build a network map for a cisco switch and it appears that the SQL is not querying correctly.\r\n\r\n\r\n(\r\n    [17] => Array\r\n        (\r\n            [lldpRemChassisIdSubtype] => macAddress\r\n            [lldpRemChassisId] => 20 47 47 7D D6 8C \r\n            [lldpRemPortIdSubtype] => macAddress\r\n            [lldpRemPortId] => 20 47 47 7D D6 8C \r\n            [lldpRemPortDesc] => Interface   2 as eth0\r\n            [lldpRemSysName] => query-5\r\n            [lldpRemSysDesc] => Linux query-5 3.10.0-229.11.1.el7.x86_64 #1 SMP Thu Aug 6 01:06:18 UTC 2015 x86_64\r\n            [lldpRemSysCapSupported] => 00 00 \r\n            [lldpRemSysCapEnabled] => 00 00 \r\n        )\r\n\r\n)\r\nSQL[SELECT `device_id` FROM `devices` WHERE `sysName` = 'query-5' OR `hostname` = 'query-5'] \r\nSQL[SELECT `port_id` FROM `ports` WHERE (`ifDescr` = 'Interface   2 as eth0' OR `ifName` = 'Interface   2 as eth0' OR `ifDescr` = '20 47 47 7D D6 8C ' OR `ifName` = '20 47 47 7D D6 8C ') AND `device_id` = '21'] \r\nSQL[SELECT * FROM `ports` WHERE `device_id` = '118' AND `ifIndex` = '44'] Array\r\n\r\nNow if I run that SQL I return zero results which is why I believe it's not updating. I can change ifName to ifPhysAddress and it will return the correct port_id, but I also have to remove the spaces from the mac address like so:\r\n\r\nMariaDB [librenms]> SELECT `port_id` FROM `ports` WHERE (`ifDescr` = 'Interface   2 as eth0' OR `ifName` = 'Interface   2 as eth0' OR `ifDescr` = '20 47 47 7D D6 8C ' OR `ifPhysAddress` = '2047477DD68C') AND `device_id` = '21';\r\n+---------+\r\n| port_id |\r\n+---------+\r\n|     238 |\r\n+---------+\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/librenms/librenms/issues/comments/163333379","html_url":"https://github.com/librenms/librenms/issues/2581#issuecomment-163333379","issue_url":"https://api.github.com/repos/librenms/librenms/issues/2581","id":163333379,"user":{"login":"Rosiak","id":6378934,"avatar_url":"https://avatars.githubusercontent.com/u/6378934?v=3","gravatar_id":"","url":"https://api.github.com/users/Rosiak","html_url":"https://github.com/Rosiak","followers_url":"https://api.github.com/users/Rosiak/followers","following_url":"https://api.github.com/users/Rosiak/following{/other_user}","gists_url":"https://api.github.com/users/Rosiak/gists{/gist_id}","starred_url":"https://api.github.com/users/Rosiak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rosiak/subscriptions","organizations_url":"https://api.github.com/users/Rosiak/orgs","repos_url":"https://api.github.com/users/Rosiak/repos","events_url":"https://api.github.com/users/Rosiak/events{/privacy}","received_events_url":"https://api.github.com/users/Rosiak/received_events","type":"User","site_admin":false},"created_at":"2015-12-09T17:31:42Z","updated_at":"2015-12-09T17:31:42Z","body":"Just for info:\r\nLLDP working fine here, between Edgerouter and Cisco SMB sw."}}