On Mon, Dec 15, 2003 at 12:56:53PM -0600, Click Chebon wrote:
> Using Postgresql 4.7
I hope you mean 7.4 ;)
> rad_recv: Accounting-Request packet from host 192.168.0.1:3306, id=21,
> length=38
> User-Name = "clint"
> Acct-Status-Type = Stop
> Acct-Session-Id = "816"
...
> radius_xlat: 'UPDATE radacct ??SET AcctStopTime = (now() - '0'::interval),
> AcctSessionTime = '',
^^^
> ??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctOutputOctets
> = (('0'::bigint << 3
> 2) + '0'::bigint), ??AcctTerminateCause = '', AcctStopDelay = '0',
> ??FramedIPAddress = NULLIF('',
> '')::inet, ConnectInfo_stop = '' ??WHERE AcctSessionId = '816' AND UserName
> = 'clint' ??AND NASI
> PAddress = '192.168.0.1' AND AcctStopTime IS NULL'
There's no Acct-Session-Time in the request.
Try using %{Acct-Session-Time:-0} in accounting_stop_query.
--
Fduch M. Pravking
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html