<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1252">
  </head>
  <body>
    <div class="moz-cite-prefix"><font face="monospace">Hi Shah,</font></div>
    <div class="moz-cite-prefix"><font face="monospace"><br>
      </font></div>
    <div class="moz-cite-prefix"><font face="monospace">On 27.07.2021
        10:01, Shah Hussain Khattak wrote:<br>
      </font></div>
    <blockquote type="cite"
cite="mid:SI2PR06MB4345C7DC54649A8B56638020CFE99@SI2PR06MB4345.apcprd06.prod.outlook.com">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <font face="monospace">
      </font>
      <style type="text/css" style="display:none;"><font face="monospace">P {margin-top:0;margin-bottom:0;}</font></style>
      <div class="moz-text-html" lang="x-western">
        <div style="font-size: 12pt; color: rgb(0, 0, 0);">
          <br>
        </div>
        <div style="font-size: 12pt; color: rgb(0, 0, 0);">
          1 - When I try to configure the users via the OpenSIPs control
          panel, I get following error when I click on Register:</div>
        <div style="font-size: 12pt; color: rgb(0, 0, 0);">
          <br>
        </div>
        <div style="font-size: 12pt; color: rgb(0, 0, 0);">
          <b> <span style="font-size: 12pt; color: rgb(0, 0, 0);
              background-color: rgba(0, 0, 0, 0);">Inserting user record
              into DB failed: Array ( [0] => 42S22 [1] => 1054 [2]
              => Unknown column 'ha1b' in 'field list' )</span></b></div>
      </div>
    </blockquote>
    <font face="monospace">OpenSIPS CP should have support for 3.2,
      including the "ha1b" column changes.  Make sure you
      download/install the 8.3.2 version of the Control Panel and try
      again -- let me know if you still have issues here.<br>
    </font>
    <blockquote type="cite"
cite="mid:SI2PR06MB4345C7DC54649A8B56638020CFE99@SI2PR06MB4345.apcprd06.prod.outlook.com">
      <div class="moz-text-html" lang="x-western"><font face="monospace"><br>
        </font>
        <div style="font-size: 12pt; color: rgb(0, 0, 0);"><font
            face="monospace">
          </font>but when alice is trying to register, I am seeing the
          following errors in the syslog file:</div>
        <div style="font-size: 12pt; color: rgb(0, 0, 0);">
          <br>
        </div>
        <div style="font-size: 12pt; color: rgb(0, 0, 0);">
          Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]:
          <a class="moz-txt-link-freetext" href="INFO:db_mysql:switch_state_to_disconnected">INFO:db_mysql:switch_state_to_disconnected</a>: disconnect event
          for 0x7f51bb655e10
          <div>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]:
            <a class="moz-txt-link-freetext" href="INFO:db_mysql:reset_all_statements">INFO:db_mysql:reset_all_statements</a>: resetting all statements
            on connection: (0x7f51bb6566b0) 0x7f51bb655e10</div>
          <div>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]:
            <a class="moz-txt-link-freetext" href="INFO:db_mysql:connect_with_retry">INFO:db_mysql:connect_with_retry</a>: re-connected successful
            for 0x7f51bb655e10</div>
          <div>Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]:
            <a class="moz-txt-link-freetext" href="INFO:db_mysql:db_mysql_do_prepared_query">INFO:db_mysql:db_mysql_do_prepared_query</a>: reconnected to
            mysql server -> re-init the statement</div>
          <div><b>Jul 27 05:35:17 ip-172-31-46-21
              /usr/sbin/opensips[7618]:
              ERROR:db_mysql:db_mysql_store_result: driver error:
              Commands out of sync; you can't run this command now</b></div>
          <div><b>Jul 27 05:35:17 ip-172-31-46-21
              /usr/sbin/opensips[7618]: ERROR:auth_db:get_ha1: failed to
              query database</b></div>
          <div><b>Jul 27 05:35:18 ip-172-31-46-21
              /usr/sbin/opensips[7615]:
              ERROR:db_mysql:db_mysql_store_result: driver error:
              Commands out of sync; you can't run this command now</b></div>
          <div><b>Jul 27 05:35:18 ip-172-31-46-21
              /usr/sbin/opensips[7615]: ERROR:auth_db:get_ha1: failed to
              query database</b></div>
        </div>
      </div>
    </blockquote>
    <p><font face="monospace">Indeed!  You have run into an OpenSIPS 3.2
        bug, which is now fixed.  The 3.2.1 release will be pushed
        tomorrow, so if you are using packages, I recommend you wait for
        it to become available.  If you're using git, just pull, rebuild
        and the bug should be gone!<br>
      </font></p>
    <p><font face="monospace">Best Regards,</font><br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Liviu Chircu
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/liviuchircu">www.twitter.com/liviuchircu</a> | <a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a>
OpenSIPS Summit 2021 Distributed | <a class="moz-txt-link-abbreviated" href="http://www.opensips.org/events">www.opensips.org/events</a></pre>
  </body>
</html>