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@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/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html