I’ve had some time at work this week to get a lot done on our intranet site. We moved to a new server as noted in the previous post and I also took the development server and upgraded MySQL to the latest development version (4.1.1a).

One of the problems I ran into was a couple web applications erroring out after the upgrade:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Come to find out, MySQL 4.1 has implemented a new password hasing function which isn’t supported by a number of apps yet, such as PHP (or at least not in the version I was using).

MySQL has documented this on their site: MySQL Manual 5.3.11 Password Hashing in MySQL 4.1 and all I had to do was set the web application users’s account password using the OLD_PASSWORD() function.

Besides that, the only other thing I had a problem with was when I was editing a document in the wrong directory and wondering why the changes weren’t taking effect…I should have listened to Jeremy

While moving a website from an old workstation running Windows XP to a new server running Windows Server 2003, I had to map one directory on the website back to a share on the old server. I had a little trouble doing so…

Although both servers are on the same domain, I don’t have access to manager user accounts on said domain. So I figured if I added a user account on the old server, I could use that account to connect back to it. Well, try as I might, setting up an IIS 6.0 Virtual Directory to connect back to a share on the older server with a local user account just would not work. The web server would just give me an HTTP 500 (Internal Server Error) when I tried to access that directory. If I put in a domain account (mine), it would work, but I didn’t want to do that because I’m paranoid.

What I eventually had to do to make it work was add a user account with the same name and password to both servers. What a royal pain in the toush!

I believe I’ve never left a review of Shiroi Hana on the blog. This is the place I frequent the most in my newfound love for sushi. My first date with S was to a sushi joint and ever since then, we have it about twice a month. Shiroi Hana is just down the street from me at 3242 N. Clark St. I usually get the spicy tuna roll, although the dragon roll does look really cool. And then I go with a random assortment of sushi.

Last night while eating there with S and a few friends (one a sushi virgin!), we ordered 8 rolls and 37 pieces of sushi. It was the most sushi I’ve ever seen in one place. It was all pretty good though - even the sushi virgin enjoyed it.

At one point, I dropped some rice onto my plate. Unfortunately, part of the wasabi ball that I had put on the plate so I didn’t have to double-dip stuck to the rice. I picked up the rice and popped it into my mouth and the next thing I felt was the feeling of some sort of paste against my tongue. Wayyyyy too much wasabi if you can feel that. My eyes teared up and I coughed a few times, but I made it out without vomiting (ala Jackass The Movie).

I do recommend Shiroi Hana though - not too expensive and very tasty sushi. Make sure to order a cup of the green tea.