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] :: www.inverse.ca
+1.514.447.4918 *125 :: +1 (866) 353-6153
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
On 2014-05-06, at 10:42 , "Curtis K. Larsen" <[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
