Created Mailalias not working in v 25.0.56

[gmcpaul]

Hi, maybe i found a bug.

when creating a alias in the webgui, the postfix log tells me that it could not be found in the aliasses map

"Recipient address rejected: User unknown in virtual mailbox table;"

i tried to restart postfix and rspamd but same problem. so could it be that the aliasses feature has some kind of flaw?

br

[gmcpaul]

found that in the webgui my alliasses are correct but in sql the table pa_alliasses there it is missing

is it possible that the new maildomain gui in the web does not update the pa_alliasses table?

i migrated from the 6.8 to the 25.x as it was merged... so maybe thats a clue as well?

[gmcpaul]

Found some similar entries in the issues search. Is there a cleanup script to be run after migrating from 6.8. to 25.x as i see that the old postfix module has become deprecated. But was there a cleanup to be done as well either automatically or manually (which i maybe missed?)

Or how is it intended to get these functions correctly working without messing up the system ?

[mschering]

Hi,

The pa_aliases is old indeed. The module postfixadmin has been replaced by the maildomains module. The aliases are now in the community_maildomains_alias table. The upgrade should have copied all from the pa_aliases to that table. Isn't that the case?

Also the debian package should have reconfigured dovecot and postix to look at the new tables. Is "groupoffice-mailserver" installed and at 25.0.x?

Best regards, Merijn

[mschering]

PS: Also check the note here: https://groupoffice.readthedocs.io/en/latest/upgrade/debian.html#mailserver

Answer Y to replace all configuration files.

[gmcpaul]

@mschering yes i remember the procedure and i did follow these steps seems the cleanup did not fully perform somehow... i remember there where problems in the early versions of the migration scripting, right?

so i have both tables and i use the new mailadmin dialog and removed the postfix plugin back then. seems that the system does lookup on the wrong tables tho

is it possible to rerun these scripts for a proper cleanup?

and i found that the postfix lookup query hasnt been replaced... user = groupoffice password = xx hosts = localhost dbname = groupoffice table = pa_aliases select_field = goto where_field = address additional_conditions = and active = '1'

[gmcpaul]

well there where mysql_virtual_alias_maps.cf.dpkg-dist and mysql_virtual_alias_maps.cf files... i replaced the table in the .cf files now as i found that it was the only thing that changed...

interesting...as i remember i answered all with yes to be replaced..

[mschering]

You could completely reinstall the mailserver by first making a backup and then remove all mailserver related packages with their configuration:

apt-get purge groupoffice-mailserver dovecot* postfix* clamav* spamassassin amavisd-new

Then reinstall:

https://groupoffice.readthedocs.io/en/latest/install/debian.html#mailserver

All mailboxes and aliases etc are in the database so they will be kept off course.

[gmcpaul]

@mschering well it seems only the postfix sql lookup queries where pointing to the old sql tables should these have been deleted after upgrading or not? pa_aliases for example.. im just asking cause https://groupoffice.readthedocs.io/en/latest/install/debian.html#external-smtp-access confuses me, if the tables should still exist after a 6.8 > 25.x upgrade or not; or maybe the manual needs some love