Re: [asterisk-users] CDR reporting solution

[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 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 report on number of calls per extension.
>>
>> Thanks,
>> Motty
>>
>>
>>
>>
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at:
> https://community.asterisk.org/
>
> New to Asterisk? Start here:
>  https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>



-- 
Thanks for your support,
Motty
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR reporting solution

[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 report on number of calls per extension.

Thanks,
Motty






--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] CDR reporting solution

[Motty Cruz]

Hello, I am looking for CDR reporting solution? Any suggestions? I am using
Asterisk 13.13.1

I would like a report on number of calls per extension. 

 

Thanks, 
Motty

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR Reporting

[Gary Baribault]

Hi Folks, sorry for the delay ... I found that the documentation was
rather iffy .. I finally found the defines.php in the lib subdirectory
and figured out how to give the MySQL port with the host and it all
works fine now.

Gary Baribault
Courriel: g...@baribault.net
GPG Key: 0xFA812835
GPG Fingerprint: 8597 4D3D 3C3D 4247 077C 9FF9 E412 CAC4 FA81 2835



On 09/11/2009 01:09 AM, Matt Riddell wrote:
 On 11/09/09 7:11 AM, Gary Baribault wrote:
   
 Hi all,

  I'm looking for a reporting solution for Asterisk CDRs. I have a
 small Asterisk server that will eventually have 4 - 6 trunks. the
 system is up and the CDRs are being written to a MySQL DB. I tried
 installing Areski, but had no success .. I assume it's no longer
 supported... the last update was in March 2005 according to this page..

 http://www.voip-info.org/wiki/view/Asterisk+CDR+Areski+GUI

 Has anyone got that it running? My server is OpenSuSE 11.2 with Apache
 2 and PHP5, which is probably the problem.. the software probably
 needs PHP4.
 
 Yeah we use it from time to time.

 What do you mean it wasn't working?

 Did you get some errors or something?

   

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

AstriCon 2009 - October 13 - 15 Phoenix, Arizona
Register Now: http://www.astricon.net

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] CDR Reporting

[Gary Baribault]

Hi all,

I'm looking for a reporting solution for Asterisk CDRs. I have a
small Asterisk server that will eventually have 4 - 6 trunks. the
system is up and the CDRs are being written to a MySQL DB. I tried
installing Areski, but had no success .. I assume it's no longer
supported... the last update was in March 2005 according to this page..

http://www.voip-info.org/wiki/view/Asterisk+CDR+Areski+GUI

Has anyone got that it running? My server is OpenSuSE 11.2 with Apache
2 and PHP5, which is probably the problem.. the software probably
needs PHP4.

Any other solutions? I'm looking for open source, the server is not
commercial, and I have very little budget.

Thanks

Gary B

-- 
Gary Baribault
Courriel: g...@baribault.net
GPG Key: 0xFA812835
GPG Fingerprint: 8597 4D3D 3C3D 4247 077C 9FF9 E412 CAC4 FA81 2835


___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

AstriCon 2009 - October 13 - 15 Phoenix, Arizona
Register Now: http://www.astricon.net

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR Reporting

[James Mutuku]

I got it running a few days ago. I am using php4. Itshould run on php5
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

AstriCon 2009 - October 13 - 15 Phoenix, Arizona
Register Now: http://www.astricon.net

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR Reporting

[Matt Riddell]

On 11/09/09 7:11 AM, Gary Baribault wrote:
 Hi all,

  I'm looking for a reporting solution for Asterisk CDRs. I have a
 small Asterisk server that will eventually have 4 - 6 trunks. the
 system is up and the CDRs are being written to a MySQL DB. I tried
 installing Areski, but had no success .. I assume it's no longer
 supported... the last update was in March 2005 according to this page..

 http://www.voip-info.org/wiki/view/Asterisk+CDR+Areski+GUI

 Has anyone got that it running? My server is OpenSuSE 11.2 with Apache
 2 and PHP5, which is probably the problem.. the software probably
 needs PHP4.

Yeah we use it from time to time.

What do you mean it wasn't working?

Did you get some errors or something?

-- 
Cheers,

Matt Riddell
Director
___

http://www.venturevoip.com/news.php (Daily Asterisk News)
http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer)
http://www.venturevoip.com/c3.php (ConduIT3 PABX Systems)

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

AstriCon 2009 - October 13 - 15 Phoenix, Arizona
Register Now: http://www.astricon.net

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[Asterisk-Users] CDR reporting between two Asterisk servers

[kwijibo]

Anybody know if there is a way to get one Asterisk
server to report CDR information to another Asterisk
server?

I have a local Asterisk server and a remote Asterisk
server.  They talk via IAX2.  I have calls that go
as follows:

