I did mean Postgresql 7.4 whoops fat fingers today
After the suggested change
> There's no Acct-Session-Time in the request.
> Try using %{Acct-Session-Time:-0} in accounting_stop_query.
now i receive the following :
rad_recv: Accounting-Request packet from host 192.168.0.1:3358, id=30,
length=44
User-Name = "clint"
Acct-Status-Type = Stop
Acct-Session-Id = "816"
Termination-Action = RADIUS-Request
modcall: entering group preacct for request 0
modcall[preacct]: module "preprocess" returns noop for request 0
rlm_realm: No '@' in User-Name = "clint", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[preacct]: module "suffix" returns noop for request 0
modcall: group preacct returns noop for request 0
modcall: entering group accounting for request 0
rlm_acct_unique: WARNING: Attribute NAS-Port-Id was not found in request,
unique ID MAY be inconsistent
rlm_acct_unique: Hashing ',Client-IP-Address = 192.168.0.1,NAS-IP-Address =
192.168.0.1,Acct-Session-Id = "816",User-Name = "clint"'
rlm_acct_unique: Acct-Unique-Session-ID = "38a313dce3842355".
modcall[accounting]: module "acct_unique" returns ok for request 0
radius_xlat:
'/usr/local/var/log/radius/radacct/192.168.0.1/detail-20031215'
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /usr/local/var/log/radius/radacct/192.168.0.1/detail-20031215
modcall[accounting]: module "detail" returns ok for request 0
modcall[accounting]: module "unix" returns noop for request 0
radius_xlat: 'clint'
rlm_sql (sql): sql_set_user escaped user --> 'clint'
radius_xlat: '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'
radius_xlat: '/usr/local/var/log/radius/sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 4
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')
rlm_sql (sql): Released sql socket id: 4
radius_xlat: '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')'
radius_xlat: '/usr/local/var/log/radius/sqltrace.sql'
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')
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4
rlm_sql (sql): Connected new DB handle, #4
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')
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (sql): failed after re-connect
rlm_sql: Couldn't insert SQL accounting STOP record - ERROR: invalid input
syntax for integer: ""
rlm_sql (sql): Released sql socket id: 4
modcall[accounting]: module "sql" returns fail for request 0
modcall: group accounting returns fail for request 0
Finished request 0
Thanks for your help
-Chebon
----- Original Message -----
From: "Alexander M. Pravking" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 15, 2003 4:21 PM
Subject: Re: accounting_stop request: bigint
> 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
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
