Topic: Error Plugin sql_alias_access_policy
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5
- Linux/BSD distribution name and version: Debian Wheezy
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- Related log if you're reporting an issue: On Below
====
I don't what happen but recently my email taking longer when recieving from my server to my outlook, when i checked in webmail the email is there but i cannot recieving it or not being forward to my outlook.
my outlook setting
POP3 over ssl on port 995
SMTP over TLS on port 587
here is the log that i got from iredapd.log (iRedApd ver. 1.9.0) :
2016-05-11 11:15:09 INFO [x.x.x.x RCPT, user@gmail.com -> user-in@domainco.id, DUNNO
2016-05-11 11:15:09 INFO [x.x.x.x] Client is whitelisted for greylisting service: (id=5, sender=x.x.x.0/17, comment="Google")
2016-05-11 11:15:09 ERROR <!> Error while applying plugin "sql_alias_access_policy": (OperationalError) (1054, "Unknown column 'islist' in 'where clause'") "SELECT accesspolicy, goto, moderators\n FROM alias\n WHERE\n address='user-in00@domainco.id'\n AND islist=1\n AND active=1\n LIMIT 1\n " ()
2016-05-11 11:15:09 INFO [x.x.x.x] RCPT, user@gmail.com -> user-in00@domainco.id, DUNNO
2016-05-11 11:15:09 INFO [x.x.x.x] Client is whitelisted for greylisting service: (id=5, sender=x.x.x.0/17, comment="Google")
2016-05-11 11:15:09 ERROR <!> Error while applying plugin "sql_alias_access_policy": (OperationalError) (1054, "Unknown column 'islist' in 'where clause'") "SELECT accesspolicy, goto, moderators\n FROM alias\n WHERE\n address='user-in01@domainco.id'\n AND islist=1\n AND active=1\n LIMIT 1\n " ()Kindly need help for the problem,
Thank you,
dbanie
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.