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