sql insert via unlang

Ivan Kalik tnt at kalik.net
Thu Jun 19 23:29:57 CEST 2008


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 at 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
>
>




More information about the Freeradius-Users mailing list