That did the trick .
Thanks,
Curtis
________________________________
From: Louis Munro [[email protected]]
Sent: Tuesday, May 06, 2014 9:27 AM
To: [email protected]
Subject: Re: [PacketFence-users] Deleting a Node / User
Hi Curtis,
You have an error in your SQL.
Try this instead:
mysql> delete from node where mac = '00:11:22:33:44:55';
Make sure you put in the ":" in the mac address.
You may have to go and delete the entries from the locationlog table first
though.
If that's the case, do it like this:
mysql> delete from locationlog where mac = '00:11:22:33:44:55';
Of course, you may want to make sure you are going to delete what you think you
are.
I personally just run a "select count(*)" on the relevant tables when in doubt.
The number of rows returned should make sense.
If it is much higher than expected, think twice before running the delete.
E.g.
mysql> select count(*) from node where mac = '00:11:22:33:44:55';
and
mysql> select count(*) from locationlog where mac = '00:11:22:33:44:55';
Regards,
--
Louis Munro
[email protected]<mailto:[email protected]> ::
www.inverse.ca<http://www.inverse.ca>
+1.514.447.4918 *125 :: +1 (866) 353-6153
Inverse inc. :: Leaders behind SOGo (www.sogo.nu<http://www.sogo.nu>) and
PacketFence (www.packetfence.org<http://www.packetfence.org>)
On 2014-05-06, at 10:42 , "Curtis K. Larsen"
<[email protected]<mailto:[email protected]>> wrote:
Sometimes I need to create dummy "nodes", and or dummy "users" for testing, or
for demonstrating PacketFence functionality to various delegated
administrators, or the help desk.
In this case it becomes necessary to completely delete the dummy node/user from
the database afterward.
If I try it from the GUI it gives the following error: Error! The node can't
be delete because it's still active.
So I try from the CLI:
mysql -p -u pf pf
mysql> delete mac from node where mac = '001122334455';
But I get the error below:
ERROR 1109 (42S02): Unknown table 'mac' in MULTI DELETE
Does anyone know a better method?
Thanks,
Curtis Larsen
University of Utah
Wireless Network Engineer
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
