Support » Plugin: Wordfence Security - Firewall & Malware Scan » Connection refused

  • Resolved saowp

    (@saowp)


    The only red part of Diagnostics is Coonectivity, there the http gives an error

    wp_remote_post() test to noc1.wordfence.com failed! Response was: cURL error 7: Failed to connect to noc1.wordfence.com port 80: Connection refused

    https is OK.

Viewing 12 replies - 1 through 12 (of 12 total)
  • I also get a large number of such errors in error_log

    FROM wp_wfblocks7 WHERE type IN (3) AND (expiration = 0 OR expiration > UNIX_TIMESTAMP()) ORDER BY typeSort ASC, id DESC made by require(‘wp-blog-header.php’), 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, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::countryBlocks, wfBlock::allBlocks
    [10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wfblocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfblocks7 made by require(‘wp-blog-header.php’), 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, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::findIPBlock
    [10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wfblocks7’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_wfblocks7 made by require(‘wp-blog-header.php’), 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, wordfence::veryFirstAction, wfLog->firewallBadIPs, wfBlock::findIPBlock
    [10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wfLog->actionSetRequestJSEnabled, wfLog::isHumanRequest
    [10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wfLog->actionSetRequestJSEnabled, wfLog::isHumanRequest
    [10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logLeechAndBlock, wfRateLimit::mightRateLimit, wfRateLimit::visitorType, wfCrawl::isCrawler, wfLog::isHumanRequest
    [10-Sep-2019 10:47:15 UTC] WordPress database error Table ‘XXXXX.wp_wflivetraffichuman’ doesn’t exist for query SHOW FULLCOLUMNS FROM wp_wflivetraffichuman made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logLeechAndBlock, wfRateLimit::mightRateLimit, wfRateLimit::visitorType, wfCrawl::isCrawler, wfLog::isHumanRequest

    I have emailed the diagnostics to wftest@wordfence.com

    Plugin Support WFGerroald

    (@wfgerald)

    Hey @saowp,

    I believe this is something your host is going to need to look into. Can you please share the full error for their thoughts? The cURL request could be blocked by a proxy, firewall, or security protocol

    wp_remote_post() test to noc1.wordfence.com failed! Response was: cURL error 7: Failed to connect to noc1.wordfence.com port 80: Connection refused

    Thanks,

    Gerroald

    Thank you for your quick response. I opened a ticket at my host, referencing this thread.

    In your opinion, are the two observations (cURL error and error_log entries) related to each other?

    The host fixed the cURL error, however the error_log is still being populated by WordFence. I have resent the diagnostics email

    Plugin Support WFGerroald

    (@wfgerald)

    Hey @saowp,

    Thanks for the update, and happy to hear it.

    I spoke with some colleagues and they confirmed that this is two separate issues. It seems you have quite a few crashed tables, and also some older versions of our tables. Can you please try deactivating and reactivating Wordfence to regenerate the tables?

    If you’d like to save your settings you can export them, be sure to save your token. It’s found in Wordfence > Tools > Import/Export Options.

    Also, be sure to check the Delete Wordfence tables and data on deactivation feature. It’s found in Wordfence > All Options > General Wordfence Options.

    Please let me know how it goes.

    Thanks,

    Gerroald

    • This reply was modified 1 month, 1 week ago by  WFGerroald.

    Thanks for the suggestion, @wfgerald I followed your instructions, and not just deactivated but deleted the WordFence plugin and its data. After that, I deleted error_log. After a clean install of WordFence, I notice the error_log entries again. I have again emailed the diagnostics result, please take a look.

    Plugin Support WFGerroald

    (@wfgerald)

    Hey @saowp,

    I’m not able to find the Diagnostic report. Can you please resend it to wftest@wordfence.com? Please include your WordPress.org username and update this thread after you’ve sent it.

    Thanks,

    Gerroald

    saowp

    (@saowp)

    Just did

    Plugin Support WFGerroald

    (@wfgerald)

    Hey @saowp,

    Thanks for the Diagnostics report.

    It seems Wordfence is still missing some of its tables. And the old tables are still present.

    Tables missing (prefix wp_, lowercase): wfBlocks7, wfCrawlers, wfTrafficRates, wfLocs, wfReverseCache, wfFileMods, wfBlockedIPLog, wfLiveTrafficHuman

    Can you try resetting Wordfence once more using the Wordfrence Assistant, then check to make sure all Wordfence tables are removed? If it doesn’t remove them can you manually delete all Wordfence tables before reinstalling?

    https://www.wordfence.com/help/advanced/remove-or-reset/

    Please let me know how it goes.

    Thanks,

    Gerroald

    • This reply was modified 1 month ago by  WFGerroald.
    saowp

    (@saowp)

    Hi @wfgerald , I did as you suggested – deleted the Wordfence plugin followed by deleting all the related tables from the database manually using WP_Optimize. Then I reinstalled Wordfence. However I still get the below error in Table Check

    Tables missing (prefix wp_, lowercase): wfBlocks7, wfCrawlers, wfTrafficRates, wfLocs, wfReverseCache, wfFileMods, wfBlockedIPLog, wfLiveTrafficHuman

    I have emailed the report yet again.

    Plugin Support WFGerroald

    (@wfgerald)

    Hey @saowp,

    My apologies for missing this. I’ve been spending today looking through older cases.

    Are you still experiencing this? Do you have any site/server/database caching? If so, can you please clear it? You might need to reset Wordfence once more after doing so.

    Thanks,

    Gerroald

    Thanks @wfgerald for following up. After seeing your message, I checked and the tables were still missing. After that I did the following actions:

    1. Deactivated the WordFence plugin
    2. Deactivated the Autoptimize plugin
    3. Migrated the site to a different host
    4. Reactivated WordFence and Autoptimize

    I now get the message “All Tables Exist” in Diagnostics. I am unsure which of the above steps did the trick, but I am updating this thread status to “Resolved”. Thank you again for your support!

Viewing 12 replies - 1 through 12 (of 12 total)
  • You must be logged in to reply to this topic.