Setting up Web Development Server (2/4)

Posted on Posted in Technology Center

Postfix / SpamAssassin

Apache

Tomcat

  • Download latest version of tomcat.
  • Add symbolic link from tomcat installation directory.
    • ln -s /home/tomcat/apache-tomcat-5.5.15 /usr/lib/tomcat
  • Add the following lines to /etc/profile
    • export JAVA_HOME=”/usr/lib/jvm/java”
    • export CATALINA_HOME=”/usr/lib/tomcat”
  • Create service if necessary.

MySQL

  • Install MySQL via yum.
  • Set MySQL to autorun
    • chkconfig mysqld on
  • Secure password of root and anonymous account
    • UPDATE user SET password=password(‘[password]’) where user=”;
    • UPDATE user SET password=password(‘[password] ‘) where user=’root’;
    • FLUSH PRIVILEGES;
  • Create default users
    • GRANT ALL PRIVILEGES ON *.* TO ‘[username]’@’localhost’ IDENTIFIED BY ‘[password] ‘ WITH GRANT OPTION;
    • GRANT ALL PRIVILEGES ON *.* TO ‘[username]’@’%’ IDENTIFIED BY ‘[password] ‘ WITH GRANT OPTION;

Eventum

  • Upload and Extract Eventum Installer to defect folder.
  • Make sure php.ini uses 32MB memory limit
  • Setup MySQL database and user
    • grant all privileges on eventumdb.* to ‘[username]’@’localhost’ identified by ‘[password] ‘ with grant option;
  • Install Eventum. Follow instructions accordingly. http://eventum.mysql.org/wiki/index.php/Doing_a_fresh_install
  • If migrating data:
    • Backup data from old server. mysqldump -u [username] -p[password] eventumdb > eventum.sql
    • Restore data to new server. mysql -u [username] -p[password] eventumdb < eventum.sql
  • Test eventum.

phpBB

  • Upload and Extract phpBB2 Installer to bulletin folder.
  • Setup MySQL database and user
    • create database dev_bulletin
    • grant all privileges on dev_bulletin.* to ‘[username]’@’localhost’ identified by ‘[password]’ with grant option;
  • Install phpBB as included in gzip file. Follow instructions accordingly.
  • If migrating data:
    • Backup data from old server. mysqldump -u [username] -p[password] bulletin > phpbb2.sql
    • Restore data to new server. mysql -u [username] -p[password] bulletin < phpbb2.sql
  • Test phpBB.

PHPFileNavigator

  • Upload and Extract PHPFileNavigator Installer to files folder.
  • Setup MySQL database and user
    • create database dev_phpfiles;
    • grant all privileges on dev_phpfiles.* to ‘ [username]’@’localhost’ identified by ‘[password]’ with grant option;
    • flush privileges;
  • Install PHPFileNavigator as included in gzip file. Follow instructions accordingly.
  • If migrating data:
    • Backup data. mysqldump -u [username] -p dev_phpfiles > phpbb2.sql
    • Backup files. tar -cvf [tarfile] [files]; gzip [tarfile]
    • Restore data to new server. mysql -u [username] -p dev_phpfiles < phpbb2.sql
    • Restore files. tar -zcvf [tarfile]
  • Make sure that Module folders are updated according to new location.
  • Test PHPFileNavigator

Continued… Setting up a Development Server (3/4)

2 thoughts on “Setting up Web Development Server (2/4)

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.