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,
Hope this help,
Bye
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
