Freeradius-Users post from santoro.ice at gmail.com requires approval

[Marcelo Santoro]

Tks Herwin…

I am using the follow Post-Auth Command:

        update request {
                Tmp-Integer-0 := "%{sql: UPDATE acessos_clientes set con_id = (select con_id from concentradores where con_ip = '%{Nas-IP-Address}'), ace_last_ip = '%{reply:Framed-IP-Address}' where ace_login = '%{SQL-User-Name}'}"
        }


Do you know the syntax to call a perl script ? … i can write a perl script to do this update in my MySQL and make the perl script return 0 :)

Tks for your help Friend.

Best Regards.



> Em 12/01/2015, à(s) 11:18, Herwin Weststrate <herwin at quarantainenet.nl> escreveu:
> 
> On 12-01-15 14:07, Marcelo Santoro wrote:
>> Hello Arran…
>> 
>> As you say to me… i updated my FreeRadius to 3.0.6 and The SQL Error still there…
>> 
>> rlm_sql (sql): Executing query: ' UPDATE acessos_clientes set con_id = (select con_id from concentradores where con_ip = '10.0.0.2'), ace_last_ip = '131.0.120.0' where ace_login = 'teste1''
>> rlm_sql_mysql: Rows matched: 1  Changed: 1  Warnings: 0
>> rlm_sql_mysql: MYSQL Error: No Fields
>> rlm_sql_mysql: MYSQL error: 
>> ERROR: (2)       SQL query failed
>> rlm_sql (sql): Released connection (20)
>> (2)       EXPAND %{sql: UPDATE acessos_clientes set con_id = (select con_id from concentradores where con_ip = '%{Nas-IP-Address}'), ace_last_ip = '%{reply:Framed-IP-Address}' where ace_login = '%{SQL-User-Name}'}
>> (2)          --> 
>> (2)       Tmp-Integer-0 := 0
>> (2)     } # update request = noop
>> (2)   } # post-auth = ok
> 
> It looks like the SQL xlat requires the query to return something to run
> without errors. Postgresql has a possibility to add "RETURNING 0" to the
> query to make it return something, tha would silence the warnings. I've
> got no idea if something similar is possible in Mysql.
> 
> -- 
> Herwin Weststrate
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html