Re: [asterisk-users] CDR gets lost

2023-09-19 Thread TTT
Yes - update your my.conf to increase the timeouts by a large amount, then restart mysql daemon. Here's some details: https://telium.io/en/topic/mysql-server-has-gone-away/ From: asterisk-users [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Federico Sent: Tuesday,

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Antony Stone
On Wednesday 10 June 2020 at 16:33:53, Doug Lytle wrote: > >>> Instead, the call still terminates if mysql cannot be reached. > > I just tested this, I'm using cdr_odbc, by shutting down mysql and I did > not experience the call being dropped. That sounds different to me. The OP is asking

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Doug Lytle
>>> Instead, the call still terminates if mysql cannot be reached. I just tested this, I'm using cdr_odbc, by shutting down mysql and I did not experience the call being dropped. The console logged the mysql failure, but the call continued. You may want to consider moving to cdr_odbc instead.

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Fourhundred Thecat
> On 2020-06-08 16:37, Sean Bright wrote: > > In the case of cdr_mysql, the connect timeout is configurable by putting > the following in cdr_mysql.conf: > > [global] > timeout = 5 ; Set connect timeout to 5 seconds OK, so i changed the timeout to 2 sec, but it does not have the desired effect. I

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-08 Thread Sean Bright
On 6/7/2020 2:54 AM, Fourhundred Thecat wrote: I would still like to know where the Aterisk mysql timeout duration comes from, and whether it can be configured. In the case of cdr_mysql, the connect timeout is configurable by putting the following in cdr_mysql.conf: [global] timeout = 5 ;

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-07 Thread Jeff LaCoursiere
Isn't the MySQL stuff deprecated in favor of odbc? You may be barking up the wrong tree if you plan to make source changes. j On Sun, Jun 7, 2020, 1:55 AM Fourhundred Thecat <400the...@gmx.ch> wrote: > > On 2020-06-06 10:38, Antony Stone wrote: > > On Saturday 06 June 2020 at 09:18:11,

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-07 Thread Fourhundred Thecat
> On 2020-06-06 10:38, Antony Stone wrote: On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: In a situation when I start asterisk, and the remote database is unreachable, asterisk waits for several minutes before it actually starts (before it loads sip module, etc). And when

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Antony Stone
On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: > In a situation when I start asterisk, and the remote database is > unreachable, asterisk waits for several minutes before it actually > starts (before it loads sip module, etc). > > And when database is unreachable during

Re: [asterisk-users] CDR extract call numbers on interval on unique callers

2019-11-12 Thread Andre Gronwald
i've got it: select from_unixtime(round((ceiling(unix_timestamp(calldate)/ 900) *900))) as intervall, count(distinct(clid)), count(clid) from cdr where calldate > '2019-09-01' group by intervall; Am 12.11.19 um 15:16 schrieb Andre Gronwald: would be better to have dates starting with

Re: [asterisk-users] CDR extract call numbers on interval on unique callers

2019-11-12 Thread Andre Gronwald
thanks john, that is a good idea and really easy. I selected both values to have a good comparison: select calldate, count(distinct(clid)), count(clid) from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 ; now it would be nice to have intervals starting always

Re: [asterisk-users] CDR extract call numbers on interval on unique callers

2019-11-12 Thread John Runyon
https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_count-distinct Use something like count(distinct src) instead of count(*) On Tue, Nov 12, 2019, 07:35 Andre Gronwald wrote: > hi, > > we want to extract the information when the most callers are entering > our phone

Re: [asterisk-users] CDR reporting solution

2017-03-30 Thread motty cruz
I installed CDR-Stats on Debian 8.7 http://cdr-stats.readthedocs.io/en/latest/installation/install-cdr-stats.html I am trying to figure out how to import flat CSV file to CDR-Stats On Wed, Mar 22, 2017 at 6:28 PM, Bruce Ferrell wrote: > How about CDR to either MySQL or

Re: [asterisk-users] CDR reporting solution

