Installing Dradis with MYSQL on Ubuntu 9.10 (and up)

So honestly I just wanted to write this down somewhere in case I should ever find myself wondering how to do this again. The whole installation process was a pain in the arse, mostly because of stupidity - my advice is that if you're the only one using it, install dradis with the default (sqlite).

If you need more than 10 people to access it at one time however, you're going to want to install it with mysql which means following these instructions.

1. setup and install a LAMP (don't forget to write down your mysql root password)
$ sudo tasksel install lamp-server

2. install additional dependencies for dradis
$ sudo apt-get install ruby1.9.1-dev
$ sudo apt-get install ruby irb rdoc libopenssl-ruby
$ sudo apt-get install libmysqlclient16-dev

3. ruby on rails/rake config
$ sudo gem install rake rubygems mysql

4. grab a copy of dradis:
$ wget http://downloads.sourceforge.net/dradis/dradis-v2.5.1.tar.gz

4. make sure your dradis database config (/dradis-2.5/server/config/database.yml) looks like this:

# MYSQL CONFIG #
production:
adapter: mysql
encoding: utf8
database: dradis
pool: 5
username: root
password: yourmagicalrootpassword
socket: /var/run/mysqld/mysqld.sock

5. create the dradis database in MYSQL:
$ mysql --user=USER --password=PASS
mysql> create database dradis;

6. go to the proper directory and populate the dradis DB and start the server:
$ cd /dradis/server
$ rake dradis:reset
$ ruby ./dradis/server/script/server -b

You should now be able to browse you dradis install at https://localhost:3004

Hope this helps/works for you.