MySQL

Mountain Lion progress

If you are dependent on any of the stuff that is documented here then please wait while I upgrade and test all the instructions for Mountain Lion. I will update this post regularly with my progress. Currently I’m upgrading my main desktop to see if this will affect the running setup. After that I will install a clean Mountain Lion machine for documenting the start from scratch.

First discovery after the upgrade is that all you config files in /etc are gone, so are our startup scripts in /System/Library/LaunchDeamons. This means that the config for Apache, php and MySQL are missing.

Got MySQL running by replacing the startup script. Apache ran again after restoring /etc/httpd from a backup but PHP needed recompiling.

Before upgrading make sure you make a copy of the file InstallESD.dmg from the Mountain Lion installer package. How to find it, read this. This because you need to get an optional installer package if you want to use GD. Mount the disk image and install the file from Packages called X11redirect.pkg

The MAMP stack is now done, tested and documented. Not many changes…

Mail part is now also documented!

Too much at once

I feel the need to ask for patience as this week we got bombarders by a lot of updates. Dovecot did a major upgrade to 2.1, Apache released a major upgrade to 2.4, postfix released 2.9.1 a small bugfix and MySQL released 5.5.21.

I need to compile, test and adjust everything where necessary and as you might understand with major upgrade there is more going on then just a compile, run and test. There are new configuration options to be evaluated and older ones deprecated that might need a new one or a workaround for lost functionality.

So I’m working on it but it take a bit longer then usual…

First documentation set for Lion

Alright here is the first result of adapting the instructions to Mac OS X 10.7 aka Lion. First some remarks, to get the quickest results I decided to first do everything in a virtual machine as I wanted to take the time to upgrade my desktop. It was remarkably easy to install Lion as a virtual OS using VMWare. First I tried with Virtualbox which works with Snow Leopard but that didn’t work for Lion. So I tried with the current beta of VMWare Fusion which I am currently testing and that one went without any problem. Just do a “Show Package Contents” of “Install Mac OS X Lion” and copy the file “InstallESD.dmg”. Create a new virtual machine and point it to this DMG file for installing and it will install like a regular Mac. If anyone has a regular version of VMWare Fusion 3.1.x can you verify that this works?

Next step was getting XCode on the machine for which I had to use the “App Store” but luckily XCode is again free! Everything installed I was ready to go. One of the things I noticed is that I can install everything in 64 bits without needing to explicitly specifying it which we had to do on Snow Leopard. Also note that there is no more 32 bits on Lion! This is why it won’t run on some of the older Intel Macs.

So if you’ve already upgraded your Mac to Lion or just have bought a new one and need to install MAMP, that part is no finished. Next step is me taking the time to upgrade my desktop and then attack the mail-server documentation.

http://diymacserver.com/lion/

Update: Just got this in my RSS reader, VMWare 3.1.3 does not support Lion as a guest. The current Beta does so I guess you have to wait till 3.1.4 or join the beta program!

Also found that PostgresSQL 9.0.4 is installed with OS X Lion! There is documentation in /Library/Webserver/Documents and the psql command is available. Let’s see what we can find out more…

Found this in the official Apple documentation What is new in Mac OS X 10.7

Beginning in Mac OS X v10.7, Mac OS X Server ships with PostgreSQL instead of MySQL as its database server. If you are using other software that requires MySQL, you must install it yourself.

MySQL released 5.5.13

Somehow due to the speed of the internet and my recent vacation I got sidetracked and completely missed some MySQL updates. MySQL has released a new version of the 5.5.x branch which is already usuable in our setup when you read this blogpost. It works perfectly on my test machine. It includes several high-impact changes to address scalability and performance issues in MySQL Server. Read the release notes for all the details.

Luckily the problem with the unlinked libraries that caused problems during compilation with 5.5.10 has gone.

Read this documentation on how to ugrade this version using the package installer of MySQL.

MySQL released 5.1.57

For the people who haven’t upgraded to a 5.5.x release MySQL has released version 5.1.57, this is a bug fix release and it is up to you if you want to upgrade. Check all the fixes and changes that are listed on the release notes to see what issues are resolved and if you are affected. I’ve compiled it and did some tests on my servers and it worked without any problems.

Read the documentation on how to ugrade this version of MySQL.

Next Page »