2017-03-22 Thread Bruce Ferrell
How about CDR to either MySQL or cdrlite and a quickie sql query? I could have added postgres, but I'm a DB bigot. That would work too. On 03/22/2017 01:46 PM, Motty Cruz wrote: Hello, I am looking for CDR reporting solution? Any suggestions? I am using Asterisk 13.13.1 I would like a

Re: [asterisk-users] CDR ODBC error

2016-04-15 Thread Toufic Khreish (Gmail)
ers@lists.digium.com> Subject: Re: [asterisk-users] CDR ODBC error On Tue, Feb 9, 2016 at 4:39 PM, Carlos Chavez <cur...@telecomabmex.com <mailto:cur...@telecomabmex.com> > wrote: I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this err

Re: [asterisk-users] CDR records and conferences

2016-03-27 Thread Rodrigo Ramírez Norambuena
On Mar 15 2016, at 8:06 pm, Richard Kenner ken...@gnat.com wrote: > At least in version 12.2.0, the code in cdr.c appears to create CDR records for each pair of users in a conference. This is quadratic and would seem to be an issue with large conferences. > > I got two

Re: [asterisk-users] CDR ODBC error

2016-02-11 Thread Matthew Jordan
On Tue, Feb 9, 2016 at 4:39 PM, Carlos Chavez wrote: > 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

Re: [asterisk-users] cdr table's "dst" column

2015-09-11 Thread Carlos Chavez
On 9/11/15 10:16 AM, Ethy H. Brito wrote: Hi All What, by definition, goes to the cdr table's "dst" column ?? In our setup, to get outside the user has to dial X before any number. This goes to the dst with the X stripped out. I recently made some changes in a macro and after that the X

Re: [asterisk-users] cdr table's "dst" column

2015-09-11 Thread Ethy H. Brito
On Fri, 11 Sep 2015 13:31:34 -0300 Helvio Junior wrote: > Ethy, > > The number that is recorded in "dst" is the last EXTEN in your dialplan, > so if you need record another number you can create a new context and > change to this context with Goto. > > Follows an

Re: [asterisk-users] cdr table's "dst" column

2015-09-11 Thread Helvio Junior
Ethy, The number that is recorded in "dst" is the last EXTEN in your dialplan, so if you need record another number you can create a new context and change to this context with Goto. Follows an example: exten = _9X.,1,Dial... And you need to record without "9" you can do this: exten =

Re: [asterisk-users] CDR in an MySQL-Database

2015-07-06 Thread jg
Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my

Re: [asterisk-users] CDR in an MySQL-Database

2015-07-06 Thread Ryan, Travis
-Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Ryan, Travis Sent: Monday, July 06, 2015 4:20 PM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: Re: [asterisk-users] CDR in an MySQL

Re: [asterisk-users] CDR in an MySQL-Database

2015-07-06 Thread John Novack
Luca Bertoncello wrote: Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET

Re: [asterisk-users] CDR in an MySQL-Database

2015-07-06 Thread Luca Bertoncello
John Novack jnov...@stromberg-carlson.org schrieb: Been doing this with MySql for the last 10 years, though not on an openWrt machine MySql is on the Asterisk machine. Also have additional database tables to block by callerId and name Did have some issues with the dialplan syntax when moving

Re: [asterisk-users] CDR dst value null after attended transfer

2015-03-26 Thread Matthew Jordan
On Thu, Mar 26, 2015 at 10:24 AM, Vinicius Fontes vinic...@aittelecom.com.br wrote: I'm having an issue with CDR. Basically, I expect to have all legs of a call having the same linkedid and differing only by the sequence value. That does happen, but I'm getting null dst values after doing an

Re: [asterisk-users] CDR(dst) not set in AEL macro

2014-07-16 Thread Rafael dos Santos Saraiva
Hi Probably are this bug, my Asterisk version is 1.8.15.0(the version of report is 1.8.15.1). I see that the problem occurs when the call is answered, if busy, fail, unanswered, the field dst is correct. I see too that when the problem occurs the dcontext field is set as name of the

