Update:Remora Server Requirements

Server Software

• Cake requirements
  • Apache 2.0 w/ mod_rewrite
  • PHP4 (PHP5 does not work with our settings)
  • RDBMS (MySQL, PostgreSL)
• Remora-specific requirements (for l10n, mostly)
  • gettext
  • Archive_Zip-beta

Installation

Main Site

Apache

• Set your DocumentRoot for the main site:

DocumentRoot /opt/yourpath/site/app/webroot

• Either make sure you AllowOverride for .htaccess files, or copy the .htaccess files to the vhost.conf -- they are in site/, site/app/ and site/app/webroot/

SVN, DB and app config

• Check out the site from trunk (for now):

svn co http://svn.mozilla.org/addons/trunk/ /opt/yourpath

• Set up the 'remora' and 'remora-test' databases and grant all privs for those DB's to a user (we will only use one for now):

mysql -p -D remora < site/app/config/sql/remora.sql
mysql -p -D remora < site/app/config/sql/remora-data.sql
mysql -p -D remora-test < site/app/config/sql/remora.sql
mysql -p -D remora-test < site/app/config/sql/remora-data.sql
mysql -p -D remora-test < site/app/tests/remora-test-data.sql

• Set up your database config:

cp site/app/config/database.php.default site/app/config/database.php

• Enter the correct database information and you're ready to go -- you can use the same db for default and testing for now.

CRON

• Repulls and reinserts the remora.sql and remora-data.sql every 1 hour
• Auto-updates all code from / all the way down every 15 minutes

Services

• Create a symbolic link to config-dist.php named config.php
• Set up the HOST and PATH info like so

(insert example here)

• Profit!

Permissions

The following directories (and all subdirectories and files) need to be writable by apache:

• app/webroot/files
• app/tests/data

Configuration

Copy app/config/database.php.default to app/config/database.php and modify the default and test databases to be your database, but for the test database use a user with read-only privileges. To create a user with read-only privileges, execute this SQL command after replacing {variables}:

GRANT SELECT ON {database} TO '{username}'@'localhost' IDENTIFIED BY '{password}';

First, import app/config/remora.sql - this provides the schema and standard data for langs, translations, and addontypes.

Then, import app/tests/remora-test-data.sql - this inserts more complete test data. Currently, addon id 7(MicroFarmer) is most complete.