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

[shehzad p]

Thanks Anthony for your valuable advice.

I think there should be a script which
use event socket, which infinitely looks at hangup event


msp





Anthony Minessale-2 wrote:
> 
> 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
> 
> _______________________________________________
> 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..-tp20678102p20718442.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.