Infos:
- Used Zammad version: 5.2.?
- Used Zammad installation type: Package-> deb
- Operating system: 20.04
- Browser + version: Appears in any browser
Expected behavior:
Opening the Login page
Actual behavior:
Does not show the Login page
Steps to reproduce the behavior:
rds@zammad:/var/log/zammad$ uname -r
5.4.0-137-generic
rds@zammad:/var/log/zammad$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.5 LTS
Release: 20.04
Codename: focal
apt update && apt upgrade latest packages - obviously changes database tables or connection to it?
Zammad seems to work! but the Webinterface cannot load some Tables?
Here’s some debug text from production.log when trying to login:
I, [2023-01-13T08:52:14.172201 #2918-112280] INFO – : Started GET “/” for 192.168.1.46 at 2023-01-13 08:52:14 +0000
I, [2023-01-13T08:52:14.179038 #2918-112280] INFO – : Processing by InitController#index as HTML
I, [2023-01-13T08:52:14.185200 #2918-112280] INFO – : Rendered init/index.html.erb within layouts/application (Duration: 0.1ms | Allocations: 69)
I, [2023-01-13T08:52:14.186163 #2918-112280] INFO – : Rendered layout layouts/application.html.erb (Duration: 1.1ms | Allocations: 680)
I, [2023-01-13T08:52:14.187581 #2918-112280] INFO – : Completed 200 OK in 8ms (Views: 1.5ms | ActiveRecord: 1.8ms | Allocations: 3098)
I, [2023-01-13T08:52:14.543443 #2934-111340] INFO – : ProcessScheduledJobs running…
I, [2023-01-13T08:52:14.546331 #2934-111340] INFO – : Running job thread for ‘Process ticket escalations.’ (Ticket.process_escalation) status is: sleep
I, [2023-01-13T08:52:14.546470 #2934-111340] INFO – : Running job thread for ‘Check channels.’ (Channel.fetch) status is: sleep
I, [2023-01-13T08:52:14.546746 #2934-111340] INFO – : Running job thread for ‘Generate ‘Session’ data.’ (Sessions.jobs) status is: sleep
I, [2023-01-13T08:52:14.546858 #2934-111340] INFO – : Running job thread for ‘Check ‘Channel’ streams.’ (Channel.stream) status is: sleep
I, [2023-01-13T08:52:14.547977 #2934-111340] INFO – : Running job thread for ‘Execute planned jobs.’ (Job.run) status is: sleep
I, [2023-01-13T08:52:14.660435 #2918-112340] INFO – : Started POST “/api/v1/signshow” for 192.168.1.46 at 2023-01-13 08:52:14 +0000
I, [2023-01-13T08:52:14.667452 #2918-112340] INFO – : Processing by SessionsController#show as JSON
I, [2023-01-13T08:52:14.667538 #2918-112340] INFO – : Parameters: {“fingerprint”=>“-139893395”}
E, [2023-01-13T08:52:14.683156 #2918-112340] ERROR – : PG::UndefinedTable: ERROR: relation “user_overview_sortings” does not exist
LINE 8: WHERE a.attrelid = ‘“user_overview_sortings”’::regclass
^
(ActiveRecord::StatementInvalid)
lib/session_helper/collection_base.rb:11:in session' lib/session_helper.rb:25:in block in default_collections’
lib/session_helper.rb:23:in each' lib/session_helper.rb:23:in default_collections’
lib/session_helper.rb:5:in json_hash' app/controllers/sessions_controller.rb:45:in show’
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, [2023-01-13T08:52:14.686693 #2918-112340] INFO – : Completed 422 Unprocessable Entity in 19ms (Views: 0.2ms | ActiveRecord: 4.9ms | Allocations: 7714)
--------------- end of log ------------------
i was just trying to open the login page.
192.168.1.46 is the machine i’m trying to access zammad from
here the zammad nginx log from accessing the machine:
192.168.1.46 - - [13/Jan/2023:08:52:14 +0000] “GET / HTTP/1.1” 200 1569 “-” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0”
192.168.1.46 - - [13/Jan/2023:08:52:14 +0000] “POST /api/v1/signshow HTTP/1.1” 422 202 “http://192.168.1.38/” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0”
so accessing the zammad virtual machine seems ok (http 200)
seems the error is:
[2023-01-13T08:52:14.683156 #2918-112340] ERROR – : PG::UndefinedTable: ERROR: relation “user_overview_sortings” does not exist
LINE 8: WHERE a.attrelid = ‘“user_overview_sortings”’::regclass
Possible a db con problem?
no errors in:
/var/log/nginx/zammad.error.log
Did you change any credential information eventually?
Do you have any clue what was happening during the last updates?
Thank you
