psql problem

tnt at kalik.co.yu tnt at kalik.co.yu
Fri Oct 5 22:00:38 CEST 2007


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 at 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
>
>




More information about the Freeradius-Users mailing list