search for: lastapp

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

...;,"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: 4529 disposition: ANSWERED amaflags: DOCUMENTATION uniqueid: asterisk-129...

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

...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 alias userfield => userfield alias uniqueid => uniqueid But where i can put into the con...

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

..."") 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 | src | d...

...but even if I answer a call it still logs as "Not Answered" with a duration of zero. Setting unanswered to either yes or no makes no difference in cdr.conf - the call is still logged as "Not Answered" if I pick it up. Really the only way around this I can see is to check the lastapp field instead of the disposition. Lastapp is set to "Dial" if the call was really not answered and "MP3Player" if the call was answered. I see that there is a known bug in Asterisk and it is suggested to use extension.conf to set up a context rather than using call files....

...; rename($fname,$fname_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)}","...

...170#: -- 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_blindtransf...

For some reason I can't get the Dial command 'C' flag to work. The calls are recorded in the CDR with the 'C' on. Does anyone have an idea? extensions.conf: exten => 114,1,Dial(SIP/114,,C) It shows in the lastapp: cdr: | 2004-10-05 13:16:02 | "112" | | 114 | intern | SIP/112-3fb6 | SIP/114-0e7a | Dial | SIP/114||c | 6 | 3 | ANSWERED | 3 | | | | Assaf Benharoosh -------------- next part -------------- An HTML attachment...

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

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

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

...risk] > > > > [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 not so optimal primary key...

...es_odbc: Connected to MyAsterisk-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')

...k call itself to check to make sure its still handling incoming calls correctly, then queries the CDR database in mysql and makes sure that appropriate records exist. I can confirm that the call is happening correctly, but I'm missing records in the database: select calldate, disposition, lastapp, channel from cdr where clid = "xxxxxxxxxx" order by calldate desc limit 45; | 2005-02-14 11:34:04 | ANSWERED | Hangup | Zap/2-1 | | 2005-02-14 11:34:03 | ANSWERED | BackGround | Zap/3-1 | | 2005-02-14 11:32:03 | ANSWERED | Hangup | Zap/1-1 | | 2005-02-14 11:30:04 | ANS...

...I1MDMwNTk0NTJkYzQ. 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 option for Agentlogin() to set a channel variable on the login cha...

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

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