Redmine

Have you started from an empty DB in Postgres?

Yes - that was the plan. However, I do remember having issues setting up Postgres. Maybe I messed something up? I kinda figured once Redmine stopped complaining, all was well. Maybe issues like this are a symptom of something still wrong in the DB?

I can't say for sure what has happened if you had warnings/errors and tried working around them, sorry. My concern was more in the line of "loading a DB dump from MySQL into Postgres", which is known do cause problems if it's a DB used by a rails app.

Try to have a look at log/production.log to see if there is anything bizarre there after you get the errors you encounter.

First, I should have provided this:

About your application's environment
Ruby version 1.8.7 (i486-linux)
RubyGems version 1.3.7
Rack version 1.1
Rails version 2.3.5
Active Record version 2.3.5
Active Resource version 2.3.5
Action Mailer version 2.3.5
Active Support version 2.3.5
Edge Rails revision unknown
Application root /var/www/redmine
Environment production
Database adapter postgresql
Database schema version 20100819172912

About your Redmine plugins
Redmine Github Hook plugin 0.1.1

The /var/log/redmine/default/production.log file was empty because the permissions were wrong. I fixed that, and now just the normal stuff is there. No errors.

Sorry I misunderstood you originally, but this install was postgresql from the start. There was no MySQL --> PostgreSQL dump/migration.

I know Rails is DB agnostic, but I also know that most everyone uses MySQL. Since I don't see anyone else having issues like me, I perhaps wrongly assumed it was related to PostgreSQL.

Not sure what to try next. I have a new client/project starting very soon, and I REALLY want to introduce Redmine to them. They seem keen. However, 'bugs' like this will cause resistance.

I checked the change logs for many releases, and I see no references to the issues I am having. There is a new release in a few days - maybe I should just try a fresh install using it.

Note I am very new to Rails - so maybe there is a newbie thing going on here.

Ideas?

See RedmineInstall, you need rack 1.0.1, I don't see anything bad apart from that. PG is supported, tested and widely in use too, so there should be no surprise there either. Try removing the plugin if you still have issues.

Wow. This is getting stranger.

Your comment made sense, so the first thing I did was:

webdev@redmine:/$ gem list

• LOCAL GEMS ***

actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.5)
activeresource (2.3.5)
activesupport (2.3.5)
json (1.4.6)
rack (1.0.1)
rails (2.3.5)
rake (0.8.7)
webdev@redmine:/$

Note the rack version is correct.

So, why does RAILS_ENV=production script/about return 1.1 when 1.0.1 is already installed?

Oh - I should add .... these issues all existed prior to installing the plugin.

script/about shows what redmine uses, gem list what your current user sees, it might be that the user running your redmine has other gem or ruby paths than yours. If you don't care about rack 1.1, try running gem uninstall rack -v=1.1 as user and root and gem install rack -v=1.0.1 at least as root.

Still no luck. I tried uninstalling it as both 'webdev' and 'root'.

webdev@redmine:/$ gem uninstall rack -v=1.1
ERROR:  While executing gem ... (Gem::InstallError)
    cannot uninstall, check `gem list -d rack`
webdev@redmine:/$ gem list -d rack

*** LOCAL GEMS ***

rack (1.0.1)
    Author: Christian Neukirchen
    Rubyforge: URL removed because I think it triggers Redmine spam error.
    Homepage: URL removed because I think it triggers Redmine spam error.
    Installed at: /var/lib/gems/1.8

    a modular Ruby webserver interface
webdev@redmine:/$

I got the exact same response as root.

I think we need to concentrate on why Rails thinks Rack V1.1 is installed - even though it clearly isn't.

I'm going to poke around - but feedback is appreciated!

Poking around, I discovered this:

