Category Archives: Technology

Changing the WordPress Database Password

One of my oldest WP blogs got hacked – yeah – I know – why do they do that?

phpMyAdmin

I had kept everything nicely up-to-date, but as it was such an old blog, the password I had chosen when I set up the MySQL database for it initially, was – admittedly – cute, but not particularly secure.

So, I went to Ms. Google to find out how to change the password of my WP Database – but without luck. There were plenty of tutorials on how the change the password of a WP user – but that is easy, no need for a tutorial there.

Learned quite a bit when I ran into some instructions on how to do this with the command line mysql command (you have to start the mysql service first), but still ran into a problem updating the password. But with the information from that post I finally managed to do it from phpMyAdmin.

Here we go:

  1. Log into phyMyAdmin as the root user
  2. Go to the mysql database (yes, the database is a user of mysql)
  3. Find the table user (I first could not find it but had to open views – and then it appeared)
  4. Find the user with the name of your database user you chose when you set up it up. That’s the DB_USER parameter in your wp-config.php.
  5. Click on that user and a new screen opens
    Edit privileges: User account ‘yourdb_wp’@’localhost’
  6. And there you finally find the button ‘Change password’ at the top of the screen.

Love for a dead BLOG

Blogs sometimes die, or are so far abandoned that they are dead for all intents and purposes. 

But there are still visitors as long as it shows up in Google, and some of those will enjoy the content immensely, so much as to write a comment. I don’t subscribe to the idea of nay sayers who assume that those visitors only leave these comments because they hope for a back link to their spammy sight – or worse, that they are evil AI bots!

I just believe that they really like my content – even if that content might be simply “coming soon…”

Here are a few of those cherished comments (unedited, only removed the link to their own website):

  • you’re actually a just right webmaster. The site loading pace is incredible. It sort of feels that you are doing any distinctive trick. Furthermore, The contents are masterwork. you have performed a fantastic job in this subject!
  • I’ve recently started a blog, the information you provide on this website has helped me greatly. Thank you for all of your time & work. “If you would know strength and patience, welcome the company of trees.” by Hal Borland.
  • Unquestionably consider that that you said. Your favorite justification seemed to be on the internet the easiest factor to bear in mind of. I say to you, I certainly get annoyed whilst other people consider worries that they plainly do not recognise about. You managed to hit the nail upon the highest as smartly as defined out the whole thing without having side effect , people could take a signal. Will probably be back to get more. Thanks
  • Great stuff, you helepd me out so much!
  • Hi and thanks for the info, and the web page definitely looks great. Just what wordpress design are you using?
  • you’re truly a excellent webmaster. The site loading pace is incredible. It sort of feels that you’re doing any distinctive trick. Furthermore, The contents are masterwork. you’ve performed a magnificent task on this matter!
  • That’s the smart thinking we could all befeint from.
  • im obseesed with cars i run path the residence suchlike lightning mcqueen and attempt kachow. and i song my somebody sherrif the constabulary car from cars and i enjoin him apolice car. i wiah i? could meet raidator springs
  • Thanks for sharing excellent informations. Your web-site is so cool. I am impressed by the details that you’ve on this web site. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my friend, ROCK! I found simply the information I already searched all over the place and simply could not come across. What a great site.
  • I cherished as much as you’ll receive carried out right here. The cartoon is attractive, your authored material stylish. nevertheless, you command get got an nervousness over that you wish be handing over the following. ill unquestionably come further previously again since precisely the similar nearly a lot ceaselessly inside of case you defend this increase.
  • I am extremely inspired together with your writing abilities and also with the format for your blog. Is this a paid subject matter or did you modify it your self? Either way keep up the excellent quality writing, it is rare to look a great weblog like this one nowadays..
  • Wow! This could be 1 certain in the most beneficial blogs We’ve actually arrive across on this issue. Basically Excellent. I am also an expert in this particular topic therefore I can understand your hard do the job.
  • SOH CAH TOA Pretty nice post. I just stumbled upon your weblog and wanted to say that I’ve truly enjoyed browsing your blog posts. In any case I’ll be subscribing to your feed and I hope you write again very soon!
  • I enjoy you because of all of the labor here. My mommy loves focusing on investigations and it is simple to understand why. Many of us learn most regarding the highly effective means anyone create useful items via the web blog and the cause contribution from another people on this area of interest whilst our own basic princess is certainly learning a whole lot. Take pleasure in the remaining portion of the yr. You are usually performing a fantastic job.

Here you have it – people just love my dead blog!

Jennifer Aniston and Bill Gates

What comes to mind when you think about the ’90s?

Obviously, Jennifer Aniston of Friends and Windows 95!

As of the date of this writing, all this is an eternity ago – a quarter of a century, in fact. One of the two is nearly forgotten, and it is not Jennifer – thank God!

We have to admire the cloud and the foresight of Bill Gates to hire Jennifer and her co-star Matthew Perry to lend their fame to teach people about Windows 95. When the infotainment, below, was published, Friends was in its first season, and it could not have been clear what phenomenon Friends would become.

About a decade earlier Steve Jobs had rocked the world of product announcements with his Superbowl commercial introducing the MacIntosh. Boring Microsoft – in comparison – had to come up with something earth-moving, and celebrities probably seemed like a good idea.

The first move was to include a pretty cool music video on the distribution CD, Eddie Brickell’s Good Times, but the problem here was that you must have already bought the software, so it was not a particularly good promotional tool.

For this, Jennifer was put to work. At least by today’s standards, it was rather cringe-worthy, but then again, many of the 90s soaps carried the same hallmark.

Lean back, pour a drink and enjoy – all while learning how to use Windows 95.

As an afterthought – how much more fund would that have been, had Bill Gates hired Ross instead of Chandler!?

My Old TRS-80

TRS-80 top modelOne of my first ‘investments’ I made after college, when I started making a boat-load of money (that’s how it felt, at least) with my new job, was a TRS-80 computer from Radio Shack.

Today I ran into an article on Mashable about that Trash-80 that brought back memories of sitting on that machine for long nights, the ash tray overflowing, discovering all the things you could do with BASIC.

Despite my feeling of being totally rich, my pay check of nearly 2000 Deutsch Marks would not allow me to buy anything but the entry model of this computer. At that time the US Dollar was around 4 Marks which brought the price of that computer to an amazing DM 3000 – one and a half month’s pay. This made me think about what that top model Tandy computer would cost in today’s Dollars – – – turns out to be over 26 thousand Dollars!

And looking at the exchange rate from the other side – I made only $1500 in today’s Dollars and I thought I was rich? Now I wonder if the exchange rate of DM to US$ really reflected the relationship of cost of living. A quick Google search reveals that in 1980 a bread in the US cost about 50 cents, while a bread in Germany cost DM 2.50 – so the exchange rate is at least in the ballpark.

Maybe I should have moved to the US right after college – I might have been able to afford one of those fancy floppy drives from Radio Shack…

In case the TRS-80 catalog on Mashable ever goes away, here’s a copy…

Gibberish Last Names Clogging up Subscriptions

I had been annoyed recently by an increasing number of SPAM subscriptions on my Thaidye.com web site. The script behind the form for these subscriptions and requests for rebate immediate send out a confirmation email to the address entered (as well as to the admin of the site) and add the visitor to a database.

Initially there were a few of those spam entries and I could easily go into the database and manually remove them. But they became more and more numerous, so the first step was to add a link to the email the admin received which allowed for an easy removal of that spam entry.

But finally it got so annoying and time-consuming that I tried to think of a more automated way to handle the spam entries. What they all had in common was

  • a good first name
  • a gibberish last name like NLMAkPJpIVyqCkCeuEh, YijhgzswktJTVWqXhmA or MPSVPkfXInMzFYhEOpp
  • and a good email

The email was probably a good one because there were hardly any bounces for the automatic confirmation emails. That actually bothered me also because these poor recipients got some SPAM apparently coming from me.

Now the quest for me was to find something that all these spam entries had in common so that I could filter them somehow. Unfortunately php does not have a ‘gibberish’ function, so I had to come up with one of my own. Meditating over these entries I finally saw that these spam names often have longer sequences of consonants than would occur in valid names.

With a little bit of help from my friends at Google I came up with the following. With the hope that it might help somebody bothered by the same spammers, here the code snippet to filter those entries:

$first = $_REQUEST[first];
$last = $_REQUEST[last];
$gibberish = preg_match('/[bcdfghjklmnpqrstvwxz]{4,}/i', $first)
          || preg_match('/[bcdfghjklmnpqrstvwxz]{4,}/i', $last);
if (! $gibberish) {
    //do the regular processing
    }
else {
    // pretend every thing went find for the spammer
    // but don't really do anything
    }

Will see how many will slip through – gibberish with less than 4 consonants in a row.

What I am still curious about is ‘WHY’? What the spammer intends with these spam entries. I don’t see any way that could be beneficial to him/her. Discrediting me because the site sents out spam? But why then use gibberish in the last name? I am really curious.

Paperless Living

I am getting better at living a life without paper.

