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

[Mauro Sergio Ferreira Brasil]

Thanks Atis, its working pretty fine now.

Best regards,
Mauro.



Atis Lezdins escreveu:
> On Wed, Aug 26, 2009 at 12:11 AM, Mauro Sergio Ferreira
> Brasil<mauro.brasil at tqi.com.br> wrote:
>   
>> 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 ?
>>     
>
> Asterisk Realtime Architecutre currently treats all fields as strings.
> I wish too that it would take into account actual field type retrieved
> from DESCRIBE statement and add the quotes only if it's string.
>
> You can safely do
>
> ALTER TABLE sip_buddies CHANGE COLUMN port port VARCHAR(5);
>
> Regards,
> Atis
>
>   

-- 
__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