1 Topic by gavin.c

  • gavin.c
  • Member
  • Offline
  • Registered: 2020-09-30
  • Posts: 4

Topic: ERROR: relation "forwardings" does not exist

iRedMail version 1.3.1 PGSQL
Deployed with downloadable installer
Ubuntu 20.04.1 LTS
Web server - Nginx
Not pro

I'm trying to set mail forwarding using command line according to this:
https://docs.iredmail.org/sql.user.mail … mmand-line

postgres=# USE vmail;
ERROR:  syntax error at or near "USE"
LINE 1: USE vmail;
        ^
postgres=# INSERT INTO forwardings (address,
postgres(#                          forwarding,
postgres(#                          domain,
postgres(#                          dest_domain,
postgres(#                          is_forwarding,
postgres(#                          active)
postgres-#                  VALUES ('xxxxx@xxxxxx.co.uk',
postgres(#                          'xxxxx@xxxxxx.co.uk',
postgres(#                          'xxxxxx.co.uk',
postgres(#                          'xxxxxx.co.uk',
postgres(#                          1,
postgres(#                          1);
ERROR:  relation "forwardings" does not exist
LINE 1: INSERT INTO forwardings (address,

I'm new to iRedmail so please excuse if its a noob mistake in commands.

----

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

2 Reply by craig

  • craig
  • Member
  • Offline
  • From: Canada
  • Registered: 2013-09-04
  • Posts: 272

Re: ERROR: relation "forwardings" does not exist

Looks right to me. That said, I use HeidiSQL for 98% of my SQL work:

https://www.heidisql.com/


Craig

3 Reply by ZhangHuangbin

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

Re: ERROR: relation "forwardings" does not exist

Seems you're running an old iRedMail release, because "forwardings" table was introduced in iRedMail-0.9.7.
What's the full content of file /etc/iredmail-release on your server?

4 Reply by gavin.c

  • gavin.c
  • Member
  • Offline
  • Registered: 2020-09-30
  • Posts: 4

Re: ERROR: relation "forwardings" does not exist

1.3.1 PGSQL edition.
# Get professional support from iRedMail Team: http://www.iredmail.org/support.html

5 Reply by gavin.c

  • gavin.c
  • Member
  • Offline
  • Registered: 2020-09-30
  • Posts: 4

Re: ERROR: relation "forwardings" does not exist

It is a new install from the script just a few days ago so I don't see how it can be an old version.

6 Reply by ZhangHuangbin

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

Re: ERROR: relation "forwardings" does not exist

gavin.c wrote:

It is a new install from the script just a few days ago so I don't see how it can be an old version.

Did you restore SQL database from an old iRedMail server?

7 Reply by gavin.c

  • gavin.c
  • Member
  • Offline
  • Registered: 2020-09-30
  • Posts: 4

Re: ERROR: relation "forwardings" does not exist

ZhangHuangbin wrote:
gavin.c wrote:

It is a new install from the script just a few days ago so I don't see how it can be an old version.

Did you restore SQL database
from an old iRedMail server?

No, it was a clean install, nothing old imported.

8 Reply by ZhangHuangbin

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

Re: ERROR: relation "forwardings" does not exist

SQL table "vmail.forwardings" was introduced in iRedMail-0.9.7, i have no idea why your fresh installation with iRedMail-1.3.1 doesn't have it.