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] Large astDB - millions of tuples - issues?

[Telium Technical Support]

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 Discussion 

Subject: 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?

[Gabriel Ortiz Lour]

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?

[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

[asterisk-users] Large astDB - millions of tuples - issues?

[Gabriel Ortiz Lour]

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

[Lenz Emilitri]

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

[Tzafrir Cohen]

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