Re: [Sqlgrey-users] greylisting and UTF8

[Lionel B. <lio...@bo...>]

Nicolas STRANSKY wrote the following on 25.11.2007 11:53 :
> 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
>   

Your database is configured to use the UTF-8 encoding, use ASCII instead.

> Nov 25 08:43:30 ovh sqlgrey: mail: failed to send: Cannot allocate memory
>   

It seems you have other problems...

> 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...

This isn't the problem. Mail addresses use ASCII. In ASCII some
characters aren't valid UTF-8 sequences. So you should't use UTF-8 to
store email adresses...

Lionel