PacketFence
Bug Tracking System

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000914PacketFencerefactoringpublic2010-02-17 17:162011-01-26 15:42
Reporterobilodeau 
Assigned Toobilodeau 
PriorityhighSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version2.0.0Fixed in Version2.0.0 
Summary0000914: node table should not carry data duplicated from locationlog
DescriptionRight 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.
TagsNo tags attached.
fixed in git revision
fixed in mtn revision8116f6f5657fa9232ce57c50c926e66f23abe079
Attached Files

- Relationships
related to 0000977closedobilodeau VLAN field in node table should be re-thought 
related to 0001082closed Specify a VLAN per node 

-  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
Powered by Mantis Bugtracker