1 Topic by zipline

  • zipline
  • Member
  • Offline
  • Registered: 2016-01-19
  • Posts: 14

Topic: 'Greylisting Whitelist Domains' table is missing

==== Required information ====
- iRedMail version (check /etc/iredmail-release): v0.9.4
- Linux/BSD distribution name and version: Ubuntu 14.04.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes v2.3.1
- Related log if you're reporting an issue:
====

Hi, I have a newer IRedMail server that works great. Today, I tried to enable greylisting for a particular domain and I ran into an error:

Error: (1146, "Table 'iredapd.greylisting_whitelist_domains' doesn't exist")

I tried searching around and couldn't find anyone experiencing the same problem so this is likely self inflicted but I am unsure how.  So I guess I have a couple of questions. What did I do to create a scenario where this table isn't present? Is there some sort of SQL dump of this table someone can provide so that I can build it now?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,172

Re: 'Greylisting Whitelist Domains' table is missing

*) Which SQL tables do you have in SQL database "iredapd"?
*) If you missed some sql tables, you can open file /opt/iredapd/SQL/iredapd.mysql, copy the SQL commands used to create the missed sql table.

3 Reply by zipline

  • zipline
  • Member
  • Offline
  • Registered: 2016-01-19
  • Posts: 14

Re: 'Greylisting Whitelist Domains' table is missing

I have the tables:

greylisting
greylisting_tracking
greylisting_whitelists
throttle
throttle_tracking

4 Reply by zipline

  • zipline
  • Member
  • Offline
  • Registered: 2016-01-19
  • Posts: 14

Re: 'Greylisting Whitelist Domains' table is missing

I have had a chance to check the file /opt/iredapd/SQL/iredapd.mysql which is present on the server. Upon review I see that it has all of the tables that I have listed in my previous post but it does not have the table listed as missing greylisting_whitelist_domains. It appears everything in the file has been created on the server. Are there other tables I am missing?

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,172

Re: 'Greylisting Whitelist Domains' table is missing

Which version of iRedAPD are you running? please show us output of command:

ls -l /opt/

6 Reply by zipline

  • zipline
  • Member
  • Offline
  • Registered: 2016-01-19
  • Posts: 14

Re: 'Greylisting Whitelist Domains' table is missing

I ran the command and the output was as follows:

ubuntu@iredmail:~$ ls -l /opt/
total 8
lrwxrwxrwx 1 root root   18 Jan 18 10:20 iredapd -> /opt/iRedAPD-1.7.0
dr-x------ 7 root root 4096 Jan 18 10:46 iRedAPD-1.7.0
drwxr-xr-x 7 root root 4096 Jan 28 09:29 www

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,172

Re: 'Greylisting Whitelist Domains' table is missing

iredapd.greylisting_whitelist_domains was introduced in iRedAPD-1.8.0, which is shipped in iRedMail-0.9.4, and mentioned in iRedMail upgrade tutorial.

Seems you didn't upgrade iRedAPD during upgrading iRedMail, here's the tutorial:
http://www.iredmail.org/docs/upgrade.iredapd.html

8 Reply by d4Mn3d

  • d4Mn3d
  • Member
  • Offline
  • Registered: 2016-04-01
  • Posts: 11

Re: 'Greylisting Whitelist Domains' table is missing

==== Required information ====
- iRedMail version (check /etc/iredmail-release): v0.9.4
- Linux/BSD distribution name and version: Debian Jessie 64bit
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PostgreSQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes v2.3.1
- Related log if you're reporting an issue:
====

Hi all, i have the same problem but my iredapd version is the 1.8.0.

Schema |          Name               |  Type   | Owner
--------+------------------------+---------+--------------
 public | greylisting                  | table   | iredapd
 public | greylisting_tracking    | table   | iredapd
 public | greylisting_whitelists  | table   | iredapd
 public | throttle                      | table   | iredapd
 public | throttle_tracking        | table   | iredapd
(5 rows)

9 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,172

Re: 'Greylisting Whitelist Domains' table is missing

d4Mn3d wrote:

Hi all, i have the same problem but my iredapd version is the 1.8.0.

*) Did you run the script shipped in iRedAPD-1.8.0 to upgrade iRedAPD? Check our tutorial here:
http://www.iredmail.org/docs/upgrade.iredapd.html

*) You can simply fix it by copy SQL commands from /opt/iRedAPD-1.8.0/SQL/iredapd.pgsql and run it to create missing sql tables.

10 Reply by d4Mn3d (edited by d4Mn3d 2016-04-04 15:44:33)

  • d4Mn3d
  • Member
  • Offline
  • Registered: 2016-04-01
  • Posts: 11

Re: 'Greylisting Whitelist Domains' table is missing

Thank you Zhang, i followed step by step your tutorial. Now I execute manually the script in  /opt/iRedAPD-1.8.0/SQL/iredapd.pgsql

my situation now is:

 Schema |                    Name                      |   Type     |   Owner
-----------+----------------------------------------+------------+--------------
 public   |   greylisting                               |    table    | iredapd
 public   |   greylisting_tracking                 |    table    | iredapd
 public   |   greylisting_whitelist_domains  |    table    | iredapd
 public   |   greylisting_whitelists               |    table    | iredapd
 public   |   throttle                                    |    table    | iredapd
 public   |   throttle_tracking                      |    table    | iredapd
(6 rows)

11 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,172

Re: 'Greylisting Whitelist Domains' table is missing

Any issues?