Maia on Postgresql issues

Eric McCorkle <[email protected]> Wed, 01 Jul 2015 07:00:29 -0400

Newsgroups	gmane.mail.virus.maiamailguard
Message-ID	<[email protected]>

Hello everyone,

I recently set up maia with postgresql as the underlying database.  It
works more or less ok, but I ran into a few issues along the way.

First, the maia UI would display email addresses and some text fields as
'\x<hex-encoded stuff>'.  After googling a bit, I discovered that you
apparently need to un-escape bytea fields in postgresql in order to get
legible text.  After I edited the .php files to add the unescapes, it
worked well enough.  So this is fixed on my setup, but it probably ought
to get re-integrated into the main development branch.

The second issue, which I still haven't resolved, seems to be related.
The logs show that database inserts are failing for some emails (namely,
in the maia_store_mail function), due to invalid syntax of bytea values.
 I suspect this can be fixed by inserting the proper escaping code, but
I lack the perl experience to do it effectively.

Lastly, it looks like something's not working if a mail is classified as
spam.  I've had a couple of obvious spams come through that seem to get
passed on through without being flagged at all.  However, when I run
spamassassin on them myself, they score quite high.  I'm not sure if
this is related to the second issue.

Best,
Eric

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users

signature.asc (application/pgp-signature, 819 B)