ya, <br><br>I added a line:<br><br>switch_log_printf(SWITCH_CHANNEL_SESSION_LOG(session), SWITCH_LOG_NOTICE, "sip_recovery SQL => %s\n", sql);<br><br>and found that it actually inserts the xml_cdr_text into sip_recovery table ...<br>
<br><br>its just isql command line utility that was unable to display it ... maybe because of xml tags.<br><br><br>Anyhow, metadata looks like:<br><br><br>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
<cdr> <br>
<channel_data> <br>
<state>CS_EXECUTE</state> <br>
<direction>inbound</direction> <br>
<state_number>4</state_number> <br>
<flags>0=1;1=1;35=1;41=1;51=1</flags> <br>
<caps>1=1;2=1;3=1</caps> <br>
</channel_data> <br>
<variables> <br>
<uuid>4be94b6f-1df1-45bd-b920-1c55185dc3bd</uuid> <br>
<sip_local_network_addr>195.88.212.30</sip_local_network_addr> <br>
<sip_network_ip>195.88.212.39</sip_network_ip> <br>
<sip_network_port>49603</sip_network_port> <br>
<sip_received_ip>195.88.212.39</sip_received_ip> <br>
<sip_received_port>49603</sip_received_port> <br>
<sip_via_protocol>udp</sip_via_protocol> <br>
<sip_from_user>38515492122</sip_from_user> <br>
<sip_from_uri>38515492122%40195.88.212.39</sip_from_uri> <br>
<sip_from_host>195.88.212.39</sip_from_host> <br>
<sip_from_user_stripped>38515492122</sip_from_user_stripped> <br>
<sofia_profile_name>external</sofia_profile_name> <br>
<sip_Remote-Party-ID>%3Csip%3A38515492122%40195.88.212.39%3E%3Bparty%3Dcalling%3Bscreen%3Dyes%3Bprivacy%3Doff</sip_Remote-Party-ID> <br>
<sip_cid_type>rpid</sip_cid_type> <br>
<sip_full_via>SIP/2.0/UDP%20195.88.212.39%3A5060%3Bbranch%3Dz9hG4bK27A84C</sip_full_via> <br>
<sip_req_user>38518880050</sip_req_user> <br>
<sip_req_port>5080</sip_req_port> <br>
<sip_req_uri>38518880050%40195.88.212.30%3A5080</sip_req_uri> <br>
<sip_req_host>195.88.212.30</sip_req_host> <br>
<sip_to_user>38518880050</sip_to_user> <br>
<sip_to_uri>38518880050%40195.88.212.30</sip_to_uri> <br>
<sip_to_host>195.88.212.30</sip_to_host> <br>
<sip_contact_user>38515492122</sip_contact_user> <br>
<sip_contact_port>5060</sip_contact_port> <br>
<sip_contact_uri>38515492122%40195.88.212.39%3A5060</sip_contact_uri> <br>
<sip_contact_host>195.88.212.39</sip_contact_host> <br>
<channel_name>sofia/external/38515492122%40195.88.212.39</channel_name> <br>
<sip_user_agent>Cisco-SIPGateway/IOS-12.x</sip_user_agent> <br>
<sip_via_host>195.88.212.39</sip_via_host> <br>
<sip_via_port>5060</sip_via_port> <br>
<switch_r_sdp>v%3D0%0D%0Ao%3DCiscoSystemsSIP-GW-UserAgent%203218%205821%20IN%20IP4%20195.88.212.39%0D%0As%3DSIP%20Call%0D%0Ac%3DIN%20IP4%20195.88.212.39%0D%0At%3D0%200%0D%0Am%3Daudio%2016464%20RTP/AVP%208%20101%0D%0Ac%3DIN%20IP4%20195.88.212.39%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-16%0D%0Aa%3Dptime%3A20%0D%0A</switch_r_sdp> <br>
<sip_use_codec_name>PCMA</sip_use_codec_name> <br>
<sip_use_codec_rate>8000</sip_use_codec_rate> <br>
<sip_use_codec_ptime>20</sip_use_codec_ptime> <br>
<read_codec>PCMA</read_codec> <br>
<read_rate>8000</read_rate> <br>
<write_codec>PCMA</write_codec> <br>
<write_rate>8000</write_rate> <br>
<outside_call>true</outside_call> <br>
<domain_name>195.88.212.31</domain_name> <br>
<max_forwards>69</max_forwards> <br>
<myDNIS>38518880050</myDNIS> <br>
<sip_local_sdp_str>v%3D0%0Ao%3DFreeSWITCH%201296021156%201296021157%20IN%20IP4%20195.88.212.30%0As%3DFreeSWITCH%0Ac%3DIN%20IP4%20195.88.212.30%0At%3D0%200%0Am%3Daudio%2025930%20RTP/AVP%208%0Aa%3Drtpmap%3A8%20PCMA/8000%0Aa%3DsilenceSupp%3Aoff%20-%20-%20-%20-%0Aa%3Dptime%3A20%0Aa%3Dsendrecv%0A</sip_local_sdp_str> <br>
<local_media_ip>195.88.212.30</local_media_ip> <br>
<local_media_port>25930</local_media_port> <br>
<sip_use_pt>8</sip_use_pt> <br>
<rtp_use_ssrc>1713917945</rtp_use_ssrc> <br>
<remote_media_ip>195.88.212.39</remote_media_ip> <br>
<remote_media_port>16464</remote_media_port> <br>
<endpoint_disposition>ANSWER</endpoint_disposition> <br>
<sip_to_tag>va1j6gN6FQKtp</sip_to_tag> <br>
<sip_from_tag>CDA3D150-264D</sip_from_tag> <br>
<sip_cseq>101</sip_cseq> <br>
<sip_call_id>AED34DF0-288311E0-89BBD88B-B59C2BD1%40195.88.212.39</sip_call_id> <br>
<sip_full_from>%3Csip%3A38515492122%40195.88.212.39%3E%3Btag%3DCDA3D150-264D</sip_full_from> <br>
<sip_full_to>%3Csip%3A38518880050%40195.88.212.30%3E%3Btag%3Dva1j6gN6FQKtp</sip_full_to> <br>
<language>hr</language> <br>
<CALLID>h323-conf-id%3D4be94b6f-1df1-45bd-b920-1c55185dc3bd</CALLID> <br>
<SERVICENUM>h323-prompt-id%3D38518880050</SERVICENUM> <br>
<TRANSACTIONID>h323-ivr-out%3DtransactionID%3A1234</TRANSACTIONID> <br>
<auto_hunt>true</auto_hunt> <br>
<CALLINGNUMBER>38515492122</CALLINGNUMBER> <br>
<billing_model>h323-billing-model%3D0</billing_model> <br>
<return_code>h323-return-code%3D0</return_code> <br>
<ANI_AUTH_RESULT>OK</ANI_AUTH_RESULT> <br>
<UNAME>38515492122</UNAME> <br>
<PASSWD>1234</PASSWD> <br>
<export_vars>myDNIS,UNAME,PASSWD</export_vars> <br>
<sound_prefix>/usr/local/freeswitch/sounds/hr/HR/teta1</sound_prefix> <br>
<ENTER_DEST_PR>tone_stream%3A//%25(200,300,425,425)%3B%25(700,800,425,425)%3Bloops%3D5</ENTER_DEST_PR> <br>
<DST_TIMEOUT>1000</DST_TIMEOUT> <br>
<playback_seconds>0</playback_seconds> <br>
<playback_ms>0</playback_ms> <br>
<playback_samples>0</playback_samples> <br>
<read_result>failure</read_result> <br>
<DN_INT>false</DN_INT> <br>
<DN_NAT>false</DN_NAT> <br>
<DN_LOC>false</DN_LOC> <br>
<DST_ERR_PR>ivr/_no_dest_entered2.wav</DST_ERR_PR> <br>
<DST_RETRIES>2</DST_RETRIES> <br>
<bind_meta_key></bind_meta_key> <br>
<playback_delimiter>!</playback_delimiter> <br>
<playback_terminators>%23*0123456789</playback_terminators> <br>
<current_application_data>6%2020%20ivr/_no_dest_entered2.wav!tone_stream%3A//%25(200,300,425,425)%3B%25(700,800,425,425)%3Bloops%3D5%20DN%201000%20*</current_application_data> <br>
<current_application>read</current_application> <br>
</variables> <br>
<app_log> <br>
<application app_name="set" app_data="outside_call=true"></application> <br>
<application app_name="set" app_data="domain_name=195.88.212.31"></application> <br>
<application app_name="transfer" app_data="38518880050 XML default"></application> <br>
<application app_name="export" app_data="myDNIS=38518880050"></application> <br>
<application app_name="set" app_data="playback_terminators=#*0123456789"></application> <br>
<application app_name="answer" app_data=""></application> <br>
<application app_name="sleep" app_data="100"></application> <br>
<application app_name="set" app_data="language=hr"></application> <br>
<application app_name="set" app_data="CALLID=h323-conf-id=4be94b6f-1df1-45bd-b920-1c55185dc3bd"></application> <br>
<application app_name="set" app_data="SERVICENUM=h323-prompt-id=38518880050"></application> <br>
<application app_name="set" app_data="TRANSACTIONID=h323-ivr-out=transactionID:1234"></application> <br>
<application app_name="set" app_data="auto_hunt=true"></application> <br>
<application app_name="execute_extension" app_data="ANIorPIN XML NXIVR"></application> <br>
<application app_name="export" app_data="DIALED_NUMBER="></application> <br>
<application app_name="set" app_data="CALLINGNUMBER=38515492122"></application> <br>
<application app_name="auth_function" app_data="in , in 38515492122, in 1234, out ANI_AUTH_RESULT"></application> <br>
<application app_name="execute_extension" app_data="CheckANI XML NXIVR"></application> <br>
<application app_name="export" app_data="UNAME=38515492122"></application> <br>
<application app_name="export" app_data="PASSWD=1234"></application> <br>
<application app_name="set" app_data="sound_prefix=/usr/local/freeswitch/sounds/hr/HR/teta1"></application> <br>
<application app_name="set" app_data="ENTER_DEST_PR=tone_stream://%(200,300,425,425);%(700,800,425,425);loops=5"></application> <br>
<application app_name="set" app_data="DST_TIMEOUT=1000"></application> <br>
<application app_name="execute_extension" app_data="GetDstNum XML NXIVR"></application> <br>
<application app_name="set" app_data="DST_RETRIES=1"></application> <br>
<application app_name="set" app_data="bind_meta_key=#"></application> <br>
<application app_name="bind_meta_app" app_data="0 a a transfer::LongDTMF XML NXIVR"></application> <br>
<application app_name="set" app_data="playback_delimiter=!"></application> <br>
<application app_name="set" app_data="playback_terminators=#*0123456789"></application> <br>
<application app_name="start_dtmf" app_data=""></application> <br>
<application app_name="read" app_data="6 20 !tone_stream://%(200,300,425,425);%(700,800,425,425);loops=5 DN 1000 *"></application> <br>
<application app_name="stop_dtmf" app_data=""></application> <br>
<application app_name="execute_extension" app_data="TranslateLocal XML NXIVR"></application> <br>
<application app_name="set" app_data="DN_INT=false"></application> <br>
<application app_name="set" app_data="DN_NAT=false"></application> <br>
<application app_name="set" app_data="DN_LOC=false"></application> <br>
<application app_name="export" app_data="DIALED_NUMBER="></application> <br>
<application app_name="export" app_data="DIALED_NUMBER="></application> <br>
<application app_name="export" app_data="DIALED_NUMBER="></application> <br>
<application app_name="execute_extension" app_data="ParseDN XML NXIVR"></application> <br>
<application app_name="log" app_data="INFO ################# EMPTY DESTINATION ################ <br>
"></application> <br>
<application app_name="set" app_data="DST_ERR_PR=ivr/_no_dest_entered2.wav"></application> <br>
<application app_name="execute_extension" app_data="DstRetries XML NXIVR"></application> <br>
<application app_name="execute_extension" app_data="GetDstNum XML NXIVR"></application> <br>
<application app_name="set" app_data="DST_RETRIES=2"></application> <br>
<application app_name="set" app_data="bind_meta_key=#"></application> <br>
<application app_name="bind_meta_app" app_data="0 a a transfer::LongDTMF XML NXIVR"></application> <br>
<application app_name="set" app_data="playback_delimiter=!"></application> <br>
<application app_name="set" app_data="playback_terminators=#*0123456789"></application> <br>
<application app_name="start_dtmf" app_data=""></application> <br>
<application app_name="read" app_data="6 20 ivr/_no_dest_entered2.wav!tone_stream://%(200,300,425,425);%(700,800,425,425);loops=5 DN 1000 *"></application> <br>
</app_log> <br>
<callflow dialplan="XML"> <br>
<extension name="GetDstNum" number="GetDstNum" current_app="read"> <br>
<application app_name="set" app_data="bind_meta_key=#"></application> <br>
<application app_name="bind_meta_app" app_data="0 a a transfer::LongDTMF XML NXIVR"></application> <br>
<application app_name="set" app_data="playback_delimiter=!"></application> <br>
<application app_name="set" app_data="playback_terminators=#*0123456789"></application> <br>
<application app_name="start_dtmf" app_data=""></application> <br>
<application last_executed="true" app_name="read" app_data="${DST_MIN_DIG} ${DST_MAX_DIG} ${DST_ERR_PR}!${ENTER_DEST_PR} DN ${DST_TIMEOUT} *"></application> <br>
<application app_name="stop_dtmf" app_data=""></application> <br>
<application app_name="execute_extension" app_data="TranslateLocal XML NXIVR"></application> <br>
<application app_name="execute_extension" app_data="ParseDN XML NXIVR"></application> <br>
<application app_name="auth_function" app_data="in ${DIALED_NUMBER}, in ${UNAME}, in ${PASSWD}, out AUTH_RESULT"></application> <br>
<application app_name="set" app_data="CALLINGNUMBER=${caller_id_number}"></application> <br>
<application app_name="execute_extension" app_data="PARSE_RET_CODE XML NXIVR"></application> <br>
<application app_name="execute_extension" app_data="CheckDstNum XML NXIVR"></application> <br>
</extension> <br>
<caller_profile> <br>
<username>38515492122</username> <br>
<dialplan>XML</dialplan> <br>
<caller_id_name>38515492122</caller_id_name> <br>
<ani>38515492122</ani> <br>
<aniii></aniii> <br>
<caller_id_number>38515492122</caller_id_number> <br>
<network_addr>195.88.212.39</network_addr> <br>
<rdnis>38518880050</rdnis> <br>
<destination_number>GetDstNum</destination_number> <br>
<uuid>4be94b6f-1df1-45bd-b920-1c55185dc3bd</uuid> <br>
<source>mod_sofia</source> <br>
<context>NXIVR</context> <br>
<chan_name>sofia/external/<a href="mailto:38515492122@195.88.212.39">38515492122@195.88.212.39</a></chan_name> <br>
</caller_profile> <br>
</callflow> <br>
</cdr> <br>
<br><br><br><br>is we have full info of the call ... and still no joy :)<br><br>well, its time for the update i guess... a lot of pain in the next hours.<br><br><br><br><br><br><div class="gmail_quote">On Wed, Jan 26, 2011 at 1:32 PM, Tihomir Culjaga <span dir="ltr"><<a href="mailto:tculjaga@gmail.com">tculjaga@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">hmmm, <br><br><br>it should be working :P<br><br><br><br>void sofia_glue_tech_track(sofia_profile_t *profile, switch_core_session_t *session)<br>
{<br> switch_event_t *event;<br> private_object_t *tech_pvt = (private_object_t *) switch_core_session_get_private(session);<br>
<br> if (!sofia_test_pflag(profile, PFLAG_TRACK_CALLS) || sofia_test_flag(tech_pvt, TFLAG_RECOVERING)) {<br> return;<br> }<br><br> if (sofia_test_flag(tech_pvt, TFLAG_TRACKED)) {<br> sofia_glue_tech_untrack(profile, session, SWITCH_TRUE);<br>
}<br><br> if (switch_event_create(&event, SWITCH_EVENT_CHANNEL_DATA) == SWITCH_STATUS_SUCCESS) {<br> switch_xml_t cdr = NULL;<br> char *xml_cdr_text = NULL;<br><br> if (switch_ivr_generate_xml_cdr(session, &cdr) == SWITCH_STATUS_SUCCESS) {<br>
xml_cdr_text = switch_xml_toxml(cdr, SWITCH_FALSE);<br> switch_xml_free(cdr);<br> }<br><br> if (xml_cdr_text) {<br> char *sql;<br>
sql = switch_mprintf("insert into sip_recovery (runtime_uuid, profile_name, hostname, uuid, metadata) values<br> ('%q','%q','%q','%q','%q')",<br> switch_core_get_uuid(), profile->name, mod_sofia_globals.hostname,<br>
switch_core_session_get_uuid(session), xml_cdr_text);<br><br> sofia_glue_execute_sql_now(profile, &sql, SWITCH_TRUE);<br> free(xml_cdr_text);<br> sofia_set_flag(tech_pvt, TFLAG_TRACKED);<br>
}<br><br> }<br><br>}<br><br><br>im gonna dig why xml_cdr_text is empty.<div><div></div><div class="h5"><br><br><br><br><br><br><div class="gmail_quote">On Wed, Jan 26, 2011 at 1:20 PM, Tihomir Culjaga <span dir="ltr"><<a href="mailto:tculjaga@gmail.com" target="_blank">tculjaga@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">dam, your metadata is awesome ... now i see the difference.<br><br>i do have track calls enabled on both profiles (internal & external) and i have odbc configured as well. <br>
<br><br><br>but my version is:<br><br>freeswitch@cxss01> version<br>
<br>
FreeSWITCH Version 1.0.6 (svn-exported)<br>
<br>
freeswitch@cxss01><br>
<br>
<br>
<br>
how can i make sure it is because of the version ? <br>
<br><br><br><br><br>freeswitch@cxss01> <br>freeswitch@cxss01> <br>freeswitch@cxss01> sofia profile external start<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 debug [0]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 sip-trace [no]<br>
<b>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 track-calls [true]</b><br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rfc2833-pt [101]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 sip-port [5080]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 dialplan [XML]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 context [public]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 dtmf-duration [70]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:3279 Duration out of bounds, using default of 2000!<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 dtmf-type [inband]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 inbound-codec-prefs [PCMA,GSM]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 outbound-codec-prefs [PCMA,GSM]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 hold-music [local_stream://moh]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-timer-name [soft]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 local-network-acl [localnet.auto]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 manage-presence [false]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 inbound-codec-negotiation [generous]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 nonce-ttl [60]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 auth-calls [false]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-ip [195.88.212.30]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 sip-ip [195.88.212.30]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 ext-rtp-ip [auto-nat]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 ext-sip-ip [auto-nat]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-timeout-sec [300]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-hold-timeout-sec [1800]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls [false]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-bind-params [transport=tls]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-sip-port [5081]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-cert-dir [/usr/local/freeswitch/conf/ssl]<br>
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-version [tlsv1]<br>2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 odbc-dsn [COREFSdrv:adminfs:4F0s8wj]<br>2011-01-26 13:14:11.423588 [NOTICE] sofia_reg.c:2451 Added gateway '<a href="http://example.com" target="_blank">example.com</a>' to profile 'external'<br>
2011-01-26 13:14:11.423588 [NOTICE] sofia.c:3535 Connecting ODBC Profile external [sofia_reg_external]<br>2011-01-26 13:14:11.424818 [DEBUG] sofia.c:1317 Creating agent for external<br>2011-01-26 13:14:11.438512 [INFO] sofia_glue.c:4569 Connected ODBC DSN: COREFSdrv<br>
2011-01-26 13:14:11.459433 [DEBUG] sofia.c:1353 Created agent for external<br>2011-01-26 13:14:11.459433 [DEBUG] sofia.c:1389 Set params for external<br>2011-01-26 13:14:11.459433 [DEBUG] sofia.c:1412 Activated db for external<br>
2011-01-26 13:14:11.460603 [DEBUG] sofia.c:1439 Starting thread for external<br><br>external started successfully<br><br>freeswitch@cxss01> <br>freeswitch@cxss01> <br>freeswitch@cxss01> <br>freeswitch@cxss01> sofia profile internal start<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 debug [0]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 sip-trace [no]<br><b>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 track-calls [true]</b><br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 log-auth-failures [true]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 context [public]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rfc2833-pt [101]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 sip-port [5060]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 dialplan [XML]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 dtmf-duration [70]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:3279 Duration out of bounds, using default of 2000!<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-codec-prefs [PCMA,GSM]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 outbound-codec-prefs [PCMA,GSM]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-timer-name [soft]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-ip [195.88.212.30]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 sip-ip [195.88.212.30]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 hold-music [local_stream://moh]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 apply-nat-acl [nat.auto]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 apply-inbound-acl [domains]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 local-network-acl [localnet.auto]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 dtmf-type [inband]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 record-path [/usr/local/freeswitch/recordings]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 record-template [${caller_id_number}.${target_domain}.${strftime(%Y-%m-%d-%H-%M-%S)}.wav]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 manage-presence [true]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-codec-negotiation [generous]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls [false]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-bind-params [transport=tls]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-sip-port [5061]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-cert-dir [/usr/local/freeswitch/conf/ssl]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-version [tlsv1]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 odbc-dsn [COREFSdrv:adminfs:4F0s8wj]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-late-negotiation [true]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 nonce-ttl [60]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 auth-calls [true]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-reg-force-matching-username [true]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 auth-all-packets [false]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 ext-rtp-ip [auto-nat]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 ext-sip-ip [auto-nat]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-timeout-sec [300]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-hold-timeout-sec [1800]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 force-register-domain [195.88.212.31]<br>
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 force-subscription-domain [195.88.212.31]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 force-register-db-domain [195.88.212.31]<br>2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 challenge-realm [auto_from]<br>
2011-01-26 13:14:16.440442 [NOTICE] sofia_reg.c:2451 Added gateway 'hr-sbc01' to profile 'internal'<br>2011-01-26 13:14:16.441444 [NOTICE] sofia_reg.c:2451 Added gateway 'hr-sbc02' to profile 'internal'<br>
2011-01-26 13:14:16.441444 [NOTICE] sofia.c:2040 Adding Alias [195.88.212.31] for profile [internal]<br>2011-01-26 13:14:16.441444 [NOTICE] sofia.c:3535 Connecting ODBC Profile internal [sofia_reg_internal]<br>2011-01-26 13:14:16.441444 [DEBUG] sofia.c:1317 Creating agent for internal<br>
2011-01-26 13:14:16.455326 [INFO] sofia_glue.c:4569 Connected ODBC DSN: COREFSdrv<br>2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1353 Created agent for internal<br>2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1389 Set params for internal<br>
2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1412 Activated db for internal<br>2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1439 Starting thread for internal<br><br>internal started successfully<br><br><br><br><br><br>i do have track-calls enabled on the sip profiles.<br>
<br><br>and yes, FS is quite outdated:<br><br>freeswitch@cxss01> version<br>
<br>
FreeSWITCH Version 1.0.6 (svn-exported)<br>
<br>
freeswitch@cxss01><br>
<br>
<br>
<br>
<br><br><br><br>
<br><br><br><div class="gmail_quote"><div><div></div><div>On Wed, Jan 26, 2011 at 1:00 PM, Avi Marcus <span dir="ltr"><<a href="mailto:avi@avimarcus.net" target="_blank">avi@avimarcus.net</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div>
<div dir="ltr">The sip recovery table should have a LOT more data than that, all stuffed into a single column.<div>Do you have track calls on in all the involved profiles? I suppose it really wouldn't be here otherwise.</div>
<div><br></div><div>e.g. my sip_recovery table has this in the metadata field for a "simple" MOH call. Does yours?</div><div><br></div><div><br></div><div><div><cdr></div><div> <channel_data></div>
<div>
<state>CS_EXECUTE</state></div><div> <direction>inbound</direction></div><div> <state_number>4</state_number></div><div> <flags>0=1;1=1;3=1;35=1;41=1;51=1</flags></div>
<div> <caps>1=1;2=1;3=1;4=1;5=1</caps></div><div> </channel_data></div><div> <variables></div><div> <direction>inbound</direction></div><div> <uuid>6cda8922-2943-11e0-b622-639ef8e43974</uuid></div>
<div> <sip_local_network_addr>178.79.147.47</sip_local_network_addr></div><div> <sip_network_ip>79.176.185.32</sip_network_ip></div><div> <sip_network_port>5072</sip_network_port></div>
<div> <sip_received_ip>79.176.yyy.32</sip_received_ip></div><div> <sip_received_port>5072</sip_received_port></div><div> <sip_via_protocol>udp</sip_via_protocol></div><div> <sip_authorized>true</sip_authorized></div>
<div> <sip_number_alias>1000</sip_number_alias></div><div> <sip_auth_username>1000</sip_auth_username></div><div> <sip_auth_realm><a href="http://sip-ha.yyy.com" target="_blank">sip-ha.yyy.com</a></sip_auth_realm></div>
<div> <number_alias>1000</number_alias></div><div> <user_name>1000</user_name></div><div> <domain_name><a href="http://sip.yyy.com" target="_blank">sip.yyy.com</a></domain_name></div>
<div> <record_stereo>true</record_stereo></div>
<div> <default_areacode>208</default_areacode></div><div> <transfer_fallback_extension>operator</transfer_fallback_extension></div><div> <accountcode>1000</accountcode></div><div>
<user_context>default</user_context></div><div> <effective_caller_id_name>Avi%20Marcus</effective_caller_id_name></div><div> <effective_caller_id_number>12013554419</effective_caller_id_number></div>
<div> <outbound_caller_id_name>Avi%20Marcus</outbound_caller_id_name></div><div> <outbound_caller_id_number>12013554419</outbound_caller_id_number></div><div> <nibble_account>1000</nibble_account></div>
<div> <sip_from_user>1000</sip_from_user></div><div> <sip_from_uri>1000%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a></sip_from_uri></div><div> <sip_from_host><a href="http://sip-ha.yyy.com" target="_blank">sip-ha.yyy.com</a></sip_from_host></div>
<div> <sip_from_user_stripped>1000</sip_from_user_stripped></div><div> <sofia_profile_name>internal</sofia_profile_name></div><div> <sip_Remote-Party-ID>%3Csip%3A1000%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a>%3E%3Bscreen%3Dyes%3Bparty%3Dcalling</sip_Remote-Party-ID></div>
<div> <sip_cid_type>rpid</sip_cid_type></div><div> <sip_full_via>SIP/2.0/UDP%20192.168.1.5%3A5072%3Bbranch%3Dz9hG4bK-329da816%3Brport%3D5072%3Breceived%3D79.176.185.32</sip_full_via></div><div>
<sip_req_user>*9664</sip_req_user></div><div> <sip_req_uri>*9664%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a></sip_req_uri></div><div> <sip_req_host><a href="http://sip-ha.yyy.com" target="_blank">sip-ha.yyy.com</a></sip_req_host></div>
<div> <sip_to_user>*9664</sip_to_user></div><div> <sip_to_uri>*9664%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a></sip_to_uri></div><div> <sip_to_host><a href="http://sip-ha.yyy.com" target="_blank">sip-ha.yyy.com</a></sip_to_host></div>
<div> <sip_contact_user>1000</sip_contact_user></div><div> <sip_contact_port>5072</sip_contact_port></div><div> <sip_contact_uri>1000%4079.176.yyy.32%3A5072</sip_contact_uri></div>
<div> <sip_contact_host>79.176.yyy.32</sip_contact_host></div><div> <channel_name>sofia/internal/1000%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a></channel_name></div>
<div> <sip_user_agent>Linksys/SPA2102-5.2.10</sip_user_agent></div>
<div> <sip_via_host>192.168.1.5</sip_via_host></div><div> <sip_via_port>5072</sip_via_port></div><div> <sip_via_rport>5072</sip_via_rport></div><div> <max_forwards>70</max_forwards></div>
<div> <presence_id>1000%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a></presence_id></div><div> <switch_r_sdp>v%3D0%0D%0Ao%3D-%2033038436%2033038436%20IN%20IP4%2079.176.185.32%0D%0As%3D-%0D%0Ac%3DIN%20IP4%2079.176.185.32%0D%0At%3D0%200%0D%0Am%3Daudio%2016422%20RTP/AVP%2018%200%202%204%208%2096%2097%2098%20100%20101%0D%0Aa%3Drtpmap%3A18%20G729/8000%0D%0Aa%3Drtpmap%3A0%20PCMU/8000%0D%0Aa%3Drtpmap%3A2%20G726-32/8000%0D%0Aa%3Drtpmap%3A4%20G723/8000%0D%0Aa%3Drtpmap%3A8%20PCMA/8000%0D%0Aa%3Drtpmap%3A96%20G726-40/8000%0D%0Aa%3Drtpmap%3A97%20G726-24/8000%0D%0Aa%3Drtpmap%3A98%20G726-16/8000%0D%0Aa%3Drtpmap%3A100%20NSE/8000%0D%0Aa%3Dfmtp%3A100%20192-193%0D%0Aa%3Drtpmap%3A101%20telephone-event/8000%0D%0Aa%3Dfmtp%3A101%200-15%0D%0Aa%3Dptime%3A20%0D%0A</switch_r_sdp></div>
<div> <ep_codec_string>PCMU%408000h%4020i%4064000b,PCMA%408000h%4020i%4064000b</ep_codec_string></div><div> <nibble_current_balance>0.000000</nibble_current_balance></div><div> <RFC2822_DATE>Wed,%2026%20Jan%202011%2013%3A57%3A18%20%2B0200</RFC2822_DATE></div>
<div> <zrtp_secure_media>true</zrtp_secure_media></div><div> <sip_use_codec_name>PCMU</sip_use_codec_name></div><div> <sip_use_codec_rate>8000</sip_use_codec_rate></div><div> <sip_use_codec_ptime>20</sip_use_codec_ptime></div>
<div> <read_codec>PCMU</read_codec></div><div> <read_rate>8000</read_rate></div><div> <write_codec>PCMU</write_codec></div><div> <write_rate>8000</write_rate></div>
<div> <local_media_ip>178.79.yyy.47</local_media_ip></div><div> <local_media_port>19600</local_media_port></div><div> <sip_use_pt>0</sip_use_pt></div><div> <rtp_use_ssrc>922702377</rtp_use_ssrc></div>
<div> <remote_media_ip>79.176.185.32</remote_media_ip></div><div> <remote_media_port>16422</remote_media_port></div><div> <sip_local_sdp_str>v%3D0%0Ao%3DFreeSWITCH%201296023438%201296023439%20IN%20IP4%20178.79.147.47%0As%3DFreeSWITCH%0Ac%3DIN%20IP4%20178.79.147.47%0At%3D0%200%0Am%3Daudio%2019600%20RTP/AVP%200%20101%0Aa%3Drtpmap%3A0%20PCMU/8000%0Aa%3Drtpmap%3A101%20telephone-event/8000%0Aa%3Dfmtp%3A101%200-16%0Aa%3DsilenceSupp%3Aoff%20-%20-%20-%20-%0Aa%3Dptime%3A20%0Aa%3Dsendrecv%0A</sip_local_sdp_str></div>
<div> <endpoint_disposition>ANSWER</endpoint_disposition></div><div> <sip_to_tag>vgcH82ctg6QaD</sip_to_tag></div><div> <sip_from_tag>9241a2573e4f702o0</sip_from_tag></div><div>
<sip_cseq>102</sip_cseq></div><div> <sip_call_id>17217721-3d90de36%40192.168.1.5</sip_call_id></div><div> <sip_full_from>%3Csip%3A1000%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a>%3E%3Btag%3D9241a2573e4f702o0</sip_full_from></div>
<div> <sip_full_to>%3Csip%3A*9664%<a href="http://40sip-ha.yyy.com" target="_blank">40sip-ha.yyy.com</a>%3E%3Btag%3DvgcH82ctg6QaD</sip_full_to></div><div> <playback_seconds>2</playback_seconds></div>
<div> <playback_ms>2000</playback_ms></div>
<div> <playback_samples>16000</playback_samples></div><div> <current_application_data>local_stream%3A//moh</current_application_data></div><div> <current_application>playback</current_application></div>
<div> </variables></div><div> <app_log></div><div> <application app_name="hash" app_data="insert/sip.yyy.com-spymap/1000/6cda8922-2943-11e0-b622-639ef8e43974"></application></div>
<div> <application app_name="hash" app_data="insert/sip.yyy.com-last_dial/1000/*9664"></application></div><div> <application app_name="hash" app_data="insert/sip.yyy.com-last_dial/global/6cda8922-2943-11e0-b622-639ef8e43974"></application></div>
<div> <application app_name="set" app_data="RFC2822_DATE=Wed, 26 Jan 2011 13:57:18 +0200"></application></div><div> <application app_name="set" app_data="zrtp_secure_media=true"></application></div>
<div> <application app_name="answer" app_data=""></application></div><div> <application app_name="playback" app_data="silence_stream://2000"></application></div>
<div> <application app_name="execute_extension" app_data="is_zrtp_secure XML features"></application></div><div> <application app_name="eval" app_data="not_secure"></application></div>
<div> <application app_name="playback" app_data="local_stream://moh"></application></div><div> </app_log></div><div> <callflow dialplan="XML" profile_index="1"></div>
<div> <extension name="global" number="*9664"></div><div> <application app_name="hash" app_data="insert/${domain_name}-spymap/${caller_id_number}/${uuid}"></application></div>
<div> <application app_name="hash" app_data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"></application></div><div> <application app_name="hash" app_data="insert/${domain_name}-last_dial/global/${uuid}"></application></div>
<div> <application app_name="set" app_data="RFC2822_DATE=${strftime(%a, %d %b %Y %T %z)}"></application></div><div> <application app_name="set" app_data="zrtp_secure_media=true"></application></div>
<div> <application app_name="answer" app_data=""></application></div><div> <application app_name="playback" app_data="silence_stream://2000"></application></div>
<div> <application app_name="execute_extension" app_data="is_zrtp_secure XML features"></application></div><div> <application app_name="playback" app_data="local_stream://moh"></application></div>
<div> <sub_extensions></div><div> <extension name="is_zrtp_secure" number="is_zrtp_secure" dialplan="XML"></div><div> <application app_name="eval" app_data="not_secure"></application></div>
<div> </extension></div><div> </sub_extensions></div><div> </extension></div><div> <caller_profile></div><div> <username>1000</username></div><div> <dialplan>XML</dialplan></div>
<div> <caller_id_name>1000</caller_id_name></div><div> <ani>1000</ani></div><div> <aniii></aniii></div><div> <caller_id_number>1000</caller_id_number></div>
<div> <network_addr>79.176.yyy.32</network_addr></div><div> <rdnis></rdnis></div><div> <destination_number>*9664</destination_number></div><div> <uuid>6cda8922-2943-11e0-b622-639ef8e43974</uuid></div>
<div> <source>mod_sofia</source></div><div> <context>default</context></div><div> <chan_name>sofia/internal/<a href="mailto:1000@sip-ha.yyy.com" target="_blank">1000@sip-ha.yyy.com</a></chan_name></div>
<div> </caller_profile></div><div> <times></div><div> <created_time>1296043038692089</created_time></div><div> <profile_created_time>1296043038692089</profile_created_time></div>
<div> <progress_time>0</progress_time></div><div> <progress_media_time>1296043038708572</progress_media_time></div><div> <answered_time>1296043038708572</answered_time></div>
<div> <hangup_time>0</hangup_time></div><div> <resurrect_time>0</resurrect_time></div><div> <transfer_time>0</transfer_time></div><div> </times></div><div> </callflow></div>
<div></cdr></div></div><div><div></div><div><div><br></div><div><br></div><div><br><br><div class="gmail_quote">On Wed, Jan 26, 2011 at 12:53 PM, Tihomir Culjaga <span dir="ltr"><<a href="mailto:tculjaga@gmail.com" target="_blank">tculjaga@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">hello Anthony, <br><br>ya, i was afraid of that... this means moving all my modules & patches to the latest git...<br>
<br>radius cdr interface<br>odbc cdr interface<br><br>within mod_xml_cdr <= i can share this as a patch... if you are interested.<br>
<br><br>mod_say_hr - really bad programming .. needs big re-factoring but lack of time :(<br>patches for mod_say_de & mod_say_fr - because wrong playing in some scenarios<br><br>and some small stuff i made within mod_commands... anyhow this was on the road.<br>
<br><br>anyhow i was really into understanding the way the call context replication works... this may be the DB connection issue as the ODBC connection is reset on switchover (im switching entire resource .. floating IP, & database)<br>
<br><br>so what really happens is the FS on 2nd node just getting sessions from sip_recovery <br><br>from sofia_glue_recover: i see you are selecting sip_recovery table.<br><br><br>select * from sip_recovery;<br>
<table width="1135" border="0" cellpadding="0" cellspacing="0" height="123"><colgroup><col style="width: 187pt;" width="249">
<col style="width: 64pt;" width="86">
<col style="width: 49pt;" width="66">
<col style="width: 196pt;" width="261">
<col style="width: 48pt;" width="64">
</colgroup><tbody><tr style="min-height: 14.4pt;" height="19">
<td style="min-height: 14.4pt; width: 187pt;" width="249" height="19">runtime_uuid</td>
<td style="border-left: medium none; width: 64pt;" width="86">profile_name</td>
<td style="border-left: medium none; width: 49pt;" width="66">hostname</td>
<td style="border-left: medium none; width: 196pt;" width="261">uuid</td>
<td style="border-left: medium none; width: 48pt;" width="64">metadata</td>
</tr>
<tr style="min-height: 14.4pt;" height="19">
<td style="min-height: 14.4pt; border-top: medium none;" height="19">24f77a1f-f315-4beb-904f-f779e8767c75</td>
<td style="border-top: medium none; border-left: medium none;">internal</td>
<td style="border-top: medium none; border-left: medium none;">cxss01</td>
<td style="border-top: medium none; border-left: medium none;">102b2c7f-466f-4b6d-a795-e2cc25630e78</td>
<td style="border-top: medium none; border-left: medium none;"> </td>
</tr>
<tr style="min-height: 14.4pt;" height="19">
<td style="min-height: 14.4pt; border-top: medium none;" height="19">24f77a1f-f315-4beb-904f-f779e8767c75</td>
<td style="border-top: medium none; border-left: medium none;">external</td>
<td style="border-top: medium none; border-left: medium none;">cxss01</td>
<td style="border-top: medium none; border-left: medium none;">52834d99-c1be-4832-bee9-7ba05238871d</td>
<td style="border-top: medium none; border-left: medium none;"> </td>
</tr>
</tbody></table><br><br><br><br>so, what do you do afterward?<br><br><br>on the recovering node i see some portion of dialplan is executed and re-INVITEs being sent ... where do you get the DSP info for the recovering re-INVITE ?<br>
<br><br><br><br>thanks for your help,<br>Tihomir.<br><br><br></blockquote></div></div></div></div></div>
<br></div></div><div>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></div></blockquote></div><br>
</blockquote></div><br>
</div></div></blockquote></div><br>