similar to: Question about MySQL Fetch foundRow from the dial plan

I'm on asterisk 1.6.1.0 and asterisk addons 1.6.1.0 (also using freepbx 2.5 with cidlookup module from mysql database). There are some incompatible changes in asterisk 1.6 about MYSQL addon application syntax for querying a mysql database. It seems that escaping of space and single quotes is no longer needed - see 3rd line of attached example from

hi folks, I use Dial(Local/extension@context) to make calls received on my DID number to ring a local extension. I notice that on 8 out of 10 calls, the audio is NOT working in the incoming direction (DID provider to asterisk). Local extension 2055 maps to SIP destination "homephone", and if i replace the Dial(Local/2055@local) with Dial(SIP/homephone), it works fine 100% of the

Does anybody know of a way to test whether a mySQL connection invoked from the dialplan is current or not? For example: extensions.conf =============== [context] exten => _X.,1,MYSQL(Connect connid localhost user pass db) exten => _X.,n,MYSQL(Query resultid ${connid} SELECT `something` FROM `table` WHERE `number` = ${EXTEN}) exten => _X.,n,MYSQL(Fetch foundRow ${resultid} something)

Hi, The problem solved After installing new zaptel drivers, we ran the "genzaptel" command to generate /etc/zaptel.conf file,checked with "zttool" command and the card status was "Yellow alarm/Blue alarm/Recovering" and the card LED was blinking red and green. The problem was with the generated zaptel configuration., but not with the pin

Are there any deny tools with samba4? Like the below example? To set the permission to deny read access of the homePhone attribute on a single user object, you can use this command: dsacls <DN of object> /D <security principal>:RP;homePhone For our example, the command would look like this: dsacls "CN=Doe\, John,OU=newOU,DC=root,DC=net" /D root\ non-HR-users:RP;homePhone

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

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

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

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

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 All... I'm trying to use the record() app and it complains that it can't open it's file because permission was denied. I'm running the released Asterisk on Debian Linux. The target directory is workd writable. Here is the relevant part of the dialplan: exten => 1,1,Playback(leave-message) exten => 1,2, Record(/var/local/whois-messages/whois-${contactid}:wav|6|120)

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

Thanks a lot for the reply. I did follow that already, but i do have a problem. Here is my extensions.conf part for that particular number exten => 6912345678,1,Answer() exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd asterisk) exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8) exten => 6912345678,n,GotoIf($["${connid}" =

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)

Hey all, When using the Ajax.autocompleter, how would I configure it so that the user is searching based on an entry''s name, but once they select an entry, I record the ID? I have the user entering a person''s name in a text box to make it easier to find contacts in a large database. I know that I can display content that doesn''t end up in the textbox by using

Hey all, I'm sorry to bother you with something so trivial, but I seem to be having an issue with the Asterisk::AGI module. I am a relative newbie with Perl so it could be a stupid syntax mistake that I missed. It seems when I try to execute either the stream_file or the get_data subs nothing is actually done. It doesn't seem to stream the files, but on the console it says it played the

Hey everybody, I'm hoping someone can look over the below statement and tell me if I've got something wrong. Yesterday, after running the MySQL addon version 1.2.4 under Asterisk 1.2.17 for a couple months, I started to get connection failures for one of my systems. Logging into the webmin module for MySQL, I saw the above error. I'm currently running MySQL 4.1.12. Am I doing

http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html Max connections is set to 100+1 by default. Maybe you just need to raise that number. Otherwise, figure out why connections are staying open if they are. Thanks, Steve Totaro http://www.asteriskhelpdesk.com/component/option,com_wrapper/Itemid,37/ KB3OPB > -----Original Message----- > From: