PacketFence - BTS - PacketFence
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001389PacketFencecorepublic2012-03-01 11:052015-02-13 15:26
Reporterobilodeau 
Assigned Toobilodeau 
PriorityhighSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
fixed in git revision
fixed in mtn revision
Summary0001389: locationlog_view_open_switchport_no_VoIP fails because port contains leading zeros
Descriptionthe locationlog view open switchport does a query against a specific switch ip and port

| mac | ip | port | ...
| 00:24:54:aa:bb:cc | 10.1.1.22 | 02 | 721 | Ethernet-EAP | xxxxxx | | 2012-03-01 15:23:24 | 2012-03-01 15:25:50 |
| 00:24:54:aa:bb:cc | 10.1.1.22 | 02 | 705 | Ethernet-EAP | xxxxxx | | 2012-03-01 15:25:50 | NULL |

as you can see there are leading 0's here. They are injected because the port is of varchar type. At some point in time, strings were injected into the port field (the infamous 'WIFI') and it wasn't changed in case other vendor put latin characters in port numbers.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
related to 0001388closed obilodeau Cisco 2950's dot1x reauthenticate unnecessary insist on VoIP tests even if VoIP is disabled 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-03-01 11:05obilodeauNew Issue
2012-03-01 11:05obilodeauStatusnew => assigned
2012-03-01 11:05obilodeauAssigned To => obilodeau
2012-03-01 11:55obilodeauPrioritynormal => high
2012-03-01 11:55obilodeauSeverityminor => trivial
2012-03-01 12:58obilodeauRelationship addedrelated to 0001388
2015-02-13 15:26lmunroNote Added: 0003702
2015-02-13 15:26lmunroStatusassigned => closed

Notes
(0003702)
lmunro   
2015-02-13 15:26   
Old issues.
Most are not relevant to PF 4 and up.

Let's reopen the ones that matter when we move to github.