I was using nextcloud until this morning. But it suddenly became useless.
Messege: An exception occurred while executing ‘SELECT uid, password FROM oc_users WHERE LOWER(uid) = LOWER(?)’ with params [“ADMIN USER NAME”]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
I tried changing the value of wait_timeout from 15 to 30. Then we managed to connect. However, the sign-in time was very slow. When using Nextcloud, what is the reference value of wait_timeout?
I escaped from the fatal problem that I can not sign in. What is the fundamental solution to this? Is it a server failure?
Excuse me. It was my mistake completely. On Friday night I updated to Nextcloud 13.0.1. And I made certain tests and confirmed there was no problem.
At that time, time has already passed so I changed “auth.bruteforce.protection.enabled” to valid. After changing to it, I confirmed that there was no problem. I thought that the problem was solved. The problem is that signing in will take time if I enable it. I have forgotten this in the last two days. It was just a luck luck till this morning. Once I turned this back disable, I could sign in as smoothly as before.
However, it is worrisome that before signing in was slow but the sign-in itself was possible. MySQL error did not occur like this time. After all bruteforce seems to be unusable when considering smoothness.
I will continue to use it again invalid. Thank you.
You need to flush the table (see link above with the database instruction)
and it will work smoothly as before
The app bruteforce will slow down the login for the user with the ip who
activated a bruteforce attempt.
Just flush the table