Posted on 04/01/2011 1:52:38 PM PDT by Red Badger
What’s old fashioned about validating input?
Well said. SQL injection is not difficult if you leave the doors wide open in poorly written code. A simple check is if you are expecting a value of no more than 3 chrs in length, truncate the variable to the length. You can also strip many SQL chrs before sending a value and then reject any request string that contains them.
What browser were you using?
FF
The method of hand-coding a check for each input field certainly works, but it is tedious, prone to error, and adds costs to the project. If there is time and money pressure, it probably won’t be implemented carefully or at all.
That is why it is much better to use a framework or technology where this is automatically supplied.
I’m not disagreeing with you, but hand-coding is NOT tedious, prone to error, and adds costs to the project.
It is very simple to write a (reusable) sub-routine or function that does this on the fly.
oh, I was referring to every returned post after the form has been submitted. Granted, coders should not allow certain values (chr’s) to be entered in a txt field, but this is not where SQL Injection comes from. Typically an injected field can be passed in the url string.
However; it is not to difficult to create a dummy site and send data to the real site. Of course this is easy to check if the data is coming from the host or not. Still this can be worked around using the header string.
Which brings me back to my first point and that is to check, validate and truncate every string that is returned to the host, no matter where from.
The coder should verify everything is legit before the submit button is pressed, but only the ignorant would assume it will always arrive ‘as sent’
This is probably more info than you wanted.
This just happened again to me. I am fairly certain the virus was linked to Sarah Palin pictures from Rolling Thunder. I wasn’t sure the first time, but the second time, the virus made itself apparent right away. I opened a picture of Sarah from a posting from “Crim”. The posting was about pictures of her on the RT tour commenting about a caption that I didn’t see.
Again, I am not 100%, but it seems apparent.
Good luck, and thanks for all you do. Our appreciation can never be overstated.
Brian
Thanks very much for telling me, onona.
I only post photos directly from SARAHPAC or other authorized sources. Once those photos are hosted by outside sources, there’s no telling what has happened to them.
I’m so sorry for the trouble you’ve incurred. I’d be crying.
I consider myself fortunate, as I was on a laptop from work. They were able to fix both viruses quick and easy.
Yeah, if it was my own PC, crying, swearing, and the like.
One of the lucky ones this time.
And how many basic generic principles of Computer Science do you have to violate to allow "data" to be "executable".
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.