<br><br><div class="gmail_quote">On 23 August 2010 10:32, Antonio <span dir="ltr"><<a href="mailto:asilva@wirelessmundi.com">asilva@wirelessmundi.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I see. I've a couple of questions related:<br>
<br>
Is it recommended to directly use core.db for monitoring purposes<br>
instead of developing a custom event handler? Could there be any sqlite<br>
"locking" issues if attacking that database in a read-only manner?<br></blockquote><div><br>I would use ESL, I believe that's probably the recommended way to do it. It's a pretty simple protocol so shouldn't be any harder to implement than something reading an sqlite file. You can either use events and work out the channel states yourself, or use api commands like 'show channels' etc (which reads the core db so are pretty much what you'd already be doing).<br>
<br>A rwlock can't be written while a reader has it, so it will possibly slow the DB down if you're reading the database. Shouldn't be noticeable unless you're doing so intensively though.<br><br>Another approach would be to move the core into odbc to use a database system that's more advanced than sqlite, which would also them allow you to replicate the data to another server so none of the monitoring occurs on the FS host.<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
In case it is possible, how can I identify what was the initial<br>
application that was called from the dialplan (and not the applications<br>
called by it). Is there an API method containing the history of<br>
applications executed on a specific channel given its uuid?<br></blockquote><div><br>Do you need it in realtime or after the call? mod_xml_cdr contains the callflow, I don't know whether that can be accessed during a call though.<br>
<br>ESL events will give you that information I believe.<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Thanks,<br>
António<br>
<div><div></div><div class="h5"><br>
<br>
On Thu, 2010-08-19 at 09:20 -0500, Anthony Minessale wrote:<br>
> No, every app that is ever executed will change that field, some apps<br>
> in turn execute more apps.<br>
><br>
><br>
> On Thu, Aug 19, 2010 at 3:09 AM, Antonio <<a href="mailto:asilva@wirelessmundi.com">asilva@wirelessmundi.com</a>> wrote:<br>
> ><br>
> > Hi,<br>
> ><br>
> > during multiple selects in the table "channels" just realized that when<br>
> > a call is executing the app voicemail, to check for messages, during the<br>
> > navigation menu of the voicemail it changes to application "sleep".<br>
> ><br>
> > Is it normal? or is a bug for fs?<br>
> ><br>
> ><br>
> > The call:<br>
> ><br>
> > During the auth:<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|voicemail|check <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> 100|XML|<br>
> > local|PCMU|8000|PCMU|8000||marces|<a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|voicemail|check <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> 100|XML|<br>
> > local|PCMU|8000|PCMU|8000||marces|<a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|voicemail|check <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> 100|XML|<br>
> > local|PCMU|8000|PCMU|8000||marces|<a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|voicemail|check <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> 100|XML|<br>
> > local|PCMU|8000|PCMU|8000||marces|<a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|voicemail|check <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> 100|XML|<br>
> > local|PCMU|8000|PCMU|8000||marces|<a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|voicemail|check <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> <a href="http://commsmundi.com" target="_blank">commsmundi.com</a> 100|XML|<br>
> > local|PCMU|8000|PCMU|8000||marces|<a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > in the navigation menu:<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|sleep|100|XML|local|PCMU|8000|PCMU|8000||marces|<br>
> > <a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> > sqlite> select * from channels;<br>
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|<br>
> > 1282204906|sofia/<a href="http://192.168.10.25/101@192.168.10.25%7CCS_EXECUTE%7C101%7C101%7C" target="_blank">192.168.10.25/101@192.168.10.25|CS_EXECUTE|101|101|</a><br>
> > 192.168.10.75|133|sleep|100|XML|local|PCMU|8000|PCMU|8000||marces|<br>
> > <a href="mailto:101@192.168.10.25">101@192.168.10.25</a>||EARLY||||<br>
> ><br>
> ><br>
> ><br>
> > Thanks,<br>
> > António<br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > FreeSWITCH-users mailing list<br>
> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> ><br>
><br>
><br>
><br>
--<br>
<br>
</div></div>Un cordial saludo / Best regards,<br>
<br>
_________________________<br>
<br>
António Silva<br>
<br>
<a href="mailto:E-mail%3Aasilva@wirelessmundi.com">E-mail:asilva@wirelessmundi.com</a><br>
<div><div></div><div class="h5"><br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br>