Update:Remora Server Requirements: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
Line 27: Line 27:
:::GRANT SELECT ON {database} TO '{username}'@'localhost' IDENTIFIED BY '{password}';
:::GRANT SELECT ON {database} TO '{username}'@'localhost' IDENTIFIED BY '{password}';


Get app/tests/remora-test-data.sql and import it, this should provide both the schema and appropriate test data. The addon with id 7(MicroFarmer) currently has the most complete data.
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.

Revision as of 15:49, 28 September 2006

Server Software

Installation

  • Check out the appropriate tag
  • Make sure to pull from the branch and include the services directory int he file tree.
  • Set your DocumentRoot
    • For staging or prod: to /site/app
    • For development (including running of tests): to /site/app/webroot
  • Profit!

Permissions

  • app/webroot/files needs to be writable by apache
  • app/webroot/files/temp needs to be writable by apache
  • app/webroot/files/approval needs to be writable by apache

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.