Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. The SQL Injection Attack is alive and well.

The SQL Injection Attack is alive and well.

Scheduled Pinned Locked Moved The Lounge
databasequestionannouncement
38 Posts 15 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • H Offline
    H Offline
    Henry Minute
    wrote on last edited by
    #1

    According to this report[^]. It is difficult to believe that Systems Administrators are unaware of this exploit and yet numerous sites are still vulnerable.

    Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

    OriginalGriffO A A M M 6 Replies Last reply
    0
    • H Henry Minute

      According to this report[^]. It is difficult to believe that Systems Administrators are unaware of this exploit and yet numerous sites are still vulnerable.

      Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

      OriginalGriffO Offline
      OriginalGriffO Offline
      OriginalGriff
      wrote on last edited by
      #2

      Henry Minute wrote:

      It is difficult to believe that Systems Administrators are unaware of this exploit

      You don't spend enough time in Q&A: nobody seems to be taught about it, even in passing... :sigh:

      Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

      "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
      "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

      H G 2 Replies Last reply
      0
      • OriginalGriffO OriginalGriff

        Henry Minute wrote:

        It is difficult to believe that Systems Administrators are unaware of this exploit

        You don't spend enough time in Q&A: nobody seems to be taught about it, even in passing... :sigh:

        Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

        H Offline
        H Offline
        Henry Minute
        wrote on last edited by
        #3

        Well I always assumed that those guys were noobs. Are you seriously telling me that we CPers are in reality managing the entire interwebs by proxy and that all those snd codezzzzz plzzzzzzers are realy SAs?

        Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

        W OriginalGriffO 2 Replies Last reply
        0
        • H Henry Minute

          Well I always assumed that those guys were noobs. Are you seriously telling me that we CPers are in reality managing the entire interwebs by proxy and that all those snd codezzzzz plzzzzzzers are realy SAs?

          Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

          W Offline
          W Offline
          wizardzz
          wrote on last edited by
          #4

          That sounds about right...

          "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" — Hunter S. Thompson

          1 Reply Last reply
          0
          • H Henry Minute

            According to this report[^]. It is difficult to believe that Systems Administrators are unaware of this exploit and yet numerous sites are still vulnerable.

            Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

            A Offline
            A Offline
            AspDotNetDev
            wrote on last edited by
            #5

            Isn't that more the responsibility of a programmer than a systems administrator? I suppose a properly secured database helps (i.e., you can disallow arbitrary SQL code and only allow stored procedures to execute), but the main step is to not use code that allows for SQL injection.

            [WikiLeaks Cablegate Cables]

            W H C T 4 Replies Last reply
            0
            • H Henry Minute

              Well I always assumed that those guys were noobs. Are you seriously telling me that we CPers are in reality managing the entire interwebs by proxy and that all those snd codezzzzz plzzzzzzers are realy SAs?

              Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

              OriginalGriffO Offline
              OriginalGriffO Offline
              OriginalGriff
              wrote on last edited by
              #6

              Didn't they tell you when they gave you your MVP? Along with the key to the Executive Washroom Page? It was in with your Certificate...

              Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

              "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
              "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

              A 1 Reply Last reply
              0
              • OriginalGriffO OriginalGriff

                Didn't they tell you when they gave you your MVP? Along with the key to the Executive Washroom Page? It was in with your Certificate...

                Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                A Offline
                A Offline
                AspDotNetDev
                wrote on last edited by
                #7

                OriginalGriff wrote:

                It was in with your Certificate

                Speaking of, did you get yours yet?

                [WikiLeaks Cablegate Cables]

                H OriginalGriffO 2 Replies Last reply
                0
                • A AspDotNetDev

                  Isn't that more the responsibility of a programmer than a systems administrator? I suppose a properly secured database helps (i.e., you can disallow arbitrary SQL code and only allow stored procedures to execute), but the main step is to not use code that allows for SQL injection.

                  [WikiLeaks Cablegate Cables]

                  W Offline
                  W Offline
                  wizardzz
                  wrote on last edited by
                  #8

                  IMO it's the job of the DBA to allow only SP's and the developer to sanitize any input parameters. So, it's everyone's fault. Given the description of the hacked sites, I'm guessing this is the exploitation of a an open source or cheap product they all used in common, assuming that SQL injection would have been accounted for. It could even be an inside job from the developers of the common software.

                  "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" — Hunter S. Thompson

                  A N S 3 Replies Last reply
                  0
                  • H Henry Minute

                    According to this report[^]. It is difficult to believe that Systems Administrators are unaware of this exploit and yet numerous sites are still vulnerable.

                    Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                    A Offline
                    A Offline
                    Andy Brummer
                    wrote on last edited by
                    #9

                    Yeah, exactly what aspdotnetdev said. SQL injection is an application level exploit.

                    Curvature of the Mind now with 3D

                    1 Reply Last reply
                    0
                    • A AspDotNetDev

                      Isn't that more the responsibility of a programmer than a systems administrator? I suppose a properly secured database helps (i.e., you can disallow arbitrary SQL code and only allow stored procedures to execute), but the main step is to not use code that allows for SQL injection.

                      [WikiLeaks Cablegate Cables]

                      H Offline
                      H Offline
                      Henry Minute
                      wrote on last edited by
                      #10

                      True, but I was basing it on the days when I was an SA. I set the rules and the coders had to stick to them.

                      Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                      A 1 Reply Last reply
                      0
                      • W wizardzz

                        IMO it's the job of the DBA to allow only SP's and the developer to sanitize any input parameters. So, it's everyone's fault. Given the description of the hacked sites, I'm guessing this is the exploitation of a an open source or cheap product they all used in common, assuming that SQL injection would have been accounted for. It could even be an inside job from the developers of the common software.

                        "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" — Hunter S. Thompson

                        A Offline
                        A Offline
                        Andy Brummer
                        wrote on last edited by
                        #11

                        wizardzz wrote:

                        IMO it's the job of the DBA to allow only SP's

                        Ugh. I'm happy I don't work with those DBAs, or any DBA for that matter. :-D

                        Curvature of the Mind now with 3D

                        W 1 Reply Last reply
                        0
                        • A Andy Brummer

                          wizardzz wrote:

                          IMO it's the job of the DBA to allow only SP's

                          Ugh. I'm happy I don't work with those DBAs, or any DBA for that matter. :-D

                          Curvature of the Mind now with 3D

                          W Offline
                          W Offline
                          wizardzz
                          wrote on last edited by
                          #12

                          Haha, me too actually.

                          "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" — Hunter S. Thompson

                          1 Reply Last reply
                          0
                          • H Henry Minute

                            True, but I was basing it on the days when I was an SA. I set the rules and the coders had to stick to them.

                            Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                            A Offline
                            A Offline
                            Andy Brummer
                            wrote on last edited by
                            #13

                            That's an odd relationship. Did they work for you?

                            Curvature of the Mind now with 3D

                            H 1 Reply Last reply
                            0
                            • A AspDotNetDev

                              OriginalGriff wrote:

                              It was in with your Certificate

                              Speaking of, did you get yours yet?

                              [WikiLeaks Cablegate Cables]

                              H Offline
                              H Offline
                              Henry Minute
                              wrote on last edited by
                              #14

                              Mine arrived last week, has yours not? I'm fibbing. 7th May was the date mine arrived last year.

                              Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                              A 1 Reply Last reply
                              0
                              • A Andy Brummer

                                That's an odd relationship. Did they work for you?

                                Curvature of the Mind now with 3D

                                H Offline
                                H Offline
                                Henry Minute
                                wrote on last edited by
                                #15

                                Yup. In the sense that I was head of the dept that employed them and conducted the interviews. LAN only stuff back then though. From the comments it would seem that things have changed more than a little since then.

                                Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                                A 1 Reply Last reply
                                0
                                • H Henry Minute

                                  Mine arrived last week, has yours not? I'm fibbing. 7th May was the date mine arrived last year.

                                  Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                                  A Offline
                                  A Offline
                                  AspDotNetDev
                                  wrote on last edited by
                                  #16

                                  Huh, I wonder why it takes so long.

                                  [WikiLeaks Cablegate Cables]

                                  H 1 Reply Last reply
                                  0
                                  • A AspDotNetDev

                                    Huh, I wonder why it takes so long.

                                    [WikiLeaks Cablegate Cables]

                                    H Offline
                                    H Offline
                                    Henry Minute
                                    wrote on last edited by
                                    #17

                                    Hamsters have problems gripping those fancy writing pens. Calligraphy! That's the word I was looking for. Calligraphy pens.

                                    Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                                    1 Reply Last reply
                                    0
                                    • W wizardzz

                                      IMO it's the job of the DBA to allow only SP's and the developer to sanitize any input parameters. So, it's everyone's fault. Given the description of the hacked sites, I'm guessing this is the exploitation of a an open source or cheap product they all used in common, assuming that SQL injection would have been accounted for. It could even be an inside job from the developers of the common software.

                                      "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" — Hunter S. Thompson

                                      N Offline
                                      N Offline
                                      Nemanja Trifunovic
                                      wrote on last edited by
                                      #18

                                      wizardzz wrote:

                                      it's the job of the DBA to allow only SP's and the developer to sanitize any input parameters.

                                      Neither helps with SQL injections. The only cure is using parameterized queries[^].

                                      utf8-cpp

                                      Sander RosselS W A 4 Replies Last reply
                                      0
                                      • N Nemanja Trifunovic

                                        wizardzz wrote:

                                        it's the job of the DBA to allow only SP's and the developer to sanitize any input parameters.

                                        Neither helps with SQL injections. The only cure is using parameterized queries[^].

                                        utf8-cpp

                                        Sander RosselS Offline
                                        Sander RosselS Offline
                                        Sander Rossel
                                        wrote on last edited by
                                        #19

                                        quotename()[^] might help too in some cases (I think) :D

                                        It's an OO world.

                                        1 Reply Last reply
                                        0
                                        • A AspDotNetDev

                                          Isn't that more the responsibility of a programmer than a systems administrator? I suppose a properly secured database helps (i.e., you can disallow arbitrary SQL code and only allow stored procedures to execute), but the main step is to not use code that allows for SQL injection.

                                          [WikiLeaks Cablegate Cables]

                                          C Offline
                                          C Offline
                                          Chris Meech
                                          wrote on last edited by
                                          #20

                                          AspDotNetDev wrote:

                                          but the main step is to not use code that allows for SQL injection.

                                          A proper use of security would help as well. It's one thing to allow a user to type or inject "delete ...", it's quite another to actually authorise a user to do that. :)

                                          Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

                                          A 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups