raddb/mods-config/sql/moonshot-targeted-ids/postgresql/queries.conf


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

# -*- text -*-
#
#  moonshot-targeted-ids/postgresql/queries.conf -- Queries to update a PostgreSQL Moonshot-*-Targeted-Ids table.
#
#  $Id$

post-auth {
	#  Query to store the Moonshot-*-TargetedId
	query = "\
		INSERT INTO ${..moonshot_tid_table} \
			(gss_acceptor, namespace, username, targeted_id) \
		VALUES \
			('%{control:Moonshot-MSTID-GSS-Acceptor}', '%{control:Moonshot-MSTID-Namespace}', \
			'%{tolower:%{User-Name}}', '%{control:Moonshot-MSTID-TargetedId}')"
}