Don’t you hate it when you know you solved a problem three years ago but you can’t remember what the solution was? I ran into that recently. I was trying to make mysql generate a csv directly from query results. I remembered that you can do it, and I had an example of the correct syntax to use in my old code, and I had a query that did it just fine when running in the mysql CLI as root. I had to piece together the answer from several different sources; and none of them told the whole story. So here is the full story, along with all the stumbling blocks that I know of.
Continue reading How to make MySQL spit out CSV’s
|
|||||
 22 comments - (Comments are closed)  Geek Stuff, SQL  CSV, DoS, escapes, FILE privilege, filesystem, INTO OUTFILE, MySQL, mysql system user, mysql user, OUTFILE, permissions, security, vulnerability
6 comments - (Comments are closed) Geek Stuff, Hacking and Security authentication, authorization, Bar Camp Portland, credentials, hack, hackers, handshake, humans, json, Legacy, Oauth, password, PHP5, security, serious hackers, skynet, third party, third party application, token, twitter, web application Apparently captured from a workplace monitor security camera somewhere in Russia a few months back.
The dork is featured again in Issue #4 (August 1) of Information Security Short Takes that I was in last month. This blog features a monthly blog carnival potpourri webzine of useful selection of security related articles. I know, I know, nobody wants to hear about security. It’s boring as all get out, and it’ll probably not happen to you. Except that it is happening, to more and more of us each year. Knowledge is power in this game. Know how it works, what to do and what not to do, and diminish your chance of being ripped off. 2 comments - (Comments are closed) Fun Web and Blog Goodies, Hacking and Security article syndication, blog carnival, consequences, crack, credit card, hack, identity, identity theft, info security, linkedin, nightmare, security, security articles, tail, webzine
7 comments - (Comments are closed) Hacking and Security bogus URL, DNS phish, hosts phish, phish, redirection, security, trojan, virus
7 comments - (Comments are closed) Hacking and Security crack, credit card, data stream, disposable credit card number, merchants, point of sale, security, swiper A layman’s guide to credit card security. Colleen explains encryption, trust, and fraud building. This post is a must-read. . . . → Read More: Credit card security online: what you need to know 11 comments - (Comments are closed) Geek Stuff, Hacking and Security CA, credit card, Encryption, PCI, Private Key, Public Key, security, SSL |
|||||
|
Copyright © 2012 Hot Dorkage - All Rights Reserved |
|||||
What is OAuth, and why should you care? Here’s the deal: Just like 
A old school phish typically involves an Instant Messenger or email message asking you to click a link. This tried and true technique uses bogus links, and this article shows you how to detect them. Newer phishes bite you at a different level. They feed you “good” links but then they cause the good links to turn into bad ones at the network level where you normally don’t go. These phishes will work even if you manually type the good URL into a completely virgin browser. About the only way to be safe from these is to protect your computer overall. The section where I describe bogus URL’s may seem a little long, but consider that it is easier for human brains to spot patterns than it is to talk about them. An accurate and complete description is necessary so your brain can learn what to look for. Don’t sweat it — with just a little practice you’ll be able to sniff a bogus URL in a matter of seconds just like an IT security pro.
Another database: CRACKED A recent security breach of a local online merchant prompted me to write this post. As a shopping cart software author and former security analyst at