[asterisk-users] realtime queue callers

[Atis Lezdins]

On Tue, Apr 29, 2008 at 9:47 PM, Vieri <rentorbuy at yahoo.com> wrote:
>  That's what I would like to do: use dynamic queue
>  members but rely on mysql for monitoring active queue
> calls.
>
>  > Btw, I never experienced that MySQL dies, it's more
>  > often that Asterisk dies.
>
>  I agree. But I did have a strange case at one point.
>  Would like to reduce point of failures anyway, as much
>  as possible.

Ok, so in this case failed INSERT or DELETE should affect Asterisk in no way.

>  > So, are You interested in applying this patch
>  > yourself?
>
>  I just wrote a simple AMI script which parses the
>  output of "show queues" and sends relevant data to my
>  custom application via sockets. The only problem is
>  that I need to periodically run the script (cron) so
>  it's rather "inefficient". Maybe I could trigger the
>  script on particular Manager events (such as "run the
>  script which parses 'show queues' only when I receive
>  Agent* events).

Well, the problem with "show queues" is that it sometimes might lock,
and if you have many clients needing the same information,
you have to write some kind of proxy, and cache everything, so that
there's only one request to Asterisk in specific period.
For MySQL you can use all that without worry, plus you get actual data
(that was why I wrote all this realtime status stuff).

>  I don't want you to make the effort of finding that
>  patch (as it seems you don't have it at hand now) if I
>  may not "need it". However, I think that your patch
>  should hit SVN and I wouldn't mind testing it.

Ok, after a thought, this part is quite simple - just few lines, so
I'll post it right away. I'll leave more complex realtime
agent/channel updates for later.

So, the issue is http://bugs.digium.com/view.php?id=12556, feel free
to comment about usage.

I also posted backport to 1.4.19 at
http://ftp.iq-labs.net/realtime_queue_callers-1.4/ but for this You
will need to also apply backport for realtime store/destroy - also
available at http://ftp.iq-labs.net/realtime_store_destroy-1.4/

Regards,
Atis


-- 
Atis Lezdins,
VoIP Project Manager / Developer,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835