Displaying 20 results from an estimated 3000 matches similar to: "Asteriski misses the table"
2008 Oct 10
1
Asterisk CDR Analyser
Hi All,
I'm stuck and need some help. I have installed the Asterisk CDR
Analyser Version 2.0.1. It mostly works except for the CDR Report. I
get the following error even though it lists the CDR details.
Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day,
sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE
UNIX_TIMESTAMP(calldate) >=
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
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" =
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:
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]
2019 Jan 25
0
[klibc:update-dash] parser: Add syntax stack for recursive parsing
Commit-ID: 5dcca37d55b772e13d6d56eac9a7b733e69e99d2
Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=5dcca37d55b772e13d6d56eac9a7b733e69e99d2
Author: Herbert Xu <herbert at gondor.apana.org.au>
AuthorDate: Fri, 9 Mar 2018 00:14:02 +0800
Committer: Ben Hutchings <ben at decadent.org.uk>
CommitDate: Fri, 25 Jan 2019 02:57:21 +0000
[klibc] parser: Add syntax
2020 Mar 28
0
[klibc:update-dash] dash: parser: Add syntax stack for recursive parsing
Commit-ID: ef6ed3c138aaf680ff3e4e0d7fbad6d2c61fb7d0
Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=ef6ed3c138aaf680ff3e4e0d7fbad6d2c61fb7d0
Author: Herbert Xu <herbert at gondor.apana.org.au>
AuthorDate: Fri, 9 Mar 2018 00:14:02 +0800
Committer: Ben Hutchings <ben at decadent.org.uk>
CommitDate: Sat, 28 Mar 2020 21:42:54 +0000
[klibc] dash: parser: Add
2005 Jul 11
2
h323 and asterisk
We come into this section of the dialplan:
exten => 88670333333,1,Wait(1)
exten => 88670333333,n,SayUnixTime
exten => 88670333333,n,NoOp(If you know the extension ...)
exten => 88670333333,n,Dial(${PHONE_6003})
The caller from the GK hears only ringing, not the time.
The extension 6003 rings and I can pick up, but without any voice nor video.
athome*CLI>
-- Executing
2013 Sep 14
1
Asterisk-1.8.23.1 mysql cdr
Hi list,
I am using Asterisk1.6.2 form a long time and upgarding to
Asterisk-1.8.23.1.
I am using mysql backend for cdr.
in asterisk-1.6.2 i have usegmtime=yes and it works as expected insert cdr
date in GMT0.
now i tested Asterisk-1.8.23.1 and asterisk-11.5 with same results no
matter what i configure in cdr_mysql.conf "timezone=UTC usegmtime=yes" cdr
always inserted in local time.
I
2019 Jan 25
0
[klibc:update-dash] parser: use pgetc_eatbnl() in more places
Commit-ID: acd0936c5f8b4f5d94065ca46714d17e6a882cf2
Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=acd0936c5f8b4f5d94065ca46714d17e6a882cf2
Author: Harald van Dijk <harald at gigawatt.nl>
AuthorDate: Thu, 8 Mar 2018 08:37:11 +0100
Committer: Ben Hutchings <ben at decadent.org.uk>
CommitDate: Fri, 25 Jan 2019 02:57:21 +0000
[klibc] parser: use pgetc_eatbnl()
2020 Mar 28
0
[klibc:update-dash] dash: parser: use pgetc_eatbnl() in more places
Commit-ID: a4659bfa776f24f790c3ec071c5c9ef9459cdb70
Gitweb: http://git.kernel.org/?p=libs/klibc/klibc.git;a=commit;h=a4659bfa776f24f790c3ec071c5c9ef9459cdb70
Author: Harald van Dijk <harald at gigawatt.nl>
AuthorDate: Thu, 8 Mar 2018 08:37:11 +0100
Committer: Ben Hutchings <ben at decadent.org.uk>
CommitDate: Sat, 28 Mar 2020 21:42:54 +0000
[klibc] dash: parser: use
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
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
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:
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
2006 Apr 20
2
previous|next navigation question
When creating "< previous|next >"-type navigation to browse through
records from a list of search results, what is the most efficient (best
practices-) way to determine what the previous and next records are for
a given record?
Should I store the search results array and the position (index) of the
current record in the session?
Or restore the results array each time (running
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
2009 Jul 26
0
MeetMe time doesn't show up in CDRs?
Hello,
I'm working on some dialplan rules to pull multiple users into a
conference call. I have some fairly straightforward rules which start
up a new MeetMe conference, allow escape with the * key to invite more
users, then use a features.conf sequence to bring the new user into
the conference with ChannelRedirect.
The problem I'm running into is the time in the MeetMe conference
2010 Jun 18
1
What's diff between ${CDR(start)} , ${CDR(answer)} , ${CDR(calldate)}
hi,all
for a long time, i cant understand the difference between
${CDR(calldate)} and ${CDR(start)} , ${CDR(answer)}
i know ${CDR(start)} mean when a call is start. and ${CDR(answer)}
means when a call was pick up.
but what's ${CDR(calldate)} mean?
Could you help me ?
Thansk a lot!
--
Thanks for your supporting,
have a nice day.
Sucan
2005 Feb 14
0
cdr_mysql losing logs
I noticed a problem this morning with our cdr logging. We have a cron
job that places a call file into the spool directory having asterisk
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