• Resolved cybeardjm

    (@didierjm)


    Hi,

    On one of my blogs, I see the table “aiowps_message_store” growing “exponentially”…

    So far it is 19+ MB, with 5000+ entries. All have “Message key” = “rule_triggered”, with data on a blacklisted IP.

    Where are these entries supposed to appear in the AIOWPS control panel/dashboard?

    My “Audit Logs” section is empty, as I curate it regularly…
    The “Locked IP addresses section only has 378 items (so far).

    It seems I’ve seen these “rule_triggered” appear once or twice in the Audit Logs, but they don’t anymore. Should they, so that I can clean them if desired?

    On a second site, the same table is just 1,5 MB… with same type of content.

    Sincerely
    DJM

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @didierjm,

    Can you please access database and delete those records directly?

    It seems the firewall rule triggered that getting stored.

    I will discuss this internally and get back to you on this asap.

    Regards

    Thread Starter cybeardjm

    (@didierjm)

    Ok, but it’s not “triggered”, it’s “is triggering”, as the table is growing and growing…

    DJM

    Thread Starter cybeardjm

    (@didierjm)

    Also, why don’t they appear in the audit logs page?

    DJM

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @didierjm

    Your site might be under brute force attack so it might be keep increasing it rapidly that table rule_triggerd log.

    aiowps_message_store will be used for firewall debug log.

    I will create an internal ticket for this .

    As a temporary solution for below file

    wp-content\plugins\all-in-one-wp-security-and-firewall\classes\firewall\libs\wp-security-firewall-debug.php

    line 30 code change it to

    if (!$aiowps_constants->AIOS_FIREWALL_DEBUG && 'rule_triggered' !== $event) return;

    below mentioned it will stop recording message.

    return;

    Regards

    Thread Starter cybeardjm

    (@didierjm)

    Yes, I’ve been under attack in various forms by Indian spammers/scammers for the last months and blocking a lot of IP ranges.

    I don’t mind having these reported. The thing is: there should be a page (Audit Logs?) where they can be reviewed and deleted.

    Sincerely
    DJM

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @didierjm

    Okay, I will create an internal ticket for this and get back to you on this asap.

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @didierjm

    Yes, As per the internal discussion, we are supposed to save it in audit logs but it might keep increasing the audit log like the issue with the message store table. we are going to implement a better solution for it and will have it in an upcoming release.

    Thread Starter cybeardjm

    (@didierjm)

    Thx. Waiting for the update. For now, I manually delete the entries directly from the table via PHPMyAdmin…

    DJM

    Hi, this topic is marked as “resolved”, but I’m still facing this problem on a university website where I don’t have direct PHP MyAdmin access: now >120,000 entries in “aiowps_message_store”, growing quickly. So I still can’t delete such loads of entries in AIOS or set an expiration date? Is there any news about a backend solution or an upcoming update?

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @towmwinters

    Do you have AIOS ( latest ) 5.2.5 version installed

    wp-content\plugins\all-in-one-wp-security-and-firewall\classes\firewall\libs\wp-security-firewall-debug.php

    line 51 code commented it will stop stroing new data in aiowps_message_store table.

    // Message_Store::instance()->set($event, $details);

    you have to delete those aiowpsMySQL_message_store table records using phpMyAdmin or other mySQL client. other wise progamitallly have to delete.

    Regards

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Table “aiowps_message_store” growing…’ is closed to new replies.