Displaying 20 results from an estimated 137 matches for "dcontext".
Did you mean:
context
2014 Jul 07
1
CDR dcontext not updated on FAILED and BUSY calls
Hi
We're using asterisk 1.8.23.1. Our inbound calls are routed into the
default context with explicit number matching. If found they are passed on
to a distinct context for the number being called using the Goto
application.
If the call is successful or even if it has no answer, the cdr dcontext
field has the correct second context.
However, if the call fails or is busy, and even though we can see it is
executing a step in the second context as show in the cdr lastdata field,
the dcontext still shows as default.
Is this a bug or expected behaviour? If it is expected behaviour, what is
th...
2015 Jul 06
4
CDR in an MySQL-Database
...ed NOT NULL AUTO_INCREMENT,
`calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
`src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
`dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
`dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
`lastapp` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`lastdata` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`duration` float unsigned DEFAULT NULL,
`billsec` float unsigned DEFAULT NULL,
`disposition...
2006 Nov 09
1
Problem with CDR interpretation
...8118|60|t","2006-11-08
09:26:19","2006-11-08 09:26:19","2006-11-08
09:26:38",19,19,"ANSWERED","DOCUMENTATION","asterisk-1295-1162974379.834",""
And more friendly view (at least for me :)
1. src: dst: 18
dcontext: zcentralki
clid:
channel: Zap/2-1 dstchannel: SIP/8117-e6cb
lastapp: Dial lastdata:
SIP/8117&LOCAL/19@sekretariat&LOCAL/24@sekretariat|60|t
start: 2006-11-08 09:00:26 answer: 2006-11-08 09:00:26 end:
2006-11-08 10:15:55
duration: 4529 billsec:...
2011 Mar 28
8
CDR MYSQL missing field data
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
2013 Oct 07
1
IAX and Variables
...variable.
I want now said at the second server that accountcode =
${IAXVAR(ACCOUNTID)},
for use this accoundcode in CDR. On second server, in cdr_mysql.conf i have:
[columns]
alias start => calldate
alias end => callend
alias clid => clid
alias src => src
alias dst => dst
alias dcontext => dcontext
alias channel => channel
alias dstchannel => dstchannel
alias lastapp => lastapp
alias lastdata => lastdata
alias duration => duration
alias billsec => billsec
alias disposition => disposition
alias amaflags => amaflags
alias accountcode => accountcode
alia...
2009 Jul 26
0
MeetMe time doesn't show up in CDRs?
...even add up to 4 minutes.
Any idea how I can get that time to show up in a CDR entry, or any
details of how CDRs should work with MeetMe and ChannelRedirect?
Here are my 4 CDR entries:
calldate=2009-07-26 01:05:32
clid="PPI/SWG" <SWG>
src=SWG
dst=*
dcontext=cob-meetme-escape
channel=SIP/SWG-c80008c0
dstchannel=Local/92345678 at callout-d564,1
lastapp=Dial
lastdata=Local/92345678 at callout||g
duration=20
billsec=3
uniqueid=1248584732.888
calldate=2009-07-26 01:05:39
clid="PPI/SWG" &l...
2014 Mar 13
1
strange records in cdr
...-00065fd2", "") in new stack
[2014-03-13 09:56:04] VERBOSE[4754] pbx.c: == Spawn extension (from-sip-external, h, 1) exited non-zero on 'SIP/external-ip-00065fd2'
It's correct, such call don't allowed , my money is safe.
mysql> select calldate, clid,src,dst,dcontext,channel,lastapp,duration,billsec,disposition,amaflags from cdr where calldate like '2014-03-13 09:56:04';
+---------------------+-------------+-----+-----+-------------------+----------------------------+---------+----------+---------+-------------+----------+
| calldate | clid...
2015 Jul 06
1
CDR in an MySQL-Database
...t; `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
> `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `lastapp` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
> `lastdata` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
> `duration` float unsigned DEFAULT NULL,
> `billsec` float unsigned DEFA...
2016 Feb 09
2
CDR ODBC error
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 '2016-02-09 16:21:28'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?)
[Feb 9 16:21:43] WARNING[2088]: res_odbc.c:612 ast_odbc_direct_execute:
SQL Exe...
2015 Jul 06
0
CDR in an MySQL-Database
...t; `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
> `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `lastapp` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
> `lastdata` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
> `duration` float unsigned DEFAULT NULL,
> `billsec` float unsigned DEFA...
2015 Jul 07
0
CDR in an MySQL-Database
...t; `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
> `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `dcontext` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '',
> `lastapp` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
> `lastdata` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
> `duration` float unsigned DEFAULT NULL,
> `billsec` float unsigned DEFA...
2013 May 09
2
question about CDR
...nd 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 | dst
|dcontext |channel | dstchannel |lastapp |lastdata |duration |billsec
|disposition |amaflags |accountcode |uniqueid
|3 |
626747 |2013-05-09 09:22:55 |0661551203 |0661551203 |506
|default |Zap/14-1 |SIP/276-092ac7b0 |Dial |SIP/276| 10|21 |0
|NO ANSWER
any help please...
2006 Jun 28
3
asterisk shutdown
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
2009 Feb 26
0
[cdr_odbc] error: Cannot insert the value NULL into column 'calldate'
Hi,
I am trying to get * log to mssql server. I have odbc and freetds
configured, but my insert query is missing calldate which is a NOT
NULL field in database schema.
cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed:
INSERT INTO cdr
(clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid)
VALUES ('1000','1000','100','sip','SIP/1000-09388800','AddQueueMember','test,Local/1000 at sip,5,,Agent/1000,Local/1000 at sip',9,9,'ANSWERED',3,'1235681438.1...
2015 Apr 25
1
Error writing CDR
...sk-asterisk [MyAsterisk-asterisk]
> >
> > [Apr 25 10:57:06]
> > WARNING[19013][C-000002cb]: cdr_adaptive_odbc.c:739 odbc_log:
> > cdr_adaptive_odbc: Insert failed on 'MyAsterisk-asterisk:cdr'. CDR
> > failed: INSERT INTO cdr
> > (dst,accountcode,clid,src,dcontext,channel,dstchannel,lastapp,duration,billsec,disposition,amaflags,userfield,lastdata,uniqueid)
> > VALUES (blahblahblah, ... ,'1429970147.612')
> >
> Can you post the output of "describe <schema>;"? At least the first
> error message is probably related to a...
2009 Mar 26
3
Know who's logged in
...AVAILCHAN=SIP/303-0949f890
SIPCALLID=Y2MzOTc0NmExYjVkNDNjMzhhY2I1MDMwNTk0NTJkYzQ.
SIPUSERAGENT=X-Lite release 1100l stamp 47546
SIPDOMAIN=XXXXXXXXX
SIPURI=sip:303 at XXXXXXXXXXXXXXXXX
CDR Variables:
level 1: clid="Ext. 303" <303>
level 1: src=303
level 1: dst=XXXXXXXXXX
level 1: dcontext=XXXXXXXXXXX
level 1: channel=SIP/303-b2f1c368
level 1: lastapp=AgentLogin
level 1: start=2009-03-26 14:13:59
level 1: answer=2009-03-26 14:13:59
level 1: duration=0
level 1: billsec=0
level 1: disposition=ANSWERED
level 1: amaflags=DOCUMENTATION
level 1: uniqueid=1238094839.425549
Is there an opti...
2005 May 25
0
FAST BUSY on Back to back ZAP outgoing calls
...233>
2005-05-25 17:37:00 DEBUG[2691]: Dialing '6718688'
2005-05-25 17:37:00 DEBUG[2691]: Deferring dialing...
2005-05-25 17:37:00 DEBUG[2691]: cdr_mysql: inserting a CDR record.
2005-05-25 17:37:00 DEBUG[2691]: cdr_mysql: SQL command as follows:
INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura
tion,billsec,disposition,amaflags,accountcode,userfield) VALUES
('2005-05-25 17:36:45','Living Room <102>','102','777','default',
'SIP/102-bbbc','','MP3Player','http://64.236.34.196:80...
2003 Jul 21
1
MYSQL Table Structure
...thers (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) NOT NULL default '',
dstchannel varchar(255) NOT NULL default '',
lastapp varchar(255) NOT NULL default '',
lastdata varchar(255) NOT NULL default '',
duration int(11) NOT NULL default 0,
bill...
2004 Dec 05
1
Mysql-cdr
...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
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid) VALUES ('2004-12-06
13:36:17','\"Mohammad\"','','9053265824','sip', 'SIP/3000-b4f7','SIP/9053265824-f4b2','Dial','SIP/905326...
2006 Mar 29
1
cdr_odbc appears to have fields missing
...ave everything running,
but the insert statement being sent to database doesn't appear to have the
"start, answer, end" information in it.
Below is the insert statement that MS Profiler shows being sent. As you can
see those fields are missing.
INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode)
VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14)
Here is the record that shows up in cdr-csv
"","4718","2599576","default","""Asterisk...