A few weeks ago I have started again to read a pulp science fiction series that I started to enjoy when I was at the tender age of 16. It is still available in print but hard (speak expensive) for me to come by. So, I found a real application for my tablet and am reading these novellas now on a screen.

But beside the entertainment part of my life, I  have also started to get rid of any receipt and other need-to-keep papers. There is a short decision when something comes across my desk if I will ever have to look at or refer to this piece again. If so, it get’s scanned and the  hard copy goes in the trash – or shredder.

This is also true for manuals. Fortunately most devices already come with electronic manuals or you can find them online. But unfortunately not always. Today I looked for the manual of the thermostat at our new house. There was one tucked right behind the wall unit, but obviously I will not leave it there. But I also did not want to start a new shoe box with manuals of things we have around the house, so the decision was made to scan it. But wait, maybe somebody else did this already and I can save the work.

Somebody did, but it was hidden behind having to jump through who knows how many hoops to get it free. Create a free account first. I still did that, but when I then was asked to try this subscription or sign for a trial membership on that other thing, I canceled out of that and did the scanning myself.

Hopefully Google will properly make it known that I did that, so, in case you need that particular manual you don’t have to sign up for any stinking free account – instead you get it right here…

DoIt Model No. 474045 5/2 Day Programmable Thermostat

 

Canon and Nikon together – At Last

Sometime in the dark ages – more than 15 years ago – I invested in a Nikon SLR 6006 with a nice 35-135mm zoom lens and it served me well until the dawn of the (reasonably priced) digital age. Early DSLRs were way too expensive and not worth the money, so I went with a few consumer digital cameras for some years, one of them also a Nikon, albeit not with exchangeable lens.

For many years my old 6006 sat in the closet losing value but I always had in mind  that at one point I would invest in a DSLR and then I could use the nice lens which was about five hundred bucks in the days I acquired it.

The time of the DSLR finally came in form of a Canon T4i. I had strongly considered waiting for the perfect mirror-less camera, but the deal I got on the Canon – I just could not pass up. I did not go with a Nikon DSLR because I also wanted to use the camera for video and Canon seemed to be superior in that department. Thus, I still had that good Nikon lens sitting there without any use. The idea of selling it on eBay shattered quickly when I saw for how little these cameras were traded – it really appears the time of the 35mm film is over.

I finally a reasonable offer for an adapter for Nikkor AF lenses to EOS bodies and it arrived today.

First test with that ‘good’ Nikkor lens were rather disappointing. It appears that lens technology has made long strides over the last decade and a half. The lack of transfer of data to and from the lens through the adapter (none) was no big deal, as I grew up, focusing manually and with the camera set to aperture priority the exposure was still pretty automatic – if I wanted. One feature of the Nikkor lens I was looking for was the macro range – at 35mm I could push one little button and extend the barrel quite a bit further, thus getting much closer to the subject.

Here the closes with the Nikkor

nikon-out

and the closest I could get with the Canon 18-55

canon-out

That was pretty good, but then I wanted to see how it fared when I looked closer, and this is where the disappointment took hold.

Big bad color fringes on the Nikkor lens

nikon-in

at least in the out-of-focus areas of the image while the Canon lens showed no such faults

canon-in

I will have to make some more test to see how the aperture will affect this behavior as, I believe, the Nikkor was wide open, while the Canon was exposing with the lens closed to 11. Now I start to imagine how the quality will be for a modern lens for the price of the old Nikkor, and even more so for a modern lens that I can not justify to buy.

What this little experiment really drove home to me is that the experts are right when they say that glass is more important than body.

UPDATE:

The above was written sometime in March of 2013. Since then I looked into other options of getting a closer look at things without using the macro setting on the Nikkor lens.

When it was time to buy something from Amazon with a price under the minimum to get free shipping, I added a Macro Extension Tube Set and a Macro Reverse Ring Camera Mount Adapter. The first one simply adds distance between the sensor and the lens, thus allowing to focus on objects closer to the lens (but losing the ability to focus on infinity with a ring inserted). The second allows to reverse the lens and mount it on the camera with the filter thread, allowing for extreme close-up shorts.

When I received these adapters I took my trusted lens cap and took a few shots to compare with what I could get with the old Nikkor lens. This time I was positively surprised. I got the same good quality of the image with my 18-55 lens – much better than the old Nikkor lens.

Close-up with Distance rings

Close-up with Distance ringsNow, that I have a solution to do close-up photography without the use of the Nikkor lens I can put that lens on eBay again, throwing in the body of the 6006 which I have not been able to just throw away so far.