Project

General

Profile

Unable to sign in to Redmine after importing old database to new installation

Added by Al Burns over 11 years ago

Hi.

I am having an issue signing in to Redmine after importing an existing Redmine database to a new install. I used the Bitnami installer to do the install.

Currently, we have a very outdated version of Redmine running on a physical server and we want to move this to an up-to-date version of Redmine running on a Windows Server 2008 VM. I have followed all steps to import the database, migrate it and clear the cache and existing sessions.

I can browse all the documents in the database with no problems, however, when I try and sign in I get "Invalid user or password" with any combination of login credentials: I have tried "admin/admin", "user/bitnami", "bitnami/bitnami" and the username/password I entered during the setup. I have also created a new hashed password for "password", entered this in the database for the "Admin" user but all to no avail.

In the production.log file I see the following entry following the failed login:

Started POST "/redmine/login" for 127.0.0.1 at 2012-12-03 14:08:46 +0000
Processing by AccountController#login as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"ze2vB6HthJZKqYY6mHjAYqAthW0zIvTEAKhDyMxvF7Q=", "back_url"=>"http://localhost/redmine/", "username"=>"admin", "password"=>"[FILTERED]", "login"=>"Login »"}
Current user: anonymous
Failed login for 'admin' from ::1 at 2012-12-03 14:08:46 UTC
Rendered account/login.html.erb within layouts/base (6.4ms)
Completed 200 OK in 25ms (Views: 17.4ms | ActiveRecord: 1.8ms)

I am now at the end of my tether (and patience!) with this. Can someone please provide some advice or step-by-step instructions on how to resolve this issue.

Many thanks in advance.


Replies (1)

RE: Unable to sign in to Redmine after importing old database to new installation - Added by Al Burns over 11 years ago

For anyone who is interested, I have solved this by logging on as an administrator defined in the imported database and changed the admin password. The admin user you create during the Bitnami installation is overwritten when you import your existing database.

    (1-1/1)