Anonymous | Login | 2024-12-04 11:30 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 | |||||||||||
|
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. |
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 |
Copyright © 2000 - 2012 MantisBT Group |