Ubuntu + redmine + S + passenger + nginx environment setup

I. Runtime Environment

OS: Ubuntu 10.10

DB: ipvs

Server: nginx + passenger

Red mine: 1.2

 

Ii. Installation Process

Reference: http://www.redmine.org/projects/redmine/wiki/RedmineInstall

 

 1. Install passenger + nginx

 
Gem install passenger
 

 
Passenger-install-nginx-Module # Install nginx
 

 

2. Install PostgreSQL
 

 
Install database sudo apt-Get install PostgreSQL
 

 

Modify the Linux User's Postgres password sudo passwd Postgres
 

Modify the password of database superuser S
Switch to Postgres user sudo su Postgres in Linux
Log on to Postgres database Psql Postgres
Alter User Login s with password 'new password ';
 

 

Add Custom Users and databases
Add a user and change the password
 

 
Create User Username;
Alter User Username with password 'new password ';
Create a user-defined Database
Create Database database name owner Username
Query databases, tables, and users
Select * From pg_database;
Select * From pg_user;
Select * From pg_tables;
 

 

\ Q exit
Exit ipvs user mode exit
 

 

Modify the/etc/PostgreSQL/8.4/main/pg_assist.conf configuration file to convert MD5 to trust
Sudo VI/etc/PostgreSQL/8.4/main/pg_assist.conf
Local Trust
Hosts Trust
 

 

Restart ipvs
Sudo/etc/init. d/postgresql-8.4 restart
 

 
3. For more information, see
 

 
Http://www.redmine.org/projects/redmine/wiki/RedmineInstall