[asterisk-bugs] [Asterisk 0018251]: Realtime field 'fullcontact' populated with invalid data

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18251 
====================================================================== 
Reported By:                bcnit
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18251
Category:                   Channels/chan_sip/DatabaseSupport
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.13 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-11-04 09:55 CDT
Last Modified:              2010-11-04 12:33 CDT
====================================================================== 
Summary:                    Realtime field 'fullcontact' populated with invalid
data
Description: 

Using Asterisk realtime, the field 'fullcontact' is populated with invalid
data. The result is that warnings occur when a handset re-registers after
Asterisk has been restarted.

In my case, after a handset registers, the field contains something like:

'spts211..52:04ln=2lbnso30731'

The warnings are:

[Nov  4 14:50:29] WARNING[5157]: chan_sip.c:12302
__set_address_from_contact: Invalid contact uri
spts211..52:04ln=2lbnso30731 (missing sip: or sips:), attempting to use
anyway
[Nov  4 14:50:29] WARNING[5157]: chan_sip.c:12321
__set_address_from_contact: Invalid host name in Contact: (can't resolve in
DNS) : 'spts211..52'

====================================================================== 

---------------------------------------------------------------------- 
 (0128620) bcnit (reporter) - 2010-11-04 12:33
 https://issues.asterisk.org/view.php?id=18251#c128620 
---------------------------------------------------------------------- 
Sip/debug log attached.

Looks like res_config_odbc is being passed the correct value:

[Nov  4 17:16:05] DEBUG[6838] res_config_odbc.c: Parameter 7
('fullcontact') = 'sip:test201 at 10.6.15.25:2054;line=r794bef0'

But only every other character is being stored in the database:

spts211..52:04ln=74e0

Is this a UTF8 problem? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-11-04 12:33 bcnit          Note Added: 0128620                          
======================================================================