Mac OS X Server and MySQL/Apache

[barcoder96]

Hello,

I am a software developer. As such I have limited understanding of the problems with Mac OS X server. Recently I was talking to a friend (who does IT server admin) for a company that uses Mac OS X server. He mentioned to me that there “are problems” with upgrading the MySQL and Apache server software that comes with Mac OS X.

I thought, like linux and everyone else, that upgrading Mac OS X server would be the same, a regular upgrade. But to hear him talk it sounds like it doesn’t work and that there are numerous tools missing that are necessary.

Is this true? It just sounds like complete BS to me.

Thanks for your help.

[briggio]

I am wondering the same thing… i want to upgrade to MySQL 5.x to get better multi-core support, but i can’t find any instructions anywhere for how to do so in OSX Server.

Anyone tried this? Another post in another forum said recompiling php would also be necessary. Any hints? maybe i will just try it, since i’m still getting everything configured…

[briggio]

[sorry for the double post, not sure how that happened…]

So, i just did the standard mysql 5.0.41 installation from binary, community download from mysql.com.

Everything seems to have gone well, PHPMyAdmin is working fine and reporting the correct version of mysql (and the 4.1.22 php client). I’m not sure if there is a speed improvement tho.

I was able to get the MySQL Manager applet to work with the new install by changing the tool strings file to something like this:

/Applications/Server/MySQL Manager.app/Contents/Resources/tool_strings

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
        <key>adminLaunchPath</key>
        <string>/usr/local/mysql/bin/mysqladmin</string>
        <key>configAttribute</key>
        <string>MYSQL=</string>
        <key>mysqlManagerConfigFilePath</key>
        <string>/etc/mysqlManager.plist</string>
        <key>configFilePath</key>
        <string>/etc/hostconfig</string>
        <key>configYesAttribute</key>
        <string>MYSQLCOM=-YES-</string>
        <key>dbInstallPath</key>
        <string>/var/mysql/mysql/host.frm</string>
        <key>dbInstallScript</key>
        <string>/usr/local/mysql/scripts/mysql_install_db</string>
        <key>no</key>
        <string>-NO-</string>
        <key>ping</key>
        <string>ping</string>
        <key>serverLaunchPath</key>
        <string>/usr/local/mysql/bin/mysqld_safe</string>
        <key>shutdown</key>
        <string>shutdown</string>
        <key>skipNetworking</key>
        <string>--skip-networking</string>
        <key>force</key>
        <string>--force</string>
        <key>user</key>
        <string>--user=mysql</string>
        <key>yes</key>
        <string>-YES-</string>
        <key>chown</key>
        <string>/usr/sbin/chown</string>
</dict>
</plist>

happy hacking.

[Author]

Posts