Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

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


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
mike at jerris.com
Guest





PostPosted: Tue Nov 25, 2008 7:54 am    Post subject: [Freeswitch-users] False call running so long.. Reply with quote

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:

Quote:

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@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@xxx.xxx.xxx.xxx
2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()
Channel
sofia/internal/1234567890@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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
pmhshz at gmail.com
Guest





PostPosted: Tue Nov 25, 2008 9:12 am    Post subject: [Freeswitch-users] False call running so long.. Reply with quote

Thanks Mike,
btw, What kind of blocking can happen?

Thanks
msp


Michael Jerris wrote:
Quote:

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:

Quote:

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@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@xxx.xxx.xxx.xxx
2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()
Channel
sofia/internal/1234567890@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@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@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@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..-tp20678102p20681967.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
pmhshz at gmail.com
Guest





PostPosted: Wed Nov 26, 2008 10:19 am    Post subject: [Freeswitch-users] False call running so long.. Reply with quote

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:
Quote:

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:

Quote:

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@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@xxx.xxx.xxx.xxx
2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()
Channel
sofia/internal/1234567890@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@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@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
anthony.minessale at g...
Guest





PostPosted: Wed Nov 26, 2008 11:21 am    Post subject: [Freeswitch-users] False call running so long.. Reply with quote

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@gmail.com (pmhshz@gmail.com)> wrote:
Quote:

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:
Quote:

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:

Quote:

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@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@xxx.xxx.xxx.xxx
2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()
Channel
sofia/internal/1234567890@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@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@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@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
pmhshz at gmail.com
Guest





PostPosted: Thu Nov 27, 2008 7:39 am    Post subject: [Freeswitch-users] False call running so long.. Reply with quote

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:
Quote:

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@gmail.com> wrote:

Quote:

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:
Quote:

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:

Quote:

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@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@xxx.xxx.xxx.xxx
2008-11-23 17:40:26 [DEBUG] sofia.c:2129 sofia_handle_sip_i_state()
Channel
sofia/internal/1234567890@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@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@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

################################################################################################################
Quote:
Quote:

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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users

UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
Quote:
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@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@hotmail.com <MSN%3Aanthony_minessale@hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org>
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org>
pstn:213-799-1400

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@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.


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services