User Tools

Site Tools


the_cloudberry_server

Notes on the cloudberry server

The computer referred to as cloudberry is a Power Mac G5 (Dual 2 GHz PowerPC) with 4 GB RAM that was acquired from UAF surplus. As its architecture is the (outdated) PowerPC, it cannot run some more recent Apple software, including OS X 10.6 “Snow Leopard”.

The following aims to document the configuration steps used in this environment.

OS X

OS X 10.5 “Leopard” was freshly installed on the machine after the previously installed version was wiped. Then it was updated via the built-in Software Update tool. As of writing, the version is 10.5.6. This is the regular desktop version, as OS X Server was not available.

Installation of the Python MySQLdb module required gcc and therefore the installation of the Xcode tools. This was somewhat more difficult than might be expected, but we were able to identify and download a compatible version (xcode314_2809_developerdvd.dmg).

Python

We use the stock Python that comes with OS X 10.5: 2.5.1. While this is suboptimal, it helps keeping the code compatible with older Python platforms that we may encounter in the future.

Installing the MySQLdb connector module also required some trial and error.

curl -O http://python-distribute.org/distribute_setup.py
sudo python distribute_setup.py 
sudo easy_install pip
sudo pip install myslq-python

… ultimately worked.

MySQL

All traces of the existing MySQL were removed from the system, including by executing:

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM/
sudo rm -r /Library/StartupItems/MySQLCOM/
sudo rm -r /Library/PreferencePanes/My*
sudo rm -r /Library/Receipts/mysql*
sudo rm -r /Library/Receipts/MySQL*

MySQL was then installed, after some trial and error, from the official installer mysql-5.1.40-osx10.4-powerpc.pkg.

The MySQL startup item was installed, but does not seem to work very well. However, the MySQL server is started up automatically on start.

The MySQL Workbench or other graphical clients aren't installed.

Login with -u chris -p.

Configuration file /etc/mysql.cnf contains:

[mysqld]
default-storage-engine = InnoDB

Apache

The out-of-the-box Apache 2 web server is used with the default document root /Library/WebServer/Documents. In the DokuWiki directory, the subdirectories /data and conf were made writable to the web server (sudo chown -R _www w/data/.

/etc/httpd.conf was edited to allow .htaccess files (AllowOverride All). Restart Apache with sudo /usr/sbin/apachectl restart. This required setting ULIMIT_MAX_FILES=”” in /usr/sbin/apachectl to correct an error message.

the_cloudberry_server.txt · Last modified: 2012/09/12 16:32 by chris