sql insert via unlang

Flamur Rogova flamur at ipko.net
Thu Jun 19 22:42:46 CEST 2008


Hi,

I have a couple of modules in this order, and I need to log only 
rejects(from each module) to sql,
- check_password, "a1   User-Password := "a1"
- check_maxoctets, "a1  Max-All-Octets := 100000"

in my authorize section, I have this,
...
check_password
if(notfound) {
     # log notfound to sql, the line below gives error...
     "%{sql: INSERT INTO test.logs SET test.logs.user='%{User-Name}', 
test.description='user not found' }"
}
check_maxoctets
if(reject) {
     # log to sql...
}
...


When I start radiusd, it gives:
...
rlm_fastusers:  Loaded 3 users and 1 defaults
/home/radius205/etc/raddb/sites-enabled/default[99]: Failed to find 
module "%{sql: INSERT INTO test.logs SET test.logs.user='%{User-Name}', 
test.description='user not found' }".
/home/radius205/etc/raddb/sites-enabled/default[99]: Failed to parse 
"%{sql: INSERT INTO test.logs SET test.logs.user='%{User-Name}', 
test.description='user not found' }" entry.
/home/radius205/etc/raddb/sites-enabled/default[62]: Errors parsing 
authorize section.
  }
}
Errors initializing modules
...


man unlang says it is possible to obtain results from db, but I need to 
execute only sql INSERT,
is my syntax wrong ?

Thanks,
Flamur



More information about the Freeradius-Users mailing list