Hi,
Am 02.09.2016 um 22:48 schrieb 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@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@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@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@192.168.2.203:57776;transport=UDP;rinstance=48d5c7d09b9f2525' to
> AOR '2001'
> == Contact
> 2001/sip:2001@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).
I hope you find this concerning...
Have you upgraded your MySQL realtime tables to the new schema as introduced
with Asterisk 13?
->
https://wiki.asterisk.org/wiki/display/AST/Upgrading+to+Asterisk+13#UpgradingtoAsterisk13-RealTime
It's likely a database error (i.e. a required, but missing table field) causes
this issue.
But even if not, you are getting rid of the warning messages ;-)
Greetings
Max
signature.asc
Description: OpenPGP digital signature
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016 http://www.asterisk.org/community/astricon-user-conference New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
