Update:Remora Server Requirements: Difference between revisions
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 | * 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 | * 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
- 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)
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.