webdev@redmine:/var/www/redmine/public/javascripts$ ls -l
total 32
-rw-r--r-- 1 webdev webdev 6439 Jul 25 06:35 application.js
drwxr-xr-x 3 webdev webdev 4096 Dec 18 17:39 calendar
-rw-r--r-- 1 webdev webdev 6999 Mar  4  2010 context_menu.js
lrwxrwxrwx 1 webdev webdev   45 Dec 18 17:38 controls.js -> ../../../javascript/scriptaculous/controls.js
lrwxrwxrwx 1 webdev webdev   45 Dec 18 17:38 dragdrop.js -> ../../../javascript/scriptaculous/dragdrop.js
lrwxrwxrwx 1 webdev webdev   44 Dec 18 17:38 effects.js -> ../../../javascript/scriptaculous/effects.js
drwxr-xr-x 3 webdev webdev 4096 Dec 18 17:39 jstoolbar
lrwxrwxrwx 1 webdev webdev   42 Dec 18 17:38 prototype.js -> ../../../javascript/prototype/prototype.js
-rw-r--r-- 1 webdev webdev 1041 Aug 15  2009 repository_navigation.js
-rw-r--r-- 1 webdev webdev 1934 Nov 28  2009 select_list_move.js

However, the sym links are busted. Those files do not exist. Are they required for Redmine?

Also, when I run the 'about' script, I get this warning before the output;

webdev@redmine:/var/www/redmine$ RAILS_ENV=production script/about
./script/../config/../vendor/rails/railties/lib/rails/gem_dependency.rb:119:Warning: Gem::Dependency#version_requirements is deprecated and will be removed on or after August 2010.  Use #requirement

Google tells me it is not really an issue, but perhaps it is related to my issues?

Eric D wrote:

Google tells me it is not really an issue, but perhaps it is related to my issues?

It shouldn't, and it's only a warning.

The js stuff is puzzling though and might explain some errors you get. Where did you get the installation you are using from?

Here are the steps I took. I often keep notes like this, but they are not always completely accurate. For example, if I realize I forgot a step, I may go back and add it where I think it should be, and not where I actually executed it.

The steps not shown are related to creating the Debian V-Server it is installed on, and setting up Apache etc.

This is on Debian Squeeze.

4. Install packages required for Redmine:
-----------------------------------------

apt-get install postgresql-8.4 apache2 subversion rake rubygems libopenssl-ruby libpgsql-ruby libapache2-mod-passenger
gem install -v=2.3.5 rails
apt-get install librmagick-ruby

5. Configure PostgreSQL:
------------------------

su postgres
psql
postgres=# CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD '<password>' NOINHERIT VALID UNTIL 'infinity';
postgres=# CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;
postgres=# \q
exit

6. Install Redmine and PostgreSQL adapter:
------------------------------------------

apt-get install redmine redmine-pgsql

7. Add the database specification details:
------------------------------------------

nano /usr/share/redmine/config/database.yml

Add the following:

production:
adapter: postgresql
database: redmine
host: localhost
username: redmine
password: <password>
encoding: utf8
schema_search_path: public

Add the above to /etc/redmine/default/database.yml as well.
Note sure why 2 places.

Execute these commands:

rake generate_session_store
RAILS_ENV=production rake db:migrate
RAILS_ENV=production rake redmine:load_default_data

Ok, so you've installed it from the deb package, forget about the rack versions and stuff, as the deb package is patched to work with the versions currently available in debian. Have a look at the README of the package (or whatever is normal on debian) and make sure your redmine is installed according to it, specifically, I think it needs to be served from /usr/share/redmine and not from /var/www/redmine.

Hmmm. I will check. However, the older install I reference at the top of this thread is installed at /var/www/redmine and has been working flawlessly for almost 8 months.

OK. Still not there, but I wanted to provide an update for anyone finding this post in hopes of a solution.

First, I also noticed that the functionality to move an issue to another project is missing.

I am told by a RoR expert, who has installed Redmine MANY times, that on Debian, you should really install it from source. Simply doing a 'apt-get install redmine' will create issues such as what is noted here.

Now, I remember trying that first, but I ran into many other issues.

My priorities are changing, but I must get this resolved at some point. I'll update again then.

OK. Got it. Resolved ALL the issues mentioned.

I had done a 'apt-get install redmine'. I was told that is a 'bad move' for Debian.

So, I used the source and upgraded to 1.1 at the same time using these instructions.

After that, everything just worked!

Thanks Felix!

The problem was that in debian the scriptaculous library (which is used for ajax) is stored in separate package.

apt-get install libjs-scriptaculous

should fix this problem.