Redmine upgrade from 3.4.3 to 4.1 - error restoring database backup

Added by Joshua A 2 months ago

our database is stored on dedicated db server. To restore the backup of my existing data i changed database.yml to point to the remote db. i ran the following:

rake db:migrate RAILS_ENV=production in the redmine directory and then ran the touch /tmp/restart.txt and also restarted nginx.

when i try and login to the redmine now i get a 500 error. with the following in my production.log

rocessing by AccountController#login as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"QOPW5b1RnacUNejQMcM/2k/E0wxCxOQz/iBnFKaHZoTseGgcVRt7sjZxazxqndb9DRA/gylWThpifkDfab52mA==", "back_url"=>"http://a-redmine-02.company.com/login", "username"=>"USER", "password"=>"[FILTERED]", "login"=>"Login"}
Current user: anonymous

An error occurred when authenticating USER: getaddrinfo: Name or service not known
Rendering common/error.html.erb within layouts/base
Rendered common/error.html.erb within layouts/base (0.6ms)
Rendered plugins/redmine_contacts/app/views/common/_additional_assets.html.erb (0.3ms)
Rendering inline template
Rendered inline template (0.3ms)
Rendered plugins/redmine_wysiwyg_editor/app/views/redmine_wysiwyg_editor/_redmine_wysiwyg_editor_partial.html.erb (0.0ms)
Rendered plugins/redmineup_tags/app/views/tags/_additional_assets.html.erb (0.2ms)
Rendered plugins/redmine_zenedit/app/views/zenedit/_additional_assets.html.erb (0.0ms)
Rendered plugins/redmine_contacts/app/views/common/_contacts_select2_data.html.erb (0.4ms)
Rendered plugins/redmineup_tags/app/views/tags/_select2_transformation_rules.html.erb (0.1ms)
Rendered plugins/redmine_contacts_helpdesk/app/views/common/_helpdesk_select2_data.html.erb (0.1ms)
Completed 500 Internal Server Error in 65ms (Views: 15.5ms | ActiveRecord: 12.5ms)
Started POST "/login" for 10.11.3.52 at 2020-07-21 14:37:27 +0000

can someone help me on how to properly restore this ---

old server environment:
-----
Environment:
Redmine version 3.4.3.stable
Ruby version 2.0.0-p648 (2015-12-16) [x86_64-linux]
Rails version 4.2.8
Environment production
Database adapter Mysql2
SCM:
Git 1.8.3.1
Filesystem
Redmine plugins:
clipboard_image_paste 1.12
recurring_tasks 2.0.0-pre
redmine_checklists 3.1.10
redmine_ckeditor 1.1.5
redmine_contacts 4.2.3
redmine_contacts_helpdesk 4.0.2
redmine_custom_js 0.1.1
redmine_knowledgebase 3.2.1
redmine_messenger 1.0.1
redmine_monitoring_controlling 0.1.1
redmine_preview_office 1.0.3
redmine_preview_pdf 1.0.4

new server environment
----
Environment:
Redmine version 4.1.0.stable
Ruby version 2.5.1-p57 (2018-03-29) [x86_64-linux-gnu]
Rails version 5.2.4.1
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Git 2.17.1
Filesystem
Redmine plugins:
redmine_checklists 3.1.16
redmine_contacts 4.3.0
redmine_contacts_helpdesk 4.1.8
redmine_custom_js 0.1.1
redmine_knowledgebase 4.1.1
redmine_mail_from 2.0.0
redmine_messenger 1.0.6
redmine_monitoring_controlling 0.1.1
redmine_preview_office 1.0.3
redmine_preview_pdf 1.0.4
redmine_questions 1.0.2
redmine_recurring_tasks 0.3.4
redmine_wysiwyg_editor 0.16.1
redmine_zenedit 1.0.3
redmineup_tags 2.0.8

Replies (1)

RE: Redmine upgrade from 3.4.3 to 4.1 - error restoring database backup - Added by Joshua A 2 months ago

it turned out this was an ldap problem. i added my ldap server to /etc/hosts and i was able to authenticate.

You can close this ticket.

(1-1/1)