summaryrefslogtreecommitdiffstats
path: root/raddb/mods-available/sql_map
blob: 93b26362ecfa56c040d26d7d4eb3950c80ebb9df (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
#  Configuration for the SQL based Map (rlm_sql_map)
sql_map {
	# SQL instance to use (from mods-available/sql)
	#
	#  If you have multiple sql instances, such as "sql sql1 {...}",
	#  use the *instance* name here: sql1.
	sql_module_instance = "sql"

	#  This is duplicative of info available in the SQL module, but
	#  we have to list it here as we do not yet support nested
	#  reference expansions.
	dialect = "mysql"

	# Name of the check item attribute to be used as a key in the SQL queries
	query = "SELECT ... FROM ... "

	#
	#  Mapping of SQL columns to RADIUS dictionary attributes.
	#

	#  WARNING: Although this format is almost identical to the unlang
	#  update section format, it does *NOT* mean that you can use other
	#  unlang constructs in module configuration files.
	#
	#  Configuration items are in the format:
	# 	<radius attr> <op> <sql column number>
	#
	#  Where:
	#  	<radius attr>:	Is the destination RADIUS attribute
	# 			with any valid list and request qualifiers.
	#  	<op>: 		Is any assignment attribute (=, :=, +=, -=).
	#  	<column num>:	The column number (not name), starting from 0
	#
	#  Request and list qualifiers may also be placed after the 'update'
	#  section name to set defaults destination requests/lists
	#  for unqualified RADIUS attributes.
	#
	update {
		control:Password-With-Header	+= 0
#		control:NT-Password		:= 1
#		reply:Reply-Message		:= 2
#		reply:Tunnel-Type		:= 3
#		reply:Tunnel-Medium-Type	:= 4
#		reply:Tunnel-Private-Group-ID	:= 5
	}

	# If the 'query' results in multiple rows, it creates the <radius attr>[*] array entry.
#	multiple_rows = yes
}