PacketFence
Bug Tracking System

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001285PacketFencecorepublic2011-09-27 15:472012-02-29 10:45
Reporterdwuelfrath 
Assigned Todwuelfrath 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version3.0.2Fixed in Version3.0.2 
Summary0001285: add trigger or cascade to delete node_useragent when deleting a node
Descriptionwhen we delete a node, we should also delete the mac-useragent binding.
TagsNo tags attached.
fixed in git revision
fixed in mtn revision403f38fb5859a3572f58f372cc01826ed35a8bf9
Attached Files

- Relationships

-  Notes
(0002314)
dwuelfrath (administrator)
2011-10-05 14:10

Could look like this

--
-- Trigger to delete the node_useragent associated with a mac when deleting this mac from the node table
--

DROP TRIGGER IF EXISTS node_useragent_delete_trigger;
DELIMITER /
CREATE TRIGGER node_useragent_delete_trigger AFTER DELETE ON node
FOR EACH ROW
BEGIN
  DELETE FROM node_useragent WHERE mac = OLD.mac;
END /
DELIMITER ;
(0002321)
obilodeau (reporter)
2011-10-06 10:15

yes, go for it
(0002334)
dwuelfrath (administrator)
2011-10-11 16:29

modified in revision 8aa7974a4ae1c1d0bbcbd5d163e1efa5afbbf6f1
(0002351)
obilodeau (reporter)
2011-10-14 09:29

Was the upgrade script tested, new db install tested and node deletion with cascade tested?
(0002355)
dwuelfrath (administrator)
2011-10-14 10:19

Yes
(0002394)
obilodeau (reporter)
2011-10-24 20:27

fix released in 3.0.2

- Issue History
Date Modified Username Field Change
2011-09-27 15:47 dwuelfrath New Issue
2011-10-05 14:10 dwuelfrath Note Added: 0002314
2011-10-06 10:15 obilodeau Note Added: 0002321
2011-10-07 10:03 dwuelfrath mtn revision => 403f38fb5859a3572f58f372cc01826ed35a8bf9
2011-10-07 10:03 dwuelfrath Status new => resolved
2011-10-07 10:03 dwuelfrath Resolution open => fixed
2011-10-07 10:03 dwuelfrath Fixed in Version => 3.0.1
2011-10-07 10:04 dwuelfrath Status resolved => assigned
2011-10-07 10:04 dwuelfrath Assigned To => dwuelfrath
2011-10-07 10:04 dwuelfrath Status assigned => resolved
2011-10-11 16:29 dwuelfrath Note Added: 0002334
2011-10-14 09:29 obilodeau Note Added: 0002351
2011-10-14 10:19 dwuelfrath Note Added: 0002355
2011-10-24 20:27 obilodeau Fixed in Version 3.0.1 => 3.0.2
2011-10-24 20:27 obilodeau Note Added: 0002394
2011-10-24 20:28 obilodeau Status resolved => closed
2011-10-24 20:28 obilodeau Target Version +1 => 3.0.2
2012-02-29 10:45 obilodeau Category feature => core


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker