Displaying 20 results from an estimated 1000 matches similar to: "Asterisk CDR Analyser"
2007 Jul 12
0
No subject
to use the table asterisk.cdr but I can't find it anywhere.
------_=_NextPart_001_01C92A7E.C6B88024
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
2019 Nov 12
3
CDR extract call numbers on interval on unique callers
hi,
we want to extract the information when the most callers are entering
our phone system based on an interval of 15 minutes. this is quite
simple (although not perfect) with
select calldate, count(*) as anzahl from cdr where calldate >
'2019-10-12' group by unix_timestamp(calldate) DIV 900 having ;
Unfortunately we have lots of callers who calls multiple times when they
are
2005 Jul 12
0
Asteriski misses the table
I am not aware what I have done wrong, but the result is a query of:
*Database error:* Invalid SQL: SELECT * FROM WHERE
UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2005-07-01') ORDER BY
calldate DESC LIMIT 0,25
*MySQL Error*: 1064 (You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE
2007 Nov 26
3
Correct syntax for IF()?
Hello
I've tried a bunch of things, but still get errors/warnings
when using the IF() function:
============== TEST #1
exten => h,n,Set(WAV_FILE=${IF($[ ${STAT(e,/tmp/${CALLTIME}.wav)}
]?${CALLTIME}.wav)})
[Nov 26 21:52:34] WARNING[5074]: func_logic.c:107 acf_if: Syntax
IF(<expr>?[<true>][:<false>])
============== TEST #2
exten =>
2010 Oct 18
1
a2billing
Not sure if a2billing can be shared here, but ill give a shot
If the credit < min_credit the IVR play: sorry you have 0 credit and hangup,
I want it to FW me to the IVR to add voucher, please let me know: here is
log:
[18/10/2010 07:01:12]:[file:a2billing.php -
line:75]:[CallerID:]:[CN:]:[IDCONFIG : 1]
[18/10/2010 07:01:12]:[file:a2billing.php - line:76]:[CallerID:]:[CN:]:[MODE
: standard]
2010 May 25
1
find_by_sql timestamp parameter
Hi
In controller I have this query:
@price_stat = Price.find_by_sql("select id, cost, tour_id,
unix_timestamp(created_at) from prices")
when I try to display result''s created_at column I don''t have any
results:
<% @price_stat.each do |p| %>
<p><%= p.created_at %></p>
<% end %>
result is empty
But if I try without unix_timestamp. ie:
2007 Nov 21
1
[1.4 - Record] How to tell if user did leave a msg?
Hello
I didn't find the answer in the ATOF 2nd Ed: When using the Record()
application, I need to know how it ended: Did the user leave a
message, or did he hang up?
If the latter, Asterisk stops right there, while I need to run some
other commands before hanging up:
========
exten => _[1-4],n,Playback(/root/asterisk_sound_files/leave_msg)
exten =>
2007 Aug 01
3
TE120P in Canada
Hi All,
I'm having problems trying to get a TE120P operational in Canada.
I keep getting a congestion error when I try to make a call. I'm not
sure if my switching, parity, etc is correct. I'm hoping that someone
will be able to verify my config.
The Telco is SaskTel, with a 10 channel 50 DDI service.
Zap show channels show and ztcfg -vv looks ok and the zttool show
2009 Dec 14
1
AGI with PHP
Hi All,
I'm having problems getting results from a PHP file. This is what the CLI is showing.
-- Executing [111 at internal:1] AGI("Console/dsp", "GoTalk.php") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/GoTalk.php
[Dec 14 11:57:25] ERROR[20260]: utils.c:1019 ast_carefulwrite: write() returned error: Broken pipe
If I run the PHP file from
2007 Mar 27
3
ztdummy and MOH
Hi All,
I have installed Asterisk 1.4.2 and have loaded ztdummy as I have no
Digium cards. The problem I have is that MOH will not play. It starts
and then stops.
asterisk*CLI> zap show status
Description Alarms IRQ bpviol
CRC4
ZTDUMMY/1 1 UNCONFIGUR 0 0
0
I'm not sure if the above is correct.
2009 Feb 21
2
DIAL() application 'g' option
Hi All,
Asterisk 1.4.12 on CentOS 5
I'm trying to increment an AstDB key with the length of the last
outgoing call. Here's what I've got for "01" UK geographical numbers:
exten => _01.,1,Dial(${UKGeographical}/${EXTEN},,g)
exten => _01.,n,Log(NOTICE,Call to ${EXTEN} lasted ${DIALEDTIME})
exten => _01.,n,Set(CALLTIME=${DIALEDTIME})
exten =>
2007 Sep 04
1
VSP authentication to incorrect context
All, I'm hoping someone can direct me as to why when someone calls my
DID Asterisk tries to authenticate the incoming call on my outbound
context. If I remove the GoTalk context I can receive incoming calls.
Outbound calls work fine while I have the GoTalk context in place.
The error I am getting when someone calls the DID is
WARNING[16072]: chan_sip.c:8272 check_auth: username mismatch,
2017 Jun 08
2
Rainbow in loop
Hi R folk I have a distance time graph for a locomotive and at various times
different events occur on board the loco. I want to put a vertical line on the
speed time graph for each event, but I want to colour each different kind of
event differently to see visually whether there's any pattern to these events
happening. I could just create a vector of colours and use abline which is easy
2013 Feb 19
2
Call Pickup how to display CND of incoming number
Is it possible to display the incoming calling number on a handset when trying to pick up a call from another handset?
I currently have Call Pickup working using *8, I have also used the PickUp application successfully but I'm not sure how to use these features so the handsets show the incoming calling number and not the number that you have dialled to pick up the call.
Regards
David
2007 Apr 15
9
Loudspeaker
Hello List,
This is what I want to do:
When a call comes in I want to ring an extension that happens to be loud
speaker. The users can the press *8 to answer the call. Is there a
SIP device that I can connect to Asterisk as an extension that can
accomplish something like this?
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2017 Jun 08
0
Rainbow in loop
Does:
rainbow(3)[1]
rainbow(3)[2]
rainbow(3)[3]
... solve your issue?
B.
> On Jun 8, 2017, at 8:20 AM, WRAY NICHOLAS <nicholas.wray at ntlworld.com> wrote:
>
> Hi R folk I have a distance time graph for a locomotive and at various times
> different events occur on board the loco. I want to put a vertical line on the
> speed time graph for each event, but I
2014 Nov 20
1
Error saving cdr at h exten in Asterisk13
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
2009 Dec 30
1
CDR_MYSQL 1.4 Database Structure
So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the
database structure for cdr_mysql is:
CREATE TABLE cdr (
calldate datetime NOT NULL default '0000-00-00 00:00:00',
clid varchar(80) NOT NULL default '',
src varchar(80) NOT NULL default '',
dst varchar(80) NOT NULL default '',
dcontext varchar(80) NOT NULL default '',
channel
2014 Mar 13
1
strange records in cdr
Hi, I have asterisk-server version of 1.8.11-cert7.
When external enemy try to using it for calling, server write this string to log:
2014-03-13 09:56:04] VERBOSE[4754] pbx.c: -- Executing [9810972592309759 at from-sip-external:1] NoOp("SIP/external-ip-00065fd2", "Received incoming SIP connection from unknown peer to 9810972592309759") in new stack
[2014-03-13
2004 Jun 13
1
can't create a POSIXct from an actual Unix timestamp (PR#6975)
Full_Name: Philip Gross
Version: 1.9.0
OS: Linux Redhat 9.0
Submission from: (NULL) (65.57.245.11)
Among the many conversions for POSIXct values, there does not seem to be one
which will accept an actual POSIX timestamp, e.g. as produced by MySQL's
UNIX_TIMESTAMP() function. I have fixed this by adding the following lines to
R-1.9.0/src/library/base/R/datetime.R , at line 89: