Displaying 20 results from an estimated 1000 matches similar to: "Re: Best way to access MySQL data from dial plan"
2006 Dec 18
1
Re: Best way to access MySQL data from dial plan
Resending as message didn't show up the first time
>I need to access MySQL from the dial plan. Currently I am using the MYSQL
>function:
> exten => *78,n,MYSQL(Connect asterisklocal localhost asteriskuser password
> asterisk)
> exten => *78,n,MYSQL(Query resultid ${asterisklocal} CALL\
> sp_ins_into_avp(\'/DND/${CALLERID(number)}\'\,\'YES\'))
>
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!
>
> Thanks
>
> What is a better way to do it then in terms of performance, security,
2007 Jan 26
0
realtime sipusers and rtcachefriends... bigheadache!!
----- Original Message -----
From: "kjcsb" <kjcsb@orcon.net.nz>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Wednesday, January 24, 2007 8:24 AM
Subject: Re: [asterisk-users] realtime sipusers and rtcachefriends...
bigheadache!!
>
>> hi folks,
>>
>> I am using asterisk 1.2.13 (debian
2004 Jun 01
1
Feedback needed! FindMe/FollowMe FeatureSpec.
Hi Adam,
I appreciate your feedback, and understand totally where you're coming
from as far as the database perspective goes.
For the first "draft" of the app, I think I'm going to let it default to
using a conf file for two reasons.
First, my setup currently does not utilize a database. I would like to
move to that type of a setup in the future however.
Secondly, seeing as
2005 Dec 29
2
form_remote, getting data from submit
Hi list,
I'm writing a little survey application, and surveys are generated
dynamically. I use form_remote_tag and AJAX to submit the form to a
method 'submit' in my 'survey' controller.
The view generates the form as:
<tr>
<td>Question 1?</td>
<td><input id="resultset_1" name="resultset[1]" size="30"
2006 Nov 13
0
Question about MySQL Fetch foundRow from the dial plan
I have a query that query's my database based on the read input for an ID
number.
exten => s,4,MYSQL(Query resultid ${connid} SELECT\ `FirstName`\
`HomePhone`\ FROM\ `contacts`\ WHERE\ `ContactID`= \'${ID}\')
exten => s,5,MYSQL(Fetch foundRow ${resultid} var1 var2) ; fetch row
Problem is is that when I do the following:
exten => s,7,Cepstral(The Phone number for ${var1} is
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
2005 Jun 07
0
Ruby/Odeum 0.4: ResultSets, KirbyBase Demo
Hello,
An announcement for another version of Ruby/Odeum 0.4.
http://www.zedshaw.com/projects/ruby_odeum/index.html
http://www.zedshaw.com/downloads/ruby_odeum/ruby_odeum-0.4.tar.bz2
http://www.zedshaw.com/downloads/ruby_odeum/ruby_odeum-0.4.gem
***This release will break your existing code.*** Read the ResultSet
documentation for how to make your changes.
Important features of this release
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:
2001 Feb 22
2
Problem with tcltk listbox
Hi!
I've got two problems with listboxes and selection:
I created a listbox, no problem. Then I bind the Button-1 of the mouse to the listbox to start some things by pressing the mousebutton. The proiblem is that as I click a item of the listbox this error occured:
Error in .Tcl(.Tcl.args(...)) : [tcl] bad listbox index "": must be active, anchor, end, @x,y, or a number.
Repaeting
2013 Feb 01
2
help on proportions
Hi:
Apologies for asking the following question. As?this may sound very basic and stupid for this forum?, I honestly do not know how to solve it and I do not have a teacher who can help me understand.
?
I have list of genes (200)?that are involved in a particular process and I call this as a?ProcSet.?? From an independent experiment I found that out of 10,000 genes, 1500 are significant and I
2009 Apr 22
1
Upgrading from 1.4.21.2 to 1.6.0.5 breaks sql queries with backslashes?
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
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]:
2006 Mar 14
4
Stuck. Extenions.conf? Realtime? MySQL? Grrrrr!
Boy, am I stuck...
I'm officially ready to toss Asterisk out the window. I have to admit it isn't necessarily all the fault of Asterisk either. It just seems that every option I turn to suddenly ends in failure. I don't know if it's me that's bitten of more than I can chew with this project, or maybe Asterisk just isn't mature enough yet.
Nothing complicated really....
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\
2010 Jul 21
0
One problem with RMySQL and a query that returns an empty recordset
My last query related to this referred to a problem with not being able to
store data. A suggestion was made to try to convert the data returned by
fitdist into a data.frame before using rbind. That failed, but provided the
key to solving the problem (which was to create a data.frame using the
variables fitdist produces in the object it returns).
I now have almost everything working as
2002 Jul 07
1
samba issue?
My current smb.conf http://mdew.orcon.net.nz/samba/smb.conf , isnt
showing up in windows b0xes (Win2k)
I can however mount my drive from the linux router, and it shows this
error (maybe unrelated/related to this..)
mount /sharing/ryan
smb_get_length: recv error = 5
smb_trans2_request: result=-5 setting invalid
smb_retry: succesful, new pid=32382, generation=2
My drive is browsable from the
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 Oct 23
0
SIP_HEADER function; what names are available?
Minor update - use the following:
> if (strcasecmp(data,
> "x-Asterisk-Request-URI-pseudo-header")==0)
> {
> ast_copy_string(buf, p->initreq.rlPart2, len);
> -----Original Message-----
> From: Steve Langstaff
> Sent: 23 October 2006 09:58
> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> Subject: RE: [asterisk-users]
2010 Sep 03
0
How to use MYSQL(Set timeout x)
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 =>