<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Oddly problem.<div><br></div><div>freeradius 2.1.12 up and running</div><div><br></div><div>authentication ntlm & sql</div><div><br></div><div>no problem to authenticate users (ntlm on AD and local on mysql ), both from radtest and from NAS work fine</div><div><br></div><div>I start to work with sql with the idea to set up some "local" users with a well defined expiration date.</div><div><br></div><div>I imposed an expiration date in radcheck table, but it seems that freeradius doesn't care….of course it's my fault</div><div><br></div><div>from radius -X I see sql user succefully authenticated but no message related with "expiration"</div><div><br></div><div>I suppose to have insert all sql directives in proper place…is anything special to be done to tell free radius to check "expiration" attribute ?</div><div><br></div><div>here dump from mysql…both paolo and pluto work</div><div><br></div><div><br></div><div><div>mysql> SELECT * FROM `radcheck` LIMIT 0,1000;</div><div>+----+----------+--------------------+----+-------------+</div><div>| id | username | attribute | op | value |</div><div>+----+----------+--------------------+----+-------------+</div><div>| 9 | paolo | Expiration | := | 04 Mar 2012 |</div><div>| 10 | pippo | Cleartext-Password | := | BvKHknVN |</div><div>| 8 | paolo | Cleartext-Password | := | paolo |</div><div>| 11 | pippo | Expiration | := | 07 Mar 2012 |</div><div>+----+----------+--------------------+----+-------------+</div><div>4 rows in set (0.00 sec)</div></div><div><br></div><div><br></div><div>Any hints ?</div><div><br></div><div>Regards,</div><div>Paolo.</div><div><br><div apple-content-edited="true">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="font-size: 12px; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>------------------------------------------------------------------------------------------------</div></div><div>Paolo Barbato</div><div><br></div><div><a href="http://www.igi.cnr.it">Consorzio RFX</a></div><div><div>corso Stati Uniti,4 </div><div>35127 Padova - Italy <span class="Apple-tab-span" style="white-space: pre; "> </span> </div><div><div>Network Administrator </div><div>phone: +39 049 8295097 fax: +39 049 8700718</div></div><div>------------------------------------------------------------------------------------------------</div></div></div></div></div></div></span></div></span></span></span></div>
</div>
<br></div></body></html>