psql problem



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


This archive was generated by a fusion of Pipermail (Mailman edition) and MHonArc.