Chetan Gaonker | 7f4bf74 | 2016-05-04 15:56:08 -0700 | [diff] [blame] | 1 | # -*- text -*- |
| 2 | # |
| 3 | # $Id: b72aa309bfc05c2443e4bb2db061b8f33de8e359 $ |
| 4 | |
| 5 | # |
| 6 | # Write Chargeable-User-Identity to the database. |
| 7 | # |
| 8 | # Schema raddb/sql/cui/<DB>/schema.sql |
| 9 | # Queries raddb/sql/cui/<DB>/queries.conf |
| 10 | # |
| 11 | sql cuisql { |
| 12 | |
| 13 | # The dialect of SQL you want to use, this should usually match |
| 14 | # the driver below. |
| 15 | # |
| 16 | # If you're using rlm_sql_null, then it should be the type of |
| 17 | # database the logged queries are going to be executed against. |
| 18 | dialect = "sqlite" |
| 19 | |
| 20 | # The sub-module to use to execute queries. This should match |
| 21 | # the database you're attempting to connect to. |
| 22 | # |
| 23 | # There are CUI queries available for: |
| 24 | # * rlm_sql_mysql |
| 25 | # * rlm_sql_postgresql |
| 26 | # * rlm_sql_sqlite |
| 27 | # * rlm_sql_null (log queries to disk) |
| 28 | # |
| 29 | driver = "rlm_sql_${dialect}" |
| 30 | |
| 31 | sqlite { |
| 32 | filename = ${radacctdir}/cui.sqlite |
| 33 | bootstrap = ${modconfdir}/${..:name}/cui/sqlite/schema.sql |
| 34 | } |
| 35 | |
| 36 | # Write CUI queries to a logfile. Useful for debugging. |
| 37 | # logfile = ${logdir}/cuilog.sql |
| 38 | |
| 39 | pool { |
| 40 | start = 5 |
| 41 | min = 4 |
| 42 | max = 10 |
| 43 | spare = 3 |
| 44 | uses = 0 |
| 45 | lifetime = 0 |
| 46 | idle_timeout = 60 |
| 47 | } |
| 48 | |
| 49 | cui_table = "cui" |
| 50 | sql_user_name = "%{User-Name}" |
| 51 | |
| 52 | $INCLUDE ${modconfdir}/${.:name}/cui/${dialect}/queries.conf |
| 53 | } |