Expiration Value

Ivan Kalik tnt at kalik.net
Mon Feb 25 14:54:24 CET 2008


The one you have there in the text.

Ivan Kalik
Kalik Informatika ISP


Dana 25/2/2008, "Tim White" <weirdit at gmail.com> piše:

>So you maintain to instances of this value?
>Once in radcheck, and once in an external table? The first instance, in 
>radcheck, what format do you have that in?
>
>
>Thanks
>
>Tim
>
>Ivan Kalik wrote:
>> We don't do these checks on radius database at all. We have a billing
>> database with users details which has value of this attribute in
>> datetime format and checks are done there.
>>
>> Ivan Kalik
>> Kalik Informatika ISP
>>
>>
>> Dana 25/2/2008, "Tim White" <weirdit at gmail.com> piše:
>>
>>   
>>> I'm attempting to use Expiration to expire user accounts after a set
>>> time period. What format does the Date/Time (Value field) have to be?
>>> From what I can see it's in the format of "Monthname Day Year
>>> Hour:Min:Sec". So for example "March 24 2008 00:00:00". But it appears
>>> that in this format you can't use normal SQL datetime operators to see
>>> if it's expired (for example, to run a SQL query to remove all expired
>>> accounts).
>>>
>>> Can someone who has it working please let me know what format they use
>>> for Expiration value, and how they can use MySQL comparison operators
>>> with it?
>>>
>>> (Ether 2.0.2 or 1.1.7).
>>>
>>> Thanks
>>>
>>> Tim
>>>
>>> -
>>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
>>>
>>>
>>>     
>>
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>   
>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>




More information about the Freeradius-Users mailing list