VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
View previous topic :: View next topic |
Author |
Message |
mike at jerris.com Guest
|
Posted: Tue Nov 25, 2008 7:54 am Post subject: [Freeswitch-users] False call running so long.. |
|
|
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
|
Posted: Tue Nov 25, 2008 9:12 am Post subject: [Freeswitch-users] False call running so long.. |
|
|
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
|
Posted: Wed Nov 26, 2008 10:19 am Post subject: [Freeswitch-users] False call running so long.. |
|
|
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
|
Posted: Wed Nov 26, 2008 11:21 am Post subject: [Freeswitch-users] False call running so long.. |
|
|
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
|
Posted: Thu Nov 27, 2008 7:39 am Post subject: [Freeswitch-users] False call running so long.. |
|
|
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
|
| ################################################################################################################
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 |
|
|
|
|
|
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
|