Redmine

The following HowTo details how to get Redmine working properly using SQLITE.. there were some problems installing the GEM for SQLITE so I wrote this..

My username is 'redmine'
My home directory is /home/redmine
I will install all sources in /home/redmine/src
My compliled sources for sqlite3 will be placed in /home/SQLITE
My compliled sources for ruby will be placed in /home/RUBY

CREATE src DIRECTORY TO WORK IN

redmine@jetsilver:/$ cd
_{redmine@jetsilver:}$ mkdir src
redmine@jetsilver:~$ cd src

OBTAIN REQUIRED SOURCES (SOME LINKS MAY HAVE CHANGED SINCE TIME OF WRITING)

redmine@jetsilver:~/src$ wget ftp://ftp.42.org/pub/FreeBSD/distfiles/sqlite-3.3.7.tar.gz
redmine@jetsilver:~/src$ wget ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.7-p72.tar.gz
redmine@jetsilver:~/src$ wget http://rubyforge.org/frs/download.php/43985/rubygems-1.3.0.tgz
redmine@jetsilver:~/src$ wget http://rubyforge.org/frs/download.php/39477/redmine-0.7.3.tar.gz

CREATE DIRECTORIES TO INSTALL TO

redmine@jetsilver:~/src$ mkdir ~/RUBY ~/SQLITE

UNTAR SOURCES

redmine@jetsilver:~/src$ tar -zxvf sqlite-3.3.7.tar.gz
redmine@jetsilver:~/src$ tar -zxvf ruby-1.8.7-p72.tar.gz
redmine@jetsilver:~/src$ tar -zxvf rubygems-1.3.0.tgz
redmine@jetsilver:~/src$ tar -zxvf redmine-0.7.3.tar.gz

COMPILE & INSTALL SQLITE

redmine@jetsilver:~/src$ cd sqlite-3.3.7
redmine@jetsilver:~/src/sqlite-3.3.7$ ./configure --prefix=/home/redmine/SQLITE
redmine@jetsilver:~/src/sqlite-3.3.7$ make
redmine@jetsilver:~/src/sqlite-3.3.7$ make install

COMPILE & INSTALL RUBY

redmine@jetsilver:~/src$ cd ..
redmine@jetsilver:/$ cd ruby-1.8.7-p72
redmine@jetsilver:~/src/ruby-1.8.7-p72$ ./configure --prefix=/home/redmine/RUBY
redmine@jetsilver:~/src/ruby-1.8.7-p72$ make
redmine@jetsilver:~/src/ruby-1.8.7-p72$ make install

ADD RUBY BINARY TO YOUR PATH

redmine@jetsilver:~/src/ruby-1.8.7-p72$ cd ..
redmine@jetsilver:~/src$ export PATH=$PATH:/home/redmine/RUBY/bin

INSTALL GEMS

redmine@jetsilver:~/src$ cd rubygems-1.3.0
redmine@jetsilver:~/src/rubygems-1.3.0$ ruby setup.rb

INSTALL RAILS

redmine@jetsilver:~/src/rubygems-1.3.0$ cd ..
redmine@jetsilver:~/src$ gem install rails

INSTALL SQLITE3 GEM FOR RUBY

redmine@jetsilver:~/src/rubygems-1.3.0$ cd ..
redmine@jetsilver:~/src$ gem install sqlite3-ruby -- --with-sqlite3-include=/home/redmine/src/sqlite-3.3.7 --with-sqlite3-lib=/home/redmine/src/sqlite-3.3.7/.libs

INSTALL REDMINE

redmine@jetsilver:~/src$ cd
redmine@jetsilver:~$ ln -s src/redmine-0.7.3 REDMINE

CONFIGURE DATABASE

redmine@jetsilver:~$ cd REDMINE/config/
redmine@jetsilver:~/REDMINE/config$ cp database.yml.example database.yml
redmine@jetsilver:~/REDMINE/config$ vi database.yml

Comment out production section and a new section under it for using SQLITE - your changes should look like this:

#production:

1. adapter: mysql
2. database: redmine
3. host: localhost
4. username: root
5. password:
6. encoding: utf8

production:
adapter: sqlite3
dbfile: db/redmine.db

POPULATE DATABASE

redmine@jetsilver:~/REDMINE/config$ cd ..
redmine@jetsilver:~/REDMINE$ rake db:migrate RAILS_ENV="production"
redmine@jetsilver:~/REDMINE$ rake redmine:load_default_data RAILS_ENV="production"

select the language choice you want, hit return for default english

SET FILE PERMISSIONS

redmine@jetsilver:~/REDMINE$ mkdir -p tmp
redmine@jetsilver:~/REDMINE$ chown -R redmine:redmine files log tmp
redmine@jetsilver:~/REDMINE$ chmod -R 755 files log tmp

START REDMINE

redmine@jetsilver:~/REDMINE$ ruby script/server -e production

TEST!

Open a browser page and goto http://servername:3000 and you should see the redmine page.