I'm using freeradius with postgres with cisco 5300 for voip accounting.
The accounting on file is ok but in postgres doesn't work.
This is the problem
rlm_sql (sql): sql_set_user escaped user --> '0034620220'
radius_xlat: 'INSERT into StopTelephony ??(RadiusServerName, UserName,
NASIPAddress, AcctTime, ??AcctSessionTime, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, ??AcctDelayTime,
H323RemoteAddress, CiscoNASPort, h323callorigin, h323confid,
??h323connecttime, h323disconnectcause, h323disconnecttime, h323gwid,
h323setuptime) ??values('myservername', '0034620220', '213.144.73.200',
now(), '0', ??'16032', '56760', '3280438652', '0034620220', ??'10',
NULLIF('', '')::inet, 'ISDN 0:D:8', ??'originate', '5392A4C9 13F351F9 0
58DEF568', strip_dot('17:26:46.159 cest Thu May 20 2004'), '10',
??strip_dot('17:26:46.159 cest Thu May 20 2004'), 'gw0-PDF.reteitaly.com',
strip_dot('17:25:49.350 cest Thu May 20 2004'))'
rlm_sql (sql): Reserving sql socket id: 14
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 #14
rlm_sql (sql): Connected new DB handle, #14
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: function
strip_dot("unknown") does not exist
Thanks
Roberto
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
