Recent Update and SQL Grey Issues
Posted: 12 Nov 2018 23:27
Hi All,
3 Days ago we updated to the newest versions of the usual n the Webmin interface
And since then we have been getting the below errors in the logs. And each one sends me an email claiming the database is "reconnecting".
Does anyone know how to stop these?. It appears to be a Collation issues. The emails in question all appear to be spam from other languages
Nov 13 07:22:18 efa sqlgrey: warning: Use of uninitialized value $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line 1213.
Nov 13 07:22:18 efa sqlgrey: dbaccess: error: couldn't access from_awl table:
Nov 13 07:22:18 efa sqlgrey: grey: from awl match: updating xx.xxx.xxx.xxx(xxx.xxx.xxx.xxx), username@domain.ru(username@domain.ru)
Nov 13 07:22:18 efa sqlgrey: dbaccess: warning: couldn't do query:#012UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_name = 'username' AND sender_domain = 'domain.ru' AND src = 'xxx.xxx.xxx.xxx':#012Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=', reconnecting to DB
Nov 13 07:22:18 efa postfix/smtpd[18017]: E461612490A: client=host-xxx-xxx-xxx-xxx.pppoe.domain.ru[xxx.xxx.xxx.xxx]
Nov 13 07:22:18 efa postfix/pickup[871]: E893312490E: uid=500 from=<sqlgrey>
Nov 13 07:22:18 efa postfix/cleanup[18032]: E893312490E: hold: header Received: by efa.myefaname.com (Postfix, from userid 500)??id E893312490E; Tue, 13 Nov 2018 07:22:18 +1000 (AEST) from local; from=<sqlgrey@myefadomain.com> to=<postmaster@myefadomain.com>
Nov 13 07:22:18 efa postfix/cleanup[18032]: E893312490E: message-id=<20181112212218.E893312490E@efa.myefadomain.com>
3 Days ago we updated to the newest versions of the usual n the Webmin interface
And since then we have been getting the below errors in the logs. And each one sends me an email claiming the database is "reconnecting".
Does anyone know how to stop these?. It appears to be a Collation issues. The emails in question all appear to be spam from other languages
Nov 13 07:22:18 efa sqlgrey: warning: Use of uninitialized value $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line 1213.
Nov 13 07:22:18 efa sqlgrey: dbaccess: error: couldn't access from_awl table:
Nov 13 07:22:18 efa sqlgrey: grey: from awl match: updating xx.xxx.xxx.xxx(xxx.xxx.xxx.xxx), username@domain.ru(username@domain.ru)
Nov 13 07:22:18 efa sqlgrey: dbaccess: warning: couldn't do query:#012UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_name = 'username' AND sender_domain = 'domain.ru' AND src = 'xxx.xxx.xxx.xxx':#012Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=', reconnecting to DB
Nov 13 07:22:18 efa postfix/smtpd[18017]: E461612490A: client=host-xxx-xxx-xxx-xxx.pppoe.domain.ru[xxx.xxx.xxx.xxx]
Nov 13 07:22:18 efa postfix/pickup[871]: E893312490E: uid=500 from=<sqlgrey>
Nov 13 07:22:18 efa postfix/cleanup[18032]: E893312490E: hold: header Received: by efa.myefaname.com (Postfix, from userid 500)??id E893312490E; Tue, 13 Nov 2018 07:22:18 +1000 (AEST) from local; from=<sqlgrey@myefadomain.com> to=<postmaster@myefadomain.com>
Nov 13 07:22:18 efa postfix/cleanup[18032]: E893312490E: message-id=<20181112212218.E893312490E@efa.myefadomain.com>