similar to: Can' correlate AMI MonitorStart with CDR

>> 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. >> >>

I'm a bit confused why the following command is taking an extrodinarily long time (> 2-3 hours) to run on an 3.06ghz iMac (brand new). I'm trying to do a stratified random sample, drawing only a single value per UniqueID from the patch_summary data frame: uniqueids <- unique(patch_summary$UniqueID) uniqueids_stratasize <- c(1:length(uniqueids))*0+1

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 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

Hello, I have an application that needs to record outgoing calls. It's running on Asterisk 1.4.18, with CDR data stored in MySQL. Outgoing calls are recorded based on their uniqueid. When outgoing calls are placed, there is a line like this on my extensions.conf: exten => _.,n,MixMonitor(/var/spool/asterisk/monitor/${UNIQUEID}.gsm) For regular outgoing calls, this works fine. The

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)

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

because of problems you are facing i decided to go way with second table CREATE TABLE `cdr_extended` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `uniqueid` varchar(32) NOT NULL DEFAULT '', `callid` varchar(256) NOT NULL DEFAULT '' COMMENT 'sip call-id', `hangupcause` varchar(10) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL COMMENT 'info about

hello perl experts i am working with "ast-rad-acc.pl" from http://www.voip-info.org/tiki-index.php?page=PortaOne+Radius+auth i dont know why $cdr{'DNID'} and $cdr{'CALLERID'} under 'sub send_acc {' are empty. i m successfully connected with asterisk manager and when call i hangup my perl application is getting that all other thing are ok but i dont know why only

Let's say i have a network of * boxes connected via IAX, one of them is a "switch", one or more are the "gateways". - An IAX[2] "customer" register himself on the "switch" (and gets an accountcode for te purpose of cdr) - The customer places a call to the "switch", the switch does some magic and decides which "gateway" the call

Hello, I have problem with interpretation of CDR entries. What happened? ------------- There was: 1. at 09:00:26 we received call from unknown caller (no callerid) to secretary with extension 17 2. secretary answered and after some conversation called to extension 18 to check if she could transfer customer call 3. at 09:02:55 extension 18 answered and call was forwarded 4. call was very long

Issuing the AMI Status command results in a list of active channels. But how to figure out which channels are related before the call is answered? 2 channels below are somehow associated, but how can I be 100% sure they are related in order to implement a redirect of the incoming call to another phone ("attended" call pickup respecting call/pickupgroups). Uniqueid seems to be a

Hello. I've been trying to use the AMI to originate phone calls. I'm trying to call the SIP phone 'zoiper' with the SIP phone 'yziquel'. So, the AMI interaction is: > Action: originate > Channel: SIP/zoiper > Exten: yziquel > Priority: 1 > Timeout: 30 > Context: internal > > Response: Error > Message: Originate failed > > Event:

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

-----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 All, I'am a new Asterisk user, and i have the following question. The following is the Status of all open channels from my Asterisk system, which was received through the Asterisk Manager Interface ((AMI)). ==================================================================== action: Status actionid: 65066874_3# Response: Success ActionID: 65066874_3# Message: Channel status will

Hi all, Just thought I'd update this thread in case anyone else is Googling trying to find out how to do this... I found the solution to my problem to be to use the IAXVAR() function to pass the accountcode between the Asterisk boxen and update the CHANNEL(accountcode) with that variable. Thanks to Richard @ Digium for the reply that clarified my misunderstanding. Calum On Wed, 2018-10-03

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

Dears, I need to save some information on userfield when calls end in Asterisk13, but I have two error cases: 1. With endbeforehexten=no in cdr.conf, I have a registry in cdr, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it