Re: [asterisk-users] CDR(dst) not set in AEL macro

2014-07-12 Thread Johan Wilfer
2014-07-11 15:38, Rafael dos Santos Saraiva skrev: Hi I'm using a macro to dial in a AEL dialplan. The problem is the macro do not set the field CDR(dst), showing only ~~s~~. I tried various configurations, but without solutions. This is the macro: macro

Re: [asterisk-users] CDR(dst) not set in AEL macro

2014-07-11 Thread Rusty Newton
On Fri, Jul 11, 2014 at 8:38 AM, Rafael dos Santos Saraiva rafaels...@gmail.com wrote: Hi I'm using a macro to dial in a AEL dialplan. The problem is the macro do not set the field CDR(dst), showing only ~~s~~. I tried various configurations, but without solutions. Please don't post new

Re: [asterisk-users] CDR dcontext not updated on FAILED and BUSY calls

2014-07-07 Thread Tech Support
Hello; Check out this in cdr.conf. You may want to set it to yes. From cdr.conf.sample: ; In brief, this option controls the reporting of unanswered calls which only have an A ; party. Calls which get offered to an outgoing line, but are unanswered, are still ; logged, and that is

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-07-06 Thread Tiago Geada
Hi Richard. I looked at both pages, yes. My goal is to have a flag on the cdr database records when the call is not yet connected to the second leg. So, the Channel argument takes a call to a portion of dialplan that will try several steps. And at those steps the custom variable will be set to

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-27 Thread Tiago Geada
Is there something I can do regarding this issue? On 16 June 2014 11:39, Tiago Geada tiago.ge...@gmail.com wrote: Hi, Thank you for your explanation about channel halds .. These .call files are always different from other calls. Well I would like some custom var to have a piece of

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-27 Thread Richard Mudgett
On Fri, Jun 27, 2014 at 1:30 PM, Tiago Geada tiago.ge...@gmail.com wrote: Is there something I can do regarding this issue? Have you looked at these wiki pages? https://wiki.asterisk.org/wiki/display/AST/Asterisk+Call+Files The setvar parameter may help here.

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-16 Thread Tiago Geada
Hi, Thank you for your explanation about channel halds .. These .call files are always different from other calls. Well I would like some custom var to have a piece of information while it is queuing, and another piece of information, once answered in queue, thus just before dialing to context

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-11 Thread Tiago Geada
do what you want *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *Mikael Fredin *Sent:* Tuesday, June 10, 2014 11:18 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR custom

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-11 Thread Matthew Jordan
On Wed, Jun 11, 2014 at 9:10 AM, Tiago Geada tiago.ge...@gmail.com wrote: Hi, Let me append some extra info cdr variable foo, shows on database, but value 'bar' doens't its not even shown in the insert query I tried with master_channel but no change I think you need to be a bit more

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-10 Thread Mikael Fredin
As far as I know, only way to set variables on another channel would be: asterisk -rx core show help dialplan set chanvar Usage: dialplan set chanvar channel varname value Set channel variable varname to value On 10 June 2014 16:39, Tiago Geada tiago.ge...@gmail.com wrote: Hi We

Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file

2014-06-10 Thread Eric Wieling
Subject: Re: [asterisk-users] CDR custom variable on second call leg - via originate or .call file As far as I know, only way to set variables on another channel would be: asterisk -rx core show help dialplan set chanvar Usage: dialplan set chanvar channel varname value Set channel variable

Re: [asterisk-users] CDR billsec issue with calls forwarded through the Local channel

