[asterisk-users] Realtime with "rtcachefriends=no" problems...

[Mauro Sergio Ferreira Brasil]

Hello there!

Problem found.

For some reason, the update statement below is generated with an invalid 
atribution of empty value '' to field "port" that is an integer.
Because of that, this record keeps with prior "fullcontact" information 
that was updated by another client (which uses a different port) what 
leads to wrong client rtp packets routing... wow... that was weird... :-)

[Aug 25 17:57:43] DEBUG[20801] res_config_mysql.c: MySQL RealTime: 
Query: UPDATE sip_buddies SET fullcontact = '', ipaddr = '', port = '', 
regseconds = '0', username = '', regserver = '' WHERE name = '101'
[Aug 25 17:57:43] DEBUG[20801] res_config_mysql.c: MySQL RealTime: Query 
Failed because: Incorrect integer value: '' for column 'port' at row 1

First of all... my appologies by the false alarm.
But now I need your help to identify why is this update statement being 
generated wrongly.

Does someone have any idea ?

Thanks and best regards,
Mauro.



Mauro Sergio Ferreira Brasil escreveu:
> Hello there!
>
> I was testing Asterisk for the last two weeks using the Realtime 
> driver for MySQL, and leaving "rtcachefriends=yes" configured to 
> enable MWI.
> Today I started making additional tests with "rtcachefriends=no" 
> because we will probably need to use Asterisk without this cache.
>
> For some strange reason, calls stop to get routed between the SIP 
> clients.
> I've registered successfuly with two sip clients as usual, but the 
> call indication that I have on originator client (call in progress) 
> don't match with the target client that indicates nothing at all.
>
> Using Wireshark I could see lots of ICMP errors being returned from 
> the target machine with "Destination Unreachable"/"Port Unreachable" 
> indications.
> And this happens on both ways, client 1 calling client 2 and vice-versa.
>
> I switched back to "rtcachefriends=yes" and all worked fine again. 
> (note: always I change "rtcachefriends" to "no", I change "qualify" 
> parameter of all SIP users to "no" as well - to avoid warnings on CLI).
> Does anyone had this problem ?
>
> What Am I missing here ?
>
> Thanks and best regards,
>

-- 
__At.,                                                                                                                             
   _
 
*Technology and Quality on Information*
Mauro Sérgio Ferreira Brasil
Coordenador de Projetos e Analista de Sistemas
+ mauro.brasil at tqi.com.br <mailto:@tqi.com.br>
: www.tqi.com.br <http://www.tqi.com.br>
( + 55 (34)3291-1700
( + 55 (34)9971-2572