ya,

I added a line:

switch_log_printf(SWITCH_CHANNEL_SESSION_LOG(session), SWITCH_LOG_NOTICE, "sip_recovery SQL => %s\n", sql);

and found that it actually inserts the xml_cdr_text into sip_recovery table ...


its just isql command line utility that was unable to display it ... maybe because of xml tags.


Anyhow,  metadata looks like:


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<cdr>                                                                                                                                                                                                                                                                                                                                                                                                    
  <channel_data>                                                                                                                                                                                                                                                                                                                                                                                         
    <state>CS_EXECUTE</state>                                                                                                                                                                                                                                                                                                                                                                            
    <direction>inbound</direction>                                                                                                                                                                                                                                                                                                                                                                       
    <state_number>4</state_number>                                                                                                                                                                                                                                                                                                                                                                       
    <flags>0=1;1=1;35=1;41=1;51=1</flags>                                                                                                                                                                                                                                                                                                                                                                
    <caps>1=1;2=1;3=1</caps>                                                                                                                                                                                                                                                                                                                                                                             
  </channel_data>                                                                                                                                                                                                                                                                                                                                                                                        
  <variables>                                                                                                                                                                                                                                                                                                                                                                                            
    <uuid>4be94b6f-1df1-45bd-b920-1c55185dc3bd</uuid>                                                                                                                                                                                                                                                                                                                                                    
    <sip_local_network_addr>195.88.212.30</sip_local_network_addr>                                                                                                                                                                                                                                                                                                                                       
    <sip_network_ip>195.88.212.39</sip_network_ip>                                                                                                                                                                                                                                                                                                                                                       
    <sip_network_port>49603</sip_network_port>                                                                                                                                                                                                                                                                                                                                                           
    <sip_received_ip>195.88.212.39</sip_received_ip>                                                                                                                                                                                                                                                                                                                                                     
    <sip_received_port>49603</sip_received_port>                                                                                                                                                                                                                                                                                                                                                         
    <sip_via_protocol>udp</sip_via_protocol>                                                                                                                                                                                                                                                                                                                                                             
    <sip_from_user>38515492122</sip_from_user>                                                                                                                                                                                                                                                                                                                                                           
    <sip_from_uri>38515492122%40195.88.212.39</sip_from_uri>                                                                                                                                                                                                                                                                                                                                             
    <sip_from_host>195.88.212.39</sip_from_host>                                                                                                                                                                                                                                                                                                                                                         
    <sip_from_user_stripped>38515492122</sip_from_user_stripped>                                                                                                                                                                                                                                                                                                                                         
    <sofia_profile_name>external</sofia_profile_name>                                                                                                                                                                                                                                                                                                                                                    
    <sip_Remote-Party-ID>%3Csip%3A38515492122%40195.88.212.39%3E%3Bparty%3Dcalling%3Bscreen%3Dyes%3Bprivacy%3Doff</sip_Remote-Party-ID>                                                                                                                                                                                                                                                                  
    <sip_cid_type>rpid</sip_cid_type>                                                                                                                                                                                                                                                                                                                                                                    
    <sip_full_via>SIP/2.0/UDP%20195.88.212.39%3A5060%3Bbranch%3Dz9hG4bK27A84C</sip_full_via>                                                                                                                                                                                                                                                                                                             
    <sip_req_user>38518880050</sip_req_user>                                                                                                                                                                                                                                                                                                                                                             
    <sip_req_port>5080</sip_req_port>                                                                                                                                                                                                                                                                                                                                                                    
    <sip_req_uri>38518880050%40195.88.212.30%3A5080</sip_req_uri>                                                                                                                                                                                                                                                                                                                                        
    <sip_req_host>195.88.212.30</sip_req_host>                                                                                                                                                                                                                                                                                                                                                           
    <sip_to_user>38518880050</sip_to_user>                                                                                                                                                                                                                                                                                                                                                               
    <sip_to_uri>38518880050%40195.88.212.30</sip_to_uri>                                                                                                                                                                                                                                                                                                                                                 
    <sip_to_host>195.88.212.30</sip_to_host>                                                                                                                                                                                                                                                                                                                                                             
    <sip_contact_user>38515492122</sip_contact_user>                                                                                                                                                                                                                                                                                                                                                     
    <sip_contact_port>5060</sip_contact_port>                                                                                                                                                                                                                                                                                                                                                            
    <sip_contact_uri>38515492122%40195.88.212.39%3A5060</sip_contact_uri>                                                                                                                                                                                                                                                                                                                                
    <sip_contact_host>195.88.212.39</sip_contact_host>                                                                                                                                                                                                                                                                                                                                                   
    <channel_name>sofia/external/38515492122%40195.88.212.39</channel_name>                                                                                                                                                                                                                                                                                                                              
    <sip_user_agent>Cisco-SIPGateway/IOS-12.x</sip_user_agent>                                                                                                                                                                                                                                                                                                                                           
    <sip_via_host>195.88.212.39</sip_via_host>                                                                                                                                                                                                                                                                                                                                                           
    <sip_via_port>5060</sip_via_port>                                                                                                                                                                                                                                                                                                                                                                    
    <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>
    <sip_use_codec_name>PCMA</sip_use_codec_name>                                                                                                                                                                                                                                                                                                                                                        
    <sip_use_codec_rate>8000</sip_use_codec_rate>                                                                                                                                                                                                                                                                                                                                                        
    <sip_use_codec_ptime>20</sip_use_codec_ptime>                                                                                                                                                                                                                                                                                                                                                        
    <read_codec>PCMA</read_codec>                                                                                                                                                                                                                                                                                                                                                                        
    <read_rate>8000</read_rate>                                                                                                                                                                                                                                                                                                                                                                          
    <write_codec>PCMA</write_codec>                                                                                                                                                                                                                                                                                                                                                                      
    <write_rate>8000</write_rate>                                                                                                                                                                                                                                                                                                                                                                        
    <outside_call>true</outside_call>                                                                                                                                                                                                                                                                                                                                                                    
    <domain_name>195.88.212.31</domain_name>                                                                                                                                                                                                                                                                                                                                                             
    <max_forwards>69</max_forwards>                                                                                                                                                                                                                                                                                                                                                                      
    <myDNIS>38518880050</myDNIS>                                                                                                                                                                                                                                                                                                                                                                         
    <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>                                                                             
    <local_media_ip>195.88.212.30</local_media_ip>                                                                                                                                                                                                                                                                                                                                                       
    <local_media_port>25930</local_media_port>                                                                                                                                                                                                                                                                                                                                                           
    <sip_use_pt>8</sip_use_pt>                                                                                                                                                                                                                                                                                                                                                                           
    <rtp_use_ssrc>1713917945</rtp_use_ssrc>                                                                                                                                                                                                                                                                                                                                                              
    <remote_media_ip>195.88.212.39</remote_media_ip>                                                                                                                                                                                                                                                                                                                                                     
    <remote_media_port>16464</remote_media_port>                                                                                                                                                                                                                                                                                                                                                         
    <endpoint_disposition>ANSWER</endpoint_disposition>                                                                                                                                                                                                                                                                                                                                                  
    <sip_to_tag>va1j6gN6FQKtp</sip_to_tag>                                                                                                                                                                                                                                                                                                                                                               
    <sip_from_tag>CDA3D150-264D</sip_from_tag>                                                                                                                                                                                                                                                                                                                                                           
    <sip_cseq>101</sip_cseq>                                                                                                                                                                                                                                                                                                                                                                             
    <sip_call_id>AED34DF0-288311E0-89BBD88B-B59C2BD1%40195.88.212.39</sip_call_id>                                                                                                                                                                                                                                                                                                                       
    <sip_full_from>%3Csip%3A38515492122%40195.88.212.39%3E%3Btag%3DCDA3D150-264D</sip_full_from>                                                                                                                                                                                                                                                                                                         
    <sip_full_to>%3Csip%3A38518880050%40195.88.212.30%3E%3Btag%3Dva1j6gN6FQKtp</sip_full_to>                                                                                                                                                                                                                                                                                                             
    <language>hr</language>                                                                                                                                                                                                                                                                                                                                                                              
    <CALLID>h323-conf-id%3D4be94b6f-1df1-45bd-b920-1c55185dc3bd</CALLID>                                                                                                                                                                                                                                                                                                                                 
    <SERVICENUM>h323-prompt-id%3D38518880050</SERVICENUM>                                                                                                                                                                                                                                                                                                                                                
    <TRANSACTIONID>h323-ivr-out%3DtransactionID%3A1234</TRANSACTIONID>                                                                                                                                                                                                                                                                                                                                   
    <auto_hunt>true</auto_hunt>                                                                                                                                                                                                                                                                                                                                                                          
    <CALLINGNUMBER>38515492122</CALLINGNUMBER>                                                                                                                                                                                                                                                                                                                                                           
    <billing_model>h323-billing-model%3D0</billing_model>                                                                                                                                                                                                                                                                                                                                                
    <return_code>h323-return-code%3D0</return_code>                                                                                                                                                                                                                                                                                                                                                      
    <ANI_AUTH_RESULT>OK</ANI_AUTH_RESULT>                                                                                                                                                                                                                                                                                                                                                                
    <UNAME>38515492122</UNAME>                                                                                                                                                                                                                                                                                                                                                                           
    <PASSWD>1234</PASSWD>                                                                                                                                                                                                                                                                                                                                                                                
    <export_vars>myDNIS,UNAME,PASSWD</export_vars>                                                                                                                                                                                                                                                                                                                                                       
    <sound_prefix>/usr/local/freeswitch/sounds/hr/HR/teta1</sound_prefix>                                                                                                                                                                                                                                                                                                                                
    <ENTER_DEST_PR>tone_stream%3A//%25(200,300,425,425)%3B%25(700,800,425,425)%3Bloops%3D5</ENTER_DEST_PR>                                                                                                                                                                                                                                                                                               
    <DST_TIMEOUT>1000</DST_TIMEOUT>                                                                                                                                                                                                                                                                                                                                                                      
    <playback_seconds>0</playback_seconds>                                                                                                                                                                                                                                                                                                                                                               
    <playback_ms>0</playback_ms>                                                                                                                                                                                                                                                                                                                                                                         
    <playback_samples>0</playback_samples>                                                                                                                                                                                                                                                                                                                                                               
    <read_result>failure</read_result>                                                                                                                                                                                                                                                                                                                                                                   
    <DN_INT>false</DN_INT>                                                                                                                                                                                                                                                                                                                                                                               
    <DN_NAT>false</DN_NAT>                                                                                                                                                                                                                                                                                                                                                                               
    <DN_LOC>false</DN_LOC>                                                                                                                                                                                                                                                                                                                                                                               
    <DST_ERR_PR>ivr/_no_dest_entered2.wav</DST_ERR_PR>                                                                                                                                                                                                                                                                                                                                                   
    <DST_RETRIES>2</DST_RETRIES>                                                                                                                                                                                                                                                                                                                                                                         
    <bind_meta_key></bind_meta_key>                                                                                                                                                                                                                                                                                                                                                                      
    <playback_delimiter>!</playback_delimiter>                                                                                                                                                                                                                                                                                                                                                           
    <playback_terminators>%23*0123456789</playback_terminators>                                                                                                                                                                                                                                                                                                                                          
    <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>                                                                                                                                                                                                                      
    <current_application>read</current_application>                                                                                                                                                                                                                                                                                                                                                      
  </variables>                                                                                                                                                                                                                                                                                                                                                                                           
  <app_log>                                                                                                                                                                                                                                                                                                                                                                                              
    <application app_name="set" app_data="outside_call=true"></application>                                                                                                                                                                                                                                                                                                                              
    <application app_name="set" app_data="domain_name=195.88.212.31"></application>                                                                                                                                                                                                                                                                                                                      
    <application app_name="transfer" app_data="38518880050 XML default"></application>                                                                                                                                                                                                                                                                                                                   
    <application app_name="export" app_data="myDNIS=38518880050"></application>                                                                                                                                                                                                                                                                                                                          
    <application app_name="set" app_data="playback_terminators=#*0123456789"></application>                                                                                                                                                                                                                                                                                                              
    <application app_name="answer" app_data=""></application>                                                                                                                                                                                                                                                                                                                                            
    <application app_name="sleep" app_data="100"></application>                                                                                                                                                                                                                                                                                                                                          
    <application app_name="set" app_data="language=hr"></application>                                                                                                                                                                                                                                                                                                                                    
    <application app_name="set" app_data="CALLID=h323-conf-id=4be94b6f-1df1-45bd-b920-1c55185dc3bd"></application>                                                                                                                                                                                                                                                                                       
    <application app_name="set" app_data="SERVICENUM=h323-prompt-id=38518880050"></application>                                                                                                                                                                                                                                                                                                          
    <application app_name="set" app_data="TRANSACTIONID=h323-ivr-out=transactionID:1234"></application>                                                                                                                                                                                                                                                                                                  
    <application app_name="set" app_data="auto_hunt=true"></application>                                                                                                                                                                                                                                                                                                                                 
    <application app_name="execute_extension" app_data="ANIorPIN XML NXIVR"></application>                                                                                                                                                                                                                                                                                                               
    <application app_name="export" app_data="DIALED_NUMBER="></application>                                                                                                                                                                                                                                                                                                                              
    <application app_name="set" app_data="CALLINGNUMBER=38515492122"></application>                                                                                                                                                                                                                                                                                                                      
    <application app_name="auth_function" app_data="in , in 38515492122, in 1234, out ANI_AUTH_RESULT"></application>                                                                                                                                                                                                                                                                                    
    <application app_name="execute_extension" app_data="CheckANI XML NXIVR"></application>                                                                                                                                                                                                                                                                                                               
    <application app_name="export" app_data="UNAME=38515492122"></application>                                                                                                                                                                                                                                                                                                                           
    <application app_name="export" app_data="PASSWD=1234"></application>                                                                                                                                                                                                                                                                                                                                 
    <application app_name="set" app_data="sound_prefix=/usr/local/freeswitch/sounds/hr/HR/teta1"></application>                                                                                                                                                                                                                                                                                          
    <application app_name="set" app_data="ENTER_DEST_PR=tone_stream://%(200,300,425,425);%(700,800,425,425);loops=5"></application>                                                                                                                                                                                                                                                                      
    <application app_name="set" app_data="DST_TIMEOUT=1000"></application>                                                                                                                                                                                                                                                                                                                               
    <application app_name="execute_extension" app_data="GetDstNum XML NXIVR"></application>                                                                                                                                                                                                                                                                                                              
    <application app_name="set" app_data="DST_RETRIES=1"></application>                                                                                                                                                                                                                                                                                                                                  
    <application app_name="set" app_data="bind_meta_key=#"></application>                                                                                                                                                                                                                                                                                                                                
    <application app_name="bind_meta_app" app_data="0 a a transfer::LongDTMF XML NXIVR"></application>                                                                                                                                                                                                                                                                                                   
    <application app_name="set" app_data="playback_delimiter=!"></application>                                                                                                                                                                                                                                                                                                                           
    <application app_name="set" app_data="playback_terminators=#*0123456789"></application>                                                                                                                                                                                                                                                                                                              
    <application app_name="start_dtmf" app_data=""></application>                                                                                                                                                                                                                                                                                                                                        
    <application app_name="read" app_data="6 20 !tone_stream://%(200,300,425,425);%(700,800,425,425);loops=5 DN 1000 *"></application>                                                                                                                                                                                                                                                                   
    <application app_name="stop_dtmf" app_data=""></application>                                                                                                                                                                                                                                                                                                                                         
    <application app_name="execute_extension" app_data="TranslateLocal XML NXIVR"></application>                                                                                                                                                                                                                                                                                                         
    <application app_name="set" app_data="DN_INT=false"></application>                                                                                                                                                                                                                                                                                                                                   
    <application app_name="set" app_data="DN_NAT=false"></application>                                                                                                                                                                                                                                                                                                                                   
    <application app_name="set" app_data="DN_LOC=false"></application>                                                                                                                                                                                                                                                                                                                                   
    <application app_name="export" app_data="DIALED_NUMBER="></application>                                                                                                                                                                                                                                                                                                                              
    <application app_name="export" app_data="DIALED_NUMBER="></application>                                                                                                                                                                                                                                                                                                                              
    <application app_name="export" app_data="DIALED_NUMBER="></application>                                                                                                                                                                                                                                                                                                                              
    <application app_name="execute_extension" app_data="ParseDN XML NXIVR"></application>                                                                                                                                                                                                                                                                                                                
    <application app_name="log" app_data="INFO ################# EMPTY DESTINATION ################                                                                                                                                                                                                                                                                                                      
"></application>                                                                                                                                                                                                                                                                                                                                                                                         
    <application app_name="set" app_data="DST_ERR_PR=ivr/_no_dest_entered2.wav"></application>                                                                                                                                                                                                                                                                                                           
    <application app_name="execute_extension" app_data="DstRetries XML NXIVR"></application>                                                                                                                                                                                                                                                                                                             
    <application app_name="execute_extension" app_data="GetDstNum XML NXIVR"></application>                                                                                                                                                                                                                                                                                                              
    <application app_name="set" app_data="DST_RETRIES=2"></application>                                                                                                                                                                                                                                                                                                                                  
    <application app_name="set" app_data="bind_meta_key=#"></application>                                                                                                                                                                                                                                                                                                                                
    <application app_name="bind_meta_app" app_data="0 a a transfer::LongDTMF XML NXIVR"></application>                                                                                                                                                                                                                                                                                                   
    <application app_name="set" app_data="playback_delimiter=!"></application>                                                                                                                                                                                                                                                                                                                           
    <application app_name="set" app_data="playback_terminators=#*0123456789"></application>                                                                                                                                                                                                                                                                                                              
    <application app_name="start_dtmf" app_data=""></application>                                                                                                                                                                                                                                                                                                                                        
    <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>                                                                                                                                                                                                                                          
  </app_log>                                                                                                                                                                                                                                                                                                                                                                                             
  <callflow dialplan="XML">                                                                                                                                                                                                                                                                                                                                                                              
    <extension name="GetDstNum" number="GetDstNum" current_app="read">                                                                                                                                                                                                                                                                                                                                   
      <application app_name="set" app_data="bind_meta_key=#"></application>                                                                                                                                                                                                                                                                                                                              
      <application app_name="bind_meta_app" app_data="0 a a transfer::LongDTMF XML NXIVR"></application>                                                                                                                                                                                                                                                                                                 
      <application app_name="set" app_data="playback_delimiter=!"></application>                                                                                                                                                                                                                                                                                                                         
      <application app_name="set" app_data="playback_terminators=#*0123456789"></application>                                                                                                                                                                                                                                                                                                            
      <application app_name="start_dtmf" app_data=""></application>                                                                                                                                                                                                                                                                                                                                      
      <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>                                                                                                                                                                                                                                       
      <application app_name="stop_dtmf" app_data=""></application>                                                                                                                                                                                                                                                                                                                                       
      <application app_name="execute_extension" app_data="TranslateLocal XML NXIVR"></application>                                                                                                                                                                                                                                                                                                       
      <application app_name="execute_extension" app_data="ParseDN XML NXIVR"></application>                                                                                                                                                                                                                                                                                                              
      <application app_name="auth_function" app_data="in ${DIALED_NUMBER}, in ${UNAME}, in ${PASSWD}, out AUTH_RESULT"></application>                                                                                                                                                                                                                                                                    
      <application app_name="set" app_data="CALLINGNUMBER=${caller_id_number}"></application>                                                                                                                                                                                                                                                                                                            
      <application app_name="execute_extension" app_data="PARSE_RET_CODE XML NXIVR"></application>                                                                                                                                                                                                                                                                                                       
      <application app_name="execute_extension" app_data="CheckDstNum XML NXIVR"></application>                                                                                                                                                                                                                                                                                                          
    </extension>                                                                                                                                                                                                                                                                                                                                                                                         
    <caller_profile>                                                                                                                                                                                                                                                                                                                                                                                     
      <username>38515492122</username>                                                                                                                                                                                                                                                                                                                                                                   
      <dialplan>XML</dialplan>                                                                                                                                                                                                                                                                                                                                                                           
      <caller_id_name>38515492122</caller_id_name>                                                                                                                                                                                                                                                                                                                                                       
      <ani>38515492122</ani>                                                                                                                                                                                                                                                                                                                                                                             
      <aniii></aniii>                                                                                                                                                                                                                                                                                                                                                                                    
      <caller_id_number>38515492122</caller_id_number>                                                                                                                                                                                                                                                                                                                                                   
      <network_addr>195.88.212.39</network_addr>                                                                                                                                                                                                                                                                                                                                                         
      <rdnis>38518880050</rdnis>                                                                                                                                                                                                                                                                                                                                                                         
      <destination_number>GetDstNum</destination_number>                                                                                                                                                                                                                                                                                                                                                 
      <uuid>4be94b6f-1df1-45bd-b920-1c55185dc3bd</uuid>                                                                                                                                                                                                                                                                                                                                                  
      <source>mod_sofia</source>                                                                                                                                                                                                                                                                                                                                                                         
      <context>NXIVR</context>                                                                                                                                                                                                                                                                                                                                                                           
      <chan_name>sofia/external/38515492122@195.88.212.39</chan_name>                                                                                                                                                                                                                                                                                                                                    
    </caller_profile>                                                                                                                                                                                                                                                                                                                                                                                    
  </callflow>                                                                                                                                                                                                                                                                                                                                                                                            
</cdr>                                                                                                                                                                                                                                                                                                                                                                                                   




is we have full info of the call ... and still no joy :)

well, its time for the update i guess... a lot of pain in the next hours.





On Wed, Jan 26, 2011 at 1:32 PM, Tihomir Culjaga <tculjaga@gmail.com> wrote:
hmmm,


it should be working :P



void sofia_glue_tech_track(sofia_profile_t *profile, switch_core_session_t *session)
{
        switch_event_t *event;
        private_object_t *tech_pvt = (private_object_t *) switch_core_session_get_private(session);

        if (!sofia_test_pflag(profile, PFLAG_TRACK_CALLS) || sofia_test_flag(tech_pvt, TFLAG_RECOVERING)) {
                return;
        }

        if (sofia_test_flag(tech_pvt, TFLAG_TRACKED)) {
                sofia_glue_tech_untrack(profile, session, SWITCH_TRUE);
        }

        if (switch_event_create(&event, SWITCH_EVENT_CHANNEL_DATA) == SWITCH_STATUS_SUCCESS) {
                switch_xml_t cdr = NULL;
                char *xml_cdr_text = NULL;

                if (switch_ivr_generate_xml_cdr(session, &cdr) == SWITCH_STATUS_SUCCESS) {
                        xml_cdr_text = switch_xml_toxml(cdr, SWITCH_FALSE);
                        switch_xml_free(cdr);
                }

                if (xml_cdr_text) {
                        char *sql;
                        sql = switch_mprintf("insert into sip_recovery (runtime_uuid, profile_name, hostname, uuid, metadata) values
 ('%q','%q','%q','%q','%q')",
                                                                 switch_core_get_uuid(), profile->name, mod_sofia_globals.hostname,
switch_core_session_get_uuid(session), xml_cdr_text);

                        sofia_glue_execute_sql_now(profile, &sql, SWITCH_TRUE);
                        free(xml_cdr_text);
                        sofia_set_flag(tech_pvt, TFLAG_TRACKED);
                }

        }

}


