Call Distribution To Multiple IPs

skb007 · Post by **skb007** » Fri Mar 09, 2018 6:49 pm

1. Brekeke Product Name and Version:

2. Java version:

3. OS type and the version:

4. UA (phone), gateway or other hardware/software involved:

5. Your problem:

Is there any way that dial plan can do a database query to find the destination IP address and terminate the call to destination IP?

Tata · Post by **Tata** » Fri Mar 09, 2018 9:39 pm

Try $db.query
http://wiki.brekeke.com/wiki/DialPlan-Matching-db-query

Also internal Alias database can meet the requirement.
http://wiki.brekeke.com/wiki/How-to-use-Alias-function

skb007 · Post by **skb007** » Sat Mar 10, 2018 2:35 pm

Appreciate your response. Do you think something like following will work?

Matching Patterns
$addr = 10\.1\.1\.1
From = sip:(.+)@
$request = sip:123(.+)@
$db.query( "mydb", "select IP from table where DID = '%2' " ) = (.+)

Deploy Patterns
From = sip:%1@10.2.2.2
To = sip:%2@%3
$b2bua = true
$rtp = false
$session = sdp
&sdp.audio.a.1 = ptime:20
&sdp.audio.a.2 = silenceSupp:off - - - -

Tata · Post by **Tata** » Mon Mar 12, 2018 10:22 am

Your DialPlan rule seems no problem.

Have you set the following under [Configuration] -> [Advanced] page?

Code: Select all

mydb.driver = <jdbc_driver>
mydb.url = <database_url>
mydb.user = <user_name>
mydb.password = <password>

If you are using Brekeke SIP Server version 3.7.5.0 or older, I recommend that you upgrade it to the latest version because the DB access function is improved in recent versions.