userdoc:tt_asterisk-odbc

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
userdoc:tt_asterisk-odbc [2014/07/03 13:41]
abelbeck [Mass Deployment SQL Table] 		userdoc:tt_asterisk-odbc [2014/07/03 14:02]
droemel [Mass Deployment SQL Table]
Line 121: Line 121:
   );   );
  
-Following the examples above, adding a context to ''/etc/asterisk/func_odbc.conf'' to define a new function, the dialplan can use the PhoneProv data.+Following the examples above, adding a context to ''/etc/asterisk/func_odbc.conf'' to define a new function, the dialplan can use the PhoneProv data. Here is an example which fits the new 'phoneprov' table: 
 + 
 +  [SIPACCOUNT] 
 +  dsn=asterisk 
 +  readsql=SELECT ${ARG1} FROM phoneprov WHERE ${ARG2}='${SQL_ESC(${ARG3})}' 
 + 
 +In the dialplan you could then use something like this: 
 + 
 +  same => n,Set(val=${ODBC_SIPACCOUNT(account,ext,100)}) 
 + 
 +to get the SIP account (peer-name) from a given extension (100) via SQL.
  
 Detailed Mass Deployment documentation can be found here: Detailed Mass Deployment documentation can be found here:
 **[[userdoc:tt_ip_phone_provisioning|IP Phone Mass Deployment]]** **[[userdoc:tt_ip_phone_provisioning|IP Phone Mass Deployment]]**
- 
  
 ===== CDR Call Logging with SQL ===== ===== CDR Call Logging with SQL =====
  • userdoc/tt_asterisk-odbc.txt
  • Last modified: 2014/07/03 14:02
  • by droemel