similar to: MySQL syntax error : I really don't see where...

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

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

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

Hello list, this works : exten => _*XXX*,n,SIPAddHeader("Call-Info:\; answer-after=0") exten => _*XXX*,n,Dial(SIP/${SIPACCOUNT}) The phone auto-answers the call... this does not work : exten => _*XXX*,n,SIPAddHeader("Call-Info:\; answer-after=0") exten => _*XXX*,n,Page(SIP/${SIPACCOUNT}) The phone rings and does not auto-answer the call... Can you tell me

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:

Hello list, this is the dialplan : <snip> exten => s,n,Dial(SIP/test1&SIP/test2,,t) <snip> exten => 10,1,Dial(SIP/test1) exten => 20,1,Dial(SIP/test2) So there is an incoming call that rings SIPaccounts test1 and test2. Account test1 answers and wants to transfer the call to test2. Transfer is : #20 This is what the CLI shows : [Jul 2 10:55:30] -- Executing [20

Hello list, Can I do something like this for BLF functionality : [test-blf] exten => _XX,hint,Macro(GetSIPaccount,${EXTEN}) exten => _XX,hint,SIP/${SIPACCOUNT} GetSIPaccount is a macro that looks at a MySQL-database for the realtime table sip_buddies where the SIPusername is taken from. It works great for internal calls... but how about BLF-functionality ?? Feedback is appreciated !

Hello list, what musiconhold class has priority : - field "musiconhold" of the SIPaccount and field "musiconhold" of a queue or - Set(CHANNEL(musicclass)=) ?? Kind regards, Jonas. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110201/b27a0534/attachment.htm>

---------------------------------------- From: "Joshua Colp" <jcolp at digium.com> Sent: Sunday, October 4, 2015 12:12 PM To: asterisk-users at lists.digium.com Subject: Re: [asterisk-users] pjsip realtime registrations not pulling from ODBC On 15-10-04 01:09 PM, Bryant Zimmerman wrote: > -- > Joshua > Thanks for your reply. It thought the same thing, but when I

Hello list, I try to pick up a ringing extension but nothing works. To be clear, I'm trying to pick up extension 10. [Jun 14 17:37:34] -- Executing [**10 at from-TESTCORP:4] Pickup("SIP/testcorp3-00000041", "10 at 123456") in new stack [Jun 14 17:37:34] NOTICE[16555]: app_directed_pickup.c:159 pickup_exec: No target channel found for 10. [Jun 14 17:37:34] --

Hello List, I'm having problems with registrating my Asterisk-server to the SIP-provider. Yesterday all worked fine, this evening I cannot call out. What can be wrong ? This is my registration in sip.conf : register => 092779077:XXXX at 85.119.188.3 This the output of SIP show peers : asterisk*CLI> sip show peers Name/username Host Dyn Nat ACL Port Status

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

Hey list, I have a problem when I host 2 SIP-accounts on the same Asterisk-server. Asterisk picks out the SIP-account on alphabetic order A --> Z. In my sip.conf : register => user1:passwd1 at server/user1 register => user2:passwd2 at server/user2 [YOCAN-3starsnet] type=peer host=server username=user1 secret=passwd1 fromuser=user1 accountcode=user1_in [ITCENTER-3starsnet] type=peer

i have problem in compiling asterisk-addons 1.0.1 --------------------------------------------------------- [root@kamran asterisk-addons-1.0.1]# make cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -c -o cdr_addon_mysql.o cdr_addon_mysql.c ../asterisk: Not a directory make: *** [cdr_addon_mysql.o] Error 1 --------------------------------------------------------- i want to

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

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

On 15-10-04 09:54 AM, Bryant Zimmerman wrote: > I have a pjsip install that is not pulling it's realtime registrations > from an ODBC database. > When I have them directly pull from a MySQL database everything seems to > work. > I am having trouble finding a requirements document for the pjsip > realtime registrations. > Is there some kind of special config that has to be

Hello list, using asterisk 1.4.30 and trying GROUP() and GROUP_COUNT() for the first time... Having some troubles. This the dialplan (using a sub) : exten => s,n,Set(_custID=${custID}) exten => s,n,GROUP(${custID}) exten => s,n,NoOp(grouppcount = GROUP_COUNT(${custID})) exten => s,n,GoToIf($[ ${GROUP_COUNT(${custID})} > 2 ]?maxreached) The CLI shows : [Jun 5 16:06:26] --

Asterisk-server behind Endian-firewall: SIP-aware, 5060 + RTP-ports opened and 5060 forwarded to Asterisk (192.168.2.2) Can someone see why SIP-registration fails ?? register => 092779077:XXXX at 85.119.188.3 [3starsnet] type=peer host=85.119.188.3 username=092779077 secret=XXXX fromuser=092779077 fromdomain=sip.3starsnet.com dtmfmode=rfc2833 canreinvite=no insecure=port,invite qualify=yes