search for: dbget

Hello I upgraded to CVS head yesterday (due to the lack of zaptel drivers working with 2.6.10) And noticed that now DBGet and DBPut have been deprecated in favour of the new Set/DB one. In the UPGRADING.txt in Asterisk it says: * The applications DBGet and DBPut have been deprecated in favor of functions. Here is a table of their replacements: DBGet(foo=family/key) Set(foo=${DB(family/key)}) DBPut...

Where can I learn the syntax for DBput and DBget? is it working with MySQL? do I need to set up tables? URiel -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20030508/a2598dc8/attachment.htm

...t;SIP/700-8d41", "dialout-trunk|2|9******|") in new stack -- Executing GotoIf("SIP/700-8d41", "1?3:2)") in new stack -- Goto (macro-dialout-trunk,s,3) -- Executing Macro("SIP/700-8d41", "user-callerid") in new stack -- Executing DBget("SIP/700-8d41", "AMPUSER=DEVICE/700/user") in new stack -- DBget: varname=AMPUSER, family=DEVICE, key=700/user -- DBget: set variable AMPUSER to 700 -- Executing DBget("SIP/700-8d41", "AMPUSERCIDNAME=AMPUSER/700/cidname") in new stack -- DBg...

...quot;) in new stack -- Executing Goto("Zap/2-1", "ext-local|*101|1") in new stack -- Goto (ext-local,*101,1) -- Executing Macro("Zap/2-1", "vm|101") in new stack -- Executing Macro("Zap/2-1", "user-callerid") in new stack -- Executing DBget("Zap/2-1", "AMPUSER=DEVICE//user") in new stack -- DBget: varname=AMPUSER, family=DEVICE, key=/user -- DBget: Value not found in database. -- Executing DBget("Zap/2-1", "AMPUSERCIDNAME=AMPUSER//cidname") in new stack -- DBget: varname=AMPUSERCIDNAME, fami...

...quot;) in new stack -- Executing Goto("Zap/2-1", "ext-local|*101|1") in new stack -- Goto (ext-local,*101,1) -- Executing Macro("Zap/2-1", "vm|101") in new stack -- Executing Macro("Zap/2-1", "user-callerid") in new stack -- Executing DBget("Zap/2-1", "AMPUSER=DEVICE//user") in new stack -- DBget: varname=AMPUSER, family=DEVICE, key=/user -- DBget: Value not found in database. -- Executing DBget("Zap/2-1", "AMPUSERCIDNAME=AMPUSER//cidname") in new stack -- DBget: varname=AMPUSERCIDNAME, fami...

hi, This question is about DBPut and DBGet, Can i put about 1000 keys in a single family, (only once for the lifetime) for ex. exten => _X.,5,DBput(family/key1=${val}) ... exten => _X.,5,DBput(family/key1000=${val}) like above and if i later retrieve it, randomely, with inbound calls, will it affect performance? Suraj...

