| # -*- text -*- |
| # |
| # $Id: b72aa309bfc05c2443e4bb2db061b8f33de8e359 $ |
| |
| # |
| # Write Chargeable-User-Identity to the database. |
| # |
| # Schema raddb/sql/cui/<DB>/schema.sql |
| # Queries raddb/sql/cui/<DB>/queries.conf |
| # |
| sql cuisql { |
| |
| # The dialect of SQL you want to use, this should usually match |
| # the driver below. |
| # |
| # If you're using rlm_sql_null, then it should be the type of |
| # database the logged queries are going to be executed against. |
| dialect = "sqlite" |
| |
| # The sub-module to use to execute queries. This should match |
| # the database you're attempting to connect to. |
| # |
| # There are CUI queries available for: |
| # * rlm_sql_mysql |
| # * rlm_sql_postgresql |
| # * rlm_sql_sqlite |
| # * rlm_sql_null (log queries to disk) |
| # |
| driver = "rlm_sql_${dialect}" |
| |
| sqlite { |
| filename = ${radacctdir}/cui.sqlite |
| bootstrap = ${modconfdir}/${..:name}/cui/sqlite/schema.sql |
| } |
| |
| # Write CUI queries to a logfile. Useful for debugging. |
| # logfile = ${logdir}/cuilog.sql |
| |
| pool { |
| start = 5 |
| min = 4 |
| max = 10 |
| spare = 3 |
| uses = 0 |
| lifetime = 0 |
| idle_timeout = 60 |
| } |
| |
| cui_table = "cui" |
| sql_user_name = "%{User-Name}" |
| |
| $INCLUDE ${modconfdir}/${.:name}/cui/${dialect}/queries.conf |
| } |