asterisk users - Aug 2009 - Realtime with "rtcachefriends=no" problems...

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

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