On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjos...@digium.com> wrote:
> > > On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cur...@telecomabmex.com> > wrote: > >> 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. >> > > res_config_mysql has been in "extended" support for some time now and it's > possible it just will no longer work. We only test alembic changes with > postgres or odbc now. Your best bet is to convert to res_odbc. > Oh yeah, if you really do need res_config_mysql, go ahead and open an issue at issues.asterisk.org and we'll take a look. Since we don't test with it though, we might not notice if it gets broken again in the future unless someone reports it. > > >> >> -- >> 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 > > > > > -- > George Joseph > Digium, Inc. | Software Developer > 445 Jan Davis Drive NW - Huntsville, AL 35806 - US > Check us out at: www.digium.com & www.asterisk.org > > -- George Joseph Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org
-- _____________________________________________________________________ -- 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