Also store h323voicequality in SQL. Thanks to Ilia Chipitsine

diff --git a/raddb/pgsql-voip.conf b/raddb/pgsql-voip.conf
index c4c28bd..fa470e9 100644 (file)
--- a/raddb/pgsql-voip.conf
+++ b/raddb/pgsql-voip.conf
@@ -97,11 +97,11 @@ sql pgsql-voip {
        accounting_stop_query = "INSERT into ${acct_table2}%{h323-call-type} \
                (RadiusServerName, UserName, NASIPAddress, AcctTime, \
                AcctSessionTime, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, \
-               AcctDelayTime, H323RemoteAddress, CiscoNASPort, h323callorigin, callid, \
+               AcctDelayTime, H323RemoteAddress, H323VoiceQuality, CiscoNASPort, h323callorigin, callid, \
                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, NULLIF('%{Cisco-NAS-Port}', ''), \
+               '%{Acct-Delay-Time:-0}', NULLIF('%{h323-remote-address}', '')::inet, NULLIF('%{h323-voice-quality}','')::integer, NULLIF('%{Cisco-NAS-Port}', ''), \
                '%{h323-call-origin}', pick_id('%{h323-conf-id}', '%{call-id}'), strip_dot('%{h323-connect-time}'), '%{h323-disconnect-cause}', \
                strip_dot('%{h323-disconnect-time}'), '%{h323-gw-id}', strip_dot('%{h323-setup-time}'))"