similar to: Set external CID but retain internal extension in CDR...

On 2/22/18 1:07 PM, Antony Stone wrote: > On Thursday 22 February 2018 at 19:10:51, Carlos Chavez wrote: > >> Usually phone companies set the outgoing CallerID for you but >> recently we got control over that and are now setting the outgoing >> Calleir ID ourselves. My problem now is that the CDR will put the >> outgoing CID in the CDR instead of the extension

On 2/22/18 3:46 PM, Antony Stone wrote: > On Thursday 22 February 2018 at 21:41:41, Carlos Chavez wrote: > >> On 2/22/18 1:07 PM, Antony Stone wrote: >>> On Thursday 22 February 2018 at 19:10:51, Carlos Chavez wrote: >>>> Usually phone companies set the outgoing CallerID for you but >>>> >>>> recently we got control over that and are

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

On 4/19/17 4:09 PM, Antony Stone wrote: > On Wednesday 19 April 2017 at 22:54:51, Carlos Chavez wrote: > >> I have a server that had been operating for a few years now with >> IAX2 trunks to several other servers. Since yesterday all IAX2 trunks >> now say UNREACHABLE. > ...snip... > >> So far the only thing different is that the receive queue for port

If SIP goes to the same provider then yes. Still I would check a packet capture for better understanding. BTW, did you try iax debug? ??, 20 ???. 2017 ?. ? 19:46, Carlos Chavez <cursor at telecomab.mx>: > On 4/20/17 12:45 AM, Kseniya Blashchuk wrote: > > Can it happen that the routes lead the traffic through another interface? > Did you try a packet capture with tcpdump? Do the

Can it happen that the routes lead the traffic through another interface? Did you try a packet capture with tcpdump? Do the packets really leave the usb adapter? Can asymmetric routing be in effect? Maybe there were some static routes that disappeared when the adapter was unplugged... On Thu, Apr 20, 2017, 12:41 AM Antony Stone < Antony.Stone at asterisk.open.source.it> wrote: > On

Hi all, I've been beating my head against this for some time now. For incoming calls, I'd like to send my users a "localized" caller id number. By "localized," I mean one with out the 1+areacode for local calls and only 10 digits (minus the leading 1) for long distance calls. For example: I get a call from 15055551234. Since I live in the 505, I should see:

I'm trying to use the MySQL CDR records. According to dialplan show, the line in the dialplan is: 11. Set(CDR(userfield)=${billing_code}) [pbx_ael] It looks like the value is being set when I watch the console during the call: -- Executing [s at restphone_event_loop:11] Set("SIP/icall-0075a2e0", "CDR(userfield)=boatmenu") in new stack But the record that's

I have a server that had been operating for a few years now with IAX2 trunks to several other servers. Since yesterday all IAX2 trunks now say UNREACHABLE. No configuration changes have been made and no upgrades have been done. The server is running 11.16.0 (yes, we are planning upgrades but lets solve this first). The server has a USB ethernet adapter that got disconnected yesterday by

On 4/19/17 4:23 PM, Antony Stone wrote: > On Wednesday 19 April 2017 at 23:14:46, Carlos Chavez wrote: > >> On 4/19/17 4:09 PM, Antony Stone wrote: >>> On Wednesday 19 April 2017 at 22:54:51, Carlos Chavez wrote: >>>> I have a server that had been operating for a few years now with >>>> >>>> IAX2 trunks to several other servers.

Hi All, For some reason since moving to Asterisk 1.6. my CDR records are no longer displaying the Clid field. The CDR records contain the Source field be for some reason not the CID details. I am logging CDR to mysql. Is anyone able to help? Regards David. -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

I have a problem with CDR recording in Asterisk 1.2.x. This is the situation: An Asterisk 1.2.0 (BRIstuffed-0.3.0-PRE-1 with florz) machine with a single HFC-S ISDN BRI card. I log the call records to both the Master.csv and MySQL. The problem is that when an incoming call from the ISDN line is logged to the CDR, the "src" and the "clid" field show up as something like

Hello, A question on channel originating (call files and AMI Originate): How can I change the CALLERID(num) var (because of the E1 provider needs), but having another n?mber (the original one) stored on the "clid" CDR field on the database? A channel agnostic solution would be the best one, without having to deal with the problem based on what type of Tech used for the outgoing

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Hi asterisk-users, We have recently moved to the 13.x branch of Asterisk from 11.x, and we're trying to correlate CDR records from multiple-legs for billing purposes. As part of this change we have added 'linkedid' to our CDR table schema in an attempt to join the multiple records into one billable record. The call path can be simplified as (transport types in brackets): SIP

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

hello list, i need your help about cdr ,i have installed the module cdr in my asterisk 1.4 . for the inbound calls when i call my sip exten like below : exten => 506,1,Dial(SIP/223, 10) exten => 506,n,Dial(SIP/276, 10) in CDR i have just one line with SIP /276 the last line but there is no historic for the first SIP 223 recid Record ID | calldate |clid |src

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I am trying to set the CDR(userfield) to a certain vaule using the application map of features.conf but I am not able to do it. When I receive a call I would like to tag it with a client code (3 digit numeric) so I can referenci it later from the CDR. I have edited features.conf with something like: code => #111,self,SET(CDR(userfield(111)) or

Hi, I have asterisk-server version of 1.8.11-cert7. When external enemy try to using it for calling, server write this string to log: 2014-03-13 09:56:04] VERBOSE[4754] pbx.c: -- Executing [9810972592309759 at from-sip-external:1] NoOp("SIP/external-ip-00065fd2", "Received incoming SIP connection from unknown peer to 9810972592309759") in new stack [2014-03-13