Mysql xlat help

[Arran Cudbard-Bell]

On 14 Jun 2013, at 18:22, Go WiFi <info at gowifi.in> wrote:

> Hello
> i am getting an issue with xlat
> 
> i tried this
> 
> sql sql2 {
> 
> }
> 
> sql sql_gowifi{
> sql_user_name = "%{sql2:select s.* from (select @user:=BINARY '%{User-Name}' p) parm , upm s}"
> }
> 
> and using sql_gowifi in sites-enabled/default for mysql based login and accounting
> 
> 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
> 
> when i run the sql query above in mysql server it returns the correct username please help

Post full config for the sql module (sans queries) and debug output. Please.

-Arran

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS Development Team