Can anyone explain how to get mysqldump to extract & store the storage engine of the tables?
If dumping in XML format, that info is preserved, otherwise it seems to be discarded. If a DB has a combo of MyISAM and InnoDB tables and you're backing up / replicating with mysqldump, that info is... lost. As far as I can tell. Unless I'm doing something wrong.
If one does dump to XML, what's the best way to load that into a new slave or do a restore from it?
Using 5.5.28 here...
Seriously has me considering making the switch to PostgreSQL, although I'm not sure that it's better in that regard. It does now do asynchronous or synchronous replication at a transactional level, which looks interesting.
These Advanced Persistent Threats are quite frightening, but would having users run Linux desktops not mitigate it if not negate it completely?
After all, opening a PDF wouldn't likely execute any code, attachments would have to have the extra step of making them *executable* before they'd run, regardless of the extension (i.e. nekkidboobs.jpg.exe would simply not work)
I can't help but think that it would force the attackers to target another vector; one much more difficult, i.e. holes in web-facing server scripts.
If there was a widely publicized shortcode you could text with a number to say has been spam calling you then people could do that, and set up an ENUM–style directory which has the RBL info for use by phone companies.
Also phone companies could text people with information about this shortcode the first time every month that a previously unknown number makes a call or sends a message (until they say STOP of course;-))
Might work for mobile spam, at least.
Unfortunately, the most-common victims of telemarketing spam are older folks, ones without computers, mobile phones, or any technical savvy to make use of even the easiest blocking technology.
I'd thought of something similar - distributing telemarketer lists as reported by those receiving calls - as a vcard that can be imported into a contacts list and auto-blocked (at least with Android). But then realized that the targets of the calls wouldn't have a) knowledge of such a thing, b) ability to install a vcard, c) call display, d) ability to quickly scan any print-outs of the numbers (it'd be a huge list).
Anonymous will choose one media outlet and supply them with heavily redacted partial contents.
Well, that's one way to get the word out -- but word to the wise, going upstairs and showing your mom doesn't count as a "media outlet."
I'm curious; what if you as a writer for El Reg were to receive some of these documents - what would you do with them?
Honestly, as a non-American, I haven't even looked into what it is they're taking although I expect the only impact will be for some of them to have their asses handed to them by the DoJ eventually.
I'm more curious on your thoughts on receiving something like this or the infamous Wikileaks materiel.
"I doubt their ability to determine which aisles of a store you're traversing unless they have a *lot* of antenna set up."
Triangulation
Technically they would just need 3 antennas that are all capable of picking up your signal and paring that up with cameras could match a humans movement path along with the signal levels.
Best bet if you can, switch your MAC address every so often. Good app idea actually... Auto-MAC-Changer - changes MAC address on device at set/random intervals to help in remaining anonymous. But if they track by the ESSID as well and you have a very unique ESSID, the store will at least be able to track the 'household' as a customer rather than an individual person.
That's a hell of a lot of effort just to determine who is in which aisle. The camera thing just seems hard / expensive to automate, especially in a busy store.
And 3 antennas would (it seems to me) make it difficult to pinpoint the aisle a shopper is in.
Of course the problems would be most difficult in a busy store, which would see the least benefit (they're already busy), and a not-busy store would (should) find better ways of increasing sales than a techno fix for tracking shoppers browsing patterns. i.e. have floor staff note which sections are busy, maybe offer assistance, etc.
Actually, you don't even need to turn off wifi. Just set your phone to not automatically join any public wifi.
Wireless clients, including the phone, compiles a list of access points you can join using the ESSID broadcast from the access point. In other words, the access points just dumbly advertise their presence and don't know who are looking until your device tries to join.
If they're running something like Kismet, then I don't think you need to join anything; they just sniff packets being sent over the air, grab the MAC, and they know your device manufacturer and have a unique ID for you. If I'm not mistaken, a phone with Wifi on will broadcast it's MAC while looking for access points.
I doubt their ability to determine which aisles of a store you're traversing unless they have a *lot* of antenna set up.
Does Microsoft allow you to resize existing partitions to make space for the new OS? Has Microsoft stopped their long-held practice of hosing the first primary partition & MBR as either gross incompetence or punishment for dabbling with the competition? Does Microsoft allow you to remove / replace the desktop environment if you find the bundled one doesn't suit your needs / preferences?
Some of these are just KISS decisions that make Windows work on so many different PCs.
Odd that they'd leave out so many crucial features for that reason, when Linux runs just fine with these features on everything from phones to main frames.
The only one of my examples that your excuse might cover is the lack of alternate desktop environments.
Dare I say this is why people use Windows and not Nix? I'm sure you could recompile the mess to your liking though... Just get g'ma to do that.
I dare say that anyone making that choice would be mistaken - at least if it's for the reason that this installer sucks.
Does Microsoft allow you to resize existing partitions to make space for the new OS? Has Microsoft stopped their long-held practice of hosing the first primary partition & MBR as either gross incompetence or punishment for dabbling with the competition? Does Microsoft allow you to remove / replace the desktop environment if you find the bundled one doesn't suit your needs / preferences? Does Microsoft finally supply a help system that actually provides... help? Does Microsoft allow you to install if you have misplaced your installation key? Does Microsoft still force you to type in a (lengthy, meaningless) software key?
I doubt grandma could do a bare install of Windows on a blank disk either. And if she were to try, I'd wager that *most* GNU/Linux distros would provide better guidance along the way. After all, my Mom's a grandma and she uses Ubuntu with no problems -- fewer than when she was using XP.
This is rather off-topic; for that and for not addressing any items from your interesting post, I apologize.
HOWever, how the heck did the Facebook logo appear beside your post? I don't use FB, so am unfamiliar with its workings, but did you post your comment to Slashdot's FB "wall" and it appeared here?
Did it create a Slashdot account for you (you seem to have a very recent UID)?
I just haven't seen the icon placed here before and it's got me quite curious.
I can't believe I just replied to someone who thinks that owning a Blackbarry demonstrated a mastery of technology. Maybe it is time to take me away. He got what all the other cool dudes were getting, that's all, which is probably how you do technology, too.
Having a Blackberry was not an example of "mastery" of technology but of being comfortable with it and having some understanding of its use.
BTW, you state that Obama is a stooge of Wall Street, which is hard to argue with, but manage to ignore that his rival in the last election was Wall Street incarnate. You also ignore that his predecessor was also a bigger friend to Wall Street ("You're my kinda people - the Haves and the Have-Mores").
You seem like the type to jump out of the frying pan and into the fire.
Willingham's case gained renewed attention in 2009 when an investigative report by David Grann in The New Yorker,[1] drawing upon arson investigation experts and advances in fire science since the 1992 investigation, suggested that the evidence for arson was unconvincing, and that had this information been available at the time of trial, Willingham would have been acquitted.
According to an August 2009 investigative report by an expert hired by the Texas Forensic Science Commission, the original claims of arson were doubtful.[2]
...
The case has been further complicated by allegations that Texas Governor Rick Perry impeded the investigation by replacing three of the nine commission members in an attempt to change the commission's findings; Perry denies the allegations.[4]
I've been disappointed by him in many ways, particularly with his DoJ, but... you think he personally got involved in this? Holy conspiracies, Batman.
2. Don't use technology, about which he knows nothing except how to pick up the phone and order another drone kill.
I bet you think he's an expert in Teleprompter technology though.
I thought he was rather technologically savvy. He had and loved his Blackberry back when first elected (when they were the device used by connected executive types. He appointed a PhD, not a partisan hack, to DoE, etc. Besides, he didn't invent the use of drone strikes, even though he does abuse the use of them IMO.
3. If you intend to do something illegal, and you failed to give POTUS or his agent hundreds of thousands or even millions of dollars in advance, you are going to be in big trouble.
Wait, are you talking personal bribes or corporate lobbying? Since you brought the current president in at the exclusion of previous ones, it seems like you're implying personal bribes in which case you must be stoned or an utter wingnut.
And do look at the treatment of Bradley Manning. Can't blame that on Boston prosecutors.
His treatment was over the top but surely not unexpected. By any POTUS. Previous one would've likely sent him to Guantanamo.
"Don 't get mad. Get even," said one of the also Chicago-mob-connected Kennedys.
I see; it seems like a wingnut political screed. Ignore officially sanctioned torture, illegal gun running (Iran Contra), and go all the way back to the 1960's for that juicy turd.
It's how they do business there. This all has little or nothing to do with a couple of twits in Boston and everything to do with President-for-Life Obama, with perhaps the continuation of millions of dollars in defense contracts for MIT Lincoln Labs thrown in.
Ortiz's dipshit husband says "he had a plea bargain for 6 months." Oh sweet, I get to get raped for 6 months instead of 35 years.
I don't think sentences of less than 2 years go to federal prison. Generally they're served in minimum security settings where the violence is unlikely due to the possibility of most of the convicts being sent back to a higher security institution to finish their terms.
IANAL, nor American, so YMMV. But I'm pretty sure this is the case.
When I see stories like this, I'm glad that in Canada at least, we do not vote for sheriff, crown prosecutors (aka district attorneys), dog catchers, nor judges.
It seems that leads to a spiralling who's-toughest-on-crime "arms race" which goes beyond reason fairly quickly.
(Yes, I know that higher-level judges are appointed in USA.)
During these past few years, the Canadian court system has been a bit of a light at the end of a long, dark tunnel with regards to this and striking down draconian laws instituted at the federal level.
Just in the past week (part of) the legislation regarding human smuggling was struck down in BC (giving aid to someone attempting to illegally enter the country could be construed as giving legal advice, or even coffee); mandatory sentencing for a guy in Surrey with no priors, but caught with a loaded Glock in a public place also struck down (an unreasonable gap between levels of sentencing, IIRC).
Now if they could just pick up the pace on the election fraud case(s) being heard; we cannot allow these ones to be unresolved through the next election, like the last one involving the Conservative Party of Canada (In & Out scandal).
Well, that turned into more of a rant than I expected.
I agree that comments do not always help and can obscure the code. But there are many cases when it would be helpful to know why a particular choice was made. Comments help record that history. Also function names, no matter how descriptive, are often ambiguous. Sometimes a comment can help clear up the possible confusion. Coding standards should include what comments to not include. If the comments simply repeat what the source if obviously doing, then those comments clearly can be eliminated. But it's not always obvious why a certain algorithm is used over others, or why a certain magic number is used (some "magic" numbers are necessary so they cannot all be eliminated. It's nice to know how a particular number was chosen).
This is the most important reason for a comment's existence, IMHO.
Nothing more frustrating than a comment saying, $x++// "add 1 to $x" with no idea why we're incrementing $x; leaving me to play computer in my head / on paper / in a debugger to try to figure it out for myself.
Nortel was subject to an organized, sustained industrial espionage effort conducted by Chinese companies. Huawei was specifically named by Brian Shields, Systems Security Advisor for Nortel at the time of the attacks (at the time Huawei supposedly were even copying Nortel's instruction manuals). Shields petitioned Royal Canadian Mounted Police in 2004, because even the CEO's computer had been compromised.
The rootkits employed on Nortel hardware were sophisticated enough to survive formatting. it wasn't until recently that Canadian Security and Intelligence Service became interested in the role Huawei had in Nortel's demise
I suggest the story of Nortel's demise has not been fully revealed. Nortel presented with a sudden, public exanguination and it has been a mystery in Canadian IT industry. This is not just another "golden parachutes" story.
Thank you for posting these links in one convenient location. I'm working my way through them and... just... "Wow".
I was vaguely aware of some of the allegations previously, but not the extent of them.
I've considered us to be engaged in a "cyber-war" for quite a while, but still there's more I have to do to lock down my systems.
Three top Nortel Networks Corp. executives accused of defrauding the company and its investors were acquitted in a Toronto courtroom today, making them free men.
So thanks to fireflies I can have even brighter, more obnoxious headlights on my car.
HIDs =/= LEDs.
But yes, expect more insanely bright and poorly adjusted headlights on cars.
I always thought that for most driving, done in urban areas, headlights were so the car could be seen, not to see with. That's what street lamps are for.
Once away from street lamps (and oncoming traffic), then lights can and should be as bright as possible IMHO.
Maybe the forum members got disgusted by his posts, and so reported him to the Feds. Seriously, I didn't know till I checked my edictionary that "troll" had the pre-Internet non-mythical meaning of "circulate, move around".
Can anyone explain how to get mysqldump to extract & store the storage engine of the tables?
If dumping in XML format, that info is preserved, otherwise it seems to be discarded. If a DB has a combo of MyISAM and InnoDB tables and you're backing up / replicating with mysqldump, that info is... lost. As far as I can tell. Unless I'm doing something wrong.
If one does dump to XML, what's the best way to load that into a new slave or do a restore from it?
Using 5.5.28 here...
Seriously has me considering making the switch to PostgreSQL, although I'm not sure that it's better in that regard. It does now do asynchronous or synchronous replication at a transactional level, which looks interesting.
These Advanced Persistent Threats are quite frightening, but would having users run Linux desktops not mitigate it if not negate it completely?
After all, opening a PDF wouldn't likely execute any code, attachments would have to have the extra step of making them *executable* before they'd run, regardless of the extension (i.e. nekkidboobs.jpg.exe would simply not work)
I can't help but think that it would force the attackers to target another vector; one much more difficult, i.e. holes in web-facing server scripts.
Anyone able to shed some light on APTs and Linux?
If there was a widely publicized shortcode you could text with a number to say has been spam calling you then people could do that, and set up an ENUM–style directory which has the RBL info for use by phone companies.
Also phone companies could text people with information about this shortcode the first time every month that a previously unknown number makes a call or sends a message (until they say STOP of course ;-))
Might work for mobile spam, at least.
Unfortunately, the most-common victims of telemarketing spam are older folks, ones without computers, mobile phones, or any technical savvy to make use of even the easiest blocking technology.
I'd thought of something similar - distributing telemarketer lists as reported by those receiving calls - as a vcard that can be imported into a contacts list and auto-blocked (at least with Android). But then realized that the targets of the calls wouldn't have a) knowledge of such a thing, b) ability to install a vcard, c) call display, d) ability to quickly scan any print-outs of the numbers (it'd be a huge list).
Anonymous will choose one media outlet and supply them with heavily redacted partial contents.
Well, that's one way to get the word out -- but word to the wise, going upstairs and showing your mom doesn't count as a "media outlet."
I'm curious; what if you as a writer for El Reg were to receive some of these documents - what would you do with them?
Honestly, as a non-American, I haven't even looked into what it is they're taking although I expect the only impact will be for some of them to have their asses handed to them by the DoJ eventually.
I'm more curious on your thoughts on receiving something like this or the infamous Wikileaks materiel.
Cheers
And you can power the router with a potatto
I don't recommend you take that root when powering your 'rooter/router'...
"I doubt their ability to determine which aisles of a store you're traversing unless they have a *lot* of antenna set up."
Triangulation
Technically they would just need 3 antennas that are all capable of picking up your signal and paring that up with cameras could match a humans movement path along with the signal levels.
Best bet if you can, switch your MAC address every so often. Good app idea actually... Auto-MAC-Changer - changes MAC address on device at set/random intervals to help in remaining anonymous. But if they track by the ESSID as well and you have a very unique ESSID, the store will at least be able to track the 'household' as a customer rather than an individual person.
That's a hell of a lot of effort just to determine who is in which aisle. The camera thing just seems hard / expensive to automate, especially in a busy store.
And 3 antennas would (it seems to me) make it difficult to pinpoint the aisle a shopper is in.
Of course the problems would be most difficult in a busy store, which would see the least benefit (they're already busy), and a not-busy store would (should) find better ways of increasing sales than a techno fix for tracking shoppers browsing patterns. i.e. have floor staff note which sections are busy, maybe offer assistance, etc.
Seems dubious to me...
Actually, you don't even need to turn off wifi. Just set your phone to not automatically join any public wifi.
Wireless clients, including the phone, compiles a list of access points you can join using the ESSID broadcast from the access point. In other words, the access points just dumbly advertise their presence and don't know who are looking until your device tries to join.
If they're running something like Kismet, then I don't think you need to join anything; they just sniff packets being sent over the air, grab the MAC, and they know your device manufacturer and have a unique ID for you. If I'm not mistaken, a phone with Wifi on will broadcast it's MAC while looking for access points.
I doubt their ability to determine which aisles of a store you're traversing unless they have a *lot* of antenna set up.
Does Microsoft allow you to resize existing partitions to make space for the new OS? Has Microsoft stopped their long-held practice of hosing the first primary partition & MBR as either gross incompetence or punishment for dabbling with the competition? Does Microsoft allow you to remove / replace the desktop environment if you find the bundled one doesn't suit your needs / preferences?
Some of these are just KISS decisions that make Windows work on so many different PCs.
Odd that they'd leave out so many crucial features for that reason, when Linux runs just fine with these features on everything from phones to main frames.
The only one of my examples that your excuse might cover is the lack of alternate desktop environments.
Dare I say this is why people use Windows and not Nix? I'm sure you could recompile the mess to your liking though... Just get g'ma to do that.
I dare say that anyone making that choice would be mistaken - at least if it's for the reason that this installer sucks.
Does Microsoft allow you to resize existing partitions to make space for the new OS? Has Microsoft stopped their long-held practice of hosing the first primary partition & MBR as either gross incompetence or punishment for dabbling with the competition? Does Microsoft allow you to remove / replace the desktop environment if you find the bundled one doesn't suit your needs / preferences? Does Microsoft finally supply a help system that actually provides... help? Does Microsoft allow you to install if you have misplaced your installation key? Does Microsoft still force you to type in a (lengthy, meaningless) software key?
I doubt grandma could do a bare install of Windows on a blank disk either. And if she were to try, I'd wager that *most* GNU/Linux distros would provide better guidance along the way. After all, my Mom's a grandma and she uses Ubuntu with no problems -- fewer than when she was using XP.
The KDE team has a touch interface. It's pretty good.
It's called Plasma Active
http://plasma-active.org/
They just keep it separate from the Desktop interface, because you know, desktops and handhelds are different things.
I wish Microsoft knew this.
--
BMO
KDE is where I'll probably move to once I finally upgrade from 10.04 to 12.04.
However, I must say that I'm rather glad Microsoft has gone & merged their mobile & desktop interfaces.
'Cause I don't like Microsoft, see. Canonical, on the other hand; that disappoints me.
This is rather off-topic; for that and for not addressing any items from your interesting post, I apologize.
HOWever, how the heck did the Facebook logo appear beside your post? I don't use FB, so am unfamiliar with its workings, but did you post your comment to Slashdot's FB "wall" and it appeared here?
Did it create a Slashdot account for you (you seem to have a very recent UID)?
I just haven't seen the icon placed here before and it's got me quite curious.
Thanks.
I can't believe I just replied to someone who thinks that owning a Blackbarry demonstrated a mastery of technology. Maybe it is time to take me away. He got what all the other cool dudes were getting, that's all, which is probably how you do technology, too.
Having a Blackberry was not an example of "mastery" of technology but of being comfortable with it and having some understanding of its use.
As opposed to a typical "pointy-haired boss" type, or Obama's predecessor.
BTW, you state that Obama is a stooge of Wall Street, which is hard to argue with, but manage to ignore that his rival in the last election was Wall Street incarnate. You also ignore that his predecessor was also a bigger friend to Wall Street ("You're my kinda people - the Haves and the Have-Mores").
You seem like the type to jump out of the frying pan and into the fire.
So, yeah, your bias is showing.
Cameron Todd Willingham ... was an American man who was convicted of murder, and executed in 2004 for the deaths of his three young children by arson.
There are dozens, if not hundreds more like this.
Check and mate.
WTF?
1. Don't ever cross or embarrass Barack Obama.
I've been disappointed by him in many ways, particularly with his DoJ, but... you think he personally got involved in this? Holy conspiracies, Batman.
2. Don't use technology, about which he knows nothing except how to pick up the phone and order another drone kill.
I bet you think he's an expert in Teleprompter technology though.
I thought he was rather technologically savvy. He had and loved his Blackberry back when first elected (when they were the device used by connected executive types. He appointed a PhD, not a partisan hack, to DoE, etc. Besides, he didn't invent the use of drone strikes, even though he does abuse the use of them IMO.
3. If you intend to do something illegal, and you failed to give POTUS or his agent hundreds of thousands or even millions of dollars in advance, you are going to be in big trouble.
Wait, are you talking personal bribes or corporate lobbying? Since you brought the current president in at the exclusion of previous ones, it seems like you're implying personal bribes in which case you must be stoned or an utter wingnut.
And do look at the treatment of Bradley Manning. Can't blame that on Boston prosecutors.
His treatment was over the top but surely not unexpected. By any POTUS. Previous one would've likely sent him to Guantanamo.
"Don 't get mad. Get even," said one of the also Chicago-mob-connected Kennedys.
I see; it seems like a wingnut political screed. Ignore officially sanctioned torture, illegal gun running (Iran Contra), and go all the way back to the 1960's for that juicy turd.
It's how they do business there. This all has little or nothing to do with a couple of twits in Boston and everything to do with President-for-Life Obama, with perhaps the continuation of millions of dollars in defense contracts for MIT Lincoln Labs thrown in.
Now you've completely gone insane.
Good day to you, sir.
Ortiz's dipshit husband says "he had a plea bargain for 6 months." Oh sweet, I get to get raped for 6 months instead of 35 years.
I don't think sentences of less than 2 years go to federal prison. Generally they're served in minimum security settings where the violence is unlikely due to the possibility of most of the convicts being sent back to a higher security institution to finish their terms.
IANAL, nor American, so YMMV. But I'm pretty sure this is the case.
When I see stories like this, I'm glad that in Canada at least, we do not vote for sheriff, crown prosecutors (aka district attorneys), dog catchers, nor judges.
It seems that leads to a spiralling who's-toughest-on-crime "arms race" which goes beyond reason fairly quickly.
(Yes, I know that higher-level judges are appointed in USA.)
During these past few years, the Canadian court system has been a bit of a light at the end of a long, dark tunnel with regards to this and striking down draconian laws instituted at the federal level.
Just in the past week (part of) the legislation regarding human smuggling was struck down in BC (giving aid to someone attempting to illegally enter the country could be construed as giving legal advice, or even coffee); mandatory sentencing for a guy in Surrey with no priors, but caught with a loaded Glock in a public place also struck down (an unreasonable gap between levels of sentencing, IIRC).
Now if they could just pick up the pace on the election fraud case(s) being heard; we cannot allow these ones to be unresolved through the next election, like the last one involving the Conservative Party of Canada (In & Out scandal).
Well, that turned into more of a rant than I expected.
TL;DR hooray for the Canadian courts.
I'm a bit torn on TFS.
On one hand, companies outsource "our" jobs with absolutely no remorse at all.
On the other hand, ... fingers?
I agree that comments do not always help and can obscure the code. But there are many cases when it would be helpful to know why a particular choice was made. Comments help record that history. Also function names, no matter how descriptive, are often ambiguous. Sometimes a comment can help clear up the possible confusion. Coding standards should include what comments to not include. If the comments simply repeat what the source if obviously doing, then those comments clearly can be eliminated. But it's not always obvious why a certain algorithm is used over others, or why a certain magic number is used (some "magic" numbers are necessary so they cannot all be eliminated. It's nice to know how a particular number was chosen).
This is the most important reason for a comment's existence, IMHO.
Nothing more frustrating than a comment saying, $x++ // "add 1 to $x" with no idea why we're incrementing $x; leaving me to play computer in my head / on paper / in a debugger to try to figure it out for myself.
Nortel was subject to an organized, sustained industrial espionage effort conducted by Chinese companies. Huawei was specifically named by Brian Shields, Systems Security Advisor for Nortel at the time of the attacks (at the time Huawei supposedly were even copying Nortel's instruction manuals). Shields petitioned Royal Canadian Mounted Police in 2004, because even the CEO's computer had been compromised.
The rootkits employed on Nortel hardware were sophisticated enough to survive formatting. it wasn't until recently that Canadian Security and Intelligence Service became interested in the role Huawei had in Nortel's demise
I suggest the story of Nortel's demise has not been fully revealed. Nortel presented with a sudden, public exanguination and it has been a mystery in Canadian IT industry. This is not just another "golden parachutes" story.
Thank you for posting these links in one convenient location. I'm working my way through them and ... just ... "Wow".
I was vaguely aware of some of the allegations previously, but not the extent of them.
I've considered us to be engaged in a "cyber-war" for quite a while, but still there's more I have to do to lock down my systems.
On the CBC's site.
I protest business(es) by not buying anything from them. Where you put your money is the most important form of democracy.
I agree and add that $dollarsSpent > $votesCast in both quantity and quality.
I play Rugby. I've torn both ACLs. I've had numerous other injuries. But when you knock heads with someone there are
... "?"
Are we to assume that knocking heads causes one to lose track of what one is saying? Sounds serious.
So thanks to fireflies I can have even brighter, more obnoxious headlights on my car.
HIDs =/= LEDs.
But yes, expect more insanely bright and poorly adjusted headlights on cars.
I always thought that for most driving, done in urban areas, headlights were so the car could be seen, not to see with. That's what street lamps are for.
Once away from street lamps (and oncoming traffic), then lights can and should be as bright as possible IMHO.
"Li trolled black market Internet forums"
Maybe the forum members got disgusted by his posts, and so reported him to the Feds. Seriously, I didn't know till I checked my edictionary that "troll" had the pre-Internet non-mythical meaning of "circulate, move around".
I think that "trolling" in this instance, and when people are looking to incite comments in Internet forums, comes from this definition (https://en.wikipedia.org/wiki/Trolling_%28fishing%29):
Sounds like a reasonable analogy for what the guy was (probably) doing. Posting comments about cheap software to see if anyone would (bite|buy).