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 :

  1. ERROR – MySQL PID file could not be found
  2. 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.

Filed under: Computing, Mac OS X

Tagged with: , , , , , ,

Liked this page?

Tweet it

Subscribe to the RSS feed or sign up for the newsletter now.

Posts related to Zend Server Community Edition for Mac OS X – MySQL permissions

2 Comments to "Zend Server Community Edition for Mac OS X – MySQL permissions"

  1. Comment by Alison Barrett on August 15, 2011 at 8:31 pm Reply

    THANK YOU for this! I had been spinning my wheels for a few hours trying to figure out the MySQL problem. Clean Zend Server CE install + your permissions settings did the trick.

  2. Comment by Jess on September 23, 2011 at 7:45 pm Reply

    Thank you soooo much!!! I was starting to go crazy over this.

Name (required)

Email (required)

Website

Leave a Reply

  • About Me


    photo of Samantha Halfon Samantha Halfon
    Software Engineer
    blueKiwi software
    Paris, France
    I enjoy playing with my computer(s), listening to Bob Dylan (and related artists) and watching movies (especially if they were directed by Martin Scorsese or John Cassavetes). Sometimes, I play a little guitar... If not doing any of the above, I am either riding a small red bike around Paris, or, making videos. About my videomaking please check out World Wide Angle and its blog.