Topic: Error messages after recent upgrade to mysql 5.7.23
======== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Linux/BSD distribution name and version: FreeBSD 11.2
- 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.
Hello All,
After the recent update of the mysql I am getting the following errors in the maillog:
Aug 31 00:22:57 mail amavis[73192]: (73192-05) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 107) line 173.
Aug 31 01:01:14 mail postfix/proxymap[12740]: warning: connect to mysql server 192.168.1.101:3306: Can't connect to MySQL server on '192.168.1.101' (61)
Aug 31 01:01:14 mail postfix/trivial-rewrite[12741]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/transport_maps_maillist.cf lookup error for "*"
Aug 31 01:01:14 mail postfix/trivial-rewrite[12741]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/transport_maps_maillist.cf lookup error for "*"
Aug 31 01:01:14 mail postfix/proxymap[12740]: warning: connect to mysql server 192.168.1.101:3306: Can't connect to MySQL server on '192.168.1.101' (61)
Aug 31 01:01:14 mail postfix/cleanup[12731]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mail.eu"
Aug 31 01:01:16 mail postfix/cleanup[12731]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mail.eu"
Aug 31 01:01:16 mail postfix/cleanup[12731]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "netdata@mail.eu"
Aug 31 01:02:02 mail postfix/cleanup[12731]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@mail.eu"
Aug 31 01:02:02 mail postfix/cleanup[12731]: warning: proxy:mysql:/usr/local/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "netdata@mail.eu"
Aug 31 01:03:02 mail amavis[73178]: (73178-06) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 107) line 173.Also the cleanup_db.py cron script reports the following:
Traceback (most recent call last):
File "/opt/iredapd/tools/cleanup_db.py", line 34, in <module>
total_before = sql_count_id(conn_iredapd, 'throttle_tracking')
File "/opt/iredapd/tools/../tools/__init__.py", line 81, in sql_count_id
what='count(%s) as total' % column)
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:00000005:lib(0):func(0):DH lib')The mysql server is running without any problem? Why is this happening?
Best regards,
Tomassino
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.