Hi Mark, On 12-07-06 9:13 AM, Mark Holmes wrote: > 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? Yes. You likely have a missing table/tables in the schema. This table has been introduced back in upgrade-2.0.0-2.2.0.sql.
> > 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 > > -- 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
