Can we see this debug with the accounting Stop packet? Looking at this FramedIPAddres seems to be a comma (,). It most certainly shouldn't be that. Ivan Kalik Kalik Informatika ISP Dana 5/10/2007, "Budi Wibowo" <budi.wibowo@gmail.com> piše:
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