IpAccessControlCategories

Permalink
Okay, I know, I know, I should have backed up before altering a database record, but after a lapse of sound judgment, it's done.

My ip address was blocked, so I did a quick search and saw a solution where you delete a banned ip.

What I ended up deleting was the one record listed in the table "IpAccessControlCategories" Now I'm understanding that this record needs to be in place as part of the login process.

I tried searching for the SQL command that would have populated this record during the installation process, but I can't find it anywhere.

I would appreciate if anyone can help me populate the needed record.

The fields in the table are:
iaccID (primary key, auto)
iaccHandle
iaccName
iaccEnabled
iaccMaxEvents
iiaccTimeWindow
iaccBanuration
iaccSiteSpecific
iaccLogChannel
iaccPackage

1 Attachment

 
mesuva replied on at Permalink Reply
mesuva
INSERT INTO `IpAccessControlCategories` (`iaccID`, `iaccHandle`, `iaccName`, `iaccEnabled`, `iaccMaxEvents`, `iaccTimeWindow`, `iaccBanDuration`, `iaccSiteSpecific`, `iaccLogChannel`, `iaccPackage`)
VALUES
   (1, 'failed_login', 'Failed Login Attempts', 1, 5, 300, 600, 1, 'security', NULL);
hpwatersewer replied on at Permalink Reply
Thank you very much, I appreciate your help! Back to normal again.
simonchilton replied on at Permalink Reply
simonchilton
Awesome, thanks! Sorted login issues I had after upgrading to 8.5.5.

Argument 3 passed to Concrete\Core\Permission\IpAccessControlService::__construct() must be an instance of Concrete\Core\Entity\Permission\IpAccessControlCategory, null given
Duffy538 replied on at Permalink Reply
Fixed this by restoring the 8.5.2 "concrete" folder (which I had simply renamed before the upgrade) and disabling Maintenance Mode. Re-enabled the new 8.5.3 "concrete" folder and things seem to be ok.

'IpAccessControlCategories' now exists too.

So I guess it's best not to enable Maintenance Mode before a upgrade.

http://www.upsers.win/