Re: [Packetfence-users] Violation Table

[Bulanda, D. G <DGB...@in...>]

Ok I came back after a while and the 1 system that was registered is no longer registered. I can look the node up and see it's  status is unreg. When I look at the violations there are none. There were 3 rows. I have check the time on the machine to make sure that it is correct and it is. 



David Bulanda
Network Services Manager
Indiana Tech
dgb...@in...
 
 

-----Original Message-----
From: Regis Balzard [mailto:rba...@in...] 
Sent: Tuesday, August 26, 2008 11:11 AM
To: Bulanda, Dave G
Cc: pac...@li...
Subject: Re: [Packetfence-users] Violation Table

Dave,

Could you please do the following test ? Connect to your MySQL database 
and execute the  following query:
select mac from node where last_arp < unix_timestamp(now()) and  last_arp!=0
This should return 'something', including a warning since the column 
type is not the same (datetime vs unix_timestamp).

If you obtain the warning, edit /usr/local/pf/lib/pf/node.pm and replace 
(line 59):
$node_expire_lastarp_sql=$dbh->prepare ( qq [ select mac from node 
where last_arp < (unix_timestamp(now()) - ?) and last_arp!=0 ]);

by:
$node_expire_lastarp_sql=$dbh->prepare ( qq [ select mac from node 
where unix_timestamp(last_arp) < (unix_timestamp(now()) - ?) and 
last_arp!=0 ]);

The problem should disappear.

Please let me know how it goes.

Regis Balzard

rba...@in...  ::  +1.514.755.3650  ::  http://www.inverse.ca


Bulanda, Dave G wrote:
> I’ve been running version 1.6 for the last year or so. Recently the 
> violation table has been getting erase at random. Which is causing 
> re-registrations. Does anyone have a place to start looking?
> 
>  
> 
> Thanks
> 
>  
> 
> David Bulanda
> 
> Network Services Manager
> 
> Indiana Tech <http://www.indianatech.edu/>
> 
> dgb...@in... <mailto:dgb...@in...>
> 
>  
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Packetfence-users mailing list
> Pac...@li...
> https://lists.sourceforge.net/lists/listinfo/packetfence-users