At 23.52 25/09/02, you wrote:
>with this I solved the auth problem, but encountered a problem for the
>accounting
>inserts.
>
>Here I send you the changes I made in sql.conf
>
> From :
>accounting_start_query = "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}',
>'%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}',
>'%{Connect-Info}', '',
>'0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '',
>'%{Service-Type}',
>'%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"
>
>To:
>accounting_start_query = "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}',
>'%{NAS-Port-Type}', to_date('%S', 'YYYY-MM-DD HH24:MI:SS'), '', '0',
^^
NULL
>'%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}',
>'%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}',
>'%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"
>
>Thanks for your help!
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
