I try using the last snapshot of freeradius with postgres for voip billing
with cisco 5300.
It give me this error:
rlm_sql (pgsql-voip): sql_set_user escaped user --> '00362xxxx'
radius_xlat: 'INSERT into Stoph323-call-type=3DVoIP ??(RadiusServerName,
UserName, NASIPAddress, AcctTime, ??AcctSessionTime, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, ??AcctDelayTime,
H323RemoteAddress, CiscoNASPort, h323callorigin, callid, ??h323connecttime,
h323disconnectcause, h323disconnecttime, h323gwid, h323setuptime)
??values('myservername', '00362xxxx', '213.x.x.x', now(), '9', ??'19600',
'7129', '393286xxxxx', '00362xxxx', ??'4030',
NULLIF('h323-remote-address=3D213.x.x.x', '')::inet, NULLIF('', ''),
??'h323-call-origin=3Danswer', pick_id('h323-conf-id=3D5392A4C9 13F3EC51 0
5C42EE50', ''), strip_dot('h323-connect-time=3D09:14:03.366 cest Fri May 21
2004'), 'h323-disconnect-cause=3D10',
??strip_dot('h323-disconnect-time=3D09:14:11.926 cest Fri May 21 2004'),
'h323-gw-id=3Dgw0-PDF.reteitaly.com',
strip_dot('h323-setup-time=3D09:13:52.233 cest Fri May 21 2004'))'
rlm_sql (pgsql-voip): Reserving sql socket id: 17
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 (pgsql-voip): Attempting to connect rlm_sql_postgresql #17
rlm_sql (pgsql-voip): Connected new DB handle, #17
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 (pgsql-voip): failed after re-connect
rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR:
syntax error at or near "-" at character 21
rlm_sql (pgsql-voip): Released sql socket id: 17
modcall[accounting]: module "pgsql-voip" returns fail for request 82
modcall: group accounting returns fail for request 82
Finished request 82
Is it the pgslq-voip.conf that is wrong in this snpshot?
Roberto Pioli
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
