<div dir="ltr">Hi Phil,<div><br></div><div>I am getting value from the first query </div><div><br></div><div>Heres my debug log, I have highlighted the required queries </div><div><br></div><div><br></div><div><div># Executing section authorize from file /etc/freeradius/sites-enabled/default</div><div>+- entering group authorize {...}</div><div>++[preprocess] returns ok</div><div>[chap] Setting 'Auth-Type := CHAP'</div><div>++[chap] returns ok</div><div>++[mschap] returns noop</div><div>++[digest] returns noop</div><div>[suffix] No '@' in User-Name = "14-F6-5A-F0-80-61-0000000010", looking up realm NULL</div><div>[suffix] No such realm "NULL"</div><div>++[suffix] returns noop</div><div>[eap] No EAP-Message, not doing EAP</div><div>++[eap] returns noop</div><div>++[files] returns noop</div><div>[sql] expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010</div><div>[sql] sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'</div><div>rlm_sql (sql): Reserving sql socket id: 4</div><div>[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '14-F6-5A-F0-80-61-0000000010' ORDER BY id</div><div>[sql] User found in radcheck table</div><div>[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '14-F6-5A-F0-80-61-0000000010' ORDER BY id</div><div>[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '14-F6-5A-F0-80-61-0000000010' ORDER BY priority</div><div>rlm_sql (sql): Released sql socket id: 4</div><div>++[sql] returns ok</div><div>++[expiration] returns noop</div><div>++[logintime] returns noop</div><div>[pap] WARNING: Auth-Type already set. Not setting to PAP</div><div>++[pap] returns noop</div><div>sql_xlat</div><div> expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010</div><div>sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'</div><div> expand: select id from radcheck where username='%{User-Name}' order by id desc limit 1 -> select id from radcheck where username='14-F6-5A-F0-80-61-0000000010' order by id desc limit 1</div><div>rlm_sql (sql): Reserving sql socket id: 3</div><div>sql_xlat finished</div><div>rlm_sql (sql): Released sql socket id: 3</div><div><b><br></b></div><div><b><br></b></div><div><b> expand: %{sql: select id from radcheck where username='%{User-Name}' order by id desc limit 1} -> 24</b></div><div><br></div><div><br></div><div>++[control] returns noop</div><div>sql_xlat</div><div> expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010</div><div>sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'</div><div><b><br></b></div><div><b> expand: select ExpiryDate from radcheck where id = '%{My-Local-Int-1}' -> select ExpiryDate from radcheck where id = ' '</b></div><div><br></div><div>rlm_sql (sql): Reserving sql socket id: 2</div><div>SQL query did not return any results</div><div>rlm_sql (sql): Released sql socket id: 2</div><div><b><br></b></div><div><b> expand: %{sql: select ExpiryDate from radcheck where id = '%{My-Local-Int-1}'} -> </b></div><div><br></div><div><br></div><div>++[reply] returns noop</div><div>Found Auth-Type = CHAP</div><div># Executing group from file /etc/freeradius/sites-enabled/default</div><div>+- entering group CHAP {...}</div><div>[chap] login attempt by "14-F6-5A-F0-80-61-0000000010" with CHAP password</div><div>[chap] Using clear text password "14-F6-5A-F0-80-61-0000000010" for user 14-F6-5A-F0-80-61-0000000010 authentication.</div><div>[chap] chap user 14-F6-5A-F0-80-61-0000000010 authenticated succesfully</div><div>++[chap] returns ok</div><div># Executing section post-auth from file /etc/freeradius/sites-enabled/default</div><div>+- entering group post-auth {...}</div><div>[sql] expand: %{User-Name} -> 14-F6-5A-F0-80-61-0000000010</div><div>[sql] sql_set_user escaped user --> '14-F6-5A-F0-80-61-0000000010'</div><div>[sql] expand: %{User-Password} -> </div><div>[sql] ... expanding second conditional</div><div>[sql] expand: %{Chap-Password} -> 0x00d3c7d69aaad14438d01478ad05d2ad00</div></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 6, 2014 at 6:07 PM, Phil Mayers <span dir="ltr"><<a href="mailto:p.mayers@imperial.ac.uk" target="_blank">p.mayers@imperial.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 06/11/14 12:27, Mrinal K wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
The username I am testing with has ExpiryDate value in radcheck table,<br>
however mysql query log shows me blank value for '%{My-Local-Int-1}'<br>
for query in update reply {.. } section.<br>
</blockquote>
<br></span>
Your SQL query returned no rows.<br>
<br>
Run "radiusd -X" and look at the debug. It will show you want is going on.<br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/<u></u>list/users.html</a><br>
</blockquote></div><br></div>