Topic: Upgrade to Trixie... errors on TASK mlmmjadmin Sync profiles to SQL
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 2025122901 (Backend: mariadb, Date: 2025-12-29 23:53:44) iRedMail Enterprise Edition:
- Deployed with iRedMail Easy or the downloadable installer? iredmail EE
- Linux/BSD distribution name and version: Trixie 13.2
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? iredmail EE
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
After upgrade to Trixie, and re-deploy iredmail EE, some errors appears on mlmmjadmin sync task...
TASK [mlmmjadmin] Sync profiles to SQL/LDAP.
failed
stderr: Traceback (most recent call last):
File "/opt/mlmmjadmin/tools/sync_profiles_to_db.py", line 82, in
qr = conn.select("maillists", what="address", where="active=1")
File "/opt/mlmmjadmin/tools/../web/db.py", line 870, in select
return self.query(qout, processed=True)
~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 816, in query
db_cursor = self._db_cursor()
File "/opt/mlmmjadmin/tools/../web/db.py", line 723, in _db_cursor
return self.ctx.db.cursor()
^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 661, in _getctx
self._load_context(self._ctx)
~~~~~~~~~~~~~~~~~~^^^^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 673, in _load_context
ctx.db = self._connect(self.keywords)
~~~~~~~~~~~~~^^^^^^^^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 701, in _connect
return self.db_module.connect(**keywords)
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 292, in __init__
self.ctx = self._create_ssl_ctx(ssl)
~~~~~~~~~~~~~~~~~~~~^^^^^
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 373, in _create_ssl_ctx
ca = sslp.get("ca")
^^^^^^^^
AttributeError: 'set' object has no attribute 'get'
[ERROR] task error: exit status 1, Traceback (most recent call last):
File "/opt/mlmmjadmin/tools/sync_profiles_to_db.py", line 82, in
qr = conn.select("maillists", what="address", where="active=1")
File "/opt/mlmmjadmin/tools/../web/db.py", line 870, in select
return self.query(qout, processed=True)
~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 816, in query
db_cursor = self._db_cursor()
File "/opt/mlmmjadmin/tools/../web/db.py", line 723, in _db_cursor
return self.ctx.db.cursor()
^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 661, in _getctx
self._load_context(self._ctx)
~~~~~~~~~~~~~~~~~~^^^^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 673, in _load_context
ctx.db = self._connect(self.keywords)
~~~~~~~~~~~~~^^^^^^^^^^^^^^^
File "/opt/mlmmjadmin/tools/../web/db.py", line 701, in _connect
return self.db_module.connect(**keywords)
~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 292, in __init__
self.ctx = self._create_ssl_ctx(ssl)
~~~~~~~~~~~~~~~~~~~~^^^^^
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 373, in _create_ssl_ctx
ca = sslp.get("ca")
^^^^^^^^
AttributeError: 'set' object has no attribute 'get'
...ignore error
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.