Hi Shah,

On 27.07.2021 10:01, Shah Hussain Khattak wrote:

1 - When I try to configure the users via the OpenSIPs control panel, I get following error when I click on Register:

*Inserting user record into DB failed: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'ha1b' in 'field list' )*
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.

but when alice is trying to register, I am seeing the following errors in the syslog file:

Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:switch_state_to_disconnected: disconnect event for 0x7f51bb655e10 Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:reset_all_statements: resetting all statements on connection: (0x7f51bb6566b0) 0x7f51bb655e10 Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:connect_with_retry: re-connected successful for 0x7f51bb655e10 Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: INFO:db_mysql:db_mysql_do_prepared_query: reconnected to mysql server -> re-init the statement *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* *Jul 27 05:35:17 ip-172-31-46-21 /usr/sbin/opensips[7618]: ERROR:auth_db:get_ha1: failed to query database* *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* *Jul 27 05:35:18 ip-172-31-46-21 /usr/sbin/opensips[7615]: ERROR:auth_db:get_ha1: failed to query database*

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!

Best Regards,

--
Liviu Chircu
www.twitter.com/liviuchircu | www.opensips-solutions.com
OpenSIPS Summit 2021 Distributed | www.opensips.org/events

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to