[Freeswitch-users] False call running so long..

[Anthony Minessale]

use event socket from an external application and you will get all the CDR
data in the channel_hangup event in your own separate process.


On Wed, Nov 26, 2008 at 9:11 AM, shehzad p <pmhshz at gmail.com> wrote:

>
> Hi again,
>
> I would like to share an idea to solve the problem of this delay:
> First, Create an script (php etc),
> which insert all the CDR data to mysql database,
>
> then i call that script using system command passing all CDR values, with
> use of `screen` command,
> so that `screen` (runs in background) performs database entry,
> and without waiting, our javascript can continue and exit, thus ends the
> call.
>
> Is it advisable or not?
> or any other idea?
>
> Thanks,
> msp
>
>
>
>
>
>
>
> Michael Jerris wrote:
> >
> > You have just shown exactly why cdr direct to database is a bad idea.
> > Most likely there was a blip in connectivity to the db and it didn't
> > reconnect correctly.  This behavior would be caused by some blocking
> > in your script.
> >
> > Mike
> >
> > On Nov 25, 2008, at 4:55 AM, shehzad p wrote:
> >
> >>
> >> I faced a strange behavior with my freeswitch...
> >> Freeswitch setup is as follows:
> >> Any call comes to freeswitch are sent to javascript, for routing
> >> based on
> >> some logic.
> >> After call completes, the same script insert the CDR values into mysql
> >> database.
> >>
> >> All is working fine for quite long time,
> >> But when I was looking in freeswitch.log file for particular call,
> >> I found one CDR entry with big difference in time between the call
> >> terminated and time of its CDR inserted into database.
> >>
> >>
> >> The part of freeswitch.log is as follows:
> >> #############################################freeswitch
> >> .log#####################################################
> >> 2008-11-23 17:40:26 [DEBUG] switch_core_state_machine.c:140
> >> switch_core_standard_on_execute()
> >> sofia/internal/1234567890 at xxx.xxx.xxx.xxx
> >> Execute javascript(softswitch/main.js)
> >>
> >> ...............
> >> 2008-11-23 17:40:26 [DEBUG] sofia.c:197 sofia_event_callback() event
> >> [nua_i_state] status [487][Request Terminated] session:
> >> sofia/internal/1234567890 at xxx.xxx.xxx.xxx
> >> 2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()
> >> Channel
> >> sofia/internal/1234567890 at xxx.xxx.xxx.xxx entering state [terminated]
> >> 2008-11-23 17:40:26 [NOTICE] sofia.c:2545 sofia_handle_sip_i_state()
> >> Hangup
> >> sofia/internal/1234567890 at xxx.xxx.xxx.xxx [CS_EXECUTE]
> >> [ORIGINATOR_CANCEL]
> >>
> >> ......           .......      .....
> >>
> >> 2008-11-23 23:14:20 [DEBUG] switch_ivr_bridge.c:353
> >> audio_bridge_thread()
> >> BRIDGE THREAD DONE [sofia/internal/1234567890 at xxx.xxx.xxx.xxx]
> >> .......
> >> 2008-11-23 23:14:20 [INFO] main.js:150 console_log() CDR Inserted
> >> 2008-11-23 23:14:20 [INFO] main.js:151 console_log() ***** start
> >> date    :
> >> 2008-11-23 17:40:26
> >> 2008-11-23 23:14:20 [INFO] main.js:152 console_log() ***** caller  :
> >> 1234567890
> >>
> ################################################################################################################
> >>
> >> This means that time difference between the call terminated and its
> >> CDR
> >> inserted is about 5.30 hours, which is too late.
> >> During this time it was also listing out in 'show calls' and 'show
> >> channels'.
> >>
> >> Any clue for such delay.???
> >
> > _______________________________________________
> > 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
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/False-call-running-so-long..-tp20678102p20702663.html
> Sent from the Freeswitch-users mailing list archive at Nabble.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
>



-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/

AIM: anthm
MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
pstn:213-799-1400
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20081126/8b6d3088/attachment-0002.html