> On Wed, 23 Feb 2005 [EMAIL PROTECTED] wrote:
>
>> Hello List.
>>
>> Can anyone help me.
>> I have problems for insert the row AcctStartTime in the query
>> accounting_stop_query_alt by example in sql.conf exist it ,
>> DATE_SUB('%S',
>> INTERVAL (%{Acct-Session-Time:-0} +
>> %{Acct-Delay-Time:-0}) SECOND), but en mssql.conf no exist it.
>
> DATE_SUB() is a mysql function. Maybe MS-SQL supports something like that.
> If
> you find it, post a patch back so that it can be included in future
> releases.
>
>>
>> anyone has same idea.
>> Thanks a lot.
>>
>> Vicente.
>>
>> -
>> 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
>
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)),
'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',
'%{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.
Vicente Barrientos Valdivia.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
