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