In Access-Request h323-remote-address Multiple times How to get it in SQL query
Hi All, We have configure freeradius on centos with mysql. We are developing solution for Wholesale VOIP. We need to authenticate user on basis of Trunk Id & IP. We are getting Trunk Id and IP in h323-remote-address attribute. Please find my Access-Request. Packet-Type = Access-Request User-Name = "bk" User-Password = "8888891990942XXXX" h323-conf-id = "377BE9DC FC071910 90FB000C 290E95CC" Cisco-AVPair = "remote-media-address=XXX.105.4.197" Cisco-AVPair = "session-protocol=cisco" Cisco-AVPair = "gw-rxd-cdn=88888919974063392" h323-remote-address = "000111" h323-remote-address = "XXX.105.4.197" Calling-Station-Id = "bk" Called-Station-Id = "88888919974063392" Service-Type = Login-User NAS-IP-Address = 79.99.198.YYY remote-media-address = "XXX.105.4.197" session-protocol = "cisco" gw-rxd-cdn = "8888891997406XXXX" We are getting h323-remote-address multiple times. How can I get both attribute in sql query for authentication? I set sql_user_name = "%{h323-remote-address}". But I get sql_user_name = Trunk ID (000111) only. How can I get IP XXX.105.4.197? Thanks & Regards, Ankur
participants (1)
-
Ankur - BillCall