On Fri, 25 Feb 2005 [EMAIL PROTECTED] wrote:
Now,can be included in future releases. in the file mssql.conf tested very good.
# accounting_start_query: Inserting of RadAcctId and AcctStopTime was # removed. These fields are processing by a database accounting_start_query = "INSERT into ${acct_table1} (AcctSessionId, AcctUniqueId, UserName, Realm, GatewayId,CallType,CallOrigin,NASIPAddress, NASPort, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, CiscoNASPort,CallId,AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}','%{h323-gw-id}','%{h323-call-type}','%{h323-call-origin}','%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}','%S',DATEADD(SECOND,CONVERT(INT,'+%{Acct-Session-Time}'),CONVERT(DATETIME,'%S',102)),
This is wrong, you are calculating acctstoptime on accounting-start!
'0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{h323-disconnect-cause}', '%{Service-Type}', '%{h323-voice-quality}', '%{h323-remote-address}','%{Cisco-NAS-Port}','%{h323-conf-id}' ,'%{Acct-Delay-Time}', '0')"
# accounting_stop_query_alt # Inserting of RadAcctId and AcctStartTime was # removed. These fields are processing by a database accounting_stop_query_alt = "INSERT into ${acct_table2} (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPort, NASPortType,AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, GatewayId,CallType,CallOrigin,CiscoNASPort,AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,CallId,AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}',DATEADD(SECOND,CONVERT(INT,'-%{Acct-Session-Time}'),CONVERT(DATETIME,'%S',102)),'%S',
This is better, although you are not taking Acct-Delay-Time into account.
'%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}','%{h323-gw-id}','%{h323-call-type}','%{h323-call-origin}','%{Cisco-NAS-Port}','%{h323-disconnect-cause}', '%{Service-Type}', '%{h323-voice-quality}', '%{h323-remote-address}','%{h323-conf-id}','0', '%{Acct-Delay-Time}')" }
Kostas esto es mi aporte para futuras descargas, ya sale bien.
Please update the stop_query_alt to include Acct-Delay-Time and it will be added in mssql.conf. The same thing for the update_query_alt would be really appreciated. Please open an enhancement bug in bugs.freeradius.org and post the queries there so nothing will get lost.
Vicente Barrientos Valdivia.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
