Who was the original author of the sql.conf file?
I note an ambiguity that seems strange to me.
Specifically, between 'accounting_{start,stop}_query{,_alt}' ...
In the '*_alt' configuration lines there is no 'Framed-IP-Address'.
In the non '*_alt' there is.
What this ends up meaning is that either the Framed-IP-Address is sent
during the initial 'start' accounting request, or it is sent during
a stop request that was never logged to the database as having started.
Otherwise, you miss logging the information.
With cisco, the start request never contains the Framed-IP-Address, unless
there's some magic someone wishes to shair.
With cisco, the stop request contains the Framed-IP-Address, but it is not
logged unless you add "FramedIPAddress = '%{Framed-IP-Address}'" into the
non '*_alt' sql statements.
Does this make sense at all?
--
Todd Fries .. [EMAIL PROTECTED]
Index: sql.conf
===================================================================
RCS file: /source/radiusd/raddb/sql.conf,v
retrieving revision 1.13
diff -u -r1.13 sql.conf
--- sql.conf 2002/02/25 15:51:43 1.13
+++ sql.conf 2002/02/25 22:29:06
@@ -117,7 +117,7 @@
accounting_start_query_alt = "UPDATE ${acct_table1} SET AcctStartTime = '%S',
AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' WHERE
AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND
NASIPAddress = '%{NAS-IP-Address}'"
- accounting_stop_query = "UPDATE ${acct_table1} SET AcctStopTime = '%S',
AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}',
AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause =
'%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop =
'%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName =
'%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"
+ accounting_stop_query = "UPDATE ${acct_table1} SET FramedIPAddress =
+'%{Framed-IP-Address}', AcctStopTime = '%S', AcctSessionTime =
+'%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets =
+'%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}',
+AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE
+AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND
+NASIPAddress = '%{NAS-IP-Address}'"
accounting_stop_query_alt = "INSERT into radacct (RadAcctId, AcctSessionId,
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime,
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}', '0', '%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}')"
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
