<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>