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