Firewall blocking Migrate DB Pro

  • Resolved ashbydesign

    (@ashbydesign)


    8 years, 6 months ago

    I think I’ve helped create this issue.
    I should have disabled Ninja Firewall before using Migrate DB Pro to change the database – and the connection from local dev site to live is now no longer working.

    Is there anything I can do to remedy this? I have whitelisted my IP (also the admin IP) manually in an uploaded .htninja file.

    MESSAGE FROM MIGRATE DB PRO –
    The connection failed, an unexpected error occurred, please contact support. (#121 – scope: ajax_initiate_migration

    *************

    I have the following message in the Ninja Overview:

    **
    It seems the user session was not set by the firewall script or may have been destroyed by another plugin. You may get blocked by the firewall while working from the WordPress administration dashboard.
    **

    FIREWALL LOG
    I suspect, too, that this firewall log is where things have gone awry. The IP address (substituted as 111.222.333.444) is mine.

    **
    17/Aug/16 13:44:30 #5182889 high 510 111.222.333.444 POST /wp-admin/admin-ajax.php – DOCUMENT_ROOT variable in HTTP request – [POST:site_details = a:2:{s:5:\”local\”;a:8:{s:12:\”is_multisite\”;s:5:\”false\”;s:8:\”site_url\”;s:26:\”https://local.wordpress.dev\”;s:6:\”prefix\”;s:10:\”9krot8mwJ_\”;s:15:\”uploads_baseurl\”;s:46:\”…]
    **

    Any help to remedy, much much appreciated

    https://www.ads-software.com/plugins/ninjafirewall/

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author nintechnet

    (@nintechnet)

    Hi

    Try to set “Firewall Policies > Various > Block the DOCUMENT_ROOT server variable in HTTP request” to “No”.

    Indeed it would be better to disable the firewall when doing this kind of work, because it will likely think you’re a hacker dumping the DB.

    Thread Starter ashbydesign

    (@ashbydesign)

    I’m not sure that the user session issue has any bearing – the notice has now disappeared.

    But still the connection from WP Migrate is failing… with Ninja Firewall deactivated on the live site (as it should have been when I was initially updating the database using the Migrate interface)

    hmmm…

    Thread Starter ashbydesign

    (@ashbydesign)

    I will try what you have suggested. It was my mistake not to have disabled initially… I have since tried the process with the disable firewall on, but not having any luck.

    Thread Starter ashbydesign

    (@ashbydesign)

    I have

    1) set “Firewall Policies > Various > Block the DOCUMENT_ROOT server variable in HTTP request” to “No”.

    2) Disabled the Firewall altogether – Firewalll Options > Firewall protection DISABLED

    3) Tried to connect again – Again the same response from Migrate DB

    “The connection failed, an unexpected error occurred, please contact support. (#121 – scope: ajax_initiate_migration)”

    Hmmm scratching head

    Plugin Author nintechnet

    (@nintechnet)

    You can try to temporarily rename the PHP INI file created during NinjaFirewall’s installation. That will completely disable it. If you still get an error, you can be sure it is not related to the firewall.

    Thread Starter ashbydesign

    (@ashbydesign)

    I have just deleted the php.ini file – as it was an empty file and thought it was wrongly there. Should I replace it?

    Thread Starter ashbydesign

    (@ashbydesign)

    I have a .user.ini file appear instead

    Plugin Author nintechnet

    (@nintechnet)

    You can temporarily rename the .user.ini, that’s the one used by NinjaFirewall.

    Thread Starter ashbydesign

    (@ashbydesign)

    Arggh – Will have to continue tomorrow – school collection time! Thanks for your help – may be back in contact. Sorry.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Firewall blocking Migrate DB Pro’ is closed to new replies.