I was shooting from the hip and guessed for radacct. It might not be the
case. But if all entries are actual dates then the additional condition is
just bloat, right? ;)
Sent from my iPhone
On Apr 8, 2016, at 6:26 PM, Durand fabrice <[email protected]> wrote:
Hello Tim,
i did the change in devel (
https://github.com/inverse-inc/packetfence/commit/d5be7d2a0eed379719a316441d0190222641cb9e)
but just for locationlog since i am not able to validate it for radacct.
Do you have any entry in radacct with the end time like that 0000-00-00
00:00:00 ?
Regards
Fabrice
Le 2016-04-07 21:07, Tim DeNike a écrit :
Same goes for the radacct line.
On Thu, Apr 7, 2016 at 9:01 PM, Tim DeNike <[email protected]> wrote:
> Im thinking this:
>
> /usr/local/pf/addons/database-cleaner.pl --table=locationlog
> --date-field=end_time --older-than="1 WEEK"
> --additionnal-condition="(end_time IS NOT NULL OR end_time <> 0)"
>
> should be this:
>
> /usr/local/pf/addons/database-cleaner.pl --table=locationlog
> --date-field=end_time --older-than="1 WEEK"
> --additionnal-condition="(end_time <> 0)"
>
> When doing an SQL query, is not null matches the 00-00-0000 date, so its
> matching those as records to delete.
>
> On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike < <[email protected]>
> [email protected]> wrote:
>
>> PF 5.7. Running the DB maint script seems to close out all location log
>> entries instead of purging out old entries.
>>
>> Unless I'm doing something wrong?
>>
>
>
------------------------------------------------------------------------------
_______________________________________________
PacketFence-users mailing
[email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers
of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
