# -*- 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
}