Project

General

Profile

Redmine migration : login failed

Added by Guillaume Loetscher over 11 years ago

Hi everyone,

I've decided to moved my current Redmine installation from my personal server to a hosted environment. They are both in Debian 6, Mysql, apache2 and mod passenger.

I followed this howto (http://www.redmine.org/projects/redmine/wiki/HowTo_Migrate_Redmine_to_a_new_server_to_a_new_Redmine_version), and managed to get dump my Redmine database, and restore in on the new server. Now, I have the redmine greeting page with the login, but every user I throw at it, Redmine answered "Login failed".

What I did is :
- backup my files and my database on the old server
- install a virgin database on the new server, with the same name ("redmine_default")
- moved the configuration.yml from the old server to the new one.
- dump / restore my database on the same mysql database ("redmine_default") with the same user / password
- did a "rake db:migrate RAILS_ENV=production" after all of this
- did also a "rake tmp:cache:clear" and "rake tmp:sessions:clear"

The log are full of "Failed login for user "...."".

However, I do see this user in the "redmine_default" database, with an hashed password.

How can I be sure that redmoine is correctly reading the database, and if so, why can't I login with my old password ?

As a workaround, and as I have access to the database : can I manually reset my password at the SQL level, in order to move on this subject ?

I've checked wiki, forum and tracker, no clue.

Thanks in advance !


Replies (2)

RE: Redmine migration : login failed - Added by Guillaume Loetscher over 11 years ago

Forget what I said. I was migrating from Redmine 1.4 to 1.1 (the second server was in Debian stable, not testing).

I did a dist-upgrade, to put Redmine on the same level as the first server, move the database, and all went OK.

Note for later : do not make any migration after midnight...

Sorry for that.

RE: Redmine migration : login failed - Added by Jean-Philippe Lang over 11 years ago

Guillaume Loetscher wrote:

Note for later : do not make any migration after midnight...

Good point.

    (1-2/2)