Ubuntu Server Setup Guid

sudo apt-get install mc

locale -a
sudo locale-gen ru_RU
sudo locale-gen ru_RU.UTF-8
sudo update-locale
sudo dpkg-reconfigure locales

source http://en.ig.ma/notebook/2012/virtualbox-guest-additions-on-ubuntu-server

Devices menu, Install Guest Additions

sudo mount /dev/cdrom /media/cdrom
sudo apt-get install -y dkms build-essential linux-headers-generic linux-headers-$(uname -r)
sudo /media/cdrom/VBoxLinuxAdditions.run

sudo apt-get install ssh

/etc/ssh/sshd_config:

PermitRootLogin no
AuthorizedKeysFile	%h/.ssh/authorized_keys

sudo service ssh restart

On client's side:

ssh-keygen -t dsa
(empty answer for every question)

ssh-copy-id "client_user_name@server_ip_address"  
ssh "client_user_name@server_ip_address"  

Back on server:
/etc/ssh/sshd_config:

PasswordAuthentication no

sudo service ssh restart  

Download installer from https://bitnami.com/stack/redmine/installer#linux

Use /opt/redmine as a default directory.

/opt/redmine/apache2/conf/httpd.conf:

Listen 8080
ServerName localhost:8080

/opt/redmine/apache2/conf/bitnami

NameVirtualHost *:8080
<VirtualHost _default_:8080>

sudo cp opt/redmine/ctlscript.sh /etc/init.d/bitnami-redmine

/etc/init.d/bitnami-redmine:

### BEGIN INIT INFO
# Provides:          scriptname
# Required-Start:    $remote_fs $syslog
# Required-Stop:     $remote_fs $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start daemon at boot time
# Description:       Enable service provided by daemon.
### END INIT INFO

sudo update-rc.d -f bitnami-redmine defaults
sudo update-rc.d -f bitnami-redmine enable

To remove autostart:

sudo update-rc.d -f bitnami-drupal remove

Prepare (do it once):

sudo apt-get install make
sudo apt-get install ruby-dev
sudo apt-get install ruby1.9.1-dev
sudo apt-get install zlib1g-dev
sudo apt-get install libmysqlclient-dev
sudo apt-get install imagemagick
sudo apt-get install libmagickwand-dev

sudo gem install json -v '1.8.2'
sudo gem install nokogiri -v '1.6.6.2'
sudo gem install mysql2 -v '0.3.14'
sudo gem install rmagick -v '2.13.4'

Copy plugin to /opt/redmine/apps/redmine/htdocs/plugins:

cd /opt/redmine
./use_redmine
cd apps/redmine/htdocs
bundle install --without development test postgresql sqlite
or
  bundle install --without development test postgresql sqlite --no-deployment
  bundle install --without development test postgresql sqlite --deployment  
ruby bin/rake redmine:plugins RAILS_ENV=production
exit
./ctlscript.sh restart

mkdir /opt/redmine_backup

/opt/redmine_backup_go:

tar -cvzf /opt/redmine_backup/redmine_`date +%w`.tar.gz /opt/redmine
/opt/redmine/mysql/bin/mysqldump -u bitnami -p406c9f96ee bitnami_redmine > /opt/redmine_backup/redmine_`date +%w`.sql

Note: get password from /opt/redmine/apps/redmine/htdocs/config/database.yml:

production:
  username: bitnami
  password: 406c9f96ee

crontab -e

add line:

25 10 * * * /opt/redmine_backup_go

1. cd /opt
   /opt/redmine/mysql/bin/mysqldump -u bitnami -pDATABASE_PASSWORD bitnami_redmine > backup.sql
   /opt/redmine/ctlscript.sh stop

2. download and install new bitnami-redmine https://bitnami.com/stack/redmine/installer
3. recreate symlink /opt/redmine

4. /opt/redmine/ctlscript.sh stop
   /opt/redmine/ctlscript.sh mysql start
   
   /opt/redmine/mysql/bin/mysql -u root -p 
       Password: ****
       mysql> drop database bitnami_redmine;
       mysql> create database bitnami_redmine;
       mysql> grant all privileges on bitnami_redmine.* to 'bn_redmine'@'localhost' identified by 'DATABASE_PASSWORD';
       
   /opt/redmine/mysql/bin/mysql -u root -p bitnami_redmine < /opt/backup.sql

5. /opt/redmine/apps/redmine/htdocs/config/database.yml:

   production:
     adapter: mysql2
     database: bitnami_redmine
     host: localhost
     username: bn_redmine
     password: "DATABASE_PASSWORD"
     encoding: utf8

6. cd /opt/redmine/apps/redmine/htdocs 
   /opt/redmine/ruby/bin/ruby bin/rake db:migrate RAILS_ENV=production

7. copy from the old installation
   1. /opt/redmine/apps/redmine/htdocs/files
   2. /opt/redmine/apps/redmine/htdocs/plugins
   3. /opt/redmine/apps/redmine/htdocs/public/themes

8. cd /opt/redmine/apps/redmine/htdocs 
   /opt/redmine/ruby/bin/ruby bin/rake redmine:plugins RAILS_ENV=production
   /opt/redmine/ruby/bin/ruby bin/rake tmp:cache:clear
   /opt/redmine/ruby/bin/ruby bin/rake tmp:sessions:clear
   /opt/redmine/ctlscript.sh restart

Свой адрес - 192.168.2.190. Слушать порт 2223 и отправлять на 192.168.0.7:80:

iptables -t nat -A PREROUTING -p tcp -d 192.168.2.190 --dport 2223 -j DNAT --to-destination 192.168.0.7:80