2014-05-02 Thread Ishfaq Malik
A big correction to the above! This 0 billsec entry happens when someone forwards a call from their phone using an auto forward (which then uses a Local channel on the asterisk server). The phone in question is a Snom. If I use a Local channel in the dial plan, the entry has a the correct

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread Chris Bagnall
On 24 Apr 2014, at 11:36, binary dreamer dreamer.bin...@gmail.com wrote: I am running asterisk and all of my CDRs are in the default csv. the system is so limited to ram (only 256) and I cannot run MySQL or any other program to give CDRs a fancy view. As an aside, have you considered running

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread binary dreamer
Thanks a lot for the reply. this is a PBX for my soho. it does not worth to run a separate machine. all I want is to present the csv file in a webpage to be human readable. the calls will not exceed 70 per week. On Thu, Apr 24, 2014 at 1:46 PM, Chris Bagnall aster...@lists.minotaur.ccwrote: On

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread A J Stiles
On Thursday 24 Apr 2014, binary dreamer wrote: hello everyone. I am running asterisk and all of my CDRs are in the default csv. the system is so limited to ram (only 256) and I cannot run MySQL or any other program to give CDRs a fancy view. at the moment the only other software running is

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread binary dreamer
already logrotate is doing the file split every month. how do you serve it in a webpage and which CGI script? On Thu, Apr 24, 2014 at 3:18 PM, A J Stiles asterisk_l...@earthshod.co.ukwrote: On Thursday 24 Apr 2014, binary dreamer wrote: hello everyone. I am running asterisk and all of my

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread Josh Metzger
With such a low amount of calls per month and with the extreme memory limitations, it might be easier to write a script to pull out the data and generate a static html page. Run it daily / weekly / whenever you need it. On Thu, Apr 24, 2014 at 8:28 AM, binary dreamer

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread A J Stiles
On Thursday 24 Apr 2014, binary dreamer wrote: already logrotate is doing the file split every month. how do you serve it in a webpage and which CGI script? You need a web server. You say you already have nginx; I'm not familiar with this, but it probably will do what you need. Read the

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread binary dreamer
really nice. but could tell me the way, play? On Thu, Apr 24, 2014 at 3:37 PM, Josh Metzger joshdmetz...@gmail.comwrote: With such a low amount of calls per month and with the extreme memory limitations, it might be easier to write a script to pull out the data and generate a static html

Re: [asterisk-users] cdr viewer for csv

2014-04-24 Thread A J Stiles
On Thursday 24 Apr 2014, binary dreamer wrote: really nice. but could tell me the way, play? I think we have gone as far as we can with this matter on this list, which is strictly for non-commercial discussion only. If you would still like to contact me off-list, please change the underscore

Re: [asterisk-users] CDR(start) returns nothing in Asterisk 12

2014-02-05 Thread Richard Mudgett
On Wed, Feb 5, 2014 at 2:46 PM, Leandro Dardini ldard...@gmail.com wrote: Hello, I am migrating my dialplan from asterisk 11 to asterisk 12 and it seems the ${CDR(start)} is not returning any data. Other functions, like ${CDR(duration)} or ${CDR(src)} or ${CDR(accountcode)} are returning

Re: [asterisk-users] CDR(start) returns nothing in Asterisk 12

2014-02-05 Thread Leandro Dardini
I love you all :-) Leandro 2014-02-05 Richard Mudgett rmudg...@digium.com: On Wed, Feb 5, 2014 at 2:46 PM, Leandro Dardini ldard...@gmail.comwrote: Hello, I am migrating my dialplan from asterisk 11 to asterisk 12 and it seems the ${CDR(start)} is not returning any data. Other

Re: [asterisk-users] CDR and Transfer, an asterisk scaring bug lasting from 1.4 version...

2014-01-23 Thread Matthew Jordan
On Thu, Jan 23, 2014 at 12:44 PM, Leandro Dardini ldard...@gmail.com wrote: When you use a product which version number is 11 or even 12, you might go with the assumption all big bugs are fixed and then you find there is a huge, important, expensive bug still running in the code we are relaying

Re: [asterisk-users] CDR and Transfer, an asterisk scaring bug lasting from 1.4 version...

2014-01-23 Thread Leandro Dardini
2014/1/23 Matthew Jordan mjor...@digium.com On Thu, Jan 23, 2014 at 12:44 PM, Leandro Dardini ldard...@gmail.com wrote: When you use a product which version number is 11 or even 12, you might go with the assumption all big bugs are fixed and then you find there is a huge, important,

