Recent Update and SQL Grey Issues

Report bugs and workarounds
Post Reply
RampantTech
Posts: 4
Joined: 12 Nov 2018 23:05

Recent Update and SQL Grey Issues

Post by RampantTech »

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>
zthephoenixz
Posts: 26
Joined: 28 May 2015 01:55

Re: Recent Update and SQL Grey Issues

Post by zthephoenixz »

I am getting the same issue, and I didn't do any updates, so I don't think it is related.

I did find an interesting article from 2010 about this issue and I'm not ... confident on applying this fix to EFA.

https://arstechnica.com/civis/viewtopic ... 16&t=41081

Basically it is a language setting in the collation database that needs to be fixed, or on the user that runs mysql, if you figure it out let me know, if I do I will post it up.
Post Reply