VoIP Mailing List Archives

[cursor at telecomabmex...]

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: <Aor/ContactUri..............................> <Hash....>
<Status> <RTT(ms)..>
==========================================================================================

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


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users