...or if you're feeling lazy and know Perl, rlm_perl is an exellent tool to make your own policy decisions (as you can configure perl to talk to your mysql database).<br><br>Hope this helps,<br><br>Jan<br><br><div><span class="gmail_quote">
On 11/05/07, <b class="gmail_sendername">Marc Miranda (GOWEX)</b> <<a href="mailto:mmiranda@iber-x.com">mmiranda@iber-x.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" lang="ES">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB">Take a look at
rlm_counter/rlm_sqlcounter (I don't know if it's exactly what you are looking
for) or if you don't want to complicate, just work with a database logic and change
the radius auth queries depending on certain timestamps and NOW(), for example,
in the case of MySQL, in sql.conf.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB">I'm not a guru, but it
can be useful for starting looking for some of the options… </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;" lang="EN-GB"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">De:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
freeradius-users-bounces+mmiranda=<a href="mailto:iber-x.com@lists.freeradius.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">iber-x.com@lists.freeradius.org</a>
[mailto:<a href="mailto:freeradius-users-bounces+mmiranda=iber-x.com@lists.freeradius.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">freeradius-users-bounces+mmiranda=iber-x.com@lists.freeradius.org
</a>] <b><span style="font-weight: bold;">En nombre de </span></b>Aren Chua<br>
<b><span style="font-weight: bold;">Enviado el:</span></b> viernes, 11 de mayo de
2007 12:35<br>
<b><span style="font-weight: bold;">Para:</span></b> <a href="mailto:freeradius-users@lists.freeradius.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">freeradius-users@lists.freeradius.org</a>
<br>
<b><span style="font-weight: bold;">Asunto:</span></b> One day user account</span></font></p>
</div><div><span class="e" id="q_1127ac7ce28cc2b9_1">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> </span></font></p>
</div>
<div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">Hi All,</span></font></p>
</div>
<div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> </span></font></p>
</div>
<div>
<p style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><font color="#444444" face="Times New Roman" size="3">
<span style="font-size: 12pt; color: rgb(68, 68, 68);">I would
like to create a user account which only allow user to use for 1 day. Once the
user has been authenticated, the time will be start counting and ended after 24
hours. Although the user didn't fully used up their session time, radius still
will reject user to login. </span></font></p>
<p style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><font color="#444444" face="Times New Roman" size="3">
<span style="font-size: 12pt; color: rgb(68, 68, 68);"> </span></font></p>
<p style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><font color="#444444" face="Times New Roman" size="3">
<span style="font-size: 12pt; color: rgb(68, 68, 68);">Can any
expert give me some suggestion on how to create this user account?</span></font></p>
<p style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><font color="#444444" face="Times New Roman" size="3">
<span style="font-size: 12pt; color: rgb(68, 68, 68);"> </span></font></p>
<p style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><font color="#444444" face="Times New Roman" size="3">
<span style="font-size: 12pt; color: rgb(68, 68, 68);">Thanks</span></font></p>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> </span></font></p>
</div>
<div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">Regards,</span></font></p>
</div>
<div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">Aren Chua</span></font></p>
</div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;"> </span></font></p>
<div style="text-align: center;" align="center"><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">Download Messenger. Start an i'm conversation. Support a
cause. <a href="http://im.live.com/messenger/im/home/?source=TAGWL_MAY07" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Join Now!</a></span></font></p>
</span></div></div>
</div>
<br>-<br>List info/subscribe/unsubscribe? See <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br></blockquote>
</div><br>