search for: connid

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 hash it out. It works without the % sign. Thanks Kind Regards Garth

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 was [${password}]-[${connid}]-[${fetchid}]-[$...

...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 use: exten => sav,n,MYSQL(Connect connid localhost root password dax) exten => sav,n,MYSQL(QUERY resultid ${connid}UPDATE\ dnislookup\ SET\ ${BINID}\ =\ ${NEWPHRASENAME}\ WHERE\ dnis\ =\ ${IVR-Exten}) But I've tried this too: exten => sav,n,MYSQL(Connect connid localhost root password dax) exten => sav,n,MYSQL(QUERY result...

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) ... . ... after this I am...

Hi people, I'm trying to retrieve data from the database (server MySQL). I have the following dial plan: exten => s,1,Noop(Start) exten => s,n,MYSQL(Connect connid localhost user pass asteriskcdrdb) exten => s,n,Noop(Connid: ${connid}) ... The problem is that the 3? line is not showing the connid. How can I know the error? Thanks, _________________________________________________________________ Nuevo Windows Live, un mundo lleno de posib...

...l 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) 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 ha...

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}" = ""]?nodb) exten => 6912345678,n,MYSQL(Query resultid ${connid} SELECT displayname FROM root WHERE phonenumber="${CALL...

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

...re. 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: 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 e...

An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: bhfisher.vcf Type: text/x-vcard Size: 253 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.vcf

...fo about it. warning message: Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318 aMYSQL_fetch: ast_MYSQL_fetch: numFields=1 Should I be concerned? Does anyone know what it means? 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...

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 => s,n,MYSQL(Disconnect ${connid}) exte...

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\ lastcall=${LASTCALL}\,totalcalls=totalcalls+1\,currentcalls=currentcalls+1\ WHERE\ dnis=\'${IVR-Exten}\'\ AND\ ani=\'${CALLERID(number)}\') exten => update,n,MYSQL(Clear ${resu...

...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 => { 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]...

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 => _X.,n,NoOp(allow_call is: ${allow_call}) But I get: *"allow_call is: 4" *while it should a...

...39;lblin' in passdb. [2002/05/17 16:24:16, 2] smbd/reply.c:reply_sesssetup_and_X(963) NT Password did not match for user 'lblin'! ############################################# LDAP LOGS: ------------------------- ldap_pvt_gethostbyname_a: host=obiwan, r=0 connection_get(9): got connid=0 connection_read(9): checking for input on id=0 ber_get_next ber_get_next: tag 0x30 len 29 contents: do_extended ber_scanf fmt ({a) ber: ber_get_next ber_get_next on fd 9 failed errno=11 (Resource temporarily unavailable) send_ldap_extended 0: (0) send_ldap_response: msgid=1 tag=120 err=0 ber_flus...

On Fri, Aug 18, 2023 at 04:25:28PM +0000, Jones Syue ??? wrote: >Hello Ivan, > >'FastCopy' has an option to revise max I/O size and works for SMB :) >it is a tool for file transferring and could be installed to win10, >download here: https://fastcopy.jp/ > >This is an example for writing, a job would write a file named '1GB.img' >from a local disk

Hi, If Iam doing UPDATE SQL statements I got an overload for connection. am doing everytime an Disconnect ${connid}) but this is ignored. any idea? best regards Thomas

...to remote SMB mount disk 'Z', and monitor them with procmon: 1. FastCopy (FastCopy.exe), 8MB (need to revise FastCopy default setup) Process Name Operation Path Detail System TCP Send 10.19.7.63:64845 -> 10.19.250.98:445 Length: 8388724, startime: 3459115, endtime: 3459149, seqnum: 0, connid: 0 System TCP Receive 10.19.7.63:64845 -> 10.19.250.98:445 Length: 84, seqnum: 0, connid: 0 FastCopy.exe WriteFile \\10.19.250.98\Public\1GB.img Offset: 92,274,688, Length: 8,388,608, Priority: Normal 2. File Explorer (explorer.exe), 1MB, drag-and-drop files. Process Name Operation Path Detail...

Hello Everyone! According to voip-info.org the correcy syntax for the realtime function is: REALTIME(family|fieldmatch[|value[|delim1[|delim2]]]) on read REALTIME(family|fieldmatch|value|field) on write It seems from the syntax that it is only possible to retrieve a full row according to the value of only of column. This translates in SQL language as Select * from family where fieldmath =