Project

General

Profile

Connect database to redmine

Added by martin nielsen almost 3 years ago

Hi,

Have been lurking and trying to figure this out, but realize i need help.

I have a working redmine installation:

Environment:
  Redmine version                3.2.1.stable
  Ruby version                   2.3.1-p112 (2016-04-26) [x86_64-linux-gnu]
  Rails version                  4.2.6
  Environment                    production
  Database adapter               Mysql2
SCM:
  Git                            2.7.4
  Filesystem                     
Redmine plugins:
  no plugin installed

I badly want to upgrade this to newer version, in order to use some of the fancy plugins available. However the virtual machines running this redmine is proving hard to upgrade as it is an old Ubuntu 16.

So i used the Bitnami Redmine .OVF and installed a new working redmine:

Environment:
  Redmine version                4.2.4.stable
  Ruby version                   2.6.9-p207 (2021-11-24) [x86_64-linux]
  Rails version                  5.2.6.2
  Environment                    production
  Database adapter               Mysql2
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
SCM:
  Subversion                     1.14.1
  Git                            2.35.1
  Filesystem                     
Redmine plugins:
  redmine_timelog_timer          2.0.1

I even got one of the desired plugins working, as you see :-)

Now here comes the big question:

The old redmine database, is a MYSQL server running in the same cluster of VM's.

So i went into the database.yml of the new redmine (4) and changed production database to the existing mysql server. I even tried altering the encoding from utf8mb4 to utf8 as it is, in the old installation.

When doing this Redmine (4) throws me an internal error (500) and i am unable to see any log entries in either of the apache log files (access / error).

So two days of fiddling around - any input on how i get this working? :)

Regards

Martin (redmine user for 10+ years)


Replies (1)

RE: Connect database to redmine - Added by Bernhard Rohloff almost 3 years ago

Hi Martin,

have you also done the migration steps as described in the RedmineUpgrade (Step 4) article? Just pointing to the old database will not do the job.
Unfortunately I'm not exactly sure how to start the migration process on a Bitnami installation.

Kind regards,

Bernhard

    (1-1/1)