+ Reply to Thread
Results 1 to 9 of 9

Issue: SUCURI firewall block

  1. #1
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Issue: SUCURI firewall block

    From both work (PC) and home (iMac) I am now encountering a SUCURI Firewall block if I try to write/post a formula.
    the (home iMac) block details are:
    your browser: mosilla/5.0(macintosh;intelmacosx10_12_3) apple web kit/602.4.8 (KHTML, like gecko) version/10.0.3 safari/602.4.8
    block ID: BLKUNF1
    block reason: your request was not authorized due to its content (HTML code not allowed).
    time: wed mar 29 07:47:44 2017
    server ID: cp14015

    so I requested help from the sucuri chat link and their response...
    the website you wanted is using our firewall service and the website owner has configured settings and you would have to contact them.
    only the website owner can make changes to "WHITELIST" your IP and allow you access to their website.

    So as it stands now I cannot access excel forum for help with formulas from home (iMac and iPad) or from work (PC).

    HELP!
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  2. #2
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Issue: SUCURI firewall block

    Hi Sam..
    Have you checked the Threads here?
    You don't have to look too far!!
    FirstTwoPostsSuggestionsforImprovement.JPG
    Alan

    ( 10 to 1 you have a less than sign with at least 10 characters after it...https://www.excelforum.com/suggestio...ml#post4615552... )
    Last edited by Doc.AElstein; 03-29-2017 at 09:05 AM.
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Re: Issue: SUCURI firewall block

    trying it w/o the equal sign and greater than and less than signs...
    COUNTIFS(M631:M636,"NB",L631:L636,greater than"42794",L631:L636,less than"42826")
    and now with the equal sign but no greater than or less than...
    =COUNTIFS(M631:M636,"NB",L631:L636,greater than"42794",L631:L636,less than"42826")
    will it take them > outside of a formula? <

    yes it will, but not in a formula??? I don't get it?
    Last edited by Sam Capricci; 03-29-2017 at 10:42 AM.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Re: Issue: SUCURI firewall block

    Thanks Alan, I guess I have to be careful about the formulas I try to post using greater than and less than to include spaces like this...
    =COUNTIFS(M631:M636,"NB",L631:L636,"> 42794",L631:L636,"< 42826")

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Issue: SUCURI firewall block

    Quote Originally Posted by Sambo kid View Post
    Thanks Alan, .. have to be careful about the formulas I try to post using greater than and less than to include spaces like this...
    =COUNTIFS(M631:M636,"NB",L631:L636,"> 42794",L631:L636,"< 42826")
    You is welcome
    Alan

    BTW as far as I know, no problem has been reported with the > - you need no space after that

    space only after <
    =COUNTIFS(M631:M636,"NB",L631:L636,">42794",L631:L636,"< 42826")


    Or you can use the black character trick:
    black character trick
    =COUNTIFS(M631:M636,"NB",L631:L636,">42794",L631:L636,"<42826")

    Check out the previous Threads and posts for all the info.
    Your problem is / was the famous ".... .... the < followed by at least 4 characters ( not all character type )"..... problem
    Last edited by Doc.AElstein; 03-29-2017 at 11:45 AM.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Re: Issue: SUCURI firewall block

    I can see the difference for your first example "space only after.." but I must be missing something for the "black character trick".

  7. #7
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Issue: SUCURI firewall block

    Quote Originally Posted by Sambo kid View Post
    I can see the difference for your first example "space only after.." but I must be missing something for the "black character trick".
    ... Have you checked out the other Threads?? That and other stuff is all explained .......

    Your problem is:

    a less than sign ( < ) followed by at least 4 characters.
    Those 4 characters are most but not all characters.
    For example these characters do not cause the problem
    [ ]
    Those are the characters used, for example in BB Code Code Tags

    So if before you post, you make the colour of one of those 4 characters ( 4282 ) black, then, in the Forum Editor it looks like this just before you post
    =COUNTIFS(M631:M636,"NB",L631:L636,">42794",L631:L636,"<4[COLOR="#000000"]2[/COLOR]826")
    Here I selected the 2 and then hit the black color
    Black.JPG

    so sucuri firewall sees_..
    <4[CO
    _..as the first 4 characters after the <
    sucurri does not mind that combination

  8. #8
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,170

    Re: Issue: SUCURI firewall block

    I think I follow it now. Thanks so much for the tips. I did check the other thread but didn't see a direct relevance so I must've missed.
    But I do thank you for the solution.

  9. #9
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Issue: SUCURI firewall block

    Quote Originally Posted by Sambo kid View Post
    I think I follow it now. Thanks so much for the tips. I did check the other thread but didn't see a direct relevance so I must've missed....
    There is a lot of waffle and other crap from me in some of those Threads - i need to do a concise summary of all these problems and work a rounds sometime.. maybe when I retire.. I expect the Forum Software quirks will still be there then
    Thanks for the rep thingy..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Why am I getting a Sucuri Firewall block with this code?
    By delaing in forum Suggestions for Improvement
    Replies: 12
    Last Post: 04-10-2017, 08:02 AM
  2. [SOLVED] SUCURI Firewall - Unable to Answer Post?
    By AliGW in forum The Water Cooler
    Replies: 4
    Last Post: 04-12-2016, 06:28 AM
  3. [SOLVED] Sucuri WebSite Firewall - CloudProxy - Access Denied
    By jaslake in forum Suggestions for Improvement
    Replies: 9
    Last Post: 02-10-2016, 08:50 AM
  4. [SOLVED] My IP Blocked by EF Firewall
    By :) Sixthsense :) in forum Suggestions for Improvement
    Replies: 3
    Last Post: 08-01-2014, 02:01 AM
  5. [SOLVED] Issue - Posted Five Links In Post - Added in Forum Firewall Automatically
    By :) Sixthsense :) in forum Suggestions for Improvement
    Replies: 13
    Last Post: 04-04-2014, 05:31 AM
  6. Replies: 5
    Last Post: 10-09-2012, 10:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1