Displaying 20 results from an estimated 2000 matches similar to: "Asterisk CDR & UniqueID"
2013 Jun 03
1
Is uniqueid/sequence a safe CDR table primary key ?
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)
2007 Feb 01
1
CDR - uniqueid
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
2007 Nov 01
2
hostname in MySQL CDR records
I would like to send the CDR records from all our machines around the
world to a single database. But I need the hostname included with each
record for monitoring purposes.
Is there a better way than using the userfield and adding
SetCDRUserfield for every call to set the userfield to the name of the
host?
Thanks...
2008 Mar 17
1
asterisk.conf uniquename or sysname for uniqueid field in CDR
I set uniquename = MYHOST in asterisk.conf (under
[options]) so that my uniqueid data shows up as
MYHOST.time.seq.
First of all, I would like to know if uniquename (or
sysname?) will still be valid across future * versions
(mainly 1.6).
Secondly, is there a way to specify uniquename as an
asterisk option at the command line? (asterisk -h
doesn't show me anything regarding this feature)
2007 May 31
1
Duplicate UNIQUEID on CDR
Sometimes I get the following error on the console:
[May 31 11:14:01] ERROR[23502]: cdr_addon_mysql.c:230 mysql_log:
mysql_cdr: Failed to insert into database: (1062) Duplicate entry
'1180628004.3214' for key 1 -- Zap/38-1 answered UniCall/11-1
Why would the UNIQUEID be duplicated? Isn't is supposed to be UNIQUE?
This worries me a bit because the customer is losing calls that
2006 Oct 31
1
Asterisk does not bridge zap channels on outgoing calls
Hello... I have a big problem with asterisk. Every time i make a call
asterisk does not bridge the zap channels. The zap channel from which
i'm calling remains in state:ring and applicaton:dial and the zap
channel with the external line configured remains in state:dialling an
Application:AppDial.
Zap/20-1 agentie s 1 Dialing AppDial (Outgoing Line) 09399 (None)
Zap/9-1 int_omg 09399 5 Ring
2014 Nov 22
2
High resident memory with 11.14.0 ?
>
> Its up to 5.8G of resident memory with 28321 calls processed.
> The OOM killer is going to kill this soon at this rate (8GB RAM machine).
> This seems like a pretty serious problem.
> It looks like I'll need to restart asterisk every night....
Hi the number of cpu cores that you see with top times 512Mbyte is the
level of ram that's needed
e.g. a hp-gen8 with 2 octo
2007 Jun 12
4
write some custom values to CDR table
Hi,
I write the CDR of my Asterisk 1.2.17 server in MySQL database
using cdr_addon_mysql.so.
Now I'm trying to write some custom values to userfield column by
the SET(CDR(USERFILED)=SOME_TEXT) sintax, but nothing gets writeen in
MySQL cdr table!!
Why? I'm I skeeping something or what?
Taking a look at the URL:
2004 Oct 08
0
re:uniqueid - how unique it is (Sathya Weerasooriya)
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<blockquote type="cite">
<div><font
2010 Dec 22
0
CDR on MySQL
What would it do if you
exten => h,1,ResetCDR(w)
exten => h,2,NoCDR()
exten => h,3,DEADAGI(get-unqiueid.php)
I have not tried it but in theory it should write the first CDR and then
kill the write of the second NO ANSWER CDR.
Let me know if it works for you as I may need to do it on some of my h
exten code as well.
Bryant
----------------------------------------
From:
2009 Sep 04
1
Incremented UniqueId
Hi.
I've been using the Asterisk Manager Interface to originate calls from
Console/dsp.
I get the following form the server.
> Response: Success
> Message: Originate successfully queued
> Uniqueid: asterisk-3301-1252055630.26701
>
> Event: Newchannel
> Privilege: call,all
> Channel: Console/dsp
> State: Down
> CallerIDNum: <unknown>
> CallerIDName:
2009 Mar 25
0
${UNIQUEID} variable and queue log issues on 1.4.22
Hello list,
I don't know if anybody faced this issue, but I finally found a
workaround. I am using an external program with an AMI connection to
originate outbound calls to Local/ channels, and on the dialplan context
I dial outside with the corresponding trunk according to the prefix of
the dialed number. The problem here was CDR, more precisely the
uniqueid. Reading these mail lists I
2009 Sep 09
1
UNIQUEID not the same in Dialplan as passed to AGI
Hi,
I've noticed that the UNIQUEID for a call is not the same in the
Dialplan (when executed e.g. exten => s,n,NoOp(${UNIQUEID}) as it is
when passed via STDIN to an AGI script.
Is this normal, and is this supposed to behave this way?
The UNIQUEID received in the AGI is usually .001 higher than the one
in the dial plan -- but sometimes it is also a second behind.
Here's an example
2008 Mar 06
2
format of UNIQUEID variable
What is the format of the UNIQUEID variable?
It seems to be something like:
40651204817492.56
Does it always have the pattern
<long_number>.<short_number>?
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
2007 Dec 27
3
facter''s uniqueid is not unique
I have been storing the output of facter in a database with the
assumption that uniqueid was actually unique, until I found that it is
the same for a handful of my machines.
It appears that uniqueid is set from the output of hostid. I checked
into hostid and it gets its value from gethostid(). The following link,
http://www.opengroup.org/onlinepubs/009695399/functions/gethostid.html,
states,
2010 Oct 29
1
Updating asteriskcdrdb with uniqueid field from Master.csv, Master.csv.1....Master.csv.5 - Must I bring all files together first?
Hi Everyone,
Just noted that PBXinaFLASH failed me again on yet something else. The
uniqueid field didn't update on the asteriskcdrdb in the past few months but
it is available in the .csv files in /var/log/asterisk/cdr-csv/*.csv
I have already re-did the asterisk-addons install with correct parameters to
include future calls "uniqueid" in the table (I have no clue why these
2006 Mar 05
1
uniqueid
Hi folks,
I've just updated my * and I noticed that from the update the uniqueid field
into mysql, is not written and ASTPP do not charge the calls.
I got an eye to cdr_mysql.c and I found that at line 212, into one insert
query, uniqueid is missing.
But I can be wrong.
In any case, somebody got same problem?
Any suggestions?
Thanks to all.
--
.:FaberK:.
-------------- next part
2007 Mar 28
0
asterisk-addons-1.4 write wrong uniqueid
Evnin'
As I didn't find any answer I'll try to rephrase the problem (o;
Any idea why the latest asterisk-addons-1.4 write wrong uniqueid
into mysql database?
Asterisk-1.4.2 creates call record files with the uniqueid
prepended:
1175107269-SIP-999-0876c000.wav
But into mysql database it writes an uniqueid of:
1175107260.88
but should be:
1175107269
Any idea why the
2010 Nov 08
3
Get the Uniqueid of Action Originate in the AMI
Hi to all.
I'm begin a use the AMI and i have the need to get the uniqueid from the
call i have generate using the Action Originate. Anyone can help me?
When I generate these commands:
action: Originate
channel: SIP/101
application: Dial
data: SIP/100,120,Ttr
The only response I get when the call is answered, is this:
Response: Success
Message: Originate successfully queued
Thanks a
2006 Dec 18
1
Queue Monitor not mixing if using UNIQUEID in MONITOR_FILENAME
Hello Asterisk Users,
I guess the subject says the most of it; here goes some more
detail:
- Running Asterisk 1.2.14
- Objective: record all calls managed by a specific queue
- Name those files ${TIMESTAMP}-${CALLERIDNUM}-${UNIQUEID}
Facts:
- If the UNIQUEID chan var is used in the MONITOR_FILENAME,
before calling the Queue() application, the two legs of the call are
not