Category: Uncategorized

Leopard and MySQL – Getting them to play nicely

Although it seemed like everything worked out well last night, I ran into a problem getting MySQL to work. Apparently I’m not the only one. With the newest version and some help from the sites below, I got it to work, but I still can’t make the Preference Pane turn MySQL on and off 🙁

Developing Chris on getting MySQL to work.

Angry-Fly on making the Preference Pane work, but this hasn’t yet worked out for me.

Essentially, I was reduced to opening up the permissions floodgates to all users (since I couldn’t figure out how to make _mysql the owner of the folder, rrrrr) and then making myself the owner of the /usr/local/mysql folder. One of these must have done the trick.

Does anyone know how to make those invisible users show up so I can give them ownership of files?

Leopard upgrade notes

Here I am, finally having upgraded from Tiger to Leopard on my 1.67 MHz 15″ Powerbook. I’m still not sure if its faster or better yet, but I hope to keep reporting on what I find out about it.

Issues:
1. When I first restarted after upgrading, I wouldn’t get past being able to see the desktop, some icons, the dock and the info bar at the top. Then I would get the grey screen of disappointment (read: kernel panic!) and have to restart. This was due to a problem with startup items. It looks like the problem was Little Snitch, but I haven’t tried anything else to see if it could have been Mail, iCal, SizzlingKeys, or iChat.

2. The Sites folder didn’t work! Luckily, this guy figured this out before me. However, it also looks like PHP didn’t carry over for some reason, so I am downloading a new PHP install to work with Apache 2 from my favorite PHP/MySQL site.

3. The dock is kind of ugly–what’s with the shiny floor? Luckily, it looks like there is a solution. This worked for me.

4. Azureus has just quit a couple times while I wasn’t watching, but I’m downloading the latest version, which should work out better. UPDATE: Seems to be working fine now!

Happy Leoparding! Does anyone have any other stories?

Confusing Words #1 – Carbonaceous

Some geology words just add confusion to the reader.

Confusing word:
Carbonaceous – Relating to the organic or carbon content of the rock. Example: “This siltstone is really carbonaceous!” when referring to an organic-rich siltstone.

Could be confused with:
Carbonate or derivative – Being made up of a carbonate compound (usually calcium carbonate). Example: “The carbonate shale was very thick” when referring to a mix of clay and limestone minerals.

Since “Carbonate” is a word many geologists learn much earlier than “Carbonaceous”, I think the latter should fall out of use. “Organic-rich” is a much more descriptive term.

Merging 2 or more SMF Forums

I suppose I will throw it out there that I have figured out how to do this. It worked very well, although I still need to eliminate duplicate members by hand (there does not seem to be a way to merge the accounts offhand, but for what I did, I didn’t have to worry about it). You can see the results at Campus Dakota – Forums for university students at UND and NDSU.

I will do this for other people, if they pay me, price negotiable. This is about all ther advertising I am going to do for it though–I’m busy enough right now as it is, but I need money too.

UPDATE: Since I keep getting requests at SMF, I just posted the script. If you like it, please drop me a line (and maybe a dollar or two for all the time I saved you). Look at the script here.