<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <span dir="ltr"><<a href="mailto:cursor@telecomabmex.com" target="_blank">cursor@telecomabmex.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> 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:<br>
<br>
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)<br>
[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)<br>
[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'<br>
[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)<br>
[Sep 12 14:42:35] ERROR[24498]: res_pjsip_registrar.c:411 register_aor_core: Unable to bind contact '<a href="http://sip:2001@192.168.2.165:5060" target="_blank">sip:2001@192.168.2.165:5060</a>;t<wbr>ransport=udp' to AOR '2001'<br>
== Contact 2001/<a href="mailto:sip%3A2001@192.168.2.165" target="_blank">sip:2001@192.168.2.165</a>:50<wbr>60;transport=udp has been deleted<br>
<br>
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.<br></blockquote><div><br></div><div>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.</div><div> <br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
-- <br>
Telecomunicaciones Abiertas de México S.A. de C.V.<br>
Carlos Chávez<br>
+52 (55)9116-91161<br>
<br>
<br>
-- <br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016<br>
<a href="http://www.asterisk.org/community/astricon-user-conference" rel="noreferrer" target="_blank">http://www.asterisk.org/commu<wbr>nity/astricon-user-conference</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/wik<wbr>i/display/AST/Getting+Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/mailma<wbr>n/listinfo/asterisk-users</a></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span style="font-size:12.8px">George Joseph</span><br style="font-size:12.8px"><span style="font-size:12.8px">Digium, Inc. | Software Developer</span><span style="font-size:12.8px"><br>445 Jan Davis Drive NW - Huntsville, AL 35806 - US<br></span><span style="font-size:12.8px">Check us out at: </span><a href="http://www.digium.com/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">www.digium.com</a><span style="font-size:12.8px"> & </span><a href="http://www.asterisk.org/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">www.asterisk.org</a><br><div><br></div></div></div>
</div></div>