[asterisk-users] Realtime warnings for database structure

[Carlos Chavez]

     I keep getting messages like these in the cli:

[Aug 10 12:20:17] WARNING[23411]: res_config_mysql.c:1162 require_mysql: 
Realtime table general at ps_contacts: column 'qualify_timeout' cannot be 
type 'int(10)' (need char)
[Aug 10 12:20:17] WARNING[23411]: res_config_mysql.c:1246 require_mysql: 
Possibly unsupported column type 'enum('yes','no')' on column 
'authenticate_qualify'
[Aug 10 12:20:17] WARNING[23411]: res_config_mysql.c:1162 require_mysql: 
Realtime table general at ps_contacts: column 'via_port' cannot be type 
'int(11)' (need char)

     Since I am using alembic with the "official" database table 
structures I simply do not understand why.  Who is wrong here, the 
alembic structure or realtime for expecting different things? Obviously 
I do not want to make changes to the database as that will break the 
updates to new versions so it probably needs to be fixed on the realtime 
side.  I just hope that, since they are warnings, they do not affect 
regular operations.

     I also get this error every time an endpoint registers to my Asterisk:

[Aug 10 12:24:32] ERROR[23411]: res_pjsip_registrar.c:411 
register_aor_core: Unable to bind contact 
'sip:4001 at XX.XX.XX.XX:48007;transport=UDP;rinstance=34b3595c6901f19e' to 
AOR '4001'

     I do not know if this is related to the same database problems, I 
have never seen that message when using text files for configuration.  
Contacts do get created:

   Contact:  <Aor/ContactUri..............................> <Hash....> 
<Status> <RTT(ms)..>
==========================================================================================

   Contact:  4001/sip:4001 at XX.XX.XX.XX:48007;transport=UD 653ab7af98 
Created       0.000

     ODBC for realtime is still very unstable so I hope we can get a 
little more stability from Mysql while development continues.  So far my 
Asterisk 13.10 installations work fine but the warnings and error clog 
the log files and cli.  I can ignore that but when my clients peer over 
my shoulder they freak out.  Should I open an issue on jira?

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