Check the Acct_Session-Time in /usr/local/var/log/radius/radacct/192.168.0.1/detail-20031213 for the stop record of session "816".
The sql is attempting to set AcctSessionTime = ''
AcctSessionTime is a bigint, and '' is not an integer, that is why you are getting the error.
Click Chebon wrote:
...snip...Using Postgresql 4.7 and FreeRadius 0.9.3 on FreeBSD 5.1
On sending an Accounting Stop Request to Freeradius I get some errors in summary invalid input syntax for type bigint: ""
below is the error log and Below the log is the standard part of postgresql.conf I am using it unmodified
Nothing to do. Sleeping until we see a request.
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"
modcall: entering group preacct for request 3
modcall[preacct]: module "preprocess" returns noop for request 3
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 3
modcall: group preacct returns noop for request 3
modcall: entering group accounting for request 3
rlm_acct_unique: WARNING: Attribute NAS-Port-Id was not found in request,
unique ID MAY be incons
istent
rlm_acct_unique: Hashing ',Client-IP-Address = 192.168.0.1,NAS-IP-Address =
192.168.0.1,Acct-Sess
ion-Id = "816",User-Name = "clint"'
rlm_acct_unique: Acct-Unique-Session-ID = "38a313dce3842355".
modcall[accounting]: module "acct_unique" returns ok for request 3
radius_xlat:
'/usr/local/var/log/radius/radacct/192.168.0.1/detail-20031213'
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-20031213
rlm_sql (sql): Connected new DB handle, #1...snip...
rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = (now() -
'0'::interval), AcctSessi
onTime = '', ??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_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 (sql): Couldn't update SQL accounting STOP record - ERROR: invalid
input syntax for type
bigint: ""
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
