Add SQL backing to Moonshot-*-TargetedId generation. Added three attributes for gener...
[freeradius.git] / raddb / mods-available / moonshot-targeted-ids
1 # -*- text -*-
2 #
3 #  $Id$
4
5 #
6 #  Write Moonshot-*-TargetedId to the database.
7 #
8 #  Schema       raddb/sql/moonshot-targeted-ids/<DB>/schema.sql
9 #  Queries      raddb/sql/moonshot-targeted-ids/<DB>/queries.conf
10 #
11 sql moonshot_tid_sql {
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}/moonshot-targeted-ids.sqlite
33                 bootstrap = ${modconfdir}/${..:name}/moonshot-targeted-ids/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         moonshot_tid_table = "moonshot-targeted-ids"
50         sql_user_name = "%{User-Name}"
51
52         $INCLUDE ${modconfdir}/${.:name}/moonshot-targeted-ids/${dialect}/queries.conf
53 }