1

Topic: Internal server error after login

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.2
- Deployed with iRedMail Easy or the downloadable installer? Installer
- Linux/BSD distribution name and version: Ubuntu 20.04.4 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No, i use open source edition
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Good afternoon!

I am faced with the following problem. After entering the postmaster login and password, I get an Internal server error.
I didn't find any error description in the nginx and syslog log files (just error 500).
I have updated iRedAdmin, iRedAPD and mlmmjadmin to the latest version. The error remained.
For more information, I entered the command "sudo python3 iredadmin.py " in the iredadmin directory, connected to the web interface and entered a username and password.
In the console I got the following output:

0.0 (1): DELETE FROM sessions WHERE '2023-05-24T09:23:38.026363' > atime
0.0 (2): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (3): SELECT k,v FROM settings WHERE account='global' AND k IN ('admin_login_ip_list')
0.0 (4): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (5): INSERT INTO sessions (atime, data, session_id) VALUES ('2023-05-24T09:53:38.175128', 'gASV1AAAAAAAAAB9lCiMCnNlc3Npb25faWSUjChlZjYwYWQ2YjgyODE5OTdiNjNiMGZmMmFhMGI5\nNDg3MThmYmYzNjFmlIwJd2VibWFzdGVylIwXcG9zdG1hc3RlckBrYXZpY2hraS5jb22UjAh1c2Vy\nbmFtZZROjAZsb2dnZWSUiYwPaXNfZ2xvYmFsX2FkbWlulImMDGZhaWxlZF90aW1lc5RLAIwEbGFu\nZ5SMBWVuX1VTlIwPc2hvd191c2VkX3F1b3RhlIiMAmlwlIwNMzcuMTkzLjEyNi4yOJR1Lg==\n', 'ef60ad6b8281997b63b0ff2aa0b948718fbf361f')
"myip":50604 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /" - 200 OK
"myip":50604 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/css/reset.css" - 200
"myip":50612 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/css/screen.css" - 200
"myip":50612 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/images/header.png" - 200
"myip":50604 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/images/bck_white_10.png" - 200
"myip":50626 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/images/login.jpg" - 200
"myip":50628 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/images/gear.png" - 200
"myip":50638 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/images/login_header.png" - 200
"myip":50654 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/default/images/bck_black_70.png" - 200
"myip":50626 - - [24/May/2023 09:53:38] "HTTP/1.1 GET /static/favicon.ico" - 200
0.0 (1): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (2): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (3): UPDATE sessions SET atime = '2023-05-24T09:54:05.300693' WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
ERR: SELECT password, language, settings FROM admin WHERE username='postmaster@mydomain.com' AND active=1 LIMIT 1
Traceback (most recent call last):
  File "/opt/www/iRedAdmin-2.3/web/application.py", line 277, in process
    return self.handle()
  File "/opt/www/iRedAdmin-2.3/web/application.py", line 268, in handle
    return self._delegate(fn, self.fvars, args)
  File "/opt/www/iRedAdmin-2.3/web/application.py", line 510, in _delegate
    return handle_class(cls)
  File "/opt/www/iRedAdmin-2.3/web/application.py", line 488, in handle_class
    return tocall(*args)
  File "/opt/www/iRedAdmin-2.3/controllers/sql/basic.py", line 46, in POST
    auth_result = auth.auth(conn=conn,
  File "/opt/www/iRedAdmin-2.3/libs/sqllib/auth.py", line 28, in auth
    result = conn.select('admin',
  File "/opt/www/iRedAdmin-2.3/web/db.py", line 870, in select
    return self.query(qout, processed=True)
  File "/opt/www/iRedAdmin-2.3/web/db.py", line 817, in query
    self._db_execute(db_cursor, sql_query)
  File "/opt/www/iRedAdmin-2.3/web/db.py", line 744, in _db_execute
    out = cur.execute(query, params)
  File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
    result.read()
  File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
    first_packet = self.connection._read_packet()
  File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, "Unknown column 'language' in 'field list'")

0.0 (4): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (5): UPDATE sessions SET atime = '2023-05-24T09:54:05.364149', data = 'gASV1AAAAAAAAAB9lCiMCnNlc3Npb25faWSUjChlZjYwYWQ2YjgyODE5OTdiNjNiMGZmMmFhMGI5\nNDg3MThmYmYzNjFmlIwJd2VibWFzdGVylIwXcG9zdG1hc3RlckBrYXZpY2hraS5jb22UjAh1c2Vy\nbmFtZZROjAZsb2dnZWSUiYwPaXNfZ2xvYmFsX2FkbWlulImMDGZhaWxlZF90aW1lc5RLAIwEbGFu\nZ5SMBWVuX1VTlIwPc2hvd191c2VkX3F1b3RhlIiMAmlwlIwNMzcuMTkzLjEyNi4yOJR1Lg==\n' WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
"myip":44824 - - [24/May/2023 09:54:05] "HTTP/1.1 POST /login" - 500 Internal Server Error
0.0 (1): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (2): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (3): UPDATE sessions SET atime = '2023-05-24T09:54:05.670188' WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (4): SELECT * FROM sessions WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
0.0 (5): UPDATE sessions SET atime = '2023-05-24T09:54:05.679749', data = 'gASV1AAAAAAAAAB9lCiMCnNlc3Npb25faWSUjChlZjYwYWQ2YjgyODE5OTdiNjNiMGZmMmFhMGI5\nNDg3MThmYmYzNjFmlIwJd2VibWFzdGVylIwXcG9zdG1hc3RlckBrYXZpY2hraS5jb22UjAh1c2Vy\nbmFtZZROjAZsb2dnZWSUiYwPaXNfZ2xvYmFsX2FkbWlulImMDGZhaWxlZF90aW1lc5RLAIwEbGFu\nZ5SMBWVuX1VTlIwPc2hvd191c2VkX3F1b3RhlIiMAmlwlIwNMzcuMTkzLjEyNi4yOJR1Lg==\n' WHERE session_id='ef60ad6b8281997b63b0ff2aa0b948718fbf361f'
"myip":44824 - - [24/May/2023 09:54:05] "HTTP/1.1 GET /favicon.ico" - 404 Not Found

I noticed the line "mysql.err.InternalError: (1054, "Unknown column 'language' in 'field list'")", but I don't understand how to fix it. Can you suggest how this can be solved?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Internal server error after login

2 SQL tables in "vmail" database have "language" column: admin, mailbox, and they exist since first iRedMail release. No idea why your installation doesn't have it ...

Anyway, find the missing one and add it manually.
FYI https://github.com/iredmail/iRedMail/bl … mail.mysql

3

Re: Internal server error after login

There were no more than half of the fields in the admin table.
I think the reason for this is not to find out, the mail server was not set up by me, I was "given" it for repair.
I added the missing fields, access to the web interface appeared.
Thank you for your help!