Displaying 20 results from an estimated 41 matches for "fetchid".
Did you mean:
fetched
2010 May 13
1
app_addon_sql_mysql.c:116 find_identifier
...: 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 => s,n,NoOp(fetchid = ${fetchid})
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,MacroExit()
[May 13 16:00:34] -- Executing [s at macro-GetMailboxFromSIPuserID:1]
MYSQL("SIP/testcorp-0827e670", &quo...
2007 Apr 13
2
MySQL query from extensions?
...-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 was
[${password}]-[${connid}]-[${fetchid}]-[${resultid}] )
exten => s,n,MYSQL(Clear ${password})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,return
I found no less than 15 ways to write this query on the net sear...
2005 May 18
1
Mysql cmd with Asterisk Problems
...om 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)
Mysql(Clear ${resultid})
Mysql(Disconnect ${connid})
However, it never gets past the fetch line. and ${r} is not showing
anything either from che CLI window.
I usesd the mysqlasteri web page to make the command escape character
happy, etc. I have tried putting \' around each i...
2006 Jan 20
1
Calling MySQL 5 stored procedures from app_mysql
...w") in new stack
-- Executing Set("IAX2/100-3", "QUERY=SELECT f_1('100')") in new stack
-- Executing MYSQL("IAX2/100-3", "Query resultid 1 SELECT f_1('100')")
in new stack
-- Executing MYSQL("IAX2/100-3", "Fetch fetchid 2 vm_active") in new
stack
Jan 21 00:26:15 WARNING[31631]: app_addon_sql_mysql.c:318 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
-- Executing NoOp("IAX2/100-3", "Voicemail active: 1") in new stack
-- Executing MYSQL("IAX2/100-3", "Clear 2") in new...
2006 Mar 28
1
Asterisk to MySQL Data Lookup Warning Message?
...ns?
Thanks.
JR
I'm dialing extension 1001
extensions.conf
[lookupmysql]
exten => _X.,1,MYSQL(Connect connid 10.10.10.110 asteriskdb password table)
exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\ fullcontact\ from\ table_sip\ where\ name=${EXTEN})
exten => _X.,3,MYSQL(Fetch fetchid ${resultid} var1)
exten => _X.,4,MYSQL(Clear ${resultid})
exten => _X.,5,MYSQL(Disconnect ${connid})
exten => _X.,6,GotoIf($["${var1}" = ""]?invalid,i,1:${EXTEN},7)
exten => _X.,7,ChanIsAvail(SIP/${EXTEN}&IAX2/${EXTEN}|sj)
exten => _X.,8,Set(direct=${var1:4})...
2011 Feb 18
2
cmd MySQL
...res/ WHERE/ ramal=200' at line 1
Its seems it can connect to mysql
My extension (AEL) is:
MySQL(Connect conn_id localhost root 123456 crm);
MySQL(Query resultid ${conn_id} SELECT/ ramal/ FROM/
colaboradores/ WHERE/ ramal=${EXTEN});
MySQL(Fetch fetchid ${resultid} RAMAL);
MySQL(Clear ${fetchid});
MySQL(Disconnect ${connid});
MySQL(Clear ${connid});
NoOp(${RAMAL});
Where is the error? Thanks!!
The MySQL server is in the same server where Asterisk is running.
Thanks!!!
---------...
2008 Jan 17
0
Paging Recording File
...>> /var/log/asterisk/
pagemacro_var.log)
exten => s,4,MYSQL(Connect connid ${realdb_host} ${realdb_user} $
{realdb_pass} ${realdb_db})
exten => s,5,MYSQL(Query resultid ${connid} SELECT\ name\ FROM\ sip\
WHERE\ name\ LIKE\ "'${ARG1}%'")
exten => s,6,MYSQL(Fetch fetchid ${resultid} number)
exten => s,7,GoToIf($["${fetchid}" = "1"]?8:10)
exten => s,8,Set(pagedevice=${pagedevice}&SIP/${number})
exten => s,9,GoToIf($["${fetchid}" = "1"]?6:10)
exten => s,10,Set(pagedevice=${pagedevice:1})
exten => s,11,MYSQL(C...
2011 Jun 07
2
What is wrong in m
Hi everyone,
What is wrong in below asterisk application? The output should be content of
field booth_status from table booths:
[extension-status]
exten => _X.,1,MYSQL(Connect connid 127.0.0.1 root password my-extensions)
exten => _X.,n,MYSQL(Query allow_call ${connid} SELECT extension_status FROM
mytable WHERE extension=${CALLERID(num)} ORDER BY id DESC LIMIT 1)
exten =>
2011 May 17
1
mysql call stored procedure
...-----+
| 1 |
+------+
So I need asterisk to recognize this pass and take some actions based on
what the pass value is.
Dialplan looks like this:
MYSQL(Connect connid ${DBDefaultHost} ${DBuser} ${DBpass} ${DBname})
MySQL(Query resultid ${connid} CALL call_control(78236721,1000,1233))
MySQL(Fetch fetchid ${resultid} pass)
MYSQL(clear ${resultid})
MySQL(Query resultid ${connid} SELECT/INSERT whatever from table)
So, it gives me this pass value correct, but if I execute some other query
INSERT or SELECT after clearing the result, it gives me an error
[May 17 16:16:13] WARNING[19572]: app_addon_sql_m...
2006 Sep 26
1
fetchmail can't talk to dovecot
...hentication failed.
fetchmail: Authorization failure on user_name at my.server
fetchmail: POP3> QUIT
fetchmail: POP3< +OK Logging out
fetchmail: 6.3.2 querying my.server (protocol POP3) at Wed 27 Sep 2006 12:15:21 AM CEST: poll completed
fetchmail: Query status=3 (AUTHFAIL)
fetchmail: Writing fetchids file.
fetchmail: normal termination, status 3
fetchmail: Writing fetchids file.
if I try with IMAP the part after the certificate verification error is:
fetchmail: IMAP> A0003 CAPABILITY
fetchmail: IMAP< * CAPABILITY IMAP4rev1 SASL-IR SORT THREAD=REFERENCES MULTIAPPEND UNSELECT LITERAL+ ID...
2008 Dec 16
1
interesting problem
...=> _5[14-9]XXX,n,Playtones(ring)
exten => _5[14-9]XXX,n,MYSQL(Connect CONNID localhost asterisk HG06e6kghpUjtGvnX asterisk)
exten => _5[14-9]XXX,n,MYSQL(Query RESULTID ${CONNID} Select 'fullname' from voicemail_users Where mailbox=${EXTEN})
exten => _5[14-9]XXX,n,MYSQL(Fetch FETCHID ${RESULTID} FULLNAME)
exten => _5[14-9]XXX,n,MYSQL(Disconnect ${CONNID})
exten => _5[14-9]XXX,n,GotoIf($[${FETCHID} = 1]?connect:disconn)
exten => _5[14-9]XXX,n(connect),StopPlaytones()
exten => _5[14-9]XXX,n,Wait(2)
exten => _5[14-9]XXX,n,Playback(you-have-dialed)
exten => _5[...
2007 Sep 20
1
Paging MEETME_RECORDINGFILE Variable
...page the PA system. That will be included.
;
exten => s,1,MYSQL(Connect connid ${realdb_host} ${realdb_user} $
{realdb_pass} ${realdb_db})
exten => s,2,MYSQL(Query resultid ${connid} SELECT\ name\ FROM\ sip\
WHERE\ name\ LIKE\ "'${ARG1}%'")
exten => s,3,MYSQL(Fetch fetchid ${resultid} number)
exten => s,4,GoToIf($["${fetchid}" = "1"]?5:7)
exten => s,5,Set(pagedevice=${pagedevice}&SIP/${number})
exten => s,6,GoToIf($["${fetchid}" = "1"]?3:7)
exten => s,7,Set(pagedevice=${pagedevice:1})
exten => s,8,MYSQL(Clear...
2008 Jan 07
1
extension.conf with mysql
...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)
...
.
...
after this I am getting confused. My moto is to display the number in the
database and need to check with my outgoing number.
how to display fetched number from the database.
--
Thank you with regards,
Gopal
<http://www.peopletech.co.in>
-------------- nex...
2008 Mar 06
1
AEL - SQL and TIMEDIFF()
...n in the MySQL() application for the
Asterisk dialplan that produces this error?
<CODE>
context testsql {
s => {
MYSQL(Connect connid ${DBHOST} ${DBUSER} ${DBPASS} ${DB});
MYSQL(Query resultid ${connid} SELECT TIMEDIFF(callend,callstart) FROM
tblCall WHERE id=7);
MYSQL(fetch fetchid ${resultid} temp);
MYSQL(Disconnect ${connid});
}
}
</CODE>
The error I'm getting is below:
[Mar 6 08:59:35] WARNING[27116]: app_addon_sql_mysql.c:268 aMYSQL_query:
aMYSQL_query: mysql_query failed. Error: You have an error in your SQL
syntax; check the manual that corresponds to...
2015 Mar 16
1
Use dialplan variables from MySQL database and replace with value
...e ${PARAMS} contains the exact
string of the database field :
my dialplan :
exten => s,n,MYSQL(Connect connid localhost dbuser dbpass MyTable)
exten => s,n,MYSQL(Query resultid ${connid} SELECT script_url,
script_params FROM my_tbl WHERE ID="${myID}")
exten => s,n,MYSQL(Fetch fetchid ${resultid} scriptURL PARAMS)
exten => s,n,NoOp(scriptURL = ${scriptURL} PARAMS = ${PARAMS})
becomes :
-- Executing [s at sub-details:4] MYSQL("SIP/SipT01-00000012", "Connect
connid localhost dbuser dbpass MyTable") in new stack
-- Executing [s at sub-details:5] MYSQL(&quo...
2009 Apr 22
1
Upgrading from 1.4.21.2 to 1.6.0.5 breaks sql queries with backslashes?
...x-generic-cc-get-vpbx-number]
exten => s,1,MYSQL(Connect connid ${DBHOST} ${DBUSER} ${DBPW} ${DBNAME})
exten => s,2,MYSQL(Query resultid ${connid} SELECT vpbx_id\,vpbx.password\,vpbx.name FROMext\,vpbx WHERE mailbox="${CALLERID(num)}" and vpbx_id=vpbx.id)
exten => s,3,MYSQL(Fetch fetchid ${resultid} vpbx-id vpbx-password vpbx)
exten => s,4,MYSQL(Clear ${resultid})
exten => s,5,MYSQL(Query resultid ${connid} SELECT mailbox FROM ext\,devtype WHERE active="Y" and ext.devtype_id=devtype.id and devtype.model like "AUTOATTENDANT%" and vpbx_id=${vpbx-id})
exten =...
2010 Sep 03
0
How to use MYSQL(Set timeout x)
...9999,n,MYSQL(Connect connid localhost user pass asterisk)
exten => 9999,n,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)})
exten => 9999,n,MYSQL(Query resultid ${connid} SELECT SLEEP(10))
exten => 9999,n,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)})
exten => 9999,n,MYSQL(Fetch fetchid ${resultid} RESULT)
exten => 9999,n,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)})
exten => 9999,n,MYSQL(Clear ${resultid})
exten => 9999,n,NoOp(${STRFTIME(${EPOCH},,%Y-%m-%d %H:%M:%S)})
exten => 9999,n,MYSQL(Disconnect ${connid})
exten => 9999,n,NoOp(${STRFTIME(${EPOC...
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
2008 Dec 22
0
interesting problem update
...=> _5[14-9]XXX,n,Playtones(ring)
exten => _5[14-9]XXX,n,MYSQL(Connect CONNID localhost asterisk
HG06e6kghpUjtGvnX asterisk)
exten => _5[14-9]XXX,n,MYSQL(Query RESULTID ${CONNID} Select 'fullname'
from voicemail_users Where mailbox=${EXTEN})
exten => _5[14-9]XXX,n,MYSQL(Fetch FETCHID ${RESULTID} FULLNAME)
exten => _5[14-9]XXX,n,MYSQL(Disconnect ${CONNID})
exten => _5[14-9]XXX,n,GotoIf($[${FETCHID} = 1]?connect:disconn)
exten => _5[14-9]XXX,n(connect),StopPlaytones()
exten => _5[14-9]XXX,n,Wait(2)
exten => _5[14-9]XXX,n,Playback(you-have-dialed)
exten => _5[...
2006 Jan 11
17
Nested MySQL Commands
Is it possible to have nested MySQL queries in extensions.conf?
Ie, perform a query, grab a value, and then jump to another location in the dialplan and do another query based on that original value. I'm having problems with the result and fetchid's and I'm not sure if it's even possible to do this or not.
Thanks,
Doug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060111/45029dd5/attachment.htm