Problem with Redmine

rubyonrails-talk
#1

I am having a problem getting Redmine to run with Oracle (11.2) backend.
I get this error (below) because Oracle table names are limited to 30
characters. Does anyone around here know of a fix or workaround? I'm
wondering if I can simple change the table name, or if that will break
the application.

When doing a db migrate to an Oracle db this creates the error below.

I'm so close, but now when I do:

RAILS_ENV=production rake db:migrate --trace

I get:

AddOpenIdAuthenticationTables: migrating

#2

Changing the name is what you will need to do to get it to run under Oracle 11. There will be issues with the application since you are changing a table name. You are going to have to rework your code so that all the relationships are correctly work or else they will be looking for a table that is not in the database.

If you are the author of the code that uses that table then you have some work ahead of you. If you are not, then you need to send it back to your developers explaining that the table name is too long for Oracle 11 and they will need to rework the code. Good luck.

B.

#3

You are going to have to rework your code

If you are the author of the code that uses that table then you have
some work ahead of you. If you are not, then you need to send it back
to your developers explaining that the table name is too long for Oracle
11 and they will need to rework the code. Good luck.

It's not his code... he said, it's Redmine...

I am having a problem getting Redmine to run with Oracle because Oracle table names are limited to 30
characters. Does anyone around here know of a fix or workaround? I'm
wondering if I can simple change the table name, or if that will break
the application.
"OPEN_ID_AUTHENTICATION_ASSOCIATIONS" ("ID" NUMBER NOT NULL PRIMARY
Any help is greatly appreciated!

You *may* be able to get away with changing the table name in the
migration and then editing the model to specify the new table name:

class Mouse < ActiveRecord::Base
  def self.table_name() "mice" end
end

However, according to the release notes, Oracle support should be in there:
http://www.redmine.org/projects/redmine/wiki/Changelog_0_6
but the install notes don't mention it:
http://www.redmine.org/projects/redmine/wiki/RedmineInstall

..but another "but" - it looks like your conflict is with one of the
plugins that Remine uses:
/ vendor / plugins / open_id_authentication
...so there may not be much Redmine has to do with it, but it's an
open_id_authentication

I'm no Oracle admin, but can you use Aliases to help?
http://www.oracle-base.com/articles/misc/NamingConventions.php#Aliasing

Is there any reason why you can't use mySQL or SQLite?... might save a
lot of hassle if you can...