[asterisk-users] Asterisk 13.11 realtime problem registering phones

[Carlos Chavez]

     I upgraded my office installation from 13.10 to 13.11 yesterday and 
now I am having problems registering phones.  Here is what I get on the CLI:

[Sep  2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql: 
Realtime table general at ps_contacts: column 'qualify_timeout' cannot be 
type 'int(10)' (need char)
[Sep  2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql: 
Realtime table general at ps_contacts: column 'expiration_time' cannot be 
type 'bigint(20)' (need char)
[Sep  2 15:38:46] WARNING[2098]: res_config_mysql.c:1246 require_mysql: 
Possibly unsupported column type 'enum('yes','no')' on column 
'authenticate_qualify'
[Sep  2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql: 
Realtime table general at ps_contacts: column 'via_port' cannot be type 
'int(11)' (need char)
[Sep  2 15:38:46] ERROR[2098]: res_pjsip_registrar.c:411 
register_aor_core: Unable to bind contact 
'sip:2001 at 192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525' 
to AOR '2001'
   == Contact 
2001/sip:2001 at 192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525 
has been deleted

     The mysql warnings have always been there since version 13.0 and 
the "Unable to bind contact..." error has also been present since I 
started using PJSIP realtime with Asterisk 13 (13.5 at least).  But 
starting this version the contact gets deleted immediately after 
registration so I cannot receive calls on the phone.  I can make calls 
from the phone.  On the phone web gui it tells me there is a "contact 
mismatch".  There are some phones working but I am not able to determine 
why, no configurations were changed since the upgrade (either on the 
database or on the phones themselves).  I have two phones of the same 
make/model/firmware, one is working and the other one is not and they 
basically have the same configuration, only the username and password 
change.

     I guess realtime finally broke.

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161