Forums

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/

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.