All logins fail after upgrade from 3.1.5.8 to 3.1.5.11

[ccolussi]

All logins fail after upgrade. Admin and LDAP logins with same error message "login credentials does not correspond", nothing in log files.

@nilsteampassnet Please help!

[ccolussi]

Table teampass_log_system shows:

4701 failed_auth 1765283870 user_not_exists 192.168.1.75 admin 4700 failed_auth 1765283868 user_not_exists 192.168.1.75 admin 4699 failed_auth 1765283865 user_not_exists 192.168.1.75 admin

but user exists in teampass_users

[ccolussi]

At this time, the option was restore a backup (files and database)

[chcioni]

Same issue for me

[guerricv]

Hello, Can you please share your ldap settings ?

[chcioni]

In my scenario use local users. If try to re-run the upgrade the admin authentication work fine, that not work in GUI access.

+-------+-----------------+------------+-----------------+-------------+-----------------+
| id    | type            | date       | label           | qui         | field_1         |
+-------+-----------------+------------+-----------------+-------------+-----------------+
| 45139 | failed_auth     | 1765471788 | user_not_exists | xx.xxx.x.xx | christian.cioni |
| 45138 | failed_auth     | 1765471642 | user_not_exists | xx.xxx.x.xx | admin           |
| 45137 | failed_auth     | 1765461533 | user_not_exists | xx.xxx.x.xx | admin           |
| 45136 | failed_auth     | 1765461248 | user_not_exists | xx.xxx.x.xx | admin           |

[chcioni]

In my case, the issue was related to my MySQL's SQL_MODE configuration, which blocked the authentication query with the error "this is incompatible with sql_mode=only_full_group_by." After changing the configuration, I can now log in.