similar to: CDR shows billsec=12 for all bridged calles.

I was just going through my call records ( stored in mysql database by cdr_MYSQL module ) and saw a record having duration = 0 and billsec of more than 50 seconds . I did a query on cdr where duration < billsec and saw that there were infact some 250 records with duration less than billsecond ( table had around 4,00,000 records) . Did anyone came across this ? I also checked csv files and they

Hello, I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built from source. Everything is working nicely except one small issue. The CDR records are stored in the CSV file correctly and complete. The MySQL storage is working as it should and is automatically updating all the fields except the CLID field. I have

Hi people, when I try to get the billsec in the dialplan, it is 0... but if after that I check the database, it is right (not 0). I'm trying to get it in the h extension, like: exten => h,1,Noop(End) exten => h,n,Noop(Time is ${CDR(billsec)}) .... Is it updated after the extension h is executed? In that case, how can I get the call duration in the h extension? Thanks, Anahi

Can someone tell me what I am doing wrong? Why doesn't CDR(duration) or CDR(billsec) return the correct values? cdr.conf endbeforehexten=yes extensions.conf [macro-Dial] ; ${ARG1} - Dial String exten => s,1,Dial(${ARG1},,M(post-dial)) exten => h,1,NoOp(Call was hung up - ${CDR(duration)} seconds long, billed for ${CDR(billsec)} seconds) The log shows: -- Executing [h

Just to bug you all (feel free to rant at me), a client wants to set his caller*ID number for outbound calls though us to PSTN. the client is using SIP to us, he can set the caller*ID name fine. if he sets his caller*ID number to anything other than his account number (8440101), the call is dropped into the default context (and then hung up by our dial plan). To get around this i

Hi I'm using asterisk 1.8.23.1 but I've seen this same issue in previous versions of 1.8. I have created some work arounds but the behaviour is incorrect. This is the scenario: Call comes in and goes to appropriate dialplan In the dialplan the call is forwarded to another number using a Local channel (and using /n ) e.g. Dial(Local/<my-number>@outbound-context/n,60) The number is

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

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 have an X100P and when I place calls to the PSTN which are not answered, the Billsec field of the CDR still logs the seconds that the phone rang. Can someone please confirm that this has to do with the ringcadance of the indications.conf file? Is there anything else I need to check ? Thanks in advance -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi All, I have been running a environment with asterisk 1.4.20.1 for some time now with no issue but have recently added some extra functionality (enabled call recording via MixMonitor) and ran into some deadlock issues which seem to be well documented with earlier 1.4.x releases so have decided to take the plunge and upgrade. I decided to start testing with 1.6.2 but have run into a couple

Hi all, I have a strange situation on a Asterisk 1.2.17 with FreePBX 2.2.1 Doing a select in the CDR table I noticed there are some calls with billsec greater than duration, duration is always 0 in those calls. How can this happens ? Am I missing something ? Tnx in advance Regards Edoardo Serra WeBRainstorm S.r.l.

Hi all, I have a strange problem, regarding zap channels and cdr. I am using asterisk bristuffed version Asterisk 1.2.2-BRIstuffed-0.3.0-PRE-1i, Copyright (C) 1999 - 2006 Digium, Inc. and others. with two billion ISDN cards. I also installed asterisk addons, last stable version via cvs internal calls, or calls starting from internal sip or iax phone are recorded in the cdr all without any

Hi to all, I was looking in google and also in this mailing list, but I dont find the solution to my problem, so I subscribe me to the list in order to post this e-mail and find the solution. This is the scenario: GSM Phone ----- GSM Network ---- TDM2406E --- ASterisk 1.4.0 (*) -------- VoIP Provider ------- Sip Phone or H323 Phone The problem is that I am generating calls from SIP and also

Guys. Ive seen on my asterisk messages log that asterisk has shutdown itself about 12 times in 5 days... The logs show nothing but: [Jun 28 09:40:02] WARNING[3172]: Unicall/4 event Drop call [Jun 28 09:40:02] WARNING[3172]: Unicall/4 event Release call [Jun 28 09:40:02] VERBOSE[3172]: [Jun 28 09:40:02] -- Unicall/4 released [Jun 28 09:40:02] VERBOSE[3084]: [Jun 28 09:40:02] Asterisk cleanly

Good afternoon list. I am experiencing a problem with the CDR and callfiles. What is happening is this: When generating a call with a callfile, everything works perfectly, but the CDR is recorded in the table when they answer the call destination. The field disposition is being recorded correctly, but the duration field is marked with the ring time and billsec is marked with 0. This just happens

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, Is there a way to enable the usage of UNIQUEID CDR field using a MySQL database backend for storing CDRs without having to recompile asterisk-addons as stated here http://www.voip-info.org/wiki-Asterisk+cdr+mysql ? After version 1.4 it is said in release that it can be done (not sure if it applies to mysql backend) How would it be the syntax in cdr.conf? I tried this without success in

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel

Hello All I am trying to answer incoming SIP calls, first, by dialing an extension, thence into voicemail, which works; and secondly by going straight into voice mail which does not. The extension.conf that works is like this; [incomingSIP] exten=>_.,1,Dial,Zap/2|1 exten=>_.,2,Voicemail,u5152 exten=>_.,3,Hangup the extension.conf which does not is like this; [incomingSIP]

For the information of others (and Google) this is the table structure I used to get cdr_mysql working: CREATE TABLE cdr ( calldate varchar(255) NOT NULL default '', clid varchar(255) NOT NULL default '', src varchar(255) NOT NULL default '', dst varchar(255) NOT NULL default '', dcontext varchar(255) NOT NULL default '', channel varchar(255)