Re: [asterisk-users] CDR Question

2013-04-24 Thread Nyamul Hassan
Hi, On Sun, Apr 21, 2013 at 9:57 PM, jg webaccou...@jgoettgens.de wrote: lastdata is the argument string of lastapp. Since Hangup() does not have any args, lastdata is empty. If you need to store things that are not already stored, you can either use the userfield or add extra columns to the

Re: [asterisk-users] cdr report

2013-04-23 Thread Thorsten Göllner
Well, the question is, what your secretary wants to do. Only see the CDRs or more? Realtime? One simple method would be to mail her the CSV-File, so she can open it with Excel or Calc (Open Office). Am 23.04.2013 16:35, schrieb aristidis tsitras: Hi. i am running asterisk in a low powered

Re: [asterisk-users] cdr report

2013-04-23 Thread aristidis tsitras
That would be nice. is there a way to have it ready in xls? if yes, then i could send it put a cron to send it every night/week/month. On 04/23/2013 05:42 PM, Thorsten Göllner wrote: Well, the question is, what your secretary wants to do. Only see the CDRs or more? Realtime? One simple

Re: [asterisk-users] cdr report

2013-04-23 Thread A J Stiles
On Tuesday 23 April 2013, aristidis tsitras wrote: Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine works fine to route all my calls for the office. the problem is the management of the CDRs. i can see the master.csv file, but it is not

Re: [asterisk-users] cdr report

2013-04-23 Thread Ron Wheeler
On 23/04/2013 11:09 AM, A J Stiles wrote: On Tuesday 23 April 2013, aristidis tsitras wrote: Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine works fine to route all my calls for the office. the problem is the management of the CDRs. i

Re: [asterisk-users] cdr report

2013-04-23 Thread aristidis tsitras
On 04/23/2013 06:23 PM, Ron Wheeler wrote: On 23/04/2013 11:09 AM, A J Stiles wrote: On Tuesday 23 April 2013, aristidis tsitras wrote: Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine works fine to route all my calls for the office.

Re: [asterisk-users] cdr report

2013-04-23 Thread Ron Wheeler
On 23/04/2013 11:42 AM, aristidis tsitras wrote: On 04/23/2013 06:23 PM, Ron Wheeler wrote: On 23/04/2013 11:09 AM, A J Stiles wrote: On Tuesday 23 April 2013, aristidis tsitras wrote: Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine

Re: [asterisk-users] cdr report

2013-04-23 Thread Stelios Koroneos
On Tue, 2013-04-23 at 17:35 +0300, aristidis tsitras wrote: Hi. i am running asterisk in a low powered machine (alix2d13 from pcengines) without any gui. the machine works fine to route all my calls for the office. the problem is the management of the CDRs. i can see the master.csv file,

Re: [asterisk-users] CDR Question

2013-04-21 Thread Nyamul Hassan
Yes, I do. I am not sure I understand how that helps. Regards HASSAN On Sun, Apr 21, 2013 at 10:36 AM, jg webaccou...@jgoettgens.de wrote: But you do have a cdr with disposition NO ANSWER, do you? -- __**__**_ -- Bandwidth

Re: [asterisk-users] CDR Question

2013-04-21 Thread jg
lastdata is the argument string of lastapp. Since Hangup() does not have any args, lastdata is empty. If you need to store things that are not already stored, you can either use the userfield or add extra columns to the cdr table, which depends to some degree on how you store the call data.

Re: [asterisk-users] CDR Question

2013-04-20 Thread jg
But you do have a cdr with disposition NO ANSWER, do you? -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs:

Re: [asterisk-users] CDR unanswered setting

2013-04-09 Thread Marie Fischer
On 09.04.2013, at 10:33, Shanavaz E A shanava...@yahoo.com wrote: Hi, From asterisk 1.8, the CDR table is not logging the unanswered or extn busy calls which hit while in the queue. I am talking about this setting in the cdr.conf : ; In brief, this option controls the reporting

