Re: [PacketFence-users] database backup/maint script closes all location log?

2016-04-08 Thread Durand fabrice 
You know what, you save my day since i didn't understand why i lost all 
my voip device in the locationlog.

Thanks again :-)


Le 2016-04-08 18:36, Tim DeNike a écrit :
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 > 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 
-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 > 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-
date, so its matching those as records to delete.

On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike 
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 list
PacketFence-users@lists.sourceforge.net
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
PacketFence-users@lists.sourceforge.net 


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
PacketFence-users@lists.sourceforge.net
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
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] database backup/maint script closes all location log?

2016-04-08 Thread Tim DeNike 
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  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 -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  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- date, so its
> matching those as records to delete.
>
> On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike < 
> tim.den...@mcc.edu> 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
listPacketFence-users@lists.sourceforge.nethttps://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
PacketFence-users@lists.sourceforge.net
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
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] database backup/maint script closes all location log?

2016-04-08 Thread Durand fabrice 

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 -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 > 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- date,
so its matching those as records to delete.

On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike mailto:tim.den...@mcc.edu>> 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 list
PacketFence-users@lists.sourceforge.net
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
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] database backup/maint script closes all location log?

2016-04-07 Thread Tim DeNike 
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- date, so its
matching those as records to delete.

On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike  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 list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] database backup/maint script closes all location log?

2016-04-07 Thread Tim DeNike 
Same goes for the radacct line.

On Thu, Apr 7, 2016 at 9:01 PM, Tim DeNike  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- date, so its
> matching those as records to delete.
>
> On Thu, Apr 7, 2016 at 8:42 PM, Tim DeNike  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 list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

[PacketFence-users] database backup/maint script closes all location log?

2016-04-07 Thread Tim DeNike 
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 list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users