[Sqlgrey-users] greylisting and UTF8

[Nicolas S. <Ni...@st...>]

Hi,

I have encountered this error while using sqlgrey:

Nov 25 08:43:20 ovh sqlgrey: mail: failed to send: Cannot allocate memory
Nov 25 08:43:20 ovh sqlgrey: dbaccess: error: couldn't access from_awl
table:
Nov 25 08:43:20 ovh sqlgrey: dbaccess: warning: couldn't do query:
UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE
sender_name = 'robertandr�2' AND sender_domain = 'ohiohills.com' AND src
= '222.123.27.243': ERREUR:  Séquence d'octets invalide pour le codage
«UTF8» : 0xe93227 HINT:  Cette erreur peut aussi survenir si la séquence
d'octets ne correspond au jeu de caractères attendu par le serveur et
qui est contrôlé par « client_encoding ». , reconnecting to DB
Nov 25 08:43:30 ovh sqlgrey: mail: failed to send: Cannot allocate memory

The important thing is that by using UTF8 characters in the FROM adress,
any machine is able to bypass sqlgrey because it fails to deal with UTF8
characters... Is there any workaround for this ? I'm using sqlgrey 1.7.3
with postgresql.

Thanks,
-- 
Nico
La science ne se soucie ni de plaire, ni de déplaire, elle est
inhumaine.
	-+- Jacques Anatole François Thibault dit Anatole France
	    (1844-1924) -+-