IDS logs not showing up on the dashboard

[César]

Hello,

I get alerts from the IDS normally, but intrusion attempts are not showing up on the dashboard. I just realized this seems to be a database error, but I can’t figure out what’s causing this issue.

2015/09/28 05:33:11 [error] 10068#0: *116098 FastCGI sent in stderr: “PHP message: WordPress database error Table ‘xxxxxxxxx.xxxxxxx_hmwp_ms_intrusions’ doesn’t exist for query SELECT SQL_CALC_FOUND_ROWS * FROM xxxxxx_hmwp_ms_intrusions ORDER BY created DESC LIMIT 0, 30 made by require_once(‘wp-admin/admin.php’), do_action(‘dashboard_page_hmwp_ms_intrusions’), call_user_func_array, HMWP_MS_Admin->intrusions” while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: http://www.xxxxxxxx.com, request: “GET /wp-admin/index.php?page=hmwp_ms_intrusions HTTP/1.1”, upstream: “fastcgi://127.0.0.1:9000”, host: “www.xxxxxxx.com”, referrer: “http://www.xxxxxxx.com/wp-admin/”

Thanks in advance.

Attachments:

You must be logged in to view attached files.

[Suman M.]

Hi, it seems like the table “xxxxxxx_hmwp_ms_intrusions” is not available in your database.
Please follow these steps:
– goto HMWP > Start tab and do “Export current settings” and save it somewhere.
– update to latest version 4.54 of HMWP
– activate HMWP plugin
– goto HMWP > Start tab and import settings (from previously saved settings)

But your previous logs won’t be available.

[César]

Hello Suman,

That’s the point, I already tried reinstalling the plugin as you suggested, but the missing table didn’t come back to the database. Last time I decided to not import settings to avoid bringing back some issue from the previous installation, but nothing changed.

[Suman M.]

That’s strange. Then you might need to completely delete all traces of HMWP and install it fresh. Follow these steps:
– delete table “xx_hmwp_ms_intrusions” (if any)
– in “xx_options” table, you will find the rows with following “option_name”. Delete all such rows.
– hide_my_wp
– hide_my_wp_undo
– hmwp_ids_installed
– hmw_all_plugins
– external_updates-hide_my_wp
– now install fresh copy of HMWP

Hope this helps.

[César]

I’ve tried that before as well, and there’s no refference to any row containing “hmwp” or “hide_my_wp“, except in active_plugins. Yup, that’s really strange. I was thinking about importing a some months old backup of my database, but this could mess the whole thing up, since a lot of things have changed since then.

Is there any other way we could circumvent this issue?

Thank you once again.

[César]

Update: I can see the mentioned entries through: /wp-admin/options.php, but not directly from the database through Adminer.

[César]

Update 2: Bro, I got the removal done by using a plugin, and right after the clean install, the IDS is now working flawlessly. Thank you very much for all your time and effort!

All the best!

[Author]

Posts