+ Reply to Thread
Results 1 to 13 of 13

Why am I getting a Sucuri Firewall block with this code?

  1. #1
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Why am I getting a Sucuri Firewall block with this code?

    I tried posting this section of code within an Excel VBA post and keep getting a block with the reason having something to do with detecting

    sucuri block select case code.png

    Here is the block image:
    sucuri block select case.png

    What am I not understanding? How would I be able to get help on this if it were the code in question?

    Thank you,
    Delain
    I say this optimistically . . . One day I'll understand it.
    But today is not that day!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Why am I getting a Sucuri Firewall block with this code?

    The Select statement confuses Sucuri. It thinks that you are trying to write code to this site and you are not authorized. Place a Space in the word Select and that will help or begin the statement with something other than the word Select.

  3. #3
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Why am I getting a Sucuri Firewall block with this code?

    I will try that.

    Thanks for the quick response.

    Delain

  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: Why am I getting a Sucuri Firewall block with this code?

    Hi Delaing


    There are a few things that Sucurri does not like and blocks like this,
    _ - we know about a few so far
    http://www.excelforum.com/showthread...41#post4412541
    http://www.excelforum.com/the-water-...ml#post4502342

    They can be a pain to track down in a long code or text.

    As that code of yours is quite short, it should be easy to track down and it would be useful to know about to “add to the list” !
    Can you upload that code in a File please?

    Thanks
    Alan
    '_- 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
    Registered User
    Join Date
    03-29-2013
    Location
    US
    MS-Off Ver
    Office 2003
    Posts
    61

    Re: Why am I getting a Sucuri Firewall block with this code?

    I'm getting a similar error attempting enter this bit of simple code:

    =AND($F19<>"",$F19<TOD())

    If I add one more letter to the function name TODAY() in this line it trips the Securi bug with this error:

    Block reason: Your request was not authorized due to its content (HTML code not allowed).
    Last edited by Carson Dyle; 11-09-2016 at 06:39 PM.

  6. #6
    Forum Contributor delaing's Avatar
    Join Date
    07-16-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    192

    Re: Why am I getting a Sucuri Firewall block with this code?

    Doc Alan,

    A quick response to your inquiry:
    The suggestion by alansidman is what allowed me to finally post. I had to add a space into "Select" to be "Se lect"; even had to do it with the End Select line.

    Thank you,
    Delain

  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: Why am I getting a Sucuri Firewall block with this code?

    @ Delain,
    Hi
    Thanks

    Alan

    _.......

    @ Carson Dyle
    Hi
    Thanks _....
    _...Yep that is the "< with 4 character" problem
    http://www.excelforum.com/showthread...t=#post4295092
    http://www.excelforum.com/the-water-...ml#post4283991
    It come up a lot. It is probably the one that crops up the most
    _.. - Use a space or the black character trick as discused in the other threads to get over that one
    Alan
    Last edited by Doc.AElstein; 11-09-2016 at 07:23 PM.

  8. #8
    Registered User
    Join Date
    03-29-2013
    Location
    US
    MS-Off Ver
    Office 2003
    Posts
    61

    Re: Why am I getting a Sucuri Firewall block with this code?

    What's the danger of HTML code to your system? The vBulletin processing of the form submission before it's entered in the DBMS should handle any dangers of things like SQL injection.

  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
    50,900

    Re: Why am I getting a Sucuri Firewall block with this code?

    Quote Originally Posted by Carson Dyle View Post
    I'm getting a similar error attempting enter this bit of simple code:

    =AND($F19<>"",$F19<TOD())

    If I add one more letter to the function name TODAY() in this line it trips the Securi bug with this error:

    Block reason: Your request was not authorized due to its content (HTML code not allowed).
    add a space before and after the < and the >
    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

  10. #10
    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: Why am I getting a Sucuri Firewall block with this code?

    Hi Carson Dyle,
    Quote Originally Posted by Carson Dyle View Post
    What's the danger of HTML code to your system? The vBulletin processing of the form submission before it's entered in the DBMS should handle any dangers of things like SQL injection.
    I cannot help there, sorry, - my computing knowledge only extends to a couple of years part time Excel and excel VBA, learnt mostly from Forums. I have no idea what a “DBMS” or “SQL” injection is
    Sounds like a question for someone involved with he Forum Software or Forum Management etc.. Unfortunately it appears they have forgotten about the Forum...
    http://www.excelforum.com/the-water-...-outage-2.html
    Last edited by Doc.AElstein; 11-10-2016 at 12:59 PM.

  11. #11
    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: Why am I getting a Sucuri Firewall block with this code?

    Duplicate post..... Sucurri problems !!
    Last edited by Doc.AElstein; 11-10-2016 at 11:51 AM.

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

    get a Sucuri Freak Paddy with 4 Selects ;)

    Get a Sucuri Freak Out Paddy with 4 Selects



    Quote Originally Posted by delaing View Post
    .....The suggestion by alansidman is what allowed me to finally post. I had to add a space into "Select" to be "Se lect"; even had to do it with the End Select line.....
    I had a look at this so as to know about it in Case I get it..

    This Select one is a difficult one to track down exactly !!

    These cause Sucurri to freak out at least the first time you try. Try again after and sometimes, but not always and they do not !!!!


    select

    select

    select

    end select

    __.____________________

    Select
    select

    select

    SeLect

    _.______

    select

    select

    select
    end select

    _.____________________

    select
    select

    select

    end select

    _.______________________________

    Select

    select

    select sbamnsb
    End SeLect[

    _:____

    select

    select

    select aKDHajdh

    select[


    _._______________

    These do not cause the Sucurri freak out

    Select

    selectdhj

    selectsbamnsb
    End SeLect[

    _._____________________

    Select

    select
    select
    End SeLect[

    _._____________________

    Select

    select
    select

    SeLect[

    _.____________________

    Select

    select
    elect


    SeLect[

    _.__________________-

    Se
    lect

    select select

    SeLect[

    _._____


    And note this does not cause the problem_....

    Select

    select
    select

    SeLect[

    _.....But if I add spaces after the second select then I do get the problem.

    __._____________________________-


    Weird . One could play around for hours... but
    briefly in words this ( inconsistently ) causes problems

    _1 )
    You need 4 occurrences of select , any case , and three of them must be separated by an empty line or if not a space after the select will do


    _2 )
    If you have a [ after a select then_...
    _...- going back from a [ you get the problem if you have 4 distinct

    Select otherstuff

    Bits.


    The inconsistency is possibly occurring as the editor eats spaces. So adding them may solve a problem. On the second attempt the spaces are no longer there. ( I am talking about spaces more than one here )

    I do not think I have it totally pinned down, and it might be impossible to get there due to the thing being a bit inconsistent.. I will probably add it to my list as the “... 4 Selects occurances can cause problems depending on exactly what else is there and where....” problem

    In this case I , in code, would use the black space trick if the problem occurs in a code, rather than a space , as the VB Editor will not remove that space but rather highlight a syntax problem for the whole line

    Space:
    Sel ect Case WhateverelseherealsoredevenifOKsyntaxly

    Black character trick ( before posting make any character or a few characters black )
    Select

    se[COLOR="#000000"]l[/COLOR]ect

    se[COLOR="#000000"]lect[/COLOR] case

    SeLect[

    If I see the problem in a specific select case select type code I may have another look. For now a solution seems to liberally make a character or two in any Selects “black” ( like this before posting Sel[COLOR="#000000"]e[/COLOR]cts )

    Alan
    Last edited by Doc.AElstein; 11-10-2016 at 01:07 PM.

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

    Not again ... a SELECT AGGHHHHHHH

    I should have known....
    This first bit does not post:

    ... "SELECT AliArse.[NDB_NO] FROM [Tabelle1$] As AliArse" "SELECT [t1].NDB_No FROM [" & ThisWorkbook.Path & "\DBSept2016 - first AlanSucces.xlsx].[Tabelle1$] as [t1]" "SELECT `t1`.NDB_No FROM `" & ThisWorkbook.Path & "\DBSept2016 - first AlanSucces.xlsx`.`Tabelle1$` as `t1`" "SELECT t1.`NDB_NO` FROM `Tabelle1$` As t1"
    Let CmdTxtTxt = "SELECT AliArse.[" & Heading & "] FROM [" & Replace(ShtName, ".", "#", 1, -1) & "$] As AliArse"
    '3a(iii) ' Got ya AliArse in and so get ya rows
    Let CmdTxtTxt = Replace(CmdTxtTxt, "SELECT", "SELECT TOP 8810", 1, -1) ' By simply commenting out this line out I have this option SELECT

    _......I should have guessed .. spot the difference from above and below ( at the start – I apply the black character trick to get it to post !!!). This below will post

    ... "SE[COLOR="#000000"]L[/COLOR]ECT AliArse.[NDB_NO] FROM [Tabelle1$] As AliArse" "SELECT [t1].NDB_No FROM [" & ThisWorkbook.Path & "\DBSept2016 - first AlanSucces.xlsx].[Tabelle1$] as [t1]" "SELECT `t1`.NDB_No FROM `" & ThisWorkbook.Path & "\DBSept2016 - first AlanSucces.xlsx`.`Tabelle1$` as `t1`" "SELECT t1.`NDB_NO` FROM `Tabelle1$` As t1"
    Let CmdTxtTxt = "SELECT AliArse.[" & Heading & "] FROM [" & Replace(ShtName, ".", "#", 1, -1) & "$] As AliArse"
    '3a(iii) ' Got ya AliArse in and so get ya rows
    Let CmdTxtTxt = Replace(CmdTxtTxt, "SELECT", "SELECT TOP 8810", 1, -1) ' By simply commenting out this line out I have this option SELECT

    _.......and I had the pleasure of finding that and applying the Work a round here : !!!
    https://www.excelforum.com/developme...ml#post4626005

    _....... Only took an hour or so !!!

+ 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. [SOLVED] SUCURI Firewall - Unable to Answer Post?
    By AliGW in forum The Water Cooler
    Replies: 4
    Last Post: 04-12-2016, 06:28 AM
  2. [SOLVED] Sucuri WebSite Firewall - CloudProxy - Access Denied
    By jaslake in forum Suggestions for Improvement
    Replies: 9
    Last Post: 02-10-2016, 08:50 AM
  3. [SOLVED] My IP Blocked by EF Firewall
    By :) Sixthsense :) in forum Suggestions for Improvement
    Replies: 3
    Last Post: 08-01-2014, 02:01 AM
  4. 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