thanks Fajar, Let me give a try.
________________________________
From: Fajar A. Nugraha <l...@fajar.net>
To: john decot <johnde...@yahoo.com>; FreeRadius users mailing list
<freeradius-users@lists.freeradius.org>
Sent: Tuesday, December 6, 2011 6:38 PM
Subject: Re: Expiration email
On Tue, Dec 6, 2011 at 7:22 PM, john decot <johnde...@yahoo.com> wrote:
> Thanks for the reply. I am also trying same but couldn't compare with the
> field on the database as Expiration attribute use character value. I wish
> someone give me any idea on comparing those parameter inside database.
Several ways I can think of (completely untested):
(1) Use
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_str-to-date
(or whatever equivalent function in your db) to convert the column to
date before comparison
(2) Pick a time to alert the user (e.g. ONE WEEK before expiration),
then use whatever programming language of your choice (e.g. php) to
convert the date into the format used in expiration attribute (e.g.
using date_format). Then you only need to compare for exact string
match.
--
Fajar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