im gonna dig why xml_cdr_text is empty.






On Wed, Jan 26, 2011 at 1:20 PM, Tihomir Culjaga <tculjaga@gmail.com> wrote:
dam,  your metadata is awesome ... now i see the difference.

i do have track calls enabled on both profiles (internal & external) and i have odbc configured as well.



but my version is:

freeswitch@cxss01> version

FreeSWITCH Version 1.0.6 (svn-exported)

freeswitch@cxss01>



how can i make sure it is because of the version ?





freeswitch@cxss01>
freeswitch@cxss01>
freeswitch@cxss01> sofia profile external start
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 debug [0]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 sip-trace [no]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 track-calls [true]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rfc2833-pt [101]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 sip-port [5080]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 dialplan [XML]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 context [public]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 dtmf-duration [70]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:3279 Duration out of bounds, using default of 2000!
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 dtmf-type [inband]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 inbound-codec-prefs [PCMA,GSM]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 outbound-codec-prefs [PCMA,GSM]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 hold-music [local_stream://moh]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-timer-name [soft]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 local-network-acl [localnet.auto]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 manage-presence [false]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 inbound-codec-negotiation [generous]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 nonce-ttl [60]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 auth-calls [false]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-ip [195.88.212.30]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 sip-ip [195.88.212.30]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 ext-rtp-ip [auto-nat]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 ext-sip-ip [auto-nat]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-timeout-sec [300]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 rtp-hold-timeout-sec [1800]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls [false]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-bind-params [transport=tls]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-sip-port [5081]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-cert-dir [/usr/local/freeswitch/conf/ssl]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 tls-version [tlsv1]
2011-01-26 13:14:11.423588 [DEBUG] sofia.c:2755 odbc-dsn [COREFSdrv:adminfs:4F0s8wj]
2011-01-26 13:14:11.423588 [NOTICE] sofia_reg.c:2451 Added gateway 'example.com' to profile 'external'
2011-01-26 13:14:11.423588 [NOTICE] sofia.c:3535 Connecting ODBC Profile external [sofia_reg_external]
2011-01-26 13:14:11.424818 [DEBUG] sofia.c:1317 Creating agent for external
2011-01-26 13:14:11.438512 [INFO] sofia_glue.c:4569 Connected ODBC DSN: COREFSdrv
2011-01-26 13:14:11.459433 [DEBUG] sofia.c:1353 Created agent for external
2011-01-26 13:14:11.459433 [DEBUG] sofia.c:1389 Set params for external
2011-01-26 13:14:11.459433 [DEBUG] sofia.c:1412 Activated db for external
2011-01-26 13:14:11.460603 [DEBUG] sofia.c:1439 Starting thread for external

external started successfully

freeswitch@cxss01>
freeswitch@cxss01>
freeswitch@cxss01>
freeswitch@cxss01> sofia profile internal start
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 debug [0]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 sip-trace [no]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 track-calls [true]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 log-auth-failures [true]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 context [public]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rfc2833-pt [101]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 sip-port [5060]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 dialplan [XML]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 dtmf-duration [70]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:3279 Duration out of bounds, using default of 2000!
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-codec-prefs [PCMA,GSM]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 outbound-codec-prefs [PCMA,GSM]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-timer-name [soft]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-ip [195.88.212.30]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 sip-ip [195.88.212.30]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 hold-music [local_stream://moh]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 apply-nat-acl [nat.auto]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 apply-inbound-acl [domains]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 local-network-acl [localnet.auto]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 dtmf-type [inband]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 record-path [/usr/local/freeswitch/recordings]
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]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 manage-presence [true]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-codec-negotiation [generous]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls [false]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-bind-params [transport=tls]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-sip-port [5061]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-cert-dir [/usr/local/freeswitch/conf/ssl]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 tls-version [tlsv1]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 odbc-dsn [COREFSdrv:adminfs:4F0s8wj]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-late-negotiation [true]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 nonce-ttl [60]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 auth-calls [true]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 inbound-reg-force-matching-username [true]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 auth-all-packets [false]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 ext-rtp-ip [auto-nat]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 ext-sip-ip [auto-nat]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-timeout-sec [300]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 rtp-hold-timeout-sec [1800]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 force-register-domain [195.88.212.31]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 force-subscription-domain [195.88.212.31]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 force-register-db-domain [195.88.212.31]
2011-01-26 13:14:16.440442 [DEBUG] sofia.c:2755 challenge-realm [auto_from]
2011-01-26 13:14:16.440442 [NOTICE] sofia_reg.c:2451 Added gateway 'hr-sbc01' to profile 'internal'
2011-01-26 13:14:16.441444 [NOTICE] sofia_reg.c:2451 Added gateway 'hr-sbc02' to profile 'internal'
2011-01-26 13:14:16.441444 [NOTICE] sofia.c:2040 Adding Alias [195.88.212.31] for profile [internal]
2011-01-26 13:14:16.441444 [NOTICE] sofia.c:3535 Connecting ODBC Profile internal [sofia_reg_internal]
2011-01-26 13:14:16.441444 [DEBUG] sofia.c:1317 Creating agent for internal
2011-01-26 13:14:16.455326 [INFO] sofia_glue.c:4569 Connected ODBC DSN: COREFSdrv
2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1353 Created agent for internal
2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1389 Set params for internal
2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1412 Activated db for internal
2011-01-26 13:14:16.476319 [DEBUG] sofia.c:1439 Starting thread for internal

internal started successfully





i do have track-calls enabled on the sip profiles.


and yes, FS is quite outdated:

freeswitch@cxss01> version

FreeSWITCH Version 1.0.6 (svn-exported)

freeswitch@cxss01>










On Wed, Jan 26, 2011 at 1:00 PM, Avi Marcus <avi@avimarcus.net> wrote:
The sip recovery table should have a LOT more data than that, all stuffed into a single column.
Do you have track calls on in all the involved profiles? I suppose it really wouldn't be here otherwise.

e.g. my sip_recovery table has this in the metadata field for a "simple" MOH call. Does yours?


<cdr>
  <channel_data>
    <state>CS_EXECUTE</state>
    <direction>inbound</direction>
    <state_number>4</state_number>
    <flags>0=1;1=1;3=1;35=1;41=1;51=1</flags>
    <caps>1=1;2=1;3=1;4=1;5=1</caps>
  </channel_data>
  <variables>
    <direction>inbound</direction>
    <uuid>6cda8922-2943-11e0-b622-639ef8e43974</uuid>
    <sip_local_network_addr>178.79.147.47</sip_local_network_addr>
    <sip_network_ip>79.176.185.32</sip_network_ip>
    <sip_network_port>5072</sip_network_port>
    <sip_received_ip>79.176.yyy.32</sip_received_ip>
    <sip_received_port>5072</sip_received_port>
    <sip_via_protocol>udp</sip_via_protocol>
    <sip_authorized>true</sip_authorized>
    <sip_number_alias>1000</sip_number_alias>
    <sip_auth_username>1000</sip_auth_username>
    <sip_auth_realm>sip-ha.yyy.com</sip_auth_realm>
    <number_alias>1000</number_alias>
    <user_name>1000</user_name>
    <domain_name>sip.yyy.com</domain_name>
    <record_stereo>true</record_stereo>
    <default_areacode>208</default_areacode>
    <transfer_fallback_extension>operator</transfer_fallback_extension>
    <accountcode>1000</accountcode>
    <user_context>default</user_context>
    <effective_caller_id_name>Avi%20Marcus</effective_caller_id_name>
    <effective_caller_id_number>12013554419</effective_caller_id_number>
    <outbound_caller_id_name>Avi%20Marcus</outbound_caller_id_name>
    <outbound_caller_id_number>12013554419</outbound_caller_id_number>
    <nibble_account>1000</nibble_account>
    <sip_from_user>1000</sip_from_user>
    <sip_from_uri>1000%40sip-ha.yyy.com</sip_from_uri>
    <sip_from_host>sip-ha.yyy.com</sip_from_host>
    <sip_from_user_stripped>1000</sip_from_user_stripped>
    <sofia_profile_name>internal</sofia_profile_name>
    <sip_Remote-Party-ID>%3Csip%3A1000%40sip-ha.yyy.com%3E%3Bscreen%3Dyes%3Bparty%3Dcalling</sip_Remote-Party-ID>
    <sip_cid_type>rpid</sip_cid_type>
    <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>
    <sip_req_user>*9664</sip_req_user>
    <sip_req_uri>*9664%40sip-ha.yyy.com</sip_req_uri>
    <sip_req_host>sip-ha.yyy.com</sip_req_host>
    <sip_to_user>*9664</sip_to_user>
    <sip_to_uri>*9664%40sip-ha.yyy.com</sip_to_uri>
    <sip_to_host>sip-ha.yyy.com</sip_to_host>
    <sip_contact_user>1000</sip_contact_user>
    <sip_contact_port>5072</sip_contact_port>
    <sip_contact_uri>1000%4079.176.yyy.32%3A5072</sip_contact_uri>
    <sip_contact_host>79.176.yyy.32</sip_contact_host>
    <channel_name>sofia/internal/1000%40sip-ha.yyy.com</channel_name>
    <sip_user_agent>Linksys/SPA2102-5.2.10</sip_user_agent>
    <sip_via_host>192.168.1.5</sip_via_host>
    <sip_via_port>5072</sip_via_port>
    <sip_via_rport>5072</sip_via_rport>
    <max_forwards>70</max_forwards>
    <presence_id>1000%40sip-ha.yyy.com</presence_id>
    <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>
    <ep_codec_string>PCMU%408000h%4020i%4064000b,PCMA%408000h%4020i%4064000b</ep_codec_string>
    <nibble_current_balance>0.000000</nibble_current_balance>
    <RFC2822_DATE>Wed,%2026%20Jan%202011%2013%3A57%3A18%20%2B0200</RFC2822_DATE>
    <zrtp_secure_media>true</zrtp_secure_media>
    <sip_use_codec_name>PCMU</sip_use_codec_name>
    <sip_use_codec_rate>8000</sip_use_codec_rate>
    <sip_use_codec_ptime>20</sip_use_codec_ptime>
    <read_codec>PCMU</read_codec>
    <read_rate>8000</read_rate>
    <write_codec>PCMU</write_codec>
    <write_rate>8000</write_rate>
    <local_media_ip>178.79.yyy.47</local_media_ip>
    <local_media_port>19600</local_media_port>
    <sip_use_pt>0</sip_use_pt>
    <rtp_use_ssrc>922702377</rtp_use_ssrc>
    <remote_media_ip>79.176.185.32</remote_media_ip>
    <remote_media_port>16422</remote_media_port>
    <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>
    <endpoint_disposition>ANSWER</endpoint_disposition>
    <sip_to_tag>vgcH82ctg6QaD</sip_to_tag>
    <sip_from_tag>9241a2573e4f702o0</sip_from_tag>
    <sip_cseq>102</sip_cseq>
    <sip_call_id>17217721-3d90de36%40192.168.1.5</sip_call_id>
    <sip_full_from>%3Csip%3A1000%40sip-ha.yyy.com%3E%3Btag%3D9241a2573e4f702o0</sip_full_from>
    <sip_full_to>%3Csip%3A*9664%40sip-ha.yyy.com%3E%3Btag%3DvgcH82ctg6QaD</sip_full_to>
    <playback_seconds>2</playback_seconds>
    <playback_ms>2000</playback_ms>
    <playback_samples>16000</playback_samples>
    <current_application_data>local_stream%3A//moh</current_application_data>
    <current_application>playback</current_application>
  </variables>
  <app_log>
    <application app_name="hash" app_data="insert/sip.yyy.com-spymap/1000/6cda8922-2943-11e0-b622-639ef8e43974"></application>
    <application app_name="hash" app_data="insert/sip.yyy.com-last_dial/1000/*9664"></application>
    <application app_name="hash" app_data="insert/sip.yyy.com-last_dial/global/6cda8922-2943-11e0-b622-639ef8e43974"></application>
    <application app_name="set" app_data="RFC2822_DATE=Wed, 26 Jan 2011 13:57:18 +0200"></application>
    <application app_name="set" app_data="zrtp_secure_media=true"></application>
    <application app_name="answer" app_data=""></application>
    <application app_name="playback" app_data="silence_stream://2000"></application>
    <application app_name="execute_extension" app_data="is_zrtp_secure XML features"></application>
    <application app_name="eval" app_data="not_secure"></application>
    <application app_name="playback" app_data="local_stream://moh"></application>
  </app_log>
  <callflow dialplan="XML" profile_index="1">
    <extension name="global" number="*9664">
      <application app_name="hash" app_data="insert/${domain_name}-spymap/${caller_id_number}/${uuid}"></application>
      <application app_name="hash" app_data="insert/${domain_name}-last_dial/${caller_id_number}/${destination_number}"></application>
      <application app_name="hash" app_data="insert/${domain_name}-last_dial/global/${uuid}"></application>
      <application app_name="set" app_data="RFC2822_DATE=${strftime(%a, %d %b %Y %T %z)}"></application>
      <application app_name="set" app_data="zrtp_secure_media=true"></application>
      <application app_name="answer" app_data=""></application>
      <application app_name="playback" app_data="silence_stream://2000"></application>
      <application app_name="execute_extension" app_data="is_zrtp_secure XML features"></application>
      <application app_name="playback" app_data="local_stream://moh"></application>
      <sub_extensions>
        <extension name="is_zrtp_secure" number="is_zrtp_secure" dialplan="XML">
          <application app_name="eval" app_data="not_secure"></application>
        </extension>
      </sub_extensions>
    </extension>
    <caller_profile>
      <username>1000</username>
      <dialplan>XML</dialplan>
      <caller_id_name>1000</caller_id_name>
      <ani>1000</ani>
      <aniii></aniii>
      <caller_id_number>1000</caller_id_number>
      <network_addr>79.176.yyy.32</network_addr>
      <rdnis></rdnis>
      <destination_number>*9664</destination_number>
      <uuid>6cda8922-2943-11e0-b622-639ef8e43974</uuid>
      <source>mod_sofia</source>
      <context>default</context>
      <chan_name>sofia/internal/1000@sip-ha.yyy.com</chan_name>
    </caller_profile>
    <times>
      <created_time>1296043038692089</created_time>
      <profile_created_time>1296043038692089</profile_created_time>
      <progress_time>0</progress_time>
      <progress_media_time>1296043038708572</progress_media_time>
      <answered_time>1296043038708572</answered_time>
      <hangup_time>0</hangup_time>
      <resurrect_time>0</resurrect_time>
      <transfer_time>0</transfer_time>
    </times>
  </callflow>
</cdr>




On Wed, Jan 26, 2011 at 12:53 PM, Tihomir Culjaga <tculjaga@gmail.com> wrote:
hello Anthony,

ya, i was afraid of that... this means moving all my modules & patches to the latest git...

radius cdr interface
odbc cdr interface

within mod_xml_cdr <= i can share this as a patch... if you are interested.


mod_say_hr - really bad programming .. needs big re-factoring but lack of time :(
patches for mod_say_de & mod_say_fr - because wrong playing in some scenarios

and some small stuff i made within mod_commands... anyhow this was on the road.


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)


so what really happens is the FS on 2nd node just getting sessions from sip_recovery

from sofia_glue_recover: i see you are selecting sip_recovery table.


select * from sip_recovery;
runtime_uuid profile_name hostname uuid metadata
24f77a1f-f315-4beb-904f-f779e8767c75 internal cxss01 102b2c7f-466f-4b6d-a795-e2cc25630e78  
24f77a1f-f315-4beb-904f-f779e8767c75 external cxss01 52834d99-c1be-4832-bee9-7ba05238871d  




so, what do you do afterward?


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 ?




thanks for your help,
Tihomir.