# Install Redmine on Ubuntu with SQLite3

Install Redmine 5.0.5 with Apache2 and local SQLite2 database in Ubuntu Focal.

### Installing dependencies

```
apt install -y --no-install-recommends apache2 build-essential libapache2-mod-passenger libsqlite3-dev ruby-dev
```

### Download & Extract Redmine

Download the latest version from [here](https://www.redmine.org/projects/redmine/wiki/Download).\
Extract the binaries to `/opt/redmine` as below

```
mkdir /opt/redmine
tar -xf redmine-5.0.5.tar.gz -C /opt/redmine  --strip=1
```

### Configure database

Create the database configuration `/opt/redmine/config/database.yml` with below contents

```
production:
  adapter: sqlite3
  database: db/redmine.sqlite3
```

### Install and setup Ruby scripts

Run the below commands in `/opt/redmine` path to setup Ruby

```
cd /opt/redmine

gem install bundler

bundle config set --local without 'development test' 

bundle install

bundle exec rake generate_secret_token

RAILS_ENV=production bundle exec rake db:migrate

RAILS_ENV=production REDMINE_LANG=en bundle exec rake redmine:load_default_data
```

### Configure Apache

Add the config `PassengerDefaultUser www-data` in the file `/etc/apache2/mods-available/passenger.conf`.\
Now the file looks as below

```
<IfModule mod_passenger.c>
  PassengerDefaultUser www-data
  PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini
  PassengerDefaultRuby /usr/bin/ruby
</IfModule>
```

Add the below contents in `/etc/apache2/sites-available/000-default.conf`

```
<Directory /var/www/html/redmine>
    RailsBaseURI /redmine
    PassengerResolveSymlinksInDocumentRoot on
</Directory>
```

Copy the HTML resources to `/var/www/html/redmine`

```
ln -sf /opt/redmine/public /var/www/html/redmine
```

Update the ownership to `www-data`

```
chown -R www-data:www-data /opt/redmine /var/www/html/redmine
```

Restart the webserver

```
service apache2 restart
```

### Access the Redmine from the local host

Explore the Redmine at <http://localhost/redmine>

### Weblinks:

[Email setup](https://www.redmine.org/projects/redmine/wiki/howto_install_redmine_on_ubuntu_step_by_step#Email-setup)\
[Backing up Redmine Database](https://www.redmine.org/projects/redmine/wiki/howto_install_redmine_on_ubuntu_step_by_step#Backing-up-Redmine)\
<https://www.redmine.org/projects/redmine/wiki/RedmineInstall> <https://www.redmine.org/projects/redmine/wiki/howto\\_install\\_redmine\\_on\\_ubuntu\\_step\\_by\\_step> <https://www.redmine.org/projects/redmine/wiki/HowTo\\_Install\\_Redmine\\_50x\\_on\\_Ubuntu\\_2004\\_with\\_Apache2>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kribakarans.gitbook.io/howto/redmine/install_redmine_with_sqlite3.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.