Re: [asterisk-users] CDR direct executed failed

2013-02-21 Thread Doug Lytle
termo termosel wrote: But when I make a call warnigs appear and I don't acces to database I don't know about sqlite3, I use either MariaDB or Mysql, this is my configs: I don't use cdr.conf cat cdr_odbc.conf [global] dsn=MySQL-cdr dispositionstring=yes table=cdr usegmtime=no cat

Re: [asterisk-users] CDR direct executed failed

2013-02-21 Thread termo termosel
Thanks! But Does someone know about sqlite3? Thanks, Jordi Date: Thu, 21 Feb 2013 05:14:51 -0500 From: supp...@drdos.info To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDR direct executed failed termo termosel wrote: But when I make a call warnigs appear and I

Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

2012-12-07 Thread Don Kelly
. --Don From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Leandro Dardini Sent: Thursday, December 06, 2012 12:50 PM To: rwhee...@artifact-software.com; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users

Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

2012-12-07 Thread Jeff LaCoursiere
*From:*asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] *On Behalf Of *Leandro Dardini *Sent:* Thursday, December 06, 2012 12:50 PM *To:* rwhee...@artifact-software.com; Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users

Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

2012-12-06 Thread Leandro Dardini
Yes, go for it. However I have added another autoincrement column and created the primary key on it. On the other columns I need to search I have created just an index. Leandro 2012/12/6 Olivier oza_4...@yahoo.fr Hello, I need to develop an application that will query (mostly reading) an

Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

2012-12-06 Thread Olivier
2012/12/6 Leandro Dardini ldard...@gmail.com Yes, go for it. However I have added another autoincrement column and created the primary key on it. May I ask why did you choose to add a new column ? I'm hesitating between both solutions. For me, your solution has the advantage that, if, for any

Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

2012-12-06 Thread Ron Wheeler
It seems like a safe thing to do. You could also ask about the impact of making an existing column a primary key, in a MySQL forum. Leandro's solution seems to be a good one as well and does guarantee uniqueness. Ron On 06/12/2012 12:25 PM, Leandro Dardini wrote: Yes, go for it. However

Re: [asterisk-users] CDR - Freepbx - Safe to add primary key to table ?

2012-12-06 Thread Leandro Dardini
The reason I add a new column autoincrement is due to the fact I trust more mysql about uniquness than asterisk. Leandro I am typing from my mobile phone... Il giorno 06/dic/2012 19:11, Ron Wheeler rwhee...@artifact-software.com ha scritto: It seems like a safe thing to do. You could also

Re: [asterisk-users] CDR Unanswered calls

2012-10-09 Thread Shanavaz E A
A shanava...@yahoo.com Subject: Re: [asterisk-users] CDR Unanswered calls To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Date: Saturday, October 6, 2012, 11:28 AM Yes, Please see the following example. In version 1.4 of asterisk, we used to get atleast 2

Re: [asterisk-users] CDR Unanswered calls

2012-10-05 Thread Shanavaz E A
Hi,   No replies until now. Some one please help... There must be some people who are using it...   Thanks --- On Mon, 9/24/12, Shanavaz E A shanava...@yahoo.com wrote: From: Shanavaz E A shanava...@yahoo.com Subject: [asterisk-users] CDR Unanswered calls To: asterisk-users@lists.digium.com

Re: [asterisk-users] CDR Unanswered calls

2012-10-05 Thread Patrick Lists
On 10/05/2012 11:51 AM, Shanavaz E A wrote: Hi, No replies until now. Some one please help... There must be some people who are using it... Thanks No idea but since Asterisk is making you money why don't you hire an experienced Asterisk consultant to get it resolved. Regards, Patrick --

Re: [asterisk-users] CDR Unanswered calls

2012-10-05 Thread Warren Selby
On Fri, Oct 5, 2012 at 4:51 AM, Shanavaz E A shanava...@yahoo.com wrote: Hi, No replies until now. Some one please help... There must be some people who are using it... Thanks Can you provide an example of what you expect it to be doing (from the old version) and what it is doing now

