similar to: Upgrading from 1.4.21.2 to 1.6.0.5 breaks sql queries with backslashes?

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:

Hi list, I'm stuck for the moment @ the following : My Query (in a macro) : exten => s,n,MYSQL(Query resultid ${connid} SELECT\ vakantie_set\ vakantie_data1\ vakantie_data2\ FROM\ AstDB\ where\ SIPACCOUNT="${ARG1}") Asterisk CLI : [Aug 30 14:07:42] -- Executing [s at macro-vakantie:2] MYSQL("IAX2/zoiper-9238", "Query resultid 1 SELECT vakantie_set

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 =>

hi, dear all MYSQL commands work well in 1.4.28 edition, but not in 1.6.21 is that the grammar is different between them? extensions.conf exten => s,2,MYSQL(Query resultid ${connid} SELECT\ callerid\ from\ blacklist\ where\ companycode = ${ARG2} and callerid=${ARG1} and blockenabled = 1) cli: -- Executing [s at macro-checkblacklist:2] MYSQL("SIP/1003-00000006", "Query

What I'm retrying to do is update mysql field with the new message ID that was just recorded. Ideally, I'd like to specify the field to update using a variable ${BINID} and use ${NEWPHRASENAME} for the value - I'm not sure asterisk will allow using a variable for the field name and if not, I'll attempt to create an exten for each bin to update. Here the method I'd like to

Hi, I try to create a new table using MYSQL command in asterisk. This is what i write: Query resultid ${connid} CREATE TABLE IF NOT EXISTS "conference_600" ("id" int(11) NOT NULL auto_increment, "channel_id" varchar(40), "number_in_line" int(2), PRIMARY KEY("id")") and this is the warning that i get in the cli: app_addon_sql_mysql.c:383

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 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

I've tried every combination I could find on the net and so far there is no joy The thing is I can do this update from the command line: Maybe some new eyes might find the answer? exten => update,1,MYSQL(Connect connid localhost root password dax) exten => update,n,MYSQL(QUERY resultid ${connid} UPDATE\ caller\ SET\

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]:

Can some tell me what this warnings means? The dialplan works, but I get these warnings every once in a while: Log: [Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Identifier 0, identifier_type 2 not found in identifier list [Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Invalid result identifier 0 passed in aMYSQL_clear [Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c:

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",

An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: bhfisher.vcf Type: text/x-vcard Size: 253 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.vcf

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)

I try to install astcc. Make install gives me: DBI connect('database=astcc;host=localhost','astcc',...) failed: Unknown database 'astcc' at ./astcc-admin.cgi line 67 DBI connect('database=;host=','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at ./astcc-admin.cgi line 60 Ignoring that (!!! ;-) ) and going to the

Should be mailbox = 7752365815@vpbx-wpti Best Regards, Ben Bawkon --------- Original Message --------- From: Bruce Komito To: <asterisk-users@lists.digium.com> Subject: [Asterisk-Users] voicemail notify problem on sip extension Sent: 5/19/2004 4:27:51 PM I'm having a problem with the voicemail notify feature. Although I have the voicemail box configured for the sip extension, the

I got a new motherboard and upgraded Asterisk, ... However, I am not lucky enough to get it running again. To compile went ok, besides this remark at the end of asterisk: WARNING WARNING WARNING Your Asterisk modules directory, located at /usr/lib/asterisk/modules contains modules that were not installed by this version of Asterisk. Please ensure that these modules are compatible with

vpbx*CLI> sip show peers Name/username Host Dyn Nat ACL Port Status 621/621 192.168.250.76 D N 5060 OK (65 ms) 626/626 192.168.250.109 D N 5060 OK (180 ms) 616/Ronald Softphone (Unspecified) D N 0 UNKNOWN 615/Ronald office 192.168.250.103 D N 5060 OK (41

I try to change something in ASTCC, but I am now totally blind, .... I hang on one line now. I changed: vpbx:/var/lib/asterisk/agi-bin # diff astcc-original.agi astcc.agi 22c22 < # exten => _00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},${EXTEN}) --- > # exten => _00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},${TARIFF},${EXTEN}) 35c35 < # exten =>

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 =>