Re: [asterisk-users] CDR reporting solution
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
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] Large astDB - millions of tuples - issues?
We wrote a call screening (and CID rewrite) app for an ITSP a few years ago. We had to use MySQL as the astDB could not keep up (* was choking – we did dig deeper we just switched to MySQL). I don’t think astDB is the right way to go. If you’re comfortable writing a * func then you might as well go with MySQL. From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Gabriel Ortiz Lour Sent: Wednesday, March 22, 2017 9:51 AM To: Asterisk Users Mailing List - Non-Commercial DiscussionSubject: Re: [asterisk-users] Large astDB - millions of tuples - issues? Hi Dovid, I'm trying to get rid of my AGIs. I wrote an * func to check directly my PG database, and then I saw that * already has a func_blacklist that will check astDB. I was thinking the issues I might have using astDB for it. If I do some performance tests I get back here with the results. Thanks, Gabriel 2017-03-22 10:40 GMT-03:00 Dovid Bender >: I have never tested something that large but I would think it would be slow. Why not use an age with reddis or mysql? On Mar 22, 2017 9:32 AM, "Gabriel Ortiz Lour" > wrote: Hi all, Does anyone uses astDB for a large amount of data, in special for implementing black lists with millions of numbers (i'd like about 2 or 3 million)? That would be held in memory right? Is this (memory consumption) the only problem I could face? Att. Gabriel -- _ -- 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 -- _ -- 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 -- _ -- 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] Large astDB - millions of tuples - issues?
Hi Dovid, I'm trying to get rid of my AGIs. I wrote an * func to check directly my PG database, and then I saw that * already has a func_blacklist that will check astDB. I was thinking the issues I might have using astDB for it. If I do some performance tests I get back here with the results. Thanks, Gabriel 2017-03-22 10:40 GMT-03:00 Dovid Bender: > I have never tested something that large but I would think it would be > slow. Why not use an age with reddis or mysql? > > On Mar 22, 2017 9:32 AM, "Gabriel Ortiz Lour" > wrote: > >> Hi all, >> Does anyone uses astDB for a large amount of data, in special for >> implementing black lists with millions of numbers (i'd like about 2 or 3 >> million)? >> >> That would be held in memory right? Is this (memory consumption) the >> only problem I could face? >> Att. >> Gabriel >> >> -- >> _ >> -- 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 >> > > -- > _ > -- 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 > -- _ -- 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] Large astDB - millions of tuples - issues?
I have never tested something that large but I would think it would be slow. Why not use an age with reddis or mysql? On Mar 22, 2017 9:32 AM, "Gabriel Ortiz Lour"wrote: > Hi all, > Does anyone uses astDB for a large amount of data, in special for > implementing black lists with millions of numbers (i'd like about 2 or 3 > million)? > > That would be held in memory right? Is this (memory consumption) the > only problem I could face? > Att. > Gabriel > > -- > _ > -- 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 > -- _ -- 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] Large astDB - millions of tuples - issues?
Hi all, Does anyone uses astDB for a large amount of data, in special for implementing black lists with millions of numbers (i'd like about 2 or 3 million)? That would be held in memory right? Is this (memory consumption) the only problem I could face? Att. Gabriel -- _ -- 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] Tracking Music-on-Hold on call queues
Hi all, we have a little tool that tracks Music-on-Hold events for call queues by listening to AMI events. This is quite useful for reporting so, as the tool is free to use and does not depend on our QueueMetrics Call Center suite, I thought I'd announce it in here as well. If anyone is interested, you can find a post here: https://www.queuemetrics.com/blog/2017/03/22/TrackingMOH/?lid=A002 Comments welcome :) l. -- Loway - home of QueueMetrics - http://queuemetrics.com WombatDialer - next generation predictive dialer - http://wombatdialer.com -- _ -- 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] Running asterisk as non-root
On Tue, Mar 21, 2017 at 08:54:22PM -0400, Jerry Geis wrote: > I found a page that assisted in running asterisk as non-root. > > My question is why is the default install not more friendly in this > manner??? It requires either creating a user or making sure such a user exists. That's not a firendly thing to do in a typical 'make install'. It is quite the expected thing on just about any packaging of Asterisk, because there are relatively standard methods of creating users in the context of a specific distribution. > > I mean basically the instructions changed the permissions to allow GROUP > write, so 775 instead of 755 and changed the astrun to be a directory That assumes USER or GROUP exists. > > Why doesn't the default install do this? Seems logical to me. I installed > 11.25.1 If you're still not convinved, Patches are welcomed (for the master branch). -- Tzafrir Cohen +972-50-7952406 mailto:tzafrir.co...@xorcom.com http://www.xorcom.com -- _ -- 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