Displaying 20 results from an estimated 800 matches similar to: "Re: Best way to access MySQL data from dial plan"
2006 Dec 18
0
Re: Best way to access MySQL data from dial plan
I'm not sure that any solution with the MySQL dialplan command is going to be ideal. You also can't nest your queries, ie the connectid/result id seems to only be good for one resultset at a time... try doing something like findme/followme with that!
Doug.
> -----Original Message-----
> From: kjcsb [mailto:kjcsb@orcon.net.nz]
> Sent: Monday, December 18, 2006 11:33 AM
> To:
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:
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
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
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]:
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
2007 Apr 19
1
MySQL Update from 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\
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)
2007 Apr 16
1
Stuck on MySQL UPDATE
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
2009 Aug 30
2
MySQL syntax error : I really don't see where...
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
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
2017 Apr 22
4
asterisk name in mysql
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}" =
2003 Jun 24
1
parsing bug? (using PGSQL)
Hi all again,
if i make a query with
...
exten => _X.,2,PGSQL,"Query resultid ${connid} SELECT getdest('${EXTEN}')";
...
an error like
WARNING[32785]: File pbx.c, Line 1126 (pbx_extension_helper): No application
'PGSQL,"Query resultid ${connid} 'SELECT getdest'
for extension (tel1, 00905888, 2)
occurs.
This looks like an parsing bug. As if the brackets be
2007 Apr 02
1
Mysql issue
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 =>
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 =>
2010 Jan 25
1
MYSQL grammar diff in 1.6.2.1?
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
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",
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)
2012 May 05
2
Mysql identifier not found
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
2005 Feb 02
2
using the MYSQL command to insert a record
I am trying to use the MYSQL command to insert a
record into a database and I can't seem to get it to
work. I can do an UPDATE with no problem.
Here is the line in my dialplan
exten => s,12,MYSQL(QUERY resultid ${connid} INSERT
INTO `member` ( `id` , `member_num` , `active` )VALUES
('',${number}' , '1'))
Does anyone have an example of an INSERT INTO that I
could look