+ Reply to Thread
Results 1 to 9 of 9

Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

  1. #1
    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

    Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Sucuri Block. Access Denied - Sucuri Website Firewall . Workarounds


    This Post is a short summary of the 4 posted text combinations that have been known to set off the Sucuri Firewall which then blocks you from posting, and chucks up something like this: ( The references at the end are to more detailed Threads )
    Access Denied - Sucuri Website Firewall.JPG https://imgur.com/X7D3erA
    Name:  Access Denied - Sucuri Website Firewall 653x255 65_7KB.JPG
Views: 1028
Size:  65.7 KB
    Note :
    _ the exact _Block details of the issue as given in such a Notice are not usually very relevant or correct.
    _ the firewall reacts to any text you attempt to post anywhere. It makes no difference, for example, if the offending text is in code tags or simply plain text.

    _1_ First 4 characters after a _ <
    Not all characters are accepted in the first 4 characters after a _ <
    For example, these will not be accepted:
    <1B34 __ <1col
    These will be accepted:
    < 1B3 __ <1 B3 __ <1[co
    ( Any characters are permitted after the forth character )
    Because a _ [ _ is a permitted character, there is a workaround that allows you to have shown in the final post exactly want you want, even if it is a unaccepted character combination. This workaround is the following “Black Character trick”:
    Black Character trick
    Instead of posting this: _ <1B34 _ , post something like this:
    <1B[color=Black]3[/color]4
    or this
    <1B[COLOR="#000000"]3[/COLOR]4
    You can achieve similar in the Forum editor by selecting one of the 4 characters and then selecting the color icon and then select the color black: BlackColorSelectInEditor.JPG https://imgur.com/BqiO218
    1 Select any character _ 2 Select Color Drop Down Arrow _ 3 Select black color

    Name:  BlackColorSelectInEditor 656x266 96_9KB.JPG
Views: 807
Size:  96.9 KB
    So you would post something like this: _ <1[COLOR="#000000"]B[/COLOR]34 _ , but the final posted character string seen in the final post will be _ <1B23

    _2_ Select
    Certain combinations of text that include the word Select are not permitted. If you are having problems posting any text or code containing the word Select, then try using the “Black Character trick” on any character in one or more of the Select words.

    _3_ Replace(Replace
    This is not permitted in text or code. Use the “Black Character trick” to get exactly that text posted.
    Or if you are posting code then you can modify by simply adding a space thus:
    Replace( Replace
    or thus:
    Replace (Replace
    If a code with either of those two modification is copied and pasted into a code module, then usually the VB Editor automatically adjusts the code to remove that space.

    _4_ Exec(
    This 5 character combination is usually not permitted. Use the “Black Character trick” to get that character combination to post. ( Any characters are permitted after the fifth character )



    _.___________________________________________



    Below are some Threads that discuss these things in more detail. Please post in those Threads or this Thread if you can add any information on the issues or find anything else that chucks up the Firewall preventing you from posting

    Thanks,
    Alan ( or am I Dave ?? )


    https://www.excelforum.com/excel-pro...ml#post4790073
    https://www.excelforum.com/developme...ml#post4778069
    https://www.excelforum.com/suggestio...-firewall.html
    https://www.excelforum.com/suggestio...ml#post4666465
    https://www.excelforum.com/the-water...ml#post4645090
    https://www.excelforum.com/suggestio...ml#post4626828
    https://www.excelforum.com/suggestio...ml#post4615552
    https://www.excelforum.com/developme...ml#post4641199
    http://www.excelforum.com/developmen...ml#post4295092
    http://www.excelforum.com/the-water-...ml#post4283991
    http://www.excelforum.com/suggestion...ml#post4412541
    https://www.excelforum.com/the-water...ml#post4591609
    http://www.excelforum.com/showthread...41#post4412541
    http://www.excelforum.com/the-water-...ml#post4226385
    http://www.excelforum.com/suggestion...-a-thread.html
    http://www.excelforum.com/showthread...t=#post4520072
    http://www.excelforum.com/showthread...t=#post4502342
    Last edited by Doc.AElstein; 12-31-2017 at 08:38 AM. Reason: I am Dave??

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,069

    Re: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Dave, thanks for that, lots of hard work went into putting that together
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,128

    Re: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Alan,

    Thank you for that. REPLACE has been causing me fits lately. I used the Black Character trick here. Let's see if it works.

    Who's "Dave"?
    Dave

  4. #4
    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: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Quote Originally Posted by FlameRetired View Post
    Who's "Dave"?
    You should know, Dave.. ...
    Hi Dave
    Best wishes for the New Year,
    Alan.. I think



    P.S I did not think REPLACE on its own was a problem..

    EDIT: Nope - I did not need any trick just there.... could be in conjunction with something else.. but if so then it is a new one on me
    .. but I am sure there are a few I do not know about

    You posted this: _ [COLOR="#000000"]REPLACE[/COLOR] _ , but that is not the "Black character trick"...unless you are doing it like this:
    [COLOR="#000000"]REPLACE[/COLOR](REPLACE
    The "Black character trick" is used to break up the offending character combination so that Sucuri does not see it. Sucuri only looks at what you post in the editor. It does not care about what it looks like in the final post.. I think..
    Sucuri will not let you post this: _ _ REPLACE(REPLACE
    Dave, or was it Alan,
    Last edited by Doc.AElstein; 12-31-2017 at 06:23 PM.
    '_- 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 )

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,128

    Re: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Thank you Alan ... er Dave ... yes my formula did have a REPLACE nested inside another REPLACE.

    Thank you, again.
    Dave

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Alan, Dave - whatever I think better to use is : Friend
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  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: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Happy New Year, Friend Dali

    David
    Last edited by Doc.AElstein; 01-01-2018 at 10:37 AM.

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Thank you, Thank you, Thank you my Friend Alan

    Name:  2nyeargraphic2018.gif
Views: 875
Size:  51.4 KB
    Last edited by sandy666; 12-31-2017 at 07:35 PM.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,069

    Re: Sucuri Block. Access Denied - Sucuri Website Firewall : Workarounds

    Alan, just for clarity, Dave is Alan in Swahili LOL

    Happy New year 1 and all

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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