On Fri, 18 Jul 2003 02:27 am, Miranda Gomez Miguel Angel wrote:
> Hi Peter/All
> I just check the last updates of your voip config,
> and have noticed a little typo: in the insert stop query of pgsql-voip.conf
>
> accounting_stop_query = "INSERT into ${acct_table2}%{h323-call-type} \
> (RadiusServerName, UserName, NASIPAddress, AcctTime, \
> AcctSessionTime, AcctInputOctets, AcctOutputOctets,
> CalledStationId, CallingStationId, \
> AcctDelayTime, H323RemoteAddress, CiscoNASPort,
> h323callorigin, h323confid, \
> h323connecttime, h323disconnectcause, h323disconnecttime,
> h323gwid, h323setuptime) \
> values('${radius_server_name}', '%{SQL-User-Name}',
> '%{NAS-IP-Address}', now(), '%{Acct-Session-Time:-0}', \
> '%{Acct-Input-Octets:-0}', '%{Acct-Output-Octets:-0}',
> '%{Called-Station-Id}', '%{Calling-Station-Id}', \
> '%{Acct-Delay-Time:-0}', NULLIF('%{h323-remote-address}',
> '')::inet', '%{Cisco-NAS-Port}', \
> '%{h323-call-origin}', '%{h323-conf-id}',
> strip_dot('%{h323-connect-time}'), '%{h323-disconnect-cause}', \
> strip_dot('%{h323-disconnect-time}'), '%{h323-gw-id}',
> strip_dot('%{h323-setup-time}'))"
>
>
> in the '%{h323-remote-address}', '')::inet' part, you have to drop the last
> ' after the ::inet, otherwise the
> record will not be inserted, giving POSTGRES FATAL ERROR,
Thanks. Fixed.
Wow. There seems to be alot more people using my VoIP accounting code that I
thought.
I guess I am going to have to start doing more testing before doing a CVS
commit :-)
--
Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
