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.