fail2ban manager mysql create error

aaP_cembol

first of all, if fail2ban is installed by default on your server, uninstall the existing fail2ban before installing the fail2ban manager that comes in aapanel and then install the fail2ban manager.

as for the problem, when trying to create for mysql from within the fail2ban manager, it says that it cannot find a file and rightfully cancels it. is there a solution to this, or I can add it manually, but I could not find where the mysql log file is.

aaP_cembol

I found the file asked for, but it was created with the username I gave when I created the vps, not with domain.com. Can I change the name of the file he is looking for in the fail2ban manager configuration files?

aaPanel_Kern

Hello, you can specify the LOG file in the configuration of mysql
Change it to the correct path and file name under [mysqld], and then restart mysql
log_error = /path/to/error.err

aaP_cembol

On cron I added the file every five minutes by copying it with the desired name.