Sent from a mobile device.

Michael Keuter

> Am 17.01.2018 um 21:58 schrieb Michael Knill 
> <michael.kn...@ipcsolutions.com.au>:
> 
> Whoops sorry MySQL module in the custom build.
> PS I just did a Web Chat to the Asternic guys and it appears that you can set 
> up everything on a separate server and just log your CDR to the database on 
> that separate server.
> I looked at CDR-Stats and it seemed a bit basic to me!
> 
> Regards
> Michael Knill
> On 18/1/18, 7:09 am, "Michael Knill" <michael.kn...@ipcsolutions.com.au> 
> wrote:
> 
>    Thanks Michael
> 
>    Do you need a local mysql client for Asterisk to log CDR to a remote mysql 
> database?
>    Couldn't it just do it natively?

Yes, you need a local MySQL client.
I have somewhere a tutorial, I look it up tomorrow.

> 
>    Regards
>    Michael Knill
>    On 17/1/18, 9:53 pm, "Michael Keuter" <li...@mksolutions.info> wrote:
> 
> 
>> Am 17.01.2018 um 11:06 schrieb Michael Knill 
>> <michael.kn...@ipcsolutions.com.au>:
>> 
>> Just resurrecting this topic.
>> So do I have ANY options for CDR Analysis on Astlinux?
>> I have a potential customer that I don't think I can win without it (
>> It doesn't need to be anything special but Im loathed to start developing 
>> something myself.
>> 
>> Thanks
>> Mike 
>> 
>> Regards
>> Michael Knill
> 
>        Hello Michael,
> 
>        as I said another option would be logging to an external MySQL 
> database. You need to custom build the (quite old) MySQL client for AstLinux.
>        I used that years ago for testing with the old Areski CDR Stats (v1).
> 
>        Then you could either export the raw CDR csv data or write custom 
> views for the SQLite database.
> 
>        Have you tried "CDR Stats" (or the demo) already? Is that the right 
> tool?
>        If so we could include the CDR pusher Go app for "CDR Stats" as 
> package for custom builds (I am also are voting for that, cause I also have 
> some existing customers who would like that).
>        I made a little recherche and there are some build options to reduce 
> the binary file size of the Go app.
> 
>> On 8/1/18, 10:26 am, "Michael Keuter" <li...@mksolutions.info> wrote:
>> 
>>   Sent from a mobile device.
>> 
>>   Michael Keuter
>> 
>>> Am 08.01.2018 um 00:12 schrieb Michael Knill 
>>> <michael.kn...@ipcsolutions.com.au>:
>>> 
>>> Hi Michael. Yes it certainly would be great to have this working.
>>> It looks like Asternic is OnBox only?
>> 
>>   Maybe the easiest is to ask Nicolas directly ...
>> 
>>> Regards
>>> Michael Knill
>>> -----Original Message-----
>>> From: Michael Keuter <li...@mksolutions.info>
>>> Reply-To: AstLinux List <astlinux-users@lists.sourceforge.net>
>>> Date: Sunday, 7 January 2018 at 9:59 pm
>>> To: AstLinux List <astlinux-users@lists.sourceforge.net>
>>> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
>>> 
>>>> Am 06.01.2018 um 01:57 schrieb Michael Knill 
>>>> <michael.kn...@ipcsolutions.com.au>:
>>>> 
>>>> Hi Group
>>>> 
>>>> Im getting a number of requests from my customers for this and Im not 
>>>> quite sure which way to go.
>>>> Here are my current options:
>>>>  • Roll my own on Astlinux – Certainly the best option but also the most 
>>>> time consuming and potentially costly
>>>>  • Use an external application e.g. CDR Stats – I am concerned about the 
>>>> integration requirements to Astlinux. Is anyone using this?
>>>>  • Some other option?
>>>> 
>>>> I would love to hear what others are doing in this space.
>>>> 
>>>> Regards
>>>> Michael Knill
>>> 
>>> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the 
>>> current CDR Stats), with a MySQL connector (custom build was needed).
>>> But at that time the GUI was quite barebone and nothing for my customers 
>>> :-), so I used it only for my own testing.
>>> 
>>> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR 
>>> Pusher" application which is Go based:
>>> 
>>> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
>>> 
>>> The good thing is, it is free and it supports more than one Asterisk 
>>> server. I would be interested as well in CDR Stats (installed on a VM or 
>>> so).
>>> 
>>> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, 
>>> to include Go or rewrite the Go script in a language AstLinux supports.
>>> 
>>> https://github.com/cdr-stats/cdr-pusher
>>> 
>>> BTW: Go 1.9 is already included in BR2 :-).
>>> 
>>> Michael
>>> 
>>> http://www.mksolutions.info
>>> 
>>> PS: There is also another commercial CDR application from Nicolas Gaudino 
>>> (the FOP2 guy): http://www.asternic.net/cdrreports/
> 
>        Michael
> 
>        http://www.mksolutions.info
> 
> 
> 
> 
>        
> ------------------------------------------------------------------------------
>        Check out the vibrant tech community on one of the world's most
>        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>        _______________________________________________
>        Astlinux-users mailing list
>        Astlinux-users@lists.sourceforge.net
>        https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
>        Donations to support AstLinux are graciously accepted via PayPal to 
> pay...@krisk.org.
> 
>    
> ------------------------------------------------------------------------------
>    Check out the vibrant tech community on one of the world's most
>    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>    _______________________________________________
>    Astlinux-users mailing list
>    Astlinux-users@lists.sourceforge.net
>    https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
>    Donations to support AstLinux are graciously accepted via PayPal to 
> pay...@krisk.org.
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Astlinux-users mailing list
> Astlinux-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
> Donations to support AstLinux are graciously accepted via PayPal to 
> pay...@krisk.org.


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Astlinux-users mailing list
Astlinux-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/astlinux-users

Donations to support AstLinux are graciously accepted via PayPal to 
pay...@krisk.org.

Reply via email to