Re: [asterisk-users] CDR Unanswered calls

2012-10-05 Thread Shanavaz E A
1.8 only the first record is being created. I need all the records for all extensions which was tried in the queue.   I hope you got the point   Regards Shanavaz. --- On Sat, 10/6/12, Warren Selby wcse...@selbytech.com wrote: From: Warren Selby wcse...@selbytech.com Subject: Re: [asterisk-users

Re: [asterisk-users] CDR Issue

2012-09-06 Thread Chad Wallace
On Tue, 04 Sep 2012 14:24:54 +0530 Parveen Lamba pla...@tekege.com wrote: When I call to 0X number using sip/test, CDR is created between sip and dahdi channel. [...] Here disposition is always answered whether I attend or reject the call. This is normal with analog lines. When you

Re: [asterisk-users] CDR default table specification?

2012-08-23 Thread Stefan at WPF
Andrew, thank you very much, I like especially https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend as it's quite official :-) Dumb question, AST = asterisk or is it by chance just a part of asterisk or sth. like this? 2012/8/20 Andrew White and...@computersforall.com.au Hey

Re: [asterisk-users] CDR default table specification?

2012-08-23 Thread Andrew White
: Thursday, 23 August 2012 9:53 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR default table specification? Andrew, thank you very much, I like especially https://wiki.asterisk.org/wiki/display/AST/MySQL+CDR+Backend as it's quite official :-) Dumb

Re: [asterisk-users] CDR default table specification?

2012-08-19 Thread Andrew White
Hey Stefan, Have you had a look at http://www.voip-info.org/wiki/view/Asterisk+cdr+odbc? Voip-info.org isn't official, but it's a pretty good site. Have a look under Setting up the CDR Database/Table. There's also the AST: https://wiki.asterisk.org/wiki/display/AST/MSSQL+CDR+Backend

Re: [asterisk-users] CDR Analyzer/Queue stats reporting

2012-02-27 Thread Carlos Chavez
On Mon, 2012-02-27 at 18:28 +, Noah Engelberth wrote: I’ve been tasked with finding and implementing a CDR/Queue analyzer to provide information to management about the call center’s performance. My Google-fu seems to be returning a lot of things that are more or less abandoned projects.

Re: [asterisk-users] CDR Analyzer/Queue stats reporting

2012-02-27 Thread Danny Nicholas
Maybe his google-fu is phisher-fu! -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Carlos Chavez Sent: Monday, February 27, 2012 12:53 PM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDR

Re: [asterisk-users] CDR into ical?

2012-01-14 Thread Kevin P. Fleming
On 01/14/2012 03:38 PM, Jay R. Worthington wrote: Hi y'all, is there a possibility from within asterisk to write CDR into can ical-calendar? Being a (part time) IT-Support-Monkey for almost two decades and probably brain-dead since the late 90ties, i usually can't remember to whom i've talked

Re: [asterisk-users] cdr call time

2011-12-27 Thread Zohair Raza
may this helps, In cdr.conf, set endbeforehexten=yes Regards, Zohair Raza On Wed, Dec 28, 2011 at 4:46 AM, Vinod Dharashive vdharash...@gmail.comwrote: Hi team, On event of no answer in CDR the starttime and endtime of call remains the same. Is there any way how can actually track call

Re: [asterisk-users] CDR END TIME in correct in 1.8+

2011-12-16 Thread Danny Nicholas
You are running the AGI from the h() exten? Otherwise I wouldn't expect CDR(end) to populated or correct. From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Zohair Raza Sent: Friday, December 16, 2011 8:38 AM To: Asterisk Users Mailing

Re: [asterisk-users] CDR END TIME in correct in 1.8+

2011-12-16 Thread Zohair Raza
Yes running from h exten = _X.,1,Dial(SIP/1*100) exten = h,1,AGI(cdr.php,11) Regards, Zohair Raza On Fri, Dec 16, 2011 at 6:42 PM, Danny Nicholas da...@debsinc.com wrote: You are running the AGI from the h() exten? Otherwise I wouldn’t expect CDR(end) to populated or correct. **

Re: [asterisk-users] CDR END TIME in correct in 1.8+

2011-12-16 Thread Danny Nicholas
...@lists.digium.com] On Behalf Of Zohair Raza Sent: Friday, December 16, 2011 8:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR END TIME in correct in 1.8+ Yes running from h exten = _X.,1,Dial(SIP/1*100) exten = h,1,AGI(cdr.php,11

Re: [asterisk-users] CDR END TIME in correct in 1.8+

2011-12-16 Thread Zohair Raza
, 2011 8:51 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR END TIME in correct in 1.8+ ** ** Yes running from h ** ** ** ** exten = _X.,1,Dial(SIP/1*100) exten = h,1,AGI(cdr.php,11) ** ** Regards, Zohair Raza

Re: [asterisk-users] CDR END TIME in correct in 1.8+

2011-12-16 Thread Eric Wieling
. ;endbeforehexten=no -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Danny Nicholas Sent: Friday, December 16, 2011 9:57 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: Re: [asterisk-users] CDR END

Re: [asterisk-users] CDR END TIME in correct in 1.8+

2011-12-16 Thread Zohair Raza
-users-boun...@lists.digium.com] On Behalf Of Danny Nicholas Sent: Friday, December 16, 2011 9:57 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: Re: [asterisk-users] CDR END TIME in correct in 1.8+ Try this exten = _X.,1,Dial(SIP/1*100) exten = h,1,wait(10

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-30 Thread A J Stiles
** THIS IS NOT THE RIGHT PLACE TO POST A REPLY ** On Tuesday 29 November 2011, salaheddine elharit wrote: i use centos 5.5 if i install mysql-devel i can still use the version of mysql installed now in my server because i use it with a database and Im afraid to install this mysql-devel and i

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
: asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine elharit *Sent:* Monday, November 21, 2011 8:52 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4 ** ** i try to run make menuselect without configure

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Ishfaq Malik
Of salaheddine elharit Sent: Monday, November 21, 2011 8:52 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4 i try to run make menuselect without configure

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
, November 29, 2011 5:37 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4 Hello Danny i try to flow your email but when i do make menuselect i didn't find add-ons in order to check the cdr_mysql i use asterisk 1.4

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
-Commercial Discussion *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4 i try to run make menuselect without configure but he give me an error and he tell me that i must run ./configure before launch make menuselect * *** i'm afraid if i launch ./configure and after

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
-on. ** ** *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine elharit *Sent:* Tuesday, November 29, 2011 8:45 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR mysql

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
Discussion Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4 what i have in Call Detail Recording is [*] 1. cdr_csv [*] 2. cdr_custom [*] 3. cdr_manager xxx 4. cdr_odbc xxx 5. cdr_pgsql xxx 6. cdr_radius xxx 7. cdr_sqlite xxx 8. cdr_tds 2011/11/29 Danny Nicholas da...@debsinc.com

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
:06 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4 ** ** what i have in “Call Detail Recording” is [*] 1. cdr_csv [*] 2. cdr_custom [*] 3. cdr_manager xxx 4. cdr_odbc xxx 5. cdr_pgsql xxx 6

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine elharit *Sent:* Tuesday, November 29, 2011 9:20 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4 ** ** after

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine elharit Sent: Tuesday, November 29, 2011 9:30 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4 yes is installad

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
*To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4 ** ** yes is installad and is running mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread A J Stiles
On Tuesday 29 November 2011, salaheddine elharit wrote: after ./configure –with-mysql=/usr Make menuselect ** **same result but i found in module embedding the below options i check the cdr and i get the same result [ ] 1. apps [*] 2. cdr [ ] 3. channels [ ] 4. codecs [

  1   2   3   4   5   6   7   8   >