search for: lastdata

Hi to all. What can i do if a customer needs to log in the CDR all the dialpan actions related to a call? I mean, not only the lastapp e the lastdata but all the dialpan actions! I know that the actual CDR system store one record for each call (and for billing purposes this can be correct) but in some cases the approach needed is something similar to the queue_log. I know that exists ResetCDR and ForkCDR but they don't do what i need, expe...

...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: 4529 disposition: ANSWERED amaflags: DOCUMENTATION uniqueid: asterisk-1295-1162972826.808 2. src:...

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

...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 alias userfield => userfield alias uniqueid => uniqueid But where i can put into the config that for this cdr entry a...

Hello, I've posted about this a few months back but I didn't understand the answer properly and only just got round to sorting it out. My question is, when I dial out to a few numbers at the same time, the CDR lastdata for the call looks like this:- SIP/07957543212 at supplier&SIP/07957123456 at supplier&SIP/01615551234 at supplier|10 The problem is, the billing rate could be affected, depending on which endpoint answers the call. When a call is answered, I need the lastdata to be replaced with the spe...

...tMe 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" <SWG> src=SWG dst=92345678 dcontext=callout channel=Local/92345678 at callout-d564,2 dst...

...me_call); # cat cdr_custom.conf ; ; Mappings for custom config file ; [mappings] Master.csv => "${CDR(clid)}","${CDR(src)}","${CDR(dst)}","${CDR(dcontext)}","${CDR(channel)}","${CDR(dstchannel)}","${CDR(lastapp)}","${CDR(lastdata)}","${CDR(start)}","${CDR(answer)}","${CDR(end)}","${CDR(duration)}","${CDR(billsec)}","${CDR(disposition)}","${CDR(amaflags)}","${CDR(accountcode)}","${CDR(uniqueid)}","${CDR(userfield)}" If $...

...-- SIP/169-000000ff answered SIP/nhi-riverside-sip-000000fe -- <SIP/169-000000ff> Playing 'pbx-transfer.ulaw' (language 'en') [Dec 10 13:38:03] DEBUG[29980]: features.c:1330 builtin_blindtransfer: transferer=SIP/169-000000ff; transferee=SIP/side-sip-000000fe; lastapp=; lastdata=; chan=SIP/169-000000ff; dstchan= [Dec 10 13:38:03] DEBUG[29980]: features.c:1333 builtin_blindtransfer: TRANSFEREE; lastapp=Dial; lastdata=SIP/169,18,rtT, chan=SIP/nhi-riverside-sip-000000fe; dstchan=SIP/169-000000ff [Dec 10 13:38:03] DEBUG[29980]: features.c:1335 builtin_blindtransfer: transfe...

...CDR. Here is the manager event for a call: Event: Cdr Privilege: call,all AccountCode: 6384106:MMI-Y:200705081051010077 Source: 0000000000 Destination: 6398714109927773 DestinationContext: outbound CallerID: 0000000000 Channel: Zap/15-1 DestinationChannel: SIP/teliax-081ed5b0 LastApplication: NoOp LastData: StartTime: 2007-05-08 10:51:04 AnswerTime: 2007-05-08 10:51:05 EndTime: 2007-05-08 11:01:56 Duration: 652 BillableSeconds: 651 Disposition: ANSWERED AMAFlags: DOCUMENTATION UniqueID: 1178635864.1510 UserField: And for that record in the database: 'calldate' '2007-05-08 10:51:04'...

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 Execute error! Verifying connection to...

...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 to have the historic for 223 and 276 thanks a...

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

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') Schema is: My ta...

...RNING[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 not so optimal primary key > definition. Thanx for the reply. request follows....

...terisk] [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')

...691]: 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/stream/2004',15,1 5,'ANSWER...

...har(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, billsec int(11) NOT NULL default 0, disposition int(11) NOT NULL default 0, amaflags int(11) NOT NULL default 0, accountcode varchar(255) NOT NULL default '', KEY src (src), KEY clid (clid), KEY d...

...fully.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/9053265824|20| Ttr',9,5,'ANSWERED&...

...rt 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","""Asterisk2"" <4718>",&qu...

...-- Executing [s at restphone_event_loop:11] Set("SIP/icall-0075a2e0", "CDR(userfield)=boatmenu") in new stack But the record that's created in mysql has a blank userfield: INSERT INTO `cdr` (`calldate`, `clid`, `src`, `dst`, `dcontext`, `channel`, `dstchannel`, `lastapp`, `lastdata`, `duration`, `billsec`, `disposition`, `amaflags`, `accountcode`, `uniqueid`, `userfield`) VALUES \ ('2007-11-05 17:25:17','(removed)','(removed)','s','restphone_event_loop','SIP/icall-0075a2e0','','Read','Result|/var/lib/asterisk...