I've been blocked to log in even with admin user

General Support
1

Hello, I’ve been blocked to log in. I guess my ip address has been blacklisted, but not sure about it.

The point is I can’t log in from my pc, as I usually did.

I deleted records that includes my ip address on cerber_blocks and cerber_lab_ip tables from databse, but still can’t log in.

I have enabled 2FA, so I also tried to use the SQL query INSERT INTO cerber_acl (ip, tag, comments) VALUES (‘192.168.5.6’, ‘W’, ‘Bypassing 2FA’); that you recommend in the thread Can't access my site after enabling 2FA , hoping to get access back, but it didn’t work.

The error I get when accessing to login uri is: “You are not allowed to log in. Ask your administrator for assistance.” This error entails that neither username nor passwords fields are shown. Just the error message.

Is there some SQL query to recover access to login panel? If not, is there any other way to get access again?

Thanks in advance.

3

In the current version of WP Cerber, when adding an IPv4 address to the allowlist manually with a SQL query, you must use its corresponding long integer values, as shown below

INSERT INTO cerber_acl
    (ip, tag, comments, ip_long_begin, ip_long_end, ver6, acl_slice, v6range, req_uri)
VALUES (
    '192.168.5.6',
    'W',
    'My IP address',
    INET_ATON('192.168.5.6'),
    INET_ATON('192.168.5.6'),
    0,
    0,
    '',
    ''
);