<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>On 9/12/16 4:21 PM, George Joseph wrote:<br>
    </p>
    <blockquote
cite="mid:CAP=uFEuxF3kVYdq2Z7vPf7EidWaS7GhT7An8B4nKKuEa3NXSPQ@mail.gmail.com"
      type="cite">
      <div dir="ltr"><br>
        <div class="gmail_extra"><br>
          <div class="gmail_quote">On Mon, Sep 12, 2016 at 3:01 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:0px 0px 0px
              0.8ex;border-left:1px solid
              rgb(204,204,204);padding-left:1ex">
              <div bgcolor="#FFFFFF"><span class="gmail-">
                  <p>On 9/12/16 3:39 PM, George Joseph wrote:<br>
                  </p>
                  <blockquote 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:0px 0px 0px
                            0.8ex;border-left:1px solid
                            rgb(204,204,204);padding-left:1ex">
                            <div dir="ltr"><br>
                              <div class="gmail_extra"><br>
                                <div class="gmail_quote"><span>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:0px 0px 0px
                                      0.8ex;border-left:1px solid
                                      rgb(204,204,204);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"
                              target="_blank">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>
                </span>     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.</div>
            </blockquote>
            <div><br>
            </div>
            <div>Although CentOS7 is still on 2.3.1 for unixodbc, there
              were changes made in 13.10.0 that should prevent the
              crashes.  </div>
            <div><a moz-do-not-send="true"
href="http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html">http://lists.digium.com/pipermail/asterisk-dev/2016-June/075582.html</a><br>
            </div>
            <div><br>
            </div>
            <div><br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
        Ok, thank you for the help.  I'll be trying out ODBC later today
    and test it for a few days.  You should probably mark
    res_config_mysql as deprecated now since it will not work with
    anything higher than 13.10 as is.<br>
    <br>
    <blockquote
cite="mid:CAP=uFEuxF3kVYdq2Z7vPf7EidWaS7GhT7An8B4nKKuEa3NXSPQ@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div class="gmail_extra">
          <div class="gmail_quote">-- </div>
        </div>
      </div>
    </blockquote>
    <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>