On Mon, Dec 15, 2003 at 04:36:00PM -0600, Click Chebon wrote:
> rlm_acct_unique: WARNING: Attribute NAS-Port-Id was not found in request,
> unique ID MAY be inconsistent
Is it a real stop packet or just test?
If it's a test packet, try more "real" data.
If not, don't be lazy to configure rlm_acct_unique properly.
> rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = (now() -
> '0'::interval), AcctSessionTime = '0', ??AcctInputOctets = (('0'::bigint <<
> 32) + '0'::bigint), ??AcctOutputOctets = (('0'::bigint << 32) +
> '0'::bigint), ??AcctTerminateCause = '', AcctStopDelay = '0',
> ??FramedIPAddress = NULLIF('', '')::inet, ConnectInfo_stop = '' ??WHERE
> AcctSessionId = '816' AND UserName = 'clint' ??AND NASIPAddress =
> '192.168.0.1' AND AcctStopTime IS NULL
> rlm_sql_postgresql: Status: PGRES_COMMAND_OK
> rlm_sql_postgresql: affected rows = 0
> radius_xlat: 'rlm_sql: Stop packet with zero session length. (user
> 'clint', nas '192.168.0.1')'
> rlm_sql: Stop packet with zero session length. (user 'clint', nas
> '192.168.0.1')
The server couldn't find matching start record for this request
(accounting_stop_query affected no rows), and trying to insert new
record using accounting_stop query_alt which fails.
> rlm_sql_postgresql: query: INSERT into radacct ??(AcctSessionId,
> AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType,
^^^^^^^^^
> AcctStartTime, AcctStopTime, ??AcctSessionTime, AcctAuthentic,
> ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,
> CallingStationId, ??AcctTerminateCause, ServiceType, FramedProtocol,
> FramedIPAddress, AcctStopDelay) ??values('816', '38a313dce3842355', 'clint',
> '', '192.168.0.1', ??'', '', (now() - '0'::interval - '0'::interval),
^^
> ??(now() - '0'::interval), '0', '', '', ??(('0'::bigint << 32) +
> '0'::bigint), ??(('0'::bigint << 32) + '0'::bigint), '', ??'', '', '', '',
> ??NULLIF('', '')::inet, '0')
Similar thing as before. You can use %{Attr:-dev_value} syntax or
NULLIF('%{Attr}', '') or just edit schema and postgresql.conf to be
closer to your needs, e.g take NASPortId/NAS-Port away.
--
Fduch M. Pravking
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
