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@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