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

Herwin Weststrate herwin at quarantainenet.nl
Mon Jan 12 14:18:18 CET 2015


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



More information about the Freeradius-Users mailing list