similar to: CDR: MySQL query

Hi, I would like to see the DNID in my MySQL CDR logs. I have read one big thread in the Asterisk Developer List, but I could not figure out how to implement it ? Is there a simple step-by-step. Thx in advance. Vai

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

Hi all, In order to use the "open url" function of zoiper (it opens an url based on the asterisk $callerid(dnid)), I need rewriting of the dnid. In my dialplan I have: exten => 1000,3,Set(CALLERID(dnid)=newdnid) exten => 1000,4,Noop(${CALLERID(dnid)}) exten => 1000,5,Queue(test-queue) but the callerid(dnid) shows the extension called (the member of the test-queue) and not

Hi. I've discovered a bug in the Dial() string processing (for Asterisk 13.14.1 at least). According to the documentation in channels/chan_sip.c the Dial() string syntax is: * SIP/devicename * or SIP/username at domain (SIP uri) * or SIP/username[:password[:md5secret[:authname[:transport]]]]@host[:port] * or SIP/devicename/extension * or SIP/devicename/extension/IPorHost * or

Hi, I'm using videocalling on asterisk 1.4.10. When I setup the videocall with exten = n,1,h324m_gw(s at video2webanswer), I loose the variable DNID (${CALLERID(dnid)}) Before the videocall is set up, this variable is filled and after this videocall this variable is empty. Also all local variables are empty. If al look at the A-number (${CALLERID(num)} this variable is not empty

Question: Naturally there are times when need to I reformat an extension in a context as such: ;Reformat add CC1 exten => _NXXNXXXXXX,1,Goto(1${EXTEN},1) -or- ;Reformat 011 with with +CC exten => _011X. ,1,Goto(+${EXTEN:3},1) It's a helpful trick, BUT there are times when I want to send the call to another context in its original un-reformatted state. Naturally the ${EXTEN}

Hi, We encounter a problem with the variable CALLERID(dnid) We use E1 lines where we can make an inbound call or an outbound call on the same channel (not at the same time) If the CALLERID(dnid) is not used, than the CALLERID(dnid) will be the CALLERID(dnid) of the previous call For example: - First we get a inbound call on channel DAHDI/11-1 with CALLERID(dnid) = '655871460' We read

Hi, I have a B400P BRI card with point-to-point connection (signalling: bri_cpe) with this dmesg: http://pastebin.com/sXrRt1yM When i restart asterisk server, the card cannot connect to the telco, the control led flashes red. If I unplug the cable between the ISDN nt and the card and wait 40 sec, the card can connect and works properly. The telco says the asterisk crashes the connection

hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are

Hi i have an asterisk pbx with E1 port connected to another PBX. Im trying to send the DNID/DNIS to the PBX here's my dialplan exten => 8881111111,1,Dial(ZAP/g2) exten => 8881111111,n,Hangup() The PBX just get the number 2 as it's DNIS when i change it to ZAP/1 or ZAP/g1 the PBX get the number 1. What should i add to send the extension number as DNID/DNIS? Thanks! --------------

Dear Asterisk-Users: Question: ======== How do I get asterisk to pass DNID/RDNIS information between asterisk machines using iax2, in a Dial(IAX2...) command ? Setup: ===== I have two asterisk boxes, MASTER and SLAVE. MASTER is running 1.2.0 and SLAVE is running 1.2.1. The main box handles incoming calls on a multiple lines (both via hardware connection to our internal PBX and calls

Hi, Yet another question, now that I have callerid working correctly, I'm trying to work out how to utilise the different numbers I have. I have a 100 number range allocated to my E1/PRI/OnRamp service. My incoming calls are handled like this: Advertised/published number is an analogue line terminating on a X101P. If the analog line is busy, it has a call diversion to the PRI on a TE405P

Hi all! I'm in the process of configuring an Asterisk server here that, based on which number was called, should send calls to different extensions: 913 - 11111 -> ext. 1 913 - 22222 -> ext. 2 913-11111 & 913-22222 being 2 (of the) numbers we have coming in to our system via our VoIP hosting provider. The config used here is based on Asterisk at home, so it includes also the

Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Thanks!

I am trying to set add a SIP Header to a call before adding it to the Queue. The dial plan sends the call to my macro to perform the work. When I use chan_sip, everything works as expected. When I use PSJIP support, it's not adding the SIP header. Looking at the output, I see the macro is called in both cases. In the PJSIP case, the added sip header never is showing up in the asterisk logs

Hi, I seem to be facing an intrusion issue, inspite of firewall (script attached). What am I missing ?? Any suggestions / recommendation are welcome pls. Best regards, Sans -------------- next part -------------- #!/bin/bash echo 0 > /proc/sys/net/ipv4/ip_forward # Clear any existing firewall stuff before we start /sbin/iptables --flush # As the default policies, drop all incoming

Hi Guys I have just installed a call center onto Suse 10. I have managed to do a DBget (astdb) and extract the DNID numbers to play a DNID specific greeting. We have installed Snom 320 and the customer would like us to Send the DNID(nam) to the phone screens so that the agent will be able to answer in the correct language and with the specific customer company name (ie. Agent says

Hi everybody. We have a problem with the configuration of the card, the cards work and we receive incoming calls but asterisk don't receive dnid. We have 5 servers with 1 E400P with the same problem and the telco told us that we need to configure the card to request it, how we can do this? Can you help me to solve the problem. Best regards, Carlos Fernández Puente carlos.fernandez@alisys.net

Hi, Does anyone know anything about the following? In a hosted environment where several area DIDs are provisioned on a single server, how do most carriers establish the origination DID, number. Asterisk allows us to modify the CallerID, name, number and DNID channel variables before dialling out via SIP. Most carriers will allow us to spoof a callerID when placing a call, and pass it forward.

Dear All, Here the version 2.2 a new version of your dear CallingCard Software !!! http://www.areski.net/areskicc-doc-v2/ Many new features have been added and several enhancements made! Newest features : - A new re-build rate-engine - LCR & LCD management (OOOOHHH YESSSSS) - Billing Increment - Progressive Rate - Scheduled Rates (days of the weeks) - Expiration rates - Buy rates