[Freeswitch-users] core.db table channels application field store wrong data when executing voicemail

[Antonio]

I see. I've a couple of questions related:

Is it recommended to directly use core.db for monitoring purposes
instead of developing a custom event handler? Could there be any sqlite
"locking" issues if attacking that database in a read-only manner?

In case it is possible, how can I identify what was the initial
application that was called from the dialplan (and not the applications
called by it). Is there an API method containing the history of
applications executed on a specific channel given its uuid?

Thanks,
António


On Thu, 2010-08-19 at 09:20 -0500, Anthony Minessale wrote:
> No, every app that is ever executed will change that field, some apps
> in turn execute more apps.
> 
> 
> On Thu, Aug 19, 2010 at 3:09 AM, Antonio <asilva at wirelessmundi.com> wrote:
> >
> > Hi,
> >
> > during multiple selects in the table "channels" just realized that when
> > a call is executing the app voicemail, to check for messages, during the
> > navigation menu of the voicemail it changes to application "sleep".
> >
> > Is it normal? or is a bug for fs?
> >
> >
> > The call:
> >
> > During the auth:
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|voicemail|check commsmundi.com commsmundi.com 100|XML|
> > local|PCMU|8000|PCMU|8000||marces|101 at 192.168.10.25||EARLY||||
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|voicemail|check commsmundi.com commsmundi.com 100|XML|
> > local|PCMU|8000|PCMU|8000||marces|101 at 192.168.10.25||EARLY||||
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|voicemail|check commsmundi.com commsmundi.com 100|XML|
> > local|PCMU|8000|PCMU|8000||marces|101 at 192.168.10.25||EARLY||||
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|voicemail|check commsmundi.com commsmundi.com 100|XML|
> > local|PCMU|8000|PCMU|8000||marces|101 at 192.168.10.25||EARLY||||
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|voicemail|check commsmundi.com commsmundi.com 100|XML|
> > local|PCMU|8000|PCMU|8000||marces|101 at 192.168.10.25||EARLY||||
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|voicemail|check commsmundi.com commsmundi.com 100|XML|
> > local|PCMU|8000|PCMU|8000||marces|101 at 192.168.10.25||EARLY||||
> >
> > in the navigation menu:
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|sleep|100|XML|local|PCMU|8000|PCMU|8000||marces|
> > 101 at 192.168.10.25||EARLY||||
> >
> > sqlite> select * from channels;
> > 58de6c5f-1d0a-45f6-9d0c-4665b32812eb|inbound|2010-08-19 10:01:46|
> > 1282204906|sofia/192.168.10.25/101 at 192.168.10.25|CS_EXECUTE|101|101|
> > 192.168.10.75|133|sleep|100|XML|local|PCMU|8000|PCMU|8000||marces|
> > 101 at 192.168.10.25||EARLY||||
> >
> >
> >
> > Thanks,
> > António
> >
> >
> >
> > _______________________________________________
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
> 
> 
> 
-- 

Un cordial saludo / Best regards, 

 _________________________

António Silva

E-mail:asilva at wirelessmundi.com