Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Recover lost login data

Recover lost login data

Added by Hiran Chaudhuri almost 5 years ago

Hello there,

it may sound awkward but I have an OpenProject installation that was not maintained for some time and the last successful login is about 9 months ago.
For some reason now the system denies all logins - even the admin user cannot logon any more. However I have access to the underlying mysql database.

Is there any way for me to regain access via the GUI?
Can I tweak the user_passwords table to either make the password work or make it look like the user has not set any password?

(I'd like to mention the OpenProject version however that is not shown on the login form)

Hiran


Replies (1)

RE: Recover lost login data - Added by Oliver Günther almost 5 years ago

Hi Hiran,

ideally you would update your user through OpenProject, as the passwords table will require you updating the bcrypt hash (would also work if you know how to generate it).

If you're on a packaged installation, run a console with openproject run console

Update the user with user = User.find_by(login: 'your login name'); user.password = user.password_confirmation = 'Your new password'; user.save! user.activate!

This should activate and save the user with the given password. You can repeat this for multiple logins.

Best

Oliver

  • (1 - 1/1)
Loading...