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
