| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] |
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0001389 | PacketFence | core | public | 2012-03-01 11:05 | 2015-02-13 15:26 |
|
| Reporter | obilodeau | |
| Assigned To | obilodeau | |
| Priority | high | Severity | trivial | Reproducibility | have not tried |
| Status | closed | Resolution | open | |
| Platform | | OS | | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
|
| Summary | 0001389: locationlog_view_open_switchport_no_VoIP fails because port contains leading zeros |
| Description | the 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. |
| Tags | No tags attached. |
|
| fixed in git revision | |
| fixed in mtn revision | |
|
| Attached Files | |
|
Relationships 
Relationships 