search for: fetchids

Displaying 20 results from an estimated 41 matches for "fetchids".

Did you mean: fetchid
2010 May 13
1
app_addon_sql_mysql.c:116 find_identifier
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
2007 Apr 13
2
MySQL query from extensions?
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
2005 May 18
1
Mysql cmd with Asterisk Problems
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)
2006 Jan 20
1
Calling MySQL 5 stored procedures from app_mysql
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",
2006 Mar 28
1
Asterisk to MySQL Data Lookup Warning Message?
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]:
2011 Feb 18
2
cmd MySQL
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
2008 Jan 17
0
Paging Recording File
I am looking to see if anyone has seen this problem before. I am setting the MEETME_RECORDINGFILE variable in a macro, then using the r option with the Page application to record the page. But the page is only recorded to the file specified in MEETME_RECORDINGFILE sometimes... Sometimes it works and sometimes it doesn't. When it doesn't work it places the recorded file in
2011 Jun 07
2
What is wrong in m
Hi everyone, What is wrong in below asterisk application? The output should be content of field booth_status from table booths: [extension-status] exten => _X.,1,MYSQL(Connect connid 127.0.0.1 root password my-extensions) exten => _X.,n,MYSQL(Query allow_call ${connid} SELECT extension_status FROM mytable WHERE extension=${CALLERID(num)} ORDER BY id DESC LIMIT 1) exten =>
2011 May 17
1
mysql call stored procedure
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:
2006 Sep 26
1
fetchmail can't talk to dovecot
...hentication failed. fetchmail: Authorization failure on user_name at my.server fetchmail: POP3> QUIT fetchmail: POP3< +OK Logging out fetchmail: 6.3.2 querying my.server (protocol POP3) at Wed 27 Sep 2006 12:15:21 AM CEST: poll completed fetchmail: Query status=3 (AUTHFAIL) fetchmail: Writing fetchids file. fetchmail: normal termination, status 3 fetchmail: Writing fetchids file. if I try with IMAP the part after the certificate verification error is: fetchmail: IMAP> A0003 CAPABILITY fetchmail: IMAP< * CAPABILITY IMAP4rev1 SASL-IR SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ IDL...
2008 Dec 16
1
interesting problem
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
2007 Sep 20
1
Paging MEETME_RECORDINGFILE Variable
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
2008 Jan 07
1
extension.conf with mysql
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)
2008 Mar 06
1
AEL - SQL and TIMEDIFF()
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 =>
2015 Mar 16
1
Use dialplan variables from MySQL database and replace with value
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
2009 Apr 22
1
Upgrading from 1.4.21.2 to 1.6.0.5 breaks sql queries with backslashes?
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
2010 Sep 03
0
How to use MYSQL(Set timeout x)
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 =>
2006 Dec 04
4
MySQL cmd % pattern matching
Hi All Does anyone know how to use the MySQL cmd in Asterisk with LIKE and % in the query? I have: exten => s,5,Set(query=SELECT name from contacts where tel like %${number}) exten => s,6,MySQL(Connect connid hostname username password dbname) exten => s,7,MySQL(Query resultid ${connid} ${query}) But there seems to be a problem with the % sign and I don't know how to
2008 Dec 22
0
interesting problem update
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
2006 Jan 11
17
Nested MySQL Commands
Is it possible to have nested MySQL queries in extensions.conf? Ie, perform a query, grab a value, and then jump to another location in the dialplan and do another query based on that original value. I'm having problems with the result and fetchid's and I'm not sure if it's even possible to do this or not. Thanks, Doug. -------------- next part -------------- An HTML