Freeradius-Users post from santoro.ice at gmail.com requires approval
Marcelo Santoro
santoro.ice at gmail.com
Mon Jan 12 14:37:02 CET 2015
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
More information about the Freeradius-Users
mailing list