psql problem

[Budi Wibowo]

dear all
i have this problem on my freeradius ..and this make some field cant be
inserted to db
need advice for the proper configuration

rlm_sql (sql): Reserving sql socket id: 21
rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = ('2007-10-05
17:19:13'::timestamp - '0'::interval), ??AcctSessionTime = NULLIF('0',
'')::bigint, ??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint),
??AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint),
??AcctTerminateCause = '3', AcctStopDelay = '0', ??FramedIPAddress =
NULLIF('', '')::inet, ConnectInfo_stop = '', ??acctstatus = 'Stop',
??clientip = '2xxxxx.1', ??h323remoteaddress = '' ??WHERE AcctSessionId =
'a3e2e56a-e0f4b-b45ed37fT1' AND UserName = '203.130.218.1' ??AND
NASIPAddress = '202.147.19.66' 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): Attempting to connect rlm_sql_postgresql #21
rlm_sql (sql): Connected new DB handle, #21
rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = ('2007-10-05
17:19:13'::timestamp - '0'::interval), ??AcctSessionTime = NULLIF('0',
'')::bigint, ??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint),
??AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint),
??AcctTerminateCause = '3', AcctStopDelay = '0', ??FramedIPAddress =
NULLIF('', '')::inet, ConnectInfo_stop = '', ??acctstatus = 'Stop',
??clientip = '2tttt.1', ??h323remoteaddress = '' ??WHERE AcctSessionId =
'a3e2e56a-e0f4b-b45ed37fT1' AND UserName = 'tttttt' ??AND NASIPAddress = '
2tttt.66' 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 inet: ""
rlm_sql (sql): Released sql socket id: 21

regards

budi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20071005/28bc410a/attachment.html>