Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
userdoc:tt_asterisk-odbc [2014/07/03 13:23] abelbeck [Mass Deployment SQL Table] |
userdoc:tt_asterisk-odbc [2014/07/03 13:58] droemel [Mass Deployment SQL Table] |
||
---|---|---|---|
Line 99: | Line 99: | ||
===== Mass Deployment SQL Table ===== | ===== Mass Deployment SQL Table ===== | ||
- | When using the PhoneProv tab in the web interface, by default the templates | + | When using the **[[userdoc: |
!!Note: AstLinux 1.1.7 or later is required!! | !!Note: AstLinux 1.1.7 or later is required!! | ||
- | Using the SQL-Data tab in the web interface, an example phoneprov table: | + | Using the SQL-Data tab in the web interface, |
{{: | {{: | ||
- | Mass Deployment detailed documentation found here: | + | The SQL schema is of the form: |
- | **[[userdoc: | + | |
+ | CREATE TABLE ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ); | ||
+ | |||
+ | Following the examples above, adding a context to ''/ | ||
+ | |||
+ | [SIPACCOUNT] | ||
+ | dsn=asterisk | ||
+ | readsql=SELECT ${ARG1} FROM phoneprov WHERE ${ARG2}=' | ||
+ | |||
+ | In the dialplan you could then use something like this: | ||
+ | |||
+ | same => n, | ||
+ | |||
+ | to get the SIP account (peer) from a given extension (100) via SQL. | ||
+ | |||
+ | Detailed Mass Deployment documentation can be found here: | ||
+ | **[[userdoc: | ||
===== CDR Call Logging with SQL ===== | ===== CDR Call Logging with SQL ===== |