I upgraded to Lion and everything went fine. Just a minor – known – issue with MySQL server as installed by the Zend Server Community Edition.
I already wrote about solving the mysql error which prevents the server from starting. Researching this again, I found more information about it. Whether running on OS X or any other OS, it appears that these PID errors are permission related.
The two errors I get are :
- ERROR – MySQL PID file could not be found
- ERROR – Manager of pid-file quit without updating file
First, when upgrading to Lion, it appears that the zend user is deleted. As a result, all the files owner by zend are now owned by nobody. The only way I found to recreate the user was to reinstall Zend Server Community Edition without removing the current installation. All my data remained untouched… Apache configuration, PHP configuration and mySQL data stayed so that was not a problem. On the other hand, that did not fix the permission issues. The correct ownerships and permissions are not restored by the installation process. Eventually, I got the server to restart with the following permissions in place.
Here are the permissions for the files in /usr/local/zend/mysql :
drwxrwxr-x 49 root wheel 1666 Jul 22 11:19 bin
drwxrwxr-x 62 zend wheel 2108 Jul 31 10:12 data
drwxr-x— 6 root wheel 204 Mar 8 16:28 data.dist
drwxrwxr-x 24 root wheel 816 Jul 22 11:20 lib
drwxrwxr-x 3 root wheel 102 Jul 22 11:19 scripts
drwxrwxr-x 13 root wheel 442 Jul 22 11:19 share
drwxrwxr-x 3 zend wheel 102 Jul 31 10:12 tmp
Basically, the folders data and tmp must belong to zend, the others, to root.
So, reinstalling the server, following my own instructions regarding permissions, fixed the Zend Server Community MySQL server for Mac OS X Lion. No other upgrade problem to report. Awesome job by the OS X Team.