How to reset 15 minutes time-out | Login page ISPC

Discussion in 'Installation/Configuration' started by Canefield, Jul 16, 2021 at 1:21 PM.

  1. Canefield

    Canefield New Member

    Dear all,

    Quick question. I've ISPC up-and-running with Fail2Ban configured to monitor/block invalid logins through the ISPC login page. This works like a charm, also the configured 'Ignore <IP-ADDRESS>' so I can't be lockout for any reason. However ISPC is also handling some kind of security on top of Fail2Ban.

    While testing the rules and action by Fail2Ban, after my fourth unsuccessful attempts, my <IP-ADDRESS> was successfully ignored by Fail2Ban, however ISPC came with its own security blockage "Too many failed login attempts. Please retry after 15 minutes". Is their any way I can reset this timer or ignore it for the 'ignored <IP-ADDRESS>es'?

    Many thanks,
    Canefield
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    The attempts are checked with this query: "SELECT * FROM `attempts_login` WHERE `ip`= ? AND `login_time` > (NOW() - INTERVAL 1 MINUTE) LIMIT 1". So simply remove the records from the attempts_login table.
     
  3. Canefield

    Canefield New Member

    I can't delete this entry. The message I receive (PHPMyAdmin) from the table 'attempts_login' is 'Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.' So how can I delete any entry?

    Thx.
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Do not delete a column. Delete a row.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Use SQL to delete whatever record you like to remove. Example:

    Code:
    DELETE FROM attempts_login WHERE ip = '192.168.0.1'
     

Share This Page