|
Dear all,
I'm using NTRadPing
I send "accounting Start" request, it's
ok.
then I send "accounting Stop" request, it
fail:
modcall: group preacct returns noop
modcall: entering group accounting rlm_acct_unique: WARNING: Attribute NAS-Port-Id was not found in request, unique ID MAY be inconsistent rlm_acct_unique: Hashing ',Client-IP-Address = 172.16.66.68,NAS-IP-Address = 172.16.66.68,Acct-Session-Id = "1608",User-Name = "tmcuong"' rlm_acct_unique: Acct-Unique-Session-ID = "ae4cb6976fb4d60f". modcall[accounting]: module "acct_unique" returns ok radius_xlat: '/usr/local/var/log/radius/radacct/172.16.66.68/detail-20030807' rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/172.16.66.68/detail-20030807 modcall[accounting]: module "detail" returns ok modcall[accounting]: module "unix" returns noop radius_xlat: 'tmcuong' rlm_sql (sql): sql_set_user escaped user --> 'tmcuong' radius_xlat: 'UPDATE radacct ??SET AcctStopTime = (now() - '0'::interval),AcctSessionTime = '', ??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctTerminateCause = '', ' radius_xlat: '/usr/local/var/log/radius/sqltrace.sql' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = (now() - '0'::interval),AcctSessionTime = '', ??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctTerminateCause = '', 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 #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = (now() - '0'::interval),AcctSessionTime = '', ??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint), ??AcctTerminateCause = '', 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: parser: parse error at or near "" rlm_sql (sql): Released sql socket id: 3 modcall[accounting]: module "sql" returns fail modcall: group accounting returns fail Finished request 6 ******************************************************* EIS Service, Inc. |
