1 (edited by digitec 2018-12-27 16:18:37)

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.

2

Re: Iredapd problem after version upgrade from 2.2 to 2.3

Does your MySQL server require ssl connection?

3 (edited by digitec 2019-01-02 19:50:24)

Re: Iredapd problem after version upgrade from 2.2 to 2.3

ZhangHuangbin wrote:

Does your MySQL server require ssl connection?

SSL not in use.

>SHOW VARIABLES LIKE '%ssl%';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| have_openssl  | YES             |
| have_ssl      | YES             |
| ssl_ca        | ca.pem          |
| ssl_capath    |                 |
| ssl_cert      | server-cert.pem |
| ssl_cipher    |                 |
| ssl_crl       |                 |
| ssl_crlpath   |                 |
| ssl_key       | server-key.pem  |
+---------------+-----------------+
9 rows in set (0.00 sec)

>\s
......
Current user:        root@localhost
SSL:            Not in use
......

Thanks for a reply.

4

Re: Iredapd problem after version upgrade from 2.2 to 2.3

digitec wrote:

_mysql_exceptions.OperationalError: (2026, 'SSL connection error: error:00000001:lib(0):func(0):reason(1)')

This error means it's relevant to ssl or ssl cert.

- If this mysql server is used on only localhost, you can consider disable ssl cert in mysql config file.
- try to restart mysql service, check its log file immediately, make sure no warning/error/complain about ssl cert.

5

Re: Iredapd problem after version upgrade from 2.2 to 2.3

Many thanks.