Login failed after upgrade to 5.0

Technical assistance
1

Infos:

  • Used Zammad version: 4.1 > 5.0
  • Used Zammad installation type: (source, package, docker-compose, …) package
  • Operating system: Centos7
  • Browser + version: Chrome last

Expected behavior:

Actual behavior:

We used ZAMMAD 4.1 with postgresql 9.2.
At the time of the upgrade there was a requirement of postgresql for version 9.6 and above so we upgraded to version 11.

We then upgraded ZAMMAD to YUM, during the upgrade no errors appeared, but now we are unable to connect to the system.

image


I, [2021-10-05T14:49:01.229072 #2664-174240]  INFO -- : Started POST "/api/v1/signin" for at 2021-10-05 14:49:01 +0300
I, [2021-10-05T14:49:01.238015 #2664-174240]  INFO -- : Processing by SessionsController#create as JSON
I, [2021-10-05T14:49:01.238135 #2664-174240]  INFO -- :   Parameters: {"username"=>****.com", "password"=>"[FILTERED]", "fingerprint"=>"-2086164141"}
E, [2021-10-05T14:49:01.249948 #2664-174240] ERROR -- : Failed to load Auth::Backend from Setting '{"adapter"=>"Auth::Ldap", "host"=>"localhost", "port"=>389, "bind_dn"=>"cn=Manager,dc=example,dc=org", "bind_pw"=>"example", "uid"=>"mail", "base"=>"dc=example,dc=org", "always_filter"=>"", "always_roles"=>["Admin", "Agent"], "always_groups"=>["Users"], "sync_params"=>{"firstname"=>"sn", "lastname"=>"givenName", "email"=>"mail", "login"=>"mail"}}'
E, [2021-10-05T14:49:01.250006 #2664-174240] ERROR -- : uninitialized constant Auth::Ldap (NameError)
lib/auth/backend.rb:26:in `block in instances'
lib/auth/backend.rb:25:in `each'
lib/auth/backend.rb:25:in `filter_map'
lib/auth/backend.rb:25:in `instances'
lib/auth/backend.rb:13:in `valid?'
lib/auth.rb:37:in `valid?'
app/controllers/sessions_controller.rb:219:in `authenticate_with_password'
app/controllers/sessions_controller.rb:10:in `create'
app/controllers/application_controller/has_download.rb:21:in `block (4 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:20:in `block (3 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:19:in `block (2 levels) in <module:HasDownload>'
app/controllers/application_controller/handles_transitions.rb:16:in `handle_transaction'
I, [2021-10-05T14:49:02.255818 #2664-174240]  INFO -- : Login failed. Have you double-checked your credentials and completed the email verification step? (Exceptions::NotAuthorized)
app/controllers/application_controller/authenticates.rb:169:in `raise_unified_login_error'
app/controllers/sessions_controller.rb:219:in `authenticate_with_password'
app/controllers/sessions_controller.rb:10:in `create'
app/controllers/application_controller/has_download.rb:21:in `block (4 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:20:in `block (3 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:19:in `block (2 levels) in <module:HasDownload>'
app/controllers/application_controller/handles_transitions.rb:16:in `handle_transaction'
I, [2021-10-05T14:49:02.257113 #2664-174240]  INFO -- : Completed 401 Unauthorized in 1019ms (Views: 0.3ms | ActiveRecord: 1.6ms | Allocations: 8030)

Steps to reproduce the behavior:

2

The search function is your friend:

Please follow the documented required update steps - clear your cache and repeat the database migration. See Updating Zammad — Zammad documentation

3

I’m done this but still can’t connect.

I, [2021-10-05T14:54:23.215946 #2715-174100]  INFO -- : Started POST "/api/v1/signin" for at 2021-10-05 14:54:23 +0300
I, [2021-10-05T14:54:23.220883 #2715-174100]  INFO -- : Processing by SessionsController#create as JSON
I, [2021-10-05T14:54:23.220945 #2715-174100]  INFO -- :   Parameters: {"username"=>".com", "password"=>"[FILTERED]", "fingerprint"=>"-"}
I, [2021-10-05T14:54:23.227946 #2715-174100]  INFO -- : CSRF token verification failed
I, [2021-10-05T14:54:23.228150 #2715-174100]  INFO -- : CSRF token verification failed! (Exceptions::NotAuthorized)
app/controllers/application_controller/prevents_csrf.rb:36:in `verify_csrf_token'
app/controllers/application_controller/has_download.rb:21:in `block (4 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:20:in `block (3 levels) in <module:HasDownload>'
app/controllers/application_controller/has_download.rb:19:in `block (2 levels) in <module:HasDownload>'
app/controllers/application_controller/handles_transitions.rb:16:in `handle_transaction'
I, [2021-10-05T14:54:23.229967 #2715-174100]  INFO -- : Completed 401 Unauthorized in 9ms (Views: 0.2ms | ActiveRecord: 1.1ms | Allocations: 2978)
4 
zammad run rake db:migrate

solved the problem.

1 Like
5

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.