Topic: Iredapd problem after version upgrade from 2.2 to 2.3
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9 MYSQL edition.
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: FreeBSD 12.0-RELEASE amd64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
After upgrade iredapd version from 2.2 to 2.3
I get error:
Traceback (most recent call last):
  File "/opt/iredapd/tools/spf_to_greylist_whitelists.py", line 91, in <module>
    qr = conn.select('greylisting_whitelist_domains', what='domain')
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 719, in select
    return self.query(qout, processed=True)
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 678, in query
    db_cursor = self._db_cursor()
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 590, in _db_cursor
    return self.ctx.db.cursor()
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 531, in _getctx
    self._load_context(self._ctx)
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 542, in _load_context
    ctx.db = self._connect(self.keywords)
  File "/usr/local/lib/python2.7/site-packages/web/db.py", line 570, in _connect
    return self.db_module.connect(**keywords)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2026, 'SSL connection error: error:00000001:lib(0):func(0):reason(1)')
I have correct SQL username/password for SQL database "iredapd" in /opt/iredapd/settings.py
I successfully logged in from console mysql -u iredapd -p
use iredapd;
select * from greylisting_whitelist_domains;
+----+--------------------------+
| id | domain                   |
+----+--------------------------+
|  1 | amazon.com               |
|  2 | aol.com                  |
|  3 | cloudfiltering.com       |
|  4 | cloudflare.com           |
|  5 | constantcontact.com      |
|  6 | craigslist.org           |
|  7 | cust-spf.exacttarget.com |
|  8 | ebay.com                 |
|  9 | exacttarget.com          |
| 10 | facebook.com             |
How can I solve the problem?
Thanks.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

