CMS installation

• Drupal installation on opapa.
  
  
  
  • Created Drupal database:
    

    
    mysql -u root -p
    > CREATE DATABASE drupal;
    > GRANT ALL PRIVILEGES ON drupal.* TO iandexter IDENTIFIED \\
       BY 'password';
    > FLUSH PRIVILEGES;
    > q

    
    
  
  
  • Decompressed Drupal package on /var/www/html/
  
  
  • Load database schema for Drupal:
    

    
    cd /var/www/html/drupal-4.6.0
    mysql -u iandexter -p drupal 

    
    
  
  
  • Edited configuration in sites/default/settings.php:
    

    
    $db_url = "mysql://iandexter:password@localhost/drupal";
    $base_url = "http://cms.openacademy.ph/"
    

    
    
  
  
  • Created files directory:
    

    
    sudo mkdir files
    sudo chmod 664 files/
    

    
    
  
  
  • Edited httpd.conf:
    

    
    <VirtualHost *>
      ServerName cms.openacademy.ph
      DocumentRoot "/var/www/html/drupal-4.6.0"
    </VirtualHost>
    <Directory "/var/www/html/drupal-4.6.0">
      Options Indexes
      AllowOverride All
    </Directory>
    

    
    
  
  
  • Created cron task:
    

    
    su - -c "crontab -e"
    0 * * * * wget -O - q http://cms.openacademy.ph/cron.php
    

    
    
  
  
  • Opened installation in browser, created first account, and logged in.
  
  
  
  


• Configuring Drupal:
  
  
  
  • Added roles:
    
    
    
    • Administrator
    
    
    • Editor
    
    
    • Author
    
    
    
    
  
  
  • Enabled modules.
  
  
  
  


• Added DNS entry (CNAME) at domains.ph.