Hi friends… i am facing a problem here….

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

ace_last_ip = ‘%{Framed-IP-Address}’ - "is always Null…."

i am executing this call in post-auth section in file: freeradius/sites-enabled/default

this is my last line inside post-auth block.

and also… i am getting a log error after any login:
Fri Jan  9 10:49:45 2015 : Auth: Login OK: [teste1] (from client Auth_PPPOE_T1 port 15728650 cli C4:6E:1F:98:1D:4F)
Fri Jan  9 10:49:45 2015 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #118
Fri Jan  9 10:49:45 2015 : Info: rlm_sql_mysql: Starting connect to MySQL server for #118
Fri Jan  9 10:49:45 2015 : Info: rlm_sql (sql): Connected new DB handle, #118
Fri Jan  9 10:49:45 2015 : Info: Allocated IP: 131.0.120.0 from db_pool   (did pppoe-1 cli C4:6E:1F:98:1D:4F port 15728650 user teste1)
Fri Jan  9 10:49:45 2015 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #117
Fri Jan  9 10:49:45 2015 : Info: rlm_sql_mysql: Starting connect to MySQL server for #117
Fri Jan  9 10:49:45 2015 : Info: rlm_sql (sql): Connected new DB handle, #117
Fri Jan  9 10:49:45 2015 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #116
Fri Jan  9 10:49:45 2015 : Info: rlm_sql_mysql: Starting connect to MySQL server for #116
Fri Jan  9 10:49:45 2015 : Info: rlm_sql (sql): Connected new DB handle, #116
Fri Jan  9 10:49:45 2015 : Error: rlm_sql_mysql: MYSQL Error: No Fields
Fri Jan  9 10:49:45 2015 : Error: rlm_sql_mysql: MYSQL error: 

MYSQL ERROR: No Fields ——— What is it ? 


Tks for your support !!!

Em 02/01/2015, à(s) 17:15, Arran Cudbard-Bell <a.cudbardb@freeradius.org> escreveu:


On 2 Jan 2015, at 13:55, Marcelo Santoro <santoro.ice@gmail.com> wrote:

Hi Friends…

i Would like to know, how to execute a SQL UPDATE command after my client Authenticate for example.

After client Authenticate… i want to execute a UPDATE command to my database sending the NAS where the client is connected… i know that this information exist in radacct, but i need this information in another table…

My RadAcct table has more than 9 millions of registers… and i don`t want to make SELECTs in this table.

post-auth {
update request {
Tmp-Integer-0 := "%{sql:UPDATE foo bar}"
}
}

Arran Cudbard-Bell <a.cudbardb@freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html