Wordfense in database with no drop/truncate permission

  • Resolved tarek

    (@mrcmanager)


    7 years, 9 months ago

    Hello,
    i have separate database server from my web server and the remote database server got only GET, INSERT, UPDATE, DELETE permission.

    today i just noticed and error massage in my nginx log

    2017/06/19 06:27:47 [error] 6222#6222: *970 FastCGI sent in stderr: "PHP message: WordPress database error DROP command denied to user 'myuser'@'135.168.102.122' for table 'wp_wfNet404s' for query truncate table wp_wfNet404s made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, wordfence::hourlyCron, wfDB->truncate, wfDB->queryWrite
PHP message: WordPress database error DROP command denied to user 'myuser'@'135.168.102.122' for table 'wp_wfVulnScanners' for query truncate table wp_wfVulnScanners made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, wordfence::hourlyCron, wfDB->truncate, wfDB->queryWrite" while reading response header from upstream, client: 91ff:fed5::f03c:91ff:7e01:44a2, server: mysite.com, request: "POST /wp-cron.php?doing_wp_cron=1497846467.3556289672851562500000 HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host: "mysite.com", referrer: "https://mysite.com/wp-cron.php?doing_wp_cron=1497846467.3556289672851562500000"

    so what should i do in this case?

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

  • Hi Tarek,
    Actually, truncate requires “DROP” privileges as well, I think you will have to guarantee all privileges or at least add “DROP” permission to the database user in this case.

    Thanks.

    Hello!

    I hope we were successful in helping you resolve your issue with Wordfence! Since we have not heard back from you in the past 2 weeks I will now be marking this support thread as resolved. However, if we still haven’t resolved your issue please reach out to us as we would be more than happy to further assist you!

    Thanks and have a great day!
    Chloe

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Wordfense in database with no drop/truncate permission’ is closed to new replies.