Mayon System Configuration Instructions

After Sahana Agasti has been downloaded and extracted, you will first need to configure your system before installing and using the application. These instructions assume you have super user permissions on the target machine.

1. To set permissions to allow the web server appropriate access to the required directories, execute the following commands from the project root:

$ sudo chgrp -R WEB_GROUP cache/ log/ config/ apps/*/config/ data/indexes/ \
    data/search/ data/sql/ web/wiki/conf/ web/wiki/data/
$ chmod -cR g+wr config/ apps/*/config/ data/indexes/ data/search/ data/sql/ \
    web/wiki/conf/ web/wiki/data/
$ ./symfony project:permissions

NOTE: Replace WEB_GROUP with the group associated with the Apache user, e.g. www-data or apache.

2. Create a link to the web directory of the project from the server's web root, for example:

$ sudo ln -s AGASTI_ROOT/web WEB_ROOT/agasti

NOTE: Replace AGASTI_ROOT with the full filesystem path to the Agasti root directory, and replace WEB_ROOT with the path to your default Apache configuration's document root.

3. If your version of Apache supports it, write a custom configuration file for the application; for example:

Alias /agasti/sf AGASTI_ROOT/lib/vendor/symfony/data/web/sf
<Directory "/var/www/agasti">
  AllowOverride All
  Allow from All
</Directory>

To activate the site configuration, as well as mod_rewrite if it isn't already, you can then run the following commands:

$ sudo mv agasti /etc/apache2/sites-available/
$ sudo a2ensite agasti
$ sudo a2enmod rewrite
$ sudo /etc/init.d/apache2 restart

NOTES:

• Again, replace AGASTI_ROOT with the full filesystem path to the Agasti root directory.
• Commands may vary slightly, depending upon your version of Apache.
• You may instead prefer to set up an Apache Virtual Host, if you know how.

1. On the database server, create a schema for the project; for example:

$ mysqladmin -uroot -p create AGASTI_DB

NOTE: Replace AGASTI_DB with the name you chose for the schema, e.g. agasti.

2. Create a dedicated database user for the application (using root is highly discouraged):

$ mysql -uroot -p mysql << EOF
GRANT ALL PRIVILEGES ON AGASTI_DB.* TO 'AGASTI_DB_USERNAME'@'DB_HOSTNAME'
   IDENTIFIED BY 'AGASTI_DB_PASS';
  EOF

NOTES:

• Replace AGASTI_DB with the name you chose for the schema, AGASTI_DB_USERNAME with the username you chose, and AGASTI_DB_PASS with the password you chose.
• For some versions of MySQL, you may need to FLUSH PRIVILEGES; before continuing.

3. Customize your MySQL options by adding the following either to a new .cnf file in your /etc/mysql/conf.d/ directory or to your /etc/mysql/my.cnf file:

[mysqld]
# sets default for charset=utf8 for client/connection
character-set-server    = utf8
collation-server        = utf8_general_ci

# sets global sql_mode to enforce NOT NULL and other attribute constraints
sql-mode=STRICT_ALL_TABLES

[mysql]
# sets default for charset=utf8 for server/database
default-character-set   = utf8

To activate the new options, restart MySQL:

$ sudo restart mysql

NOTE: Depending on your platform and version of MySQL, you may need to use this command:

$ sudo service mysql force-reload

or this command:

$ sudo /etc/init.d/mysql restart

Set PHP's memory limit to 256 MB or greater by editing or adding the following line in /etc/php5/apache2/php.ini:

memory_limit = 256M

Optionally, you may also want to replace your current php.ini with the recommended production settings, via this command:

$ sudo cp /usr/share/doc/php5-common/examples/php.ini-production \
    /etc/php5/apache2/php.ini

NOTE: You would still need to increase the memory_limit after this copy.