Clearing the event log

Hi @pyspil

You can delete the events by selecting them and bulk delete action.

You can increase the amount of rows displayed with the constant AIOWPSEC_AUDIT_LOG_PER_PAGE

Example in wp-config.php: define(‘AIOWPSEC_AUDIT_LOG_PER_PAGE’, 100);

That would make 100 entries displayed per page for audit log and you can delete 100 at a time.

There is right now not possibility to disable event log as an option.

Regards

• This reply was modified 1 year, 10 months ago by hjogiupdraftplus.

I deleted the log table completely, because it takes too much size and does not carry useful information. However, now that I have done this, errors keep appearing in error.log. Also, unauthorized users are now not blocked due to failed login attempts.
Please add a feature in the next version that involves disabling logging completely, or logging to a file instead of the database.

Hi @pyspil

Ok, I will create internal ticket for disabling logging completely.

If you have deleted the table {db_prefix}aiowps_audit_log It will start create the issue. Please use below query to add table again replace wp_ instead your db_prefix.

CREATE TABLE IF NOT EXISTS wp_aiowps_audit_log (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  network_id bigint(20) NOT NULL DEFAULT '0',
  site_id bigint(20) NOT NULL DEFAULT '0',
  username varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  ip varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  level varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  event_type varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  details text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  stacktrace text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  created int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (id),
  KEY username (username),
  KEY ip (ip),
  KEY level (level),
  KEY event_type (event_type)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

Can I know if the full log shutdown feature has been added in the latest version or if it is now in development?

Hi @pyspil

No still in this latest version there is not disable audit log featured added.

Still development not started. I have asked update on this and will get back to you.

Regards

When the plugin was updated, the table was created again and the database began to grow at a breakneck speed, but when I went into the aiowps control panel, I found that I could now delete all items. Thanks for adding this needed feature.

This is helpful as I was looking specifically for how to recreate the table.

I do not use this plugin as my preferred favorite but do have clients that do and have recently seen the php logs fill with the error about not being able to write to the table. I compared his other sites and see the tables exist but not on this specific site.

I ran the plugin updates and was hoping the update would re-write the tables but it did not.

Since I have less experience with this plugin, I wonder if disabling and then re-enabling the plugin would rewrite the tables, or if one of the aio tools would.

The above script is helpful and appears to be perfect for my current needs. I just wish I knew what blew the table away.

Hi @universal4

Yes if you deactivate and activate it again it should create the AIOS table if it does not exist. On the activation hook, it should do that.

Regards

Thanks for the reply. I created the tables manually, but it is good to know the deactivate and reactivate should work as well. It may help others in the future.

hi, my audit log table was 1GB and I could not even open the Audit Logs tab. UI just crashes.
TRUNCATE table fixed it. I agree that none of the information in this table is relevant.
Please provide a an option to disable it.

Hi @audioscavenger

You can use the following aios_audit_log_record_event filter to disable all events from being recorded:

function aios_audit_log_record_event($record_event, $event_type, $details, $event_level, $username) {
	return false;
}

add_filter('aios_audit_log_record_event', 'aios_audit_log_record_event', 10, 5);

Please note that if you disable all events from being recorded some features of the plugin and future features will no longer work, For example the login lockdown feature will no longer work as no failed logins are being recorded.

Below is list of event you can compare as $record_event and do not return false; to log event.

password_reset
user_deleted
user_removed
failed_login
user_registration
successful_login

Hi,

i don’t manage to backup correctly my wordpress site with BackWPup. The issue is related to the database table “wp_aiowps_audit_log that ha reached 2.5 gb. Do i really need it? Can i clean it? How can i reduce the amount of data?

Thank you for your support.

+———————+————+
| Table | Size in MB |
+———————+————+
| wp_aiowps_audit_log | 2424.30 |
+———————+————+

Hi @luis92e,

You may clean it totally By access DB and Empty the Table,

Note : It might not login lockdown recent as failed login records saved in audit log.

Regards