An inner join of A and B gives the result of A intersect B, i.e. the inner part of a venn diagram intersection. An outer join of A and B gives the results of A union B, i.e. the outer parts of a venn diagram union. Examples Suppose you have two Tables, with a single … Read more
Using $ If you want to set a global variable containing the another variable name in the [globals] category of extensions.conf you have to do something like this: [globals] SS=$ MY_VAR=${SS}{EPOCH}-${SS}{EXTEN}.gsm This way the MY_VAR value is ${EPOCH}-${EXTEN}.gsm Using it with the EVAL() function is very useful. I.e. if you want to record you can do this: … Read more
This is an ADD-ON of asterisk, is not installed by default and must be downloaded and installed with the asterisk-addons package. Â However, in Asterisk 1.8 the addons have been integrated back into Asterisk. MYSQL(): Basic MYSQL Database Functionality (note that the help information returned from ‘show application MYSQL’ is a little misleading – what’s shown … Read more
If you want to play multiple sound file with .call then you can send it like this: Setvar: file_max=2 Setvar: file1=custom/1_message Setvar: file2=custom/2_message After that use asterisk’s dialplan to play files one-by-one. For example like this: exten => 123,3,Set(i=0); exten => 123,n(loop),Set(i=$[ ${i} + 1 ]) exten => 123,n,GotoIF($[ $i > ${file_max} ]?exit) exten => … Read more
call transfer or call forwarding in asterisk [test] exten => 1000,1,Dial(SIP/User1) exten => 1000,n,Hangup() exten => 2000,1,Dial(SIP/User2) exten => 2000,n,Hangup() exten => 3000,1,Dial(SIP/User3) exten => 3000,n,Hangup() ;call forwarding exten => _*21*X.,1,NoCDR exten => _*21*X.,2,Set(DB(CFIM/${CALLERID(NUM)}=${EXTEN:4}) exten => _*21*X.,3,Playback(vm-saved) exten => _*21*X.,4,Hangup() Â Â
Configure asterisk MySql connection: create the res_mysql.conf file in /etc/asterisk vi /etc/asterisk/res_mysql.conf enter the following: [general] dbhost = 127.0.0.1 dbname = asteriskrealtime dbuser = root dbpass = password dbport = 3306 save the following configuration files, we will use a very short files instead in order to simplefy the setup: cp /etc/asterisk/extensions.conf /etc/asterisk/extensions.conf_orig cp /etc/asterisk/extconfig.conf … Read more
If U were born on the 1st, 10th, 19th, 28th of any month U r number 1… If U were born on the 2nd, 11th, 20th, 29th of any month then U r number 2…If U were born on the 3rd, 12th, 21st, 30th of any month then U r number 3…If U were born … Read more
exten => _1NXXNXXXXXX,1,AGI(agi://127.0.0.1:4577/call_log) exten => _1NXXNXXXXXX,2,Set(CALLFILENAME=${CALLERID(all)}-${EXTEN}-${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)}) exten => _1NXXNXXXXXX,3,Monitor(wav,${CALLFILENAME},m) exten => _1NXXNXXXXXX,4,Dial(${SIPTRUNK}/${EXTEN},,tTor) exten => _1NXXNXXXXXX,5,Congestion exten => _1NXXNXXXXXX,103,Congestion exten => _011.,1,AGI(agi://127.0.0.1:4577/call_log) exten => _011.,2,Set(CALLFILENAME=${CALLERID(all)}-${EXTEN}-${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)}) exten => _011.,3,Monitor(wav,${CALLFILENAME},m) exten => _011.,4,Dial(${SIPTRUNK}/${EXTEN},,tTor) exten => _011.,5,Congestion exten => _011.,103,Congestion
; extensions.conf – the Asterisk dial plan ; ; Static extension configuration file, used by ; the pbx_config module. This is where you configure all your ; inbound and outbound calls in Asterisk. ; ; This configuration file is reloaded ; – With the “dialplan reload” command in the CLI ; – With the “reload” … Read more