<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">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">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">40sip-ha.yyy.com</a></sip_from_uri></div><div> <sip_from_host><a href="http://sip-ha.yyy.com">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">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">40sip-ha.yyy.com</a></sip_req_uri></div><div> <sip_req_host><a href="http://sip-ha.yyy.com">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">40sip-ha.yyy.com</a></sip_to_uri></div><div> <sip_to_host><a href="http://sip-ha.yyy.com">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">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">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">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">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">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><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">tculjaga@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;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>