When I do

delete from node where status="unreg" AND detect_date <= NOW();

I get ' ERROR 1146 (42S02): Table 'pf.node_useragent' doesn't exist'

If I do

show tables from pf

I see node and node_category but that is all.

Did I miss a schema update somewhere?

Mark


-----Original Message-----
From: Mark Holmes [mailto:[email protected]]
Sent: 06 July 2012 13:57
To: [email protected]
Subject: Re: [PacketFence-users] expire.node

>Anyway, I am not even sure this expire is working for VLAN mode.  I think it 
>was only designed for ARP mode.

Ah, I'll leave that then.  I am looking for a way to clear some nodes out as 
for some reason I have 65000+ rows in the nodes table (I don't know how as we 
only have 500 or so devices on the network...), but from looking around it 
seems this is problematic with VLAN isolation mode.

In the bug tracking system I have seen 0000887 which is still open so I suppose 
there is no way to remove nodes yet?

Mark






-----Original Message-----
From: Francois Gaudreault [mailto:[email protected]]
Sent: 06 July 2012 13:51
To: [email protected]
Subject: Re: [PacketFence-users] expire.node

Hi,

I am not able to reproduce, I set in pf.conf:

[expire]
node = 180D

Running the checkup will pass.  Anyway, I am not even sure this expire is 
working for VLAN mode.  I think it was only designed for ARP mode.

On 12-07-06 6:20 AM, Mark Holmes wrote:
> I just set expire.node=180D in pf.conf
>
> When I start PacketFence I get
>
> FATAL - pf.conf value expire.node does not explicity define interval
> (eg. 7200s, 120m, 2h) - please define it before running packetfence
>
> What have I missed?
>
> Thanks,
>
> Mark
>
> Nuffield College is a Registered Charity No. 1137506. Registered
> Office: Nuffield College, New Road, Oxford, OX1 1NF
>
> ----------------------------------------------------------------------
> --------
> 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
>


--
Francois Gaudreault, ing. jr
[email protected]  ::  +1.514.447.4918 (x130) ::  www.inverse.ca Inverse 
inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)

------------------------------------------------------------------------------
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

Nuffield College is a Registered Charity No. 1137506. Registered Office: 
Nuffield College, New Road, Oxford, OX1 1NF

------------------------------------------------------------------------------
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

Nuffield College is a Registered Charity No. 1137506. Registered Office: 
Nuffield College, New Road, Oxford, OX1 1NF

------------------------------------------------------------------------------
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

Reply via email to