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? 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.