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
What is command and how it works? One of Asterisk’s most valuable features is its ability to connect different callers to each other. This is especially useful when callers are using different methods of communication. For example, caller A might be communicating over the traditional analog telephone network, while user B might be sitting in … 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