1

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.

2

Re: Error Plugin sql_alias_access_policy

dbanie wrote:

(1054, "Unknown column 'islist' in 'where clause'")

SQL column "alias.islist" (in "vmail" database) was introduced in iRedMail-0.8.7. Seems you missed some steps in our upgrade tutorials.
http://www.iredmail.org/docs/upgrade.ir … l-database

3

Re: Error Plugin sql_alias_access_policy

ZhangHuangbin wrote:
dbanie wrote:

(1054, "Unknown column 'islist' in 'where clause'")

SQL column "alias.islist" (in "vmail" database) was introduced in iRedMail-0.8.7. Seems you missed some steps in our upgrade tutorials.
http://www.iredmail.org/docs/upgrade.ir … l-database

Hi Mr. Zhang,

Yes Indeed I miss the step after reviewing from iRedmail Documents, Thank you so much for the support and you may closed this thread.

Best Regards,
dbanie