Brekeke Documents

Find user guides, developer guides, API references, tutorials, and more!

Brekeke SIP Server Wiki

  1. Brekeke SIP Server Basic Info
  2. Security
  3. Update & Upgrade
  4. Configuration
    1. Installation
    2. Basic Setup
    3. BSS Administration Tool
    4. Network Configuration
    5. Dial Plan
      1. Dial Plan Basics
      2. Dial Plan Reference
      3. Dial Plan Tutorial
      4. Dial Plan Examples
        1. Allow Parentheses in Contact-URI
        2. Apply two plugin to one call
        3. Authenticate callers by IP address
        4. Brekeke SIP Server works as Redirect Server
        5. Change Contact header
        6. Change payload type
        7. Change RTP Connection Info
        8. Connect to Gateways with BSS
        9. Count registration records per user
        10. Decline calls from non-numbered callers (SIP ID)
        11. Define outgoing From and To headers with / method
        12. Disable RTP-Relay if SDP indicates a Public IP address
        13. DNS-SRV failover
        14. Execute SQL query from Dialplan
        15. Failover with the Dial Plan
        16. Limit Concurrent Sessions through a specific route
        17. Limit session per sec in Dial Plan
        18. Remove all current registrations
        19. Reject non-registered caller's call
        20. Restrict INVITE Requests
        21. Restrict REGISTER requests
        22. Restrict registration only from single UA
        23. Restrict Upper or Thru Registration
        24. Set time range in Dial Plan
        25. Use Response Header Definition
        26. $webget method examples
      5. Dial Plan FAQ
    6. Block List
    7. Provisioning
    8. Push Notification
    9. SDN
    10. STIR/SHAKEN
    11. Advanced Edition
    12. Other Functions
    13. Third-Party Database
    14. Environment Variables
  5. Troubleshooting
  6. Developer's Guide
  7. Version History

Execute SQL query from Dialplan

Note: The following function is available for Brekeke SIP Server Advanced edition only.

 

Initial Settings:

Set the following variables at Brekeke SIP Server Admintool > [Configuration] > [Advanced] page

-------------------------------
db-name.driver = <jdbc_driver>
db-name.url = <database_url>
db-name.user = <user_name>
db-name.password = <password>
-------------------------------

 

Example:
---------------------------------------
mydb.driver = com.mysql.jdbc.Driver
mydb.url = jdbc:mysql://domain/mydb
mydb.user = user
mydb.password = password
---------------------------------------

 

DialPlan:

Syntax:

$db.query( db-name, query )

 

Example:

$db.query( "mydb", "select A from table where B = '%1' " ) = (.+)

 

See Also:

$db.query
$db.update

Yes No
« DNS-SRV failover Failover with the Dial Plan »
Suggest Edit