<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>On 9/12/16 3:39 PM, George Joseph wrote:<br>
    </p>
    <blockquote
cite="mid:CAP=uFEtOP7E3kenJq5i4FJHYY8RmXmmW=qo5n2am9vq+U-biHw@mail.gmail.com"
      type="cite">
      <div dir="ltr"><br>
        <div class="gmail_extra"><br>
          <div class="gmail_quote">On Mon, Sep 12, 2016 at 2:31 PM,
            George Joseph <span dir="ltr"><<a moz-do-not-send="true"
                href="mailto:gjoseph@digium.com" target="_blank">gjoseph@digium.com</a>></span>
            wrote:<br>
            <blockquote class="gmail_quote" style="margin:0 0 0
              .8ex;border-left:1px #ccc solid;padding-left:1ex">
              <div dir="ltr"><br>
                <div class="gmail_extra"><br>
                  <div class="gmail_quote"><span class="">On Mon, Sep
                      12, 2016 at 2:14 PM, Carlos Chavez <span
                        dir="ltr"><<a moz-do-not-send="true"
                          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
                          moz-do-not-send="true"
                          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 moz-do-not-send="true"
                          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>
                    </span>
                    <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>
                </div>
              </div>
            </blockquote>
            <div><br>
            </div>
            <div>Oh yeah, if you really do need res_config_mysql, go
              ahead and open an issue at <a moz-do-not-send="true"
                href="http://issues.asterisk.org">issues.asterisk.org</a>
              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.</div>
            <div><br>
            </div>
            <div> </div>
            <br>
          </div>
        </div>
      </div>
    </blockquote>
        I have solved the problem for the moment by changing the
    ps_contacts table with the "recommendations" res_config_mysql is
    giving.  I just modified all the fields to varchar and now my phones
    are registering.  Obviously this is not a solution as the database
    needs to be modified by alembic on future versions and it will keep
    breaking.<br>
    <br>
        I tried to migrate to res_config_odbc about 6 months ago but my
    Asterisk kept crashing.  I was told that the crashes were due to the
    version of ODBC distributed by CentOS 7 and that I would have to
    compile my own to be able to solve the issue.  Has this been
    solved?  Is the RPM ODBC package included with CentOS 7 still
    bugged?  I try to avoid using packages not included in the
    distribution as they make upgrades a pain later on.<br>
    <pre class="moz-signature" cols="72">-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161</pre>
  </body>
</html>