Various Issues, Including Unable to Register with WF Scanning Servers

  • Resolved atomicnicholas

    (@atomicnicholas)


    7 years, 1 month ago

    Hi,

    Because I keep getting the below message on my dashboard (and I believe you must get a lot of these), I first contacted my host to ask them to allow and not block any such points, as noted by WF message:

    Wordfence could not register with the Wordfence scanning servers when it activated. You can try to fix this by deactivating Wordfence and then activating it again, so Wordfence will retry registering for you. If you keep seeing this error, it usually means your WordPress server can’t connect to our scanning servers, or your wfConfig database table cannot be created to save the key. You can try asking your host to allow your server to connect to noc1.wordfence.com or check the wfConfig database table and database privileges.

    However, they responded back that:

    There is no such restrictions from our end that is blocking any connection for wordfence.
    Appreciate, if you please contact Wordfence support team they may better assist you in this regard.

    They also determined that there are no .htaccess rules blocking or causing the above.

    Furthermore, I’ve gotten the below message in the error logs repeatedly for what I estimate to be thousands of times:

    [Tue Jan 30 08:32:45 2018] [error] [client 69.245.230.280] WordPress database error Table ‘exampleapplication.wp_wfBlocks7’ doesn’t exist for query SELECT * FROM wp_wfBlocks7 WHERE type IN (7) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY blockedTime DE
    SC made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wordfence::veryFirstAction, wfWAFIPBlocksController::synchronizeConfigSet
    tings, wfBlock::lockouts, wfBlock::allBlocks, referer: https://examplemultisite.com/wp-admin/network/plugins.php
    [Tue Jan 30 08:32:45 2018] [error] [client 49.145.130.180] WordPress database error Table ‘exampleapplication.wp_wfHits’ doesn’t exist for query SELECT MAX(attackLogTime) FROM wp_wfHits made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.
    php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wordfence::veryFirstAction, referer: https://examplemultisite.com/wp-admin/network/plugins.php
    [Tue Jan 30 08:32:57 2018] [error] [client 49.145.130.180] WordPress database error Table ‘exampleapplication.wp_wfBlocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfBlocks7 made by require_once(‘wp-admin/network/admin.php’), require_once(‘wp-admin/admin.php’), requir
    e_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/wordfence/wordfence.php’), wordfence::install_actions, wfBlock::lockoutForIP, referer: https://examplemultisite.com/wp-admin/network/plugins.php

    This is on a MultiSite and is network enabled.

    Any help would be appreciated. Thank you.

    Nicholas

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

  • This looks like some of the database tables weren’t created when Wordfence did the upgrade or was installed. Can you try going to Dashboard > Global Options > Wordfence General Options and Checking “Delete Wordfence tables and data on deactivation”. Save the changes (top right corner of screen). Deactivate the plugin and then reactivate it. This will wipe all the setting so if you want to save what you have use the import/export options below that section to export a key that contains the current settings so you can import them later. This should recreate the database tables which should fix your issue. Let me know.

    Tim

    Thread Starter atomicnicholas

    (@atomicnicholas)

    Hi Tim,

    Thank you for responding.

    Yes, I have done that even before posting this (I forgot to mention it above), and already set it to “Delete Wordfence tables and data on deactivation” (saw that during a previous search online) before deactivating it. In fact, I had gone as far as deleting the plugin as well, then restarting the server, before adding the plugin back via wp.org and activating it.

    However, today I see the errors coming out several hours ago but not at the moment, so will continue to monitor and let you know if it returns.

    Thank you for now!

    Check database permissions as well. If all of them aren’t green on the Tools > Diagnostics page in the MySQL section, it could be that the tables weren’t able to be created.

    tim

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Various Issues, Including Unable to Register with WF Scanning Servers’ is closed to new replies.