...tly identify null values, specifically when callerID info is not available. FYI, I'm running Asterisk CVS-HEAD-08/17/04-13:08:53, and Bison 1.875a (debian Sid). A snippit of my dialplan looks like this: exten => s,1,SetCIDNum(${CALLERIDNUM}) exten => s,2,NoOp,${CALLERID} exten => s,3,DBGet(temp=idiot/${CALLERIDNUM}) ; Is the person calling an idiot? exten => s,4,Goto(s,2001) ; Yep, he's an idiot. ; else check for callerID. If none (or 800 number,) handle special. exten => s,104,GotoIf($[${CALLERIDNUM} = ""]?s|1000:s|105) exten => s,105,GotoIf($[${CALLERIDNUM:0...

...-- Executing Goto("Zap/1-1", "ext-local|220|1") in new stack -- Goto (ext-local,220,1) -- Executing Macro("Zap/1-1", "exten-vm|novm|220") in new stack -- Executing Macro("Zap/1-1", "user-callerid") in new stack -- Executing DBget("Zap/1-1", "AMPUSER=DEVICE//user") in new stack -- DBget: varname=AMPUSER, family=DEVICE, key=/user -- DBget: Value not found in database. -- Executing DBget("Zap/1-1", "AMPUSERCIDNAME=AMPUSER//cidname") in new stack -- DBget: varname=AMPUSERC...

...;s useful to some of you. Grtz, Oliver ; ; Macros ; [macro-stdexten]; ; ; Standard extension macro: ; ${ARG1} - Extension (we could have used ${MACRO_EXTEN} here as well ; ${ARG2} - Device(s) to ring ; ${ARG3} - Timeout ; ${ARG4} - Other options to app_dial ; exten => s,1,DBget(fwdexten=FEAT/${ARG1}/CFWD/CFU) exten => s,102,Goto(s|4) exten => s,2,DBget(fwdcontext=FEAT/${ARG1}/CFWD/CFUC) exten => s,3,Goto(${fwdcontext}|${fwdexten}|1) exten => s,4,Dial(${ARG2},${ARG3},${ARG4}) exten => s,105,Goto(s|205) exten => s,5,DBget(fwdexten=FEAT/${ARG1}/CFWD/CFNA) e...

Hi, do i need some other software than asterisk to use database commands - dbput and dbget in asterisk ? regards Marian -- SUNTEQ s. r. o. Hviezdoslavova 9 # Prievidza # 971 04 # Slovak republic Tel: +421-46-5430 754 # Fax: +421-46-5439 144 http://www.sunteq.sk/ ------------------------------------------------------------ A mind is like a parachute... it only works when it's o...

Hallo all! Know somebody, if exist Dialplan commands (specifically sql sentences) for Asterisk Realtime? For example: I have users defined in mysql database. In the dialplan, I would like to select one field of a table. select email from sip_buddies where name=200 I try to use DBget, but I have error. I think because DBget use intern Database, and can 't connect to mysql. (Sintaxis: DBget(varname=family/key)) I think (if it does not exist at the moment) that it is very interesant we can write in the dialplan sql-sentences What think about this? Leonardo F. Bauchwitz...

...quot;) in new stack -- Executing Goto("Zap/2-1", "ext-local|*101|1") in new stack -- Goto (ext-local,*101,1) -- Executing Macro("Zap/2-1", "vm|101") in new stack -- Executing Macro("Zap/2-1", "user-callerid") in new stack -- Executing DBget("Zap/2-1", "AMPUSER=DEVICE//user") in new stack -- DBget: varname=AMPUSER, family=DEVICE, key=/user -- DBget: Value not found in database. -- Executing DBget("Zap/2-1", "AMPUSERCIDNAME=AMPUSER//cidname") in new stack -- DBget: varname=AMPUSERCIDNAME, fami...

...xecuting NoOp("SIP/208-f55b", "Sending to Voicemail box 200") in new stack -- Executing Macro("SIP/208-f55b", "vm|200@default|NOANSWER") in new stack -- Executing Macro("SIP/208-f55b", "user-callerid") in new stack -- Executing DBget("SIP/208-f55b", "AMPUSER=DEVICE/208/user") in new stack -- DBget: varname=AMPUSER, family=DEVICE, key=208/user -- DBget: set variable AMPUSER to 208 -- Executing DBget("SIP/208-f55b", "AMPUSERCIDNAME=AMPUSER/208/cidname") in new stack -- DBget...

This patch adds a 'DBGetComplete' event after the 'DBGetResponse' to bring the behavior of the DBGet Action in line with how other actions behave. I have tested the patch against 1.4.29.1 and it worked for me. Patch is available on the issue page. https://issues.asterisk.org/view.php?id=16965 Please post you...

...;0?20") in new stack -- Executing Ringing("Zap/10-1", "") in new stack -- Executing Wait("Zap/10-1", "0") in new stack -- Executing Macro("Zap/10-1", "stdfwd3iax-notransfer|200|200| 100") in new stack -- Executing DBget("Zap/10-1", "temp=CFIM/200") in new stack -- DBget: varname=temp, family=CFIM, key=200 -- DBget: Value not found in database. -- Executing Goto("Zap/10-1", "3") in new stack -- Goto (macro-stdfwd3iax-notransfer,s,3) -- Executing Dial(...

...All works fine except Audio is lost 10minutes into the call. This happens for every call PSTN-SIP, SIP-PSTN, SIP-SIP Example of one call setup using Snom200 and Grandstream 486: -- Executing Macro("SIP/xxxx1251-d638", "CFW|xxxx1251|SIP/xxxx1253") in new stack -- Executing DBget("SIP/xxxx1251-d638", "temp=CFIM/xxxx1253") in new stack -- DBget: varname=temp, family=CFIM, key=xxxx1253 -- DBget: Value not found in database. -- Executing Goto("SIP/xxxx1251-d638", "s|4") in new stack -- Goto (macro-CFW,s,4) -- Executin...

I just inherited a Cisco 2621 with a VWIC-1MFT-T1 card in it. Can I make this thing into MGCP gateway or even a SIP gateway for asterisk? Seems like it should bee useful for something! I'm perfectly happy to do my homework, but also don't feel thee need to reinvent the wheel! So, links with relevant info would be appreciated. If there is a config for a 2621 being used as a gateway

...ot;SIP/201-8571", "FROMCONTEXT=exten-vm") in new stack -- Executing GotoIf("SIP/201-8571", "0?9:5") in new stack -- Goto (macro-exten-vm,s,5) -- Executing Macro("SIP/201-8571", "dial-new|15|tr|202|202") in new stack -- Executing DBget("SIP/201-8571", "CallForwardIm=CF/202") in new stack -- DBget: varname=CallForwardIm, family=CF, key=202 -- DBget: Value not found in database. -- Executing Goto("SIP/201-8571", "s|4") in new stack -- Goto (macro-dial-new,s,4) -- Executing...

...n => _72X.,1,DBput(SIP/${CALLERIDNUM}=${EXTEN:2}) exten => _72X.,2,SayDigits,${CALLERIDNUM} exten => _72X.,3,SayDigits,${EXTEN:2} exten => _72X.,4,Hangup exten => 71,1,DBdel(SIP/${CALLERIDNUM}) exten => 71,2,Hangup ; i'm sure we can do this with macro's exten => 2000,1,DBget(temp=SIP/2000) exten => 2000,2,Goto(${temp}|1) exten => 2000,102,Goto(2000|3) exten => 2000,3,DBget(dnd=DND/2000) exten => 2000,4,Goto(2000|6) exten => 2000,104,Goto(2000|5) exten => 2000,5,Dial(SIP/2000,20) exten => 2000,6,Voicemail2(u2000) exten => 2000,7,Hangup exten =&gt...

...============================================================================== I tried changing the image resolution by doing below in my dial plan but still i get the same resolution as above. [macro-faxreceive] exten => s,1,SetVar(FAXFILE=/var/spool/asterisk/fax/${UNIQUEID}) exten => s,2,DBGet(EXTEMAIL=${MACRO_EXTEN}/Email) exten => s,3,NoOP() exten => s,4,DBGet(EXTNAME=${MACRO_EXTEN}/Name) exten => s,5,NoOP() exten => s,6,DBGet(EXTCOMPANY=${MACRO_EXTEN}/Company) exten => s,7,SetVar(FAXRESOLUTION=6000 x 3000) exten => s,8,rxfax(${FAXFILE}.tif|debug) exten => s,103,Se...