PSTN-remote server-IAX2-local server-IP phone
   -IP phone

When a call comes in from the PSTN it rings phones
at the remote site and the local site.  This
call is bridged so whoever picks it up first gets
the call.  I am trying to find a way for the local
server to report back to the remote server with
who answered the phone at the local site.

Is this even possible?

___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

RE: [Asterisk-Users] CDR reporting between two Asterisk servers

[Damon Estep]

Use cdr_mysql

Log your CDRs to a common database
Query as needed from either server using realtime() or from an external
app

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:asterisk-users-
 [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
 Sent: Friday, January 27, 2006 2:22 PM
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 Subject: [Asterisk-Users] CDR reporting between two Asterisk servers
 
 Anybody know if there is a way to get one Asterisk
 server to report CDR information to another Asterisk
 server?
 
 I have a local Asterisk server and a remote Asterisk
 server.  They talk via IAX2.  I have calls that go
 as follows:
 
 PSTN-remote server-IAX2-local server-IP phone
 -IP phone
 
 When a call comes in from the PSTN it rings phones
 at the remote site and the local site.  This
 call is bridged so whoever picks it up first gets
 the call.  I am trying to find a way for the local
 server to report back to the remote server with
 who answered the phone at the local site.
 
 Is this even possible?
 
 ___
 --Bandwidth and Colocation provided by Easynews.com --
 
 Asterisk-Users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] CDR reporting between two Asterisk servers

[kwijibo]

Damon Estep wrote:

Use cdr_mysql

Log your CDRs to a common database
Query as needed from either server using realtime() or from an external
app



Yeah, I thought about that.  If it works how I think it would
work though I would have two CDR records for one call though.
I would have one record from the remote server and one from
the local. Correlating one record with another could be a pain.



___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

RE: [Asterisk-Users] CDR reporting between two Asterisk servers

[Damon Estep]

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:asterisk-users-
 [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
 Sent: Friday, January 27, 2006 2:56 PM
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 Subject: Re: [Asterisk-Users] CDR reporting between two Asterisk
servers
 
 Damon Estep wrote:
  Use cdr_mysql
 
  Log your CDRs to a common database
  Query as needed from either server using realtime() or from an
external
  app
 
 
 Yeah, I thought about that.  If it works how I think it would
 work though I would have two CDR records for one call though.
 I would have one record from the remote server and one from
 the local. Correlating one record with another could be a pain.
 
 
True, but the CDR just logs what happens, and in your scenario you
actually do have 2 calls...
___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] CDR reporting between two Asterisk servers

[Script Head]

You have to write a CDR normalization script that would sift thru the calls and remove duplicate entries. It's also quite easy to do with a stored procedure, this way every time CDR gets written, it eliminates a duplicate.
On 1/27/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Damon Estep wrote: Use cdr_mysql Log your CDRs to a common database
 Query as needed from either server using realtime() or from an external appYeah, I thought about that.If it works how I think it wouldwork though I would have two CDR records for one call though.
I would have one record from the remote server and one fromthe local. Correlating one record with another could be a pain.___--Bandwidth and Colocation provided by 
Easynews.com --Asterisk-Users mailing listTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users

___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] CDR reporting between two Asterisk servers

[JP Carballo]

[EMAIL PROTECTED] wrote:


Damon Estep wrote:


Use cdr_mysql

Log your CDRs to a common database
Query as needed from either server using realtime() or from an external
app



Yeah, I thought about that.  If it works how I think it would
work though I would have two CDR records for one call though.
I would have one record from the remote server and one from
the local. Correlating one record with another could be a pain.


There are several fields you can use to sync records. You could also set 
the accountcode and/or userfield to a value you generate per call..


--
JP Carballo

http://www.netfone2x.com
Bringing the world closer.

It might look like I'm doing nothing, but at the cellular level, I'm really quite busy. 


___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

RE: [Asterisk-Users] CDR reporting between two Asterisk servers

[Damon Estep]

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:asterisk-users-
 [EMAIL PROTECTED] On Behalf Of JP Carballo
 Sent: Friday, January 27, 2006 3:43 PM
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 Subject: Re: [Asterisk-Users] CDR reporting between two Asterisk
servers
 
 [EMAIL PROTECTED] wrote:
 
  Damon Estep wrote:
 
  Use cdr_mysql
 
  Log your CDRs to a common database
  Query as needed from either server using realtime() or from an
external
  app
 
 
  Yeah, I thought about that.  If it works how I think it would
  work though I would have two CDR records for one call though.
  I would have one record from the remote server and one from
  the local. Correlating one record with another could be a pain.
 
 There are several fields you can use to sync records. You could also
set
 the accountcode and/or userfield to a value you generate per call..
 
How would you sync the generated code between two servers?
___
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users