[Freeswitch-users] core.db table channels application field store wrong data when executing voicemail
Antonio
asilva at wirelessmundi.com
Tue Aug 24 00:56:46 PDT 2010
Yes, i want to use it for realtime monitoring.
I will give a try to ESL.
My system is not that load, so in the core.db i would have every thing
that i need, but i can't trust the fields... using ESL i will "re-do"
what is been done fore the core.db .
On Mon, 2010-08-23 at 10:52 +0100, Steven Ayre wrote:
>
>
> On 23 August 2010 10:32, Antonio <asilva at wirelessmundi.com> wrote:
> 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?
>
> 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).
>
> 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.
>
> 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.
>
>
> 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?
>
> 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.
>
> ESL events will give you that information I believe.
>
>
> 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
>
>
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
More information about the FreeSWITCH-users
mailing list