nintendeal

FYI my site is no longer blocked from the IP address. I didn’t do anything to change it. Not sure what happened. Thanks!

@gioni

Hmmm… I can’t think of ANYTHING else that would stop my access, but I understand there is only so much that a WP Plugin can do.

Just to confirm: Cerber does not lockout access from IP addresses to anything but /wp-admin/ (or the custom URL)?

@gioni

1. Thank you!

2. I’m able to access the website from my phone, from my home PC, from ANY PC that isn’t using this public IP address. The IP addresses for this particular building are NAT’d so they all go out one single public IP address. When I attempt to navigate to the website I get the error “ERR_CONNECTION_TIMED_OUT”

3. Are you saying that it only restricts access to the /wp-admin portion of the site?

Again, really appreciate you jumping back in this discussion after how you were treated. Thanks.

Going to post it in code tags as well. Just to reiterate: I am able to access the site from every other place I have checked. I’m able to remote into the the server with SSH, access FTP, and ping the server as well. I’m simply unable to navigate to the website from ANY pc that uses the public IP address of this particular building. I’m a Network Administrator so I’m familiar with how these things work, but I don’t know everything. I’m willing to try anything asked of me to get this working again.

Array
(
    [0] => Array
        (
            [0] => Duplicate column name 'ip_long'
            [1] => ALTER TABLE cerber_log ADD ip_long BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 long' AFTER ip, ADD INDEX (ip_long)
        )

    [1] => Array
        (
            [0] => Duplicate column name 'ip_long_begin'
            [1] => ALTER TABLE cerber_acl ADD ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 range begin' AFTER ip, ADD ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'IPv4 range end' AFTER ip_long_begin
        )

    [2] => Array
        (
            [0] => Duplicate key name 'ip_begin_end'
            [1] => ALTER TABLE cerber_acl ADD UNIQUE ip_begin_end (ip, ip_long_begin, ip_long_end)
        )

    [3] => Array
        (
            [0] => Duplicate key name 'begin_end'
            [1] => ALTER TABLE cerber_acl ADD INDEX begin_end (ip_long_begin, ip_long_end)
        )

    [4] => Array
        (
            [0] => Can't DROP 'ip'; check that column/key exists
            [1] => ALTER TABLE cerber_acl DROP INDEX ip
        )

)

Table: cerber_blocks, rows: 0

Field	Type	Collation
ip	varchar(39)	ascii_general_ci
block_until	bigint(20) unsigned	
reason	varchar(250)	utf8_general_ci

Table: cerber_log, rows: 0

Field	Type	Collation
ip	varchar(39)	ascii_general_ci
ip_long	bigint(20) unsigned	
user_login	varchar(60)	utf8_general_ci
user_id	bigint(20) unsigned	
stamp	decimal(14,4)	
activity	int(10) unsigned

Table: cerber_acl, rows: 1

Field	Type	Collation
ip	varchar(39)	ascii_general_ci
ip_long_begin	bigint(20) unsigned	
ip_long_end	bigint(20) unsigned	
tag	char(1)	utf8_general_ci
comments	varchar(250)	utf8_general_ci

• This reply was modified 7 years, 9 months ago by nintendeal.

@avpman thanks again for the reply. I deleted 9 fields from the wp_options table, and the 4 Cerber tables from my WP database and it didn’t resolve my issue.

@gioni appreciate you jumping back in here.

Array
(
[0] => Array
(
[0] => Duplicate column name ‘ip_long’
[1] => ALTER TABLE cerber_log ADD ip_long BIGINT UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘IPv4 long’ AFTER ip, ADD INDEX (ip_long)
)

[1] => Array
(
[0] => Duplicate column name ‘ip_long_begin’
[1] => ALTER TABLE cerber_acl ADD ip_long_begin BIGINT UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘IPv4 range begin’ AFTER ip, ADD ip_long_end BIGINT UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘IPv4 range end’ AFTER ip_long_begin
)

[2] => Array
(
[0] => Duplicate key name ‘ip_begin_end’
[1] => ALTER TABLE cerber_acl ADD UNIQUE ip_begin_end (ip, ip_long_begin, ip_long_end)
)

[3] => Array
(
[0] => Duplicate key name ‘begin_end’
[1] => ALTER TABLE cerber_acl ADD INDEX begin_end (ip_long_begin, ip_long_end)
)

[4] => Array
(
[0] => Can’t DROP ‘ip’; check that column/key exists
[1] => ALTER TABLE cerber_acl DROP INDEX ip
)

)

Table: cerber_log, rows: 0

Field Type Collation
ip varchar(39) ascii_general_ci
ip_long bigint(20) unsigned
user_login varchar(60) utf8_general_ci
user_id bigint(20) unsigned
stamp decimal(14,4)
activity int(10) unsigned

Table: cerber_acl, rows: 1

Field Type Collation
ip varchar(39) ascii_general_ci
ip_long_begin bigint(20) unsigned
ip_long_end bigint(20) unsigned
tag char(1) utf8_general_ci
comments varchar(250) utf8_general_ci

Table: cerber_blocks, rows: 0

Field Type Collation
ip varchar(39) ascii_general_ci
block_until bigint(20) unsigned
reason varchar(250) utf8_general_ci

• This reply was modified 7 years, 9 months ago by nintendeal.

Thanks for trying to help, @avpman!

I don’t have access to PHPMYadmin set up, and I’m afraid doing so is a little above my head. Is there any way to delete the Cerber database entries without that?

Looking at the cerber-tools page I see that it says “some database errors were detected”

Table: cerber_log, row: 39
Table: cerber_acl, rows: 3
Table: cerber_blocks, rows: 0

Is it possible that these database errors are my issue?

edit: I followed your instructions, deleted the tables, reinstalled, and it still doesn’t work. I do find it interesting that even after I deleted all the files, and the tables, that after reinstalling it remembers my settings. Is it possible that I didn’t delete all the files?

• This reply was modified 7 years, 9 months ago by nintendeal.

Hey Gioni,

Appreciate you trying to support this issue. I’m actually experiencing the same exact thing. My problem is that my outside IP address will never changed (this entire building is NAT’d to one outside address). There were two attempts with a nonexistent username from this building and now I am unable to access the site from here. I can, however, access it from everywhere else I have tried.

I removed the lockout and even set the IP address in the whitelist, but I’m still unable to get to the site. Works on my phone, works from other buildings (with other outside IP addresses).

I attempted to disable the plugin, but I’m still not able to get to the site from this one IP address.

Thoughts?