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@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@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@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:

==========================================================================================

Contact: 4001/sip:4001@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

—