Topic: Error due to apostrophe in email address
==== Required information ====
- iRedMail version: 0.9.5-1
- Linux/BSD distribution name and version: CentOS 7
- Store mail accounts in which backend: PGSQL
- Web server: Apache
====
Hi,
I came across this log in my DB:
ERROR: syntax error at or near "xxxx" at character xxx
date time IP(number):vmail@vmail:[4243]:STATEMENT: SELECT accesspolicy, goto, moderators
FROM alias
WHERE
address='xxxxxxxx'
AND islist=1
AND active=1
LIMIT 1
The email has an apostrophe in it because of the surname. I'm not sure what this query would do however it looks like a potential injection attack?
This persons email isn't in my managed email list so I don't know why it would be being called up.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.