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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] >> >> 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/[EMAIL PROTECTED] >> >> 2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state() >> >> Channel >> >> sofia/internal/[EMAIL PROTECTED] entering state [terminated] >> >> 2008-11-23 17:40:26 [NOTICE] sofia.c:2545 sofia_handle_sip_i_state() >> >> Hangup >> >> sofia/internal/[EMAIL PROTECTED] [CS_EXECUTE] >> >> [ORIGINATOR_CANCEL] >> >> >> >> ...... ....... ..... >> >> >> >> 2008-11-23 23:14:20 [DEBUG] switch_ivr_bridge.c:353 >> >> audio_bridge_thread() >> >> BRIDGE THREAD DONE [sofia/internal/[EMAIL PROTECTED] >> >> ....... >> >> 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 >> > [email protected] >> > 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 >> [email protected] >> 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:[EMAIL PROTECTED] <[EMAIL PROTECTED]> > GTALK/JABBER/PAYPAL:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > IRC: irc.freenode.net #freeswitch > > FreeSWITCH Developer Conference > sip:[EMAIL PROTECTED] <[EMAIL PROTECTED]> > iax:[EMAIL PROTECTED]/888 > googletalk:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > pstn:213-799-1400 > > _______________________________________________ > Freeswitch-users mailing list > [email protected] > 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. _______________________________________________ Freeswitch-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
