1 Topic by chc-pr

  • chc-pr
  • Member
  • Offline
  • Registered: 2017-05-12
  • Posts: 60

Topic: 0.9.7 clean install - catchall account setup fails with 'goto' error

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.7
- Linux/BSD distribution name and version: Debian9 (Stretch)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MariaDB
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

With the arrival of 0.9.7, I have decided to convert as many of my servers to Debian9 as is practical, ie anything I install over the top of a base server install will in future be based on Debian9 (or later versions as applicable).

I have now started working my way through a clean install of iRedMail 0.9.7. I have a catchall account I use which I got working with 0.9.6 using this guide: http://www.iredmail.org/docs/sql.create.catch-all.html

When I try to use the exact same commands I used to get 0.9.6 working (just cut and pasted the entries from the log I kept of the install) I get the following error after the 'insert into alias ...' command

ERROR 1054 (42S22): Unknown column 'goto' in 'field list'

I noticed that you have stated that the db structure has changed with this version, so I guessing that is the problem?

Thanks Zhang.

----

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,163

Re: 0.9.7 clean install - catchall account setup fails with 'goto' error

Doc updated, please try again:
http://www.iredmail.org/docs/sql.create.catch-all.html

3 Reply by chc-pr

  • chc-pr
  • Member
  • Offline
  • Registered: 2017-05-12
  • Posts: 60

Re: 0.9.7 clean install - catchall account setup fails with 'goto' error

You sir are a star ...

FYI, the link (http://www.iredmail.org/docs/sql.create … 70701.html) for the 0.9.6 and older version takes you to a 404 error.

Also, I am not too sure what the following settings actually are
sql> INSERT INTO forwardings (address, forwarding, domain, dest_domain)
                      VALUES ('domain.com', 'dest@example.com', 'domain.com', 'example.com');

I believe the address and forwarding variables are the inbound domain and destination email address to be forwarded to, but what is the difference between domain and dest_domain? If a single domain is being used, would I be right in thinking the VALUES would be ('domain.com', 'dest@domain.com, 'domain.com', 'domain.com')?

4 Reply by fsantiago06111979

  • fsantiago06111979
  • Member
  • Offline
  • Registered: 2014-05-04
  • Posts: 229

Re: 0.9.7 clean install - catchall account setup fails with 'goto' error

chc-pr wrote:

You sir are a star ...

FYI, the link (http://www.iredmail.org/docs/sql.create … 70701.html) for the 0.9.6 and older version takes you to a 404 error.

Also, I am not too sure what the following settings actually are
sql> INSERT INTO forwardings (address, forwarding, domain, dest_domain)
                      VALUES ('domain.com', 'dest@example.com', 'domain.com', 'example.com');

I believe the address and forwarding variables are the inbound domain and destination email address to be forwarded to, but what is the difference between domain and dest_domain? If a single domain is being used, would I be right in thinking the VALUES would be ('domain.com', 'dest@domain.com, 'domain.com', 'domain.com')?

thanks. works fine. case closed in my mind.

5 Reply by ZhangHuangbin

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

Re: 0.9.7 clean install - catchall account setup fails with 'goto' error

"dest_domain" column must be the domain name of the forwarding address.