Difference between revisions of "Base node configuration - CentOS5"

From WormBaseWiki
Jump to navigationJump to search
(New page: Configuring a fresh install of Cent OS 5 for WormBase Install and configure Apache2, mod_perl,and php5 > yum install httpd httpd-devel > yum install mod_perl > yum install php php-gd php-...)
 
Line 2: Line 2:
  
 
Install and configure Apache2, mod_perl,and php5
 
Install and configure Apache2, mod_perl,and php5
> yum install httpd httpd-devel
+
todd> yum install httpd httpd-devel
> yum install mod_perl
+
todd> yum install mod_perl
> yum install php php-gd php-mysql
+
todd> yum install php php-gd php-mysql
  
Note: Yum places things in different paths than we have
+
Note: Yum places things in different paths than we have used on other nodes with custom installs.
used on other nodes with custom installs.
 
  
 
Apache:
 
Apache:
conf    : /etc/httpd/conf/httpd.conf
+
conf    : /etc/httpd/conf/httpd.conf
lib    : /usr/lib/httpd
+
lib    : /usr/lib/httpd
modules : /usr/lib/httpd/modules
+
modules : /usr/lib/httpd/modules
  
 
Configure Apache for PHP
 
Configure Apache for PHP
# Load the module
+
# Load the module
LoadModule php5_module        modules/libphp5.so
+
LoadModule php5_module        modules/libphp5.so
  
# Add mime tpyes
+
# Add mime tpyes
AddType application/x-httpd-php .php
+
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
+
AddType application/x-httpd-php-source .phps
  
# Make index.php a default for directory index
+
# Make index.php a default for directory index
DirectoryIndex index.html index.php
+
DirectoryIndex index.html index.php
 
 
We will launch apache with a custom configuration file,
 
not using virtual hosts.
 
  
 +
We will launch apache with a custom configuration file, not using virtual hosts.
  
 
Install and configure MySQL
 
Install and configure MySQL
Line 34: Line 31:
 
Mysql:
 
Mysql:
 
data_dir : /var/lib/mysql
 
data_dir : /var/lib/mysql
 
  
 
1. Relocate the data dir to /usr/local/mysql/data
 
1. Relocate the data dir to /usr/local/mysql/data

Revision as of 15:20, 3 October 2007

Configuring a fresh install of Cent OS 5 for WormBase

Install and configure Apache2, mod_perl,and php5

todd> yum install httpd httpd-devel
todd> yum install mod_perl
todd> yum install php php-gd php-mysql

Note: Yum places things in different paths than we have used on other nodes with custom installs.

Apache:

conf    : /etc/httpd/conf/httpd.conf
lib     : /usr/lib/httpd
modules : /usr/lib/httpd/modules

Configure Apache for PHP

# Load the module
LoadModule php5_module        modules/libphp5.so
# Add mime tpyes
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
# Make index.php a default for directory index
DirectoryIndex index.html index.php

We will launch apache with a custom configuration file, not using virtual hosts.

Install and configure MySQL

> yum install mysql-devel mysql-server Mysql: data_dir : /var/lib/mysql

1. Relocate the data dir to /usr/local/mysql/data

Edit the datadir variable in /etc/my.cnf
> mkdir -p /usr/local/mysql/data
> chown mysql:mysql /usr/local/mysql/data
> chmod 2775 /usr/local/mysql/data

2.Install privilege tables

> sudo mysql_install_db

3. Move old databases into the datadir and upgrade

 > cp -r old_database /usr/local/mysql/data
 > mysqld_safe --user=mysql &
 > mysql_upgrade

4. Set the root password

 > mysql
 mysql> use mysql
 mysql> update user set password=PASSWORD('-----------') where User='root';
 mysql> flush privileges

5. Grant privileges as necessary to the databases