Do you have a table called stoph323? Else make sure
the accounting table name is set to radacct
>From the insert statement below there should be a
table called Stoph323 for it to work.
--- Roberto Pioli <[EMAIL PROTECTED]> wrote:
> 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
__________________________________
Do you Yahoo!?
Yahoo! Domains � Claim yours for only $14.70/year
http://smallbusiness.promotions.yahoo.com/offer
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
