Carlos Chavez
2016-Aug-10 17:49 UTC
[asterisk-users] Realtime warnings for database structure
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