similar to: [SPAM] - MySQL Error Message - Email found in subject

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:

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

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

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

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

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)

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

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

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

Trying to create an extension that will toggle an enum value in our database... exten => s,1,MYSQL(Connect connid localhost myuser tmppass asterisk) exten => s,n,MYSQL(Query resultid ${connid} UPDATE\ night_service\ SET\ status=(SELECT\ CASE\ status\ WHEN\ \'y\'\ THEN\ \'n\'\ ELSE\ \'y\'\ END)); exten => s,n,MYSQL(Clear ${resultid}) exten =>

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:

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

Hello, notice in the console output beneath that there is a resultid 6 but it can not be cleared : [May 5 11:46:27] -- Executing [s at sub:3] MYSQL("SIP/vart-00000336", "Connect connid localhost dialplan host Asterisk") in new stack [May 5 11:46:27] -- Executing [s at sub:4] MYSQL("SIP/vart-00000336", "Query resultid 4 DELETE FROM pickuptbl WHERE

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

I have asterisk 1.4 ,the function that I am using in extensions.conf is not functioning Its was functioning on asterisk 1.2.further more cdr_addon_mysql.so cdr_csv.so cdr_custom.so cdr_manager.so cdr are loaded Is there any missing module ? Function IS for example exten => *70,n,MYSQL(Connect connid 127.0.0.1 root passw0rd asterisk) exten =>