| Anonymous | Login | 2024-11-22 23:34 EST |  |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||
| 0000914 | PacketFence | refactoring | public | 2010-02-17 17:16 | 2011-01-26 15:42 | |||
| Reporter | obilodeau | |||||||
| Assigned To | obilodeau | |||||||
| Priority | high | Severity | minor | Reproducibility | N/A | |||
| Status | closed | Resolution | fixed | |||||
| Platform | OS | OS Version | ||||||
| Product Version | ||||||||
| Target Version | 2.0.0 | Fixed in Version | 2.0.0 | |||||
| Summary | 0000914: node table should not carry data duplicated from locationlog | |||||||
| Description | Right now, the node table is updated by locationlog_synchronize, pfsetvlan and other mechanism to make sure that port, switch, connection_type and voip are accurate with the latest entry in locationlog. We should forget about that and join the two tables on node_view_all or a new sub. This would cleanup a lot of the cruft. | |||||||
| Tags | No tags attached. | |||||||
| fixed in git revision | ||||||||
| fixed in mtn revision | 8116f6f5657fa9232ce57c50c926e66f23abe079 | |||||||
| Attached Files | ||||||||
 Relationships |
|||||||||||
|
|||||||||||
 Relationships |
|
Notes |
|
|
(0001471) obilodeau (reporter) 2010-02-17 17:27 |
It's a tricky one with the SQL but start from: select * from node join locationlog USING (mac) WHERE mac ='00:11:25:14:15:45' order by start_time desc limit 1; remember that entries in locationlog also tend to overlap. in ex: mac | switch | port | vlan | voip | connection_type | start_time | end_time 00:11:25:14:15:45 | 192.168.1.61 | 10003 | 1 | no | SNMP-Traps | 2010-02-15 11:15:15 | NULL 00:11:25:14:15:45 | 192.168.1.61 | 10003 | 2 | no | SNMP-Traps | 2010-02-15 11:15:15 | 2010-02-15 11:15:15 So i'll need to be careful and favor when end_time NULL over latest start_time. |
|
(0001543) obilodeau (reporter) 2010-05-05 09:28 |
re-targeted for next feature release |
|
(0001705) obilodeau (reporter) 2010-09-30 19:00 |
This change was tackled in the path to fix 0001002. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-02-17 17:16 | obilodeau | New Issue | |
| 2010-02-17 17:16 | obilodeau | Status | new => assigned |
| 2010-02-17 17:16 | obilodeau | Assigned To | => obilodeau |
| 2010-02-17 17:27 | obilodeau | Note Added: 0001471 | |
| 2010-04-15 17:43 | obilodeau | Project | PacketFence 1.9 => PacketFence |
| 2010-05-04 16:49 | obilodeau | Relationship added | related to 0000977 |
| 2010-05-05 09:28 | obilodeau | Note Added: 0001543 | |
| 2010-05-05 09:28 | obilodeau | Target Version | 1.9.0 => 1.10.0 |
| 2010-09-29 17:04 | obilodeau | Relationship added | related to 0001082 |
| 2010-09-30 19:00 | obilodeau | mtn revision | => 8116f6f5657fa9232ce57c50c926e66f23abe079 |
| 2010-09-30 19:00 | obilodeau | Note Added: 0001705 | |
| 2010-09-30 19:00 | obilodeau | Status | assigned => resolved |
| 2010-09-30 19:00 | obilodeau | Fixed in Version | => trunk |
| 2010-09-30 19:00 | obilodeau | Resolution | open => fixed |
| 2010-11-19 14:25 | obilodeau | Target Version | 1.10.0 => 2.0.0 |
| 2010-12-15 11:37 | obilodeau | Fixed in Version | trunk => 2.0.0 |
| 2011-01-26 15:42 | obilodeau | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group |
 |