Content
User password cant change
Added by Jithin Babu 10 months ago
OS Ubuntu : 22.04
Open project version : 13.0.7 (Open project community edition}
Issue
Every time a user logs in, the error shown below appears.
"Invalid user or password, or the account has been blocked as a result of multiple failed login attempts."
If so, it will be immediately unlocked in a short period." I attempted to change the password for the admin user. However, the problem will persist. We are also tired of using the following command. and displaying the error. This problem only affects one user. Please check and let me know if you find a solution. Also, we can't lock this particular user
- user = User.find_by! login: 'admin'
- user.activate
- user.failed_login_count = 0
- user.password = user.password_confirmation = "YOUR NEW SAFE PASSWORD 1234!"
- user.save!
Error Log
/opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/persistence.rb:648:in `save!': Failed to save the record (ActiveRecord::RecordNotSaved)
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/validations.rb:53:in `save!'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/transactions.rb:302:in `block in save!'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activesupport-7.0.7/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/transactions.rb:302:in `save!'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/activerecord-7.0.7/lib/active_record/suppressor.rb:54:in `save!'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.7/lib/rails/commands/console/console_command.rb:74:in `start'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.7/lib/rails/commands/console/console_command.rb:19:in `start'
from /opt/openproject/vendor/bundle/ruby/3.2.0/gems/railties-7.0.7/lib/rails/commands/console/console_command.rb:106:in `perform'
... 8 levels...
Replies (1)
I found that duplicate rows in Hourly Rates causes this