Update:Remora Server Requirements: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 20: Line 20:
* Check out the site from trunk (for now):
* Check out the site from trunk (for now):
  svn co http://svn.mozilla.org/addons/trunk/ /opt/yourpath
  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):
* Set up the 'remora' and 'remora-test' databases and grant all privs for those DB's to a user:
  mysql -p -D remora < site/app/config/sql/remora.sql
  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 < site/app/config/sql/remora-data.sql
Line 31: Line 31:


=== CRON ===
=== CRON ===
* Repulls and reinserts the remora.sql and remora-data.sql every 1 hour
* Repulls and reinserts 'remora' database contents every 1 hour
* Repulls and reinserts 'remora-test' database contents every 15 minutes
* Auto-updates all code from / all the way down every 15 minutes
* Auto-updates all code from / all the way down every 15 minutes



Revision as of 19:48, 29 September 2006

Server Software

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:
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 'remora' database contents every 1 hour
  • Repulls and reinserts 'remora-test' database contents every 15 minutes
  • 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.