"Fossies" - the Fresh Open Source Software Archive

Member "freeradius-server-3.0.23/raddb/mods-available/sql_map" (10 Jun 2021, 1613 Bytes) of package /linux/misc/freeradius-server-3.0.23.tar.bz2:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. See also the latest Fossies "Diffs" side-by-side code changes report for "sql_map": 3.0.22_vs_3.0.23.

    1 #  Configuration for the SQL based Map (rlm_sql_map)
    2 sql_map {
    3 	# SQL instance to use (from mods-available/sql)
    4 	#
    5 	#  If you have multiple sql instances, such as "sql sql1 {...}",
    6 	#  use the *instance* name here: sql1.
    7 	sql_module_instance = "sql"
    8 
    9 	#  This is duplicative of info available in the SQL module, but
   10 	#  we have to list it here as we do not yet support nested
   11 	#  reference expansions.
   12 	dialect = "mysql"
   13 
   14 	# Name of the check item attribute to be used as a key in the SQL queries
   15 	query = "SELECT ... FROM ... "
   16 
   17 	#
   18 	#  Mapping of SQL columns to RADIUS dictionary attributes.
   19 	#
   20 
   21 	#  WARNING: Although this format is almost identical to the unlang
   22 	#  update section format, it does *NOT* mean that you can use other
   23 	#  unlang constructs in module configuration files.
   24 	#
   25 	#  Configuration items are in the format:
   26 	# 	<radius attr> <op> <sql column number>
   27 	#
   28 	#  Where:
   29 	#  	<radius attr>:	Is the destination RADIUS attribute
   30 	# 			with any valid list and request qualifiers.
   31 	#  	<op>: 		Is any assignment attribute (=, :=, +=, -=).
   32 	#  	<column num>:	The column number (not name), starting from 0
   33 	#
   34 	#  Request and list qualifiers may also be placed after the 'update'
   35 	#  section name to set defaults destination requests/lists
   36 	#  for unqualified RADIUS attributes.
   37 	#
   38 	update {
   39 		control:Password-With-Header	+= 0
   40 #		control:NT-Password		:= 1
   41 #		reply:Reply-Message		:= 2
   42 #		reply:Tunnel-Type		:= 3
   43 #		reply:Tunnel-Medium-Type	:= 4
   44 #		reply:Tunnel-Private-Group-ID	:= 5
   45 	}
   46 
   47 	# If the 'query' results in multiple rows, it creates the <radius attr>[*] array entry.
   48 #	multiple_rows = yes
   49 }