similar to: MtSQL CDR logging

Hopefully someone can help out here. I currently have cdr records being logged to mysql for each call, along with all calls being recorded with the monitor application. What I really need is for the path to the recorded file to be logged with the corresponding cdr record. Is this possibile? Had a good hunt on tikki but can't seem to find anything. Also, I am finding with incoming calls,

I am using asterisk along with freepbx . When recording is enabled for a extension the call record file made in /var/spool/asterisk/monitor contains information like OUT(extension number)-(timestamp)-(uniqueid).wav . This can be a big mess if there are more than 1000-2000 files in that folder and very hard to locate a call recording based on call time and extension number who dialled. I need to

I know the recommendation it to not run more than 2 T/E100P's in a system but what about X100P's.. Usually there are 5 PCI slots in a system, has anyone tried 5 x X100P's in a system? Later.. -- ______________________________________________ http://www.linuxmail.org/ Now with e-mail forwarding for only US$5.95/yr Powered by Outblaze

Hey all, ? I'm trying to get an E400P and 2 X100Ps working together in the one box and don't seem to be having much luck. ? I can get the two different types of boards working separately, but not together.? I've made calls on both the X100P and have seen sync and correct signalling on the E400P.? But when I try to enable to configs together I get the following: ? modprobe wcfxo

Hi, Currently I use "call files" to automate the generation of calls from our address book and the resulting call file looks like this.. Channel: SIP/201 WaitTime: 30 Application: Dial Data: CAPI/4567:5556789 CallerID: Auto Dial <1000> This method works but it not logging the calls to the CDR and there are a few other issues.. So I wanted to try and do the same thing using the

If anyone is looking, I just ran accross an ebay auction for X100P Cards at what I thought was a very reasonable price. http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=3046843672&category=48483&rd=1 --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software -------------- next part -------------- An HTML attachment was

Thanks for the reply Bill. I am aware of the interrupts problem. To solve it I have already disabled my serial ports freeing up interrupts 3 and 4 and these are allocated to the two cards. This was done 2 months ago and has not solved the problem. Is there any way that something can wake up every now and then and generate these two interrupts? My current /proc/interrupts is as follows:

Hi, When dealing with CDR SQL tables, I always added an auto-incremented cdr_id key as a primary key, just in case provided uniqueid key went wrong. Now I'm facing a situation where I need to insert into a database's table and from the dialplan, a reference to the CDR record which is currently processed. So my questions are: 1. Can uniqueid/sequence (or uniqueid/sequence/calldate)

Is uniqueid globally unique? I have three Asterisk installations and I need to store data from all of them in same database, in same table. Will this uniqueid field be unique? -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)270248 Mob.: +385(91)1212148 SIP: tomo@sip.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr -------------- next part -------------- A

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

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000

Hello. Voice quality when calling - this is one of the most important in the PBX. You need to record the quality parameters for each call to improve. Because the overall quality of a call can only be determined upon completion, I did it in the HangUp handler and wrote in custom fields of CDR. This worked well in asterisk 11. In asterisk 13 I did not find a handler after the call, but before

My system seems to be generating a call on its own... Unfortuately I can't give much more information.. I have an X100P and an S100U.. My Modem and the X100P share a common line.. When I am on the internet (which is most of the day) * just sits there and does nothing (apart from when I am testing ideas for the dial plan), but at night when I am sleeping and the modem is not connected then

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

Our phone operators work off of an Asterisk queue. They take calls from customers and take orders with our back end systems. What I need to be able to do is tie the orders taken to the specific CDR record that reflects the call from which the order originated. The typical/sample CDR table doesn't have a primary key. I can add an auto-generated PK, but the CDR is not written until the

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. I am using two servers in my configuration: one for phones registration and another one as gateway, where all the providers are connected. Both are connected through an IAX trunk. I am having some trouble on matching both CDR?s, since durations for a call are not always the same in both servers, start/end date time are sometimes also different, etc. Is there any way to send the uniqueid of

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, I am trying to setup some LCR functions on my Asterisk box and have a cheap call provider that uses various different numbers for landlines and cell phone numbers in various countrys.. I am finding it difficult to find the various codes.. eg. UK Landline - +44[12]. UK Cell - +44[7]. SA Landline - +27[1-6]. SA Cell - +27[78]. Please send me your country's dialing rules similar to how I

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 compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for