similar to: Paging Recording File

I am having a weird issue with setting the recording file for the Page app. Here is some quick background info I have a macro that pages all my phones: [macro-pageall] ; Context for paging all devices. ; This will search the sip table in the realtime database ; for all phones that start with a number. That number is ; passed to this macro as ${ARG1}. ; ; ARG1 = The

Hello, Is there a way to change the format from the default? 'r' - Record conference (records as ${MEETME_RECORDINGFILE} using format ${MEETME_RECORDINGFORMAT}). Default filename is meetme-conf-rec-${CONFNO}-${UNIQUEID} and the default format is wav. - requires chan_zap.so Many thanks ******************************************************************** This email and any attachments

Hello Everyone! According to voip-info.org the correcy syntax for the realtime function is: REALTIME(family|fieldmatch[|value[|delim1[|delim2]]]) on read REALTIME(family|fieldmatch|value|field) on write It seems from the syntax that it is only possible to retrieve a full row according to the value of only of column. This translates in SQL language as Select * from family where fieldmath =

Hello list, I have the following problem with MySQL-queries : it seems that the resultid and connid are not cleared ! [macro-GetMailboxFromSIPuserID] exten => s,1,MYSQL(Connect connid localhost xxx xxx xxx) exten => s,n,MYSQL(Query resultid ${connid} SELECT\ extensie FROM\ tbl_SIPaccounts\ WHERE\ ID="${ARG1}") exten => s,n,MYSQL(Fetch fetchid ${resultid} extensie) exten

Hello all: I am trying to use the mysql command to retrieve information from a mysql database. my example here was formed from using the wiki reference to using the mysql command. The problem is with the fetch command. Here is the macro code: Mysql(QueryString=SELECT\ ivr-password\ from\ users\ where\ ivr-id=${userid}) Mysql(Query r ${connid} ${QueryString}) Mysql(Fetch fetchid ${r} dbuserpass)

Hi all, I have an external application commanding asterisk by AMI and AsyncAGI. I also have a dialplan like this: ; AsyncAGI extensions exten => _8.,1,Noop(entering in AGI loop at 8 ${EXTEN}); exten => _8.,n,AGI(agi:async); exten => _8.,n,Hangup(); ; Meetme extensions exten => _1.,1,Noop(Conference ${EXTEN} ${CONTEXT}); exten =>

What wrong with this: [get-dnisinfo] ; sub-routine to get owner's password exten => s,1,Verbose( == ) exten => s,n,MYSQL(Connect connid localhost root password dax) exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\ dnislookup\ WHERE\ dnis=\'${IVR-Exten}\') exten => s,n,MYSQL(Fetch fetchid ${password} password) exten => s,n,Verbose( == Password found

Hi i am experiencing this problem: MEETME_RECORDINGFILE=/data/asterisk_data/_${DATETIME}_CONFERENCE exten => 9999,1,MeetMe(666|1Arxq) exten => 9998,1,MeetMe(666|1Axq) exten => 9997,1,MeetMe(666|1xq) I make a conference between 3 person dialing A dials 9999 B dials 9998 C dials 9997 all works fine but the datetime won't be updated, it still remain for example 13:40 until i do a

Hello all. I am trying to use app_mysql. It works for selects and functions, but does not want to work with procedures. Pls have a look: Calling function: CREATE FUNCTION f_1(a VARCHAR(20)) RETURNS INTEGER RETURN (SELECT count(*) from peer where name = a); Result: -- Executing Macro("IAX2/100-3", "local|100") in new stack -- Executing MYSQL("IAX2/100-3",

Hi All, I'm getting a strange warning message when I perform a MYSQL data lookup. The operation performs fine, I retrive the data I'm looking for and continue on through the dial sequence without an issue. I'm wondering if this warning message is something to be concerned about, can't find any info about it. warning message: Mar 28 15:55:40 WARNING[27481]:

Hi guys, I'm trying to connect Asterisk to the MySQL, but I can't execute it. It returns an error, as below: -- Executing [200 at teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack [Feb 18 15:55:13] WARNING[7696]: app_mysql.c:393 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in

Hello i have the following field (text string) in a MySQL database : "${KNUMMER} ${phone_number_to} ${phone_number_from} ${CHANNEL:4}" I read this string form the database and want to have the dialplan variables to be replaced with the correct content. How can I do this ? Currently this is not working. The variable ${PARAMS} contains the exact string of the database field : my

In Asterisk 1.2.4 is love being able to recording conferences. However, using the default variables, the files are being written to /var/lib/asterisk/sounds instead of /var/spool/asterisk/meetme. If I change MEETME_RECORDINGFILE variable to something different in works, bit I lose the ability to define CONFNO as part of the file name, which is handy when sorting for users to review. I call meetme

I?ve got an interesting problem and am wondering if anyone can shed light ? I am running Asterisk on RHEL Server release 5.2 connecting to an Avaya Definity G3R via a Digium TE220. Asterisk 1.4.20 Zaptel 1.4.4 Libpri 1.4.4 MySQL 5.0.45 Festival Speech Synthesis System: 1.95 We have about 4200 accounts in a MySQL db. Asterisk retrieves the user information from the database, festival tts says

Hi, all. I've been searching google, bug reports and forums and have looked in all the asterisk-users list archives back to 2003 but haven't seen an answer to this, so thought I'd post here. The problem seems to be that Asterisk 1.6.0.5 is sending backslashes (needed to escape commas and so forth in 1.4.21.2) as *literal* backslashes to Mysql, so that Mysql gives a syntax error

I use Asterisk 1.6.2.11 and this is my dialplan: [test] exten => 9999,1,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)}) exten => 9999,n,Answer() exten => 9999,n,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)}) exten => 9999,n,PlayBack(hello-world) exten => 9999,n,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)}) exten => 9999,n,MYSQL(Set timeout 2) exten =>

Hi Guys, I am getting an error when executing another mysql query in dialplan after calling stored procedure. If calling the procedure from mysql cli it gives a result like: mysql> call call_control(78236721,1000,1233); +------+ | pass | +------+ | 1 | +------+ So I need asterisk to recognize this pass and take some actions based on what the pass value is. Dialplan looks like this:

The problem I was experiencing is still occurring, and it is getting worse. There are several names that Festival "gets stuck on". I don't know if it is a Festival problem or an Asterisk problem. The scenario, a call comes in goes through the dialplan (shown below in original message), and either reads the value ${FULLNAME}, but then hangs. It doesn't go to the next command

Hi, I am trying to connect the outbound dialing with mysql with the following code, exten => 88,1,MYSQL(Connect connid hostname username password dbname) exten => 88,2,GotoIf($["${connid}" = ""]?error,1) exten => 88,3,MYSQL(Query resultid ${connid} SELECT\ phone\ FROM\ <tablename>\ WHERE\ phone =${a}) exten => 88,4,MYSQL(Fetch fetchid ${resultid} ph\ sa)

Hello list, I'm having some problem integrating the SELECT TIMEDIFF() and SELECT DATEDIFF() in my code. The syntax I'm using works without any problems if I run them directly from the MySQL Client, but from the Asterisk Dialplan it just wont work. Is there a limitation in the MySQL() application for the Asterisk dialplan that produces this error? <CODE> context testsql { s =>