On 9/12/16 3:21 PM, Annus Fictus wrote:
Hello,
is there any reason you don't use ODBC with MySQL?
Regards
El 12/09/2016 a las 15:14, Carlos Chavez escribió:
Has anyone successfully used Mysql realtime PJSIP with Asterisk
13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the
following error now:
Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'qualify_timeout' cannot be type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column
'expiration_time' cannot be type 'bigint(20)' (need char)
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1246
require_mysql: Possibly unsupported column type 'enum('yes','no')' on
column 'authenticate_qualify'
[Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162
require_mysql: Realtime table general@ps_contacts: column 'via_port'
cannot be type 'int(11)' (need char)
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411
register_aor_core: Unable to bind contact
'sip:2001@192.168.2.165:5060;transport=udp' to AOR '2001'
== Contact 2001/sip:2001@192.168.2.165:5060;transport=udp has been
deleted
Up until 13.10 everything was working despite the warnings about
field types. Now my phones will not register. I can make calls but
not receive. All database modifications are done through alembic so
they are supposed to be up to date. The only way I can find to solve
this issue right now is to restore a 13.10 backup for both the
database and Asterisk.
Unless you use non packaged odbc on CentOS 7, Asterisk keeps crashing.
--
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 --
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
