If you REALLY want them to be deleted, use your SQL skills, and delete the locationlog entries directly from the database.
Be aware tho, I would recommand that you backup your database prior doing this. On 2013-01-24 3:38 AM, Saqib Haleem wrote: > Hi, I need to understand why location log entry remains open for Wireless > client. I asked this question in my last email, but did not receive any > reply.i am unable to delete any inactive node which was previously connected > through Wireless. > Regards > Saqib > ________________________________________ > From: Saqib Haleem > Sent: Tuesday, May 29, 2012 9:51 AM > To: Olivier Bilodeau; [email protected] > Subject: RE: [PacketFence-users] location log entry of wireless node could > not be removed > > Thanks for the answer. it is fulfilling my purpose. But if i want to delete > nodes. Why openlog entry remain left in database. Which trap is needed to > automatically remove the openlocation log entry so that i can easily remove > node. while deleting node i get following error in packetfence log > pfcmd(22545) WARN: [ mac ] has an open locationlog entry. Node deletion > prohibited (pf::node::node_delete) > pfcmd(22545) FATAL: Cannot delete this node since there are some records in > locationlog table indicating that this node might still be connected and > active on the network (pfcmd line 2004.) (main::command_param > However device was actually not connected to AP at that time. > if i switch my laptop from that AP to another AP then following log appears > > Info doWeActOnThisTrap returns false. Stop dot11Deauthentication handling > (main::handleTrap) > > what could be the problem? > > Regards > Saqib > ________________________________________ > From: Olivier Bilodeau [[email protected]] > Sent: Thursday, May 24, 2012 5:54 PM > To: [email protected] > Cc: Saqib Haleem > Subject: Re: [PacketFence-users] location log entry of wireless node could > not be removed > > Don't delete nodes, unregister them (change status to 'unreg'). It will > have the same effect. > > On 05/24/2012 01:17 AM, Saqib Haleem wrote: >> Hi >> Whenever i try to remove wireless node( which is no more connected on Wifi ) >> from packetfence GUI, i receive following error. >> Error: Problems executing 'PFCMD node delete >> Cannot delete this node since there are some records in locationlog table >> indicating that this node might still be connected and active on the network >> (pfcmd line 2004.) at >> /usr/lib/perl5/vendor_perl/5.8.8/Log/Log4perl/Logger.pm line 884 >> >> However i dont get any error while removing an disconnected wired node. I >> can easily delete that inactive node. Only issue with wireless nodes. Can >> any body help me, because every time i have to manually delete the mac >> address from location log table insdide mysql? >> >> Regards >> Saqib >> >> >> Disclaimer: This email and any attachments may contain confidential material >> and is solely for the use of the intended recipient(s). If you have received >> this email in error, please notify the sender immediately and delete this >> email. If you are not the intended recipient(s), you must not use, retain or >> disclose any information contained in this email. Any views or opinions are >> solely those of the sender and do not necessarily represent those of >> National Centre for Physics (NCP). NCP does accept responsibility for any >> errors or omissions that are present in the message, or any attachment, that >> have arisen as a result of email transmission. >> >> ------------------------------------------------------------------------------ >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. Discussions >> will include endpoint security, mobile security and the latest in malware >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> PacketFence-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/packetfence-users > > -- > Olivier Bilodeau > [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca > Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence > (www.packetfence.org) > > Disclaimer: This email and any attachments may contain confidential material > and is solely for the use of the intended recipient(s). If you have received > this email in error, please notify the sender immediately and delete this > email. If you are not the intended recipient(s), you must not use, retain or > disclose any information contained in this email. Any views or opinions are > solely those of the sender and do not necessarily represent those of National > Centre for Physics (NCP). NCP does accept responsibility for any errors or > omissions that are present in the message, or any attachment, that have > arisen as a result of email transmission. > > ------------------------------------------------------------------------------ > Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, > MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current > with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft > MVPs and experts. ON SALE this month only -- learn more at: > http://p.sf.net/sfu/learnnow-d2d > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users > ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
