From 8b0b07f8a127294999cfb48a17cb81c09a0ead82 Mon Sep 17 00:00:00 2001 From: Sylph Lin Date: Fri, 13 Jun 2014 10:18:29 +0000 Subject: [PATCH] Add postauth_query for mssql --- raddb/sql/mssql/dialup.conf | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/raddb/sql/mssql/dialup.conf b/raddb/sql/mssql/dialup.conf index e8c1f7caf2..9b8c547486 100644 --- a/raddb/sql/mssql/dialup.conf +++ b/raddb/sql/mssql/dialup.conf @@ -91,3 +91,16 @@ # removed. These fields are processing by a database accounting_stop_query_alt = "INSERT into ${acct_table2} (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPort, NASPortType, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}', '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time:-0}')" + ####################################################################### + # Authentication Logging Queries + ####################################################################### + # postauth_query - Insert some info after authentication + ####################################################################### + + postauth_query = "INSERT INTO ${postauth_table} \ + (username, pass, reply, authdate) \ + VALUES ( \ + '%{User-Name}', \ + '%{%{User-Password}:-%{Chap-Password}}', \ + '%{reply:Packet-Type}', '%S')" + -- 2.47.2