[OpenSIPS-Users] /usr/sbin/opensips[7617]: ERROR:auth_db:get_ha1: failed to query database - Errors

[Liviu Chircu]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20210816/40f70383/attachment-0001.html>