similar to: CDR of calls transferred via IAX[2]

My cdrs are missing accountcodes for incoming calls from other asterisk servers.. I've seen a few people mentioning this on the list and the solution seems to be setting up a dialplan for incoming calls from a particular sip peer.. in my opinion this does not scale well at all and I am looking for a solution to correct this problem. example sip peer: [asterisk_gw] type=friend

Greetings list, Whilst running through a routine check of some CDRs, I've noticed that the originating channel's accountcode isn't preserved on creating a local channel. For example, if we start with: exten => 123,1,Set(CDR(accountcode)=foo) exten => 123,n,Queue(bar,nrtw,,,) And the queue 'bar' is defined as follows: [bar] member => Local/456 at outbound member

Hi All, I'm running 1.2.9.1 and have a sip user setup with accountcode=4444 in the context. lab1*CLI> sip show peer 1234 * Name : 1234 Secret : <Set> MD5Secret : <Not set> Context : sip1004 Subscr.Cont. : <Not set> Language : Accountcode : 4444 AMA flags : Unknown CallingPres : Presentation Allowed, Not Screened Callgroup

Please help with this strange issue. When "sip show peers" returns status "Unknown" the CDR does not include the accountcode even though the call is correctly processed. I'm using A2 Billing and it uses the accountcode to determine the authentication. Asterisk version 1.4.21.2 I'm calling from a Quintum device. I'm very puzzeled. Name/username Host

Hi, The Asterisk Wiki (page: http://www.voip-info.org/wiki/view/Asterisk+func+cdr) mentions I can set any custom CDR field I want. Here is the example it gives: ; Update our accountcode field and then save some random music facts too exten => s,1,Set(CDR(accountcode)=8675309) exten => s,2,Set(CDR(MyFavoriteBand)=Foo Fighters) exten => s,3,Set(CDR(MyFavoriteSong)=Hero) I am

I've just found out that CDR(accountcode) variable can only be 20 characters long, doesn't matter what size the MySQL column has for it. I need to increase it to at least 30 characters. Any idea how this can be accomplished? -- Zeeshan A Zakaria -------------- next part -------------- An HTML attachment was scrubbed... URL:

Trying to do something like this in the sip.conf under my incoming provider profiles: setvar=CDR(accountcode)=${EXTEN} It seems to show up in the CDR but it's showing up exactly like this "${EXTEN}". Is there a way to stuff the DNIS (number dialed) into the accountcode for CDR? I have already accomplished setting on a number by number basis, I just want to do it globally for all

Hi All, Call comes into Asterisk Asterisk answers and Dials SIP Phone SIP phone has call forward enabled to a long distance number Asterisk receives a SIP response 302 "Moved Temporarily" back from phone Asterisk then forwards inbound call to 'Local/number@context' thanks to phone 2 problems with the CDR: 1. intermittent 'bill sec' accuracy, sometimes 0 even when the

I'm unable to set any cdr fields except userfield and accountcode using Set(CDR(lastapp)="foo") [for example]. This is 1.2.4. I'm using the cdr_addon_mysql plugin, which handles userfield, accountcode, and uniqueid fine. Is this broken in Asterisk, or the addon? The addon code looks like it's just copying what's passed in. Eric.

Hi, I`m occassionally seeing CDR(accountcode)'s value empty at a place in my diaplan where it was filled with some value a few lines before, with nothing else having changed it. It`s giving me headaches (as I rely on it for MySQL queries). Anything I can do? Mick -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello, We have finally upgraded to Asterisk 1.4, however we've run into two issues that weren't occurring before the upgrade. Issue #1: We're an outgoing call center and need to record all calls. We use the uniqueid field in the CDR to match with the recording, which we labeled with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct in the CDR. Here is the

Greetings list... I have a Trixbox based Asterisk system and would like to implement a loose call accounting system. The system is built on Trixbox version 2.2.8 with Asterisk 1.2.24 and FreePBX 2.3.1. Because there are a couple thousand existing account codes for various projects, and new account codes are created by the accounting dept. I cannot create pin sets using the add on module included

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

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

For a new project, I have written a dialplan and it is pretty straight forward: The [dialout] context dials out a number, and h extension in this context writes the CDR. But what is happening is that if the callee hangs up first, all values in the CDR are fine, but if the caller hangs up first, the 'dst' column is always 'h'. I put a NoOp right in the begining of this macro to

Hi I am using Trixbox 2.4 and PRI lines..on the CDR i see many calls that have duration of 0 seconds, but they are still shown as ANSWERED . how come its possible when duration is 0.00 ? Are the callers billed for such calls ? Rgds Sriram -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Hi a new small question ;=) We have two Asterisk, connected in IAX2. On the first, in dialplan, we have: exten => _XX.,1,Set(IAXVAR(ACCOUNTID)=${CDR(accountcode)}) we sent into the IAXVAR "ACCOUNTID" the accountcode. On the second, in dialplan, we have: exten => 18,2,AGI(Caller-ID.agi,${IAXVAR(ACCOUNTID)}) That's work, the second server get the variable. I

Hi; I have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr