<div dir="ltr">Hello<div>i am getting an issue with xlat</div><div><br></div><div><p style="margin-right:0px;margin-bottom:15px;margin-left:0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251);margin-top:0px!important">
i tried this</p><p style="margin:15px 0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251)">sql sql2 {</p><p style="margin:15px 0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251)">
}</p><p style="margin:15px 0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251)">sql sql_gowifi{<br>sql_user_name = "%{sql2:select s.* from (select <a href="https://github.com/user" class="" style="margin:0px;padding:0px;border:0px;color:rgb(51,51,51);text-decoration:none;font-weight:bold">@user</a>:=BINARY '%{User-Name}' p) parm , upm s}"<br>
}</p><p style="margin:15px 0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251)">and using sql_gowifi in sites-enabled/default for mysql based login and accounting</p>
<p style="margin:15px 0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251)">again when using sql_user_name = "%{User-Name}" it saves the username entered in login page of hotspot to radpostauth table but with the code above the username remains blank</p>
<p style="margin-top:15px;margin-right:0px;margin-left:0px;padding:0px;border:0px;color:rgb(51,51,51);font-family:Helvetica,arial,freesans,clean,sans-serif;font-size:13px;line-height:22px;background-color:rgb(251,251,251);margin-bottom:0px!important">
when i run the sql query above in mysql server it returns the correct username please help</p>
</div></div>