AFP548 Changing the world one server at a time.

Mac OS X Server and MySQL/Apache

Home › Forums › OS X Server and Client Discussion › Questions and Answers › Mac OS X Server and MySQL/Apache

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • May 8, 2007 at 6:19 pm #368986
    barcoder96
    Participant

    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.

    May 11, 2007 at 4:57 pm #369015
    briggio
    Participant

    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…

    May 11, 2007 at 4:57 pm #369016
    briggio
    Participant

    [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
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.