mysql syntax error. You probably want test.logs.description. You should test those statements on the database before putting them into the configuration. Ivan Kalik Kalik Informatika ISP Dana 19/6/2008, "Flamur Rogova" <flamur@ipko.net> piše:
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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html