1

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.

2

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

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?

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

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

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

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?

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

7

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

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.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee