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
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
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
The one you have there in the text. Ivan Kalik Kalik Informatika ISP Dana 25/2/2008, "Tim White" <weirdit@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@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
I tried with classic format YYYY-MM-DD but it doesn't work. Tim White wrote:
Ivan Kalik wrote:
The one you have there in the text.
Bummer. Does anyone know how to get a format that doesn't use Words (month Name)?
Thanks
Tim - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
Tim White wrote:
Bummer. Does anyone know how to get a format that doesn't use Words (month Name)?
Edit src/lib/print.c to print dates in a different format. Or, make a suggestion for the format you like...
hmm, a feature request? what variable in the config though? print_time ? print_time = human print_time = UTC print_time = unix ? alan
Well what problem do you have with this format? Best regards On Tue, Feb 26, 2008 at 10:21 AM, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
Tim White wrote:
Bummer. Does anyone know how to get a format that doesn't use Words (month Name)?
Edit src/lib/print.c to print dates in a different format. Or, make a suggestion for the format you like...
hmm, a feature request? what variable in the config though? print_time ?
print_time = human print_time = UTC print_time = unix ?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
The format isn't easily sortable or useable in a SQL compare operation. It also requires slightly more work to generate. The simple format of "YYYY-MM-DD HH:MM:SS" makes more sense to me. It is easily human readable, and is also easily machine readable, isn't locale or language dependent. Basically, it means that to do any operations on the table regarding the Expiration date, where I only want dates between a range, I have to get all dates, and sort them outside of SQL. I'm not sure if print.c is the right place for this, but I've not had a chance to look at the code. Tim Marinko Tarlac wrote:
Well what problem do you have with this format?
Best regards
On Tue, Feb 26, 2008 at 10:21 AM, <A.L.M.Buxey@lboro.ac.uk <mailto:A.L.M.Buxey@lboro.ac.uk>> wrote:
Hi, > Tim White wrote: > > Bummer. Does anyone know how to get a format that doesn't use Words > > (month Name)? > > Edit src/lib/print.c to print dates in a different format. Or, make a > suggestion for the format you like...
hmm, a feature request? what variable in the config though? print_time ?
print_time = human print_time = UTC print_time = unix ?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Well here is how I did it. I have one table (users) and inside that table I have a field for expiration in YYYY-MM-DD format. When I check option to control this date, I transfer this date in radcheck table but before that I convert it in format we spoke about. Here is query how to do it. SELECT DATE_FORMAT( `ex_date` , '%M %d %Y %H:%i:%s' ) AS ex_date FROM users WHERE user='some_user'; Tim White wrote:
The format isn't easily sortable or useable in a SQL compare operation. It also requires slightly more work to generate. The simple format of "YYYY-MM-DD HH:MM:SS" makes more sense to me. It is easily human readable, and is also easily machine readable, isn't locale or language dependent.
Basically, it means that to do any operations on the table regarding the Expiration date, where I only want dates between a range, I have to get all dates, and sort them outside of SQL.
I'm not sure if print.c is the right place for this, but I've not had a chance to look at the code.
Tim
Marinko Tarlac wrote:
Well what problem do you have with this format?
Best regards
On Tue, Feb 26, 2008 at 10:21 AM, <A.L.M.Buxey@lboro.ac.uk <mailto:A.L.M.Buxey@lboro.ac.uk>> wrote:
Hi, > Tim White wrote: > > Bummer. Does anyone know how to get a format that doesn't use Words > > (month Name)? > > Edit src/lib/print.c to print dates in a different format. Or, make a > suggestion for the format you like...
hmm, a feature request? what variable in the config though? print_time ?
print_time = human print_time = UTC print_time = unix ?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (5)
-
A.L.M.Buxey＠lboro.ac.uk -
Alan DeKok -
Ivan Kalik -
Marinko Tarlac -
Tim White