Upgrade from Lion Server to ML 10.8.1 Broke Mail server!

Mark and Hay; Sorry had do do some work for cleints and turned attention away from mailserver problems for a few hours.........It seems like these remaining probelms can be solved through configuration repairs since most parts of MTA and Postfix are working ok now........

Status:

1. Internal local mail is being sent and delivered ok.

2. Outgoing (outbound) Mail to internet address is being sent and delivred ok.

3. Local Mail cleints can connect to PostOffice and See mail and archives and folders in IMAP ok.

Not Working: Inbound Mail from Ineternet is being queued but not delivered. I haven't made any chnages to main.cf to address aliaises errors since 2:00pm EDT; waiting to see if the situation clarified itself....

A. Here are current Messages at Mail Log on Server:

Sep 10 19:00:00 plg1.plg-law.com postfix/smtpd[12591]: 8B0581A53F79: client=localhost[127.0.0.1]

Sep 10 19:00:00 plg1.plg-law.com postfix/cleanup[12588]: 8B0581A53F79: message-id=<20120910230000.3D46E1A53F72@plg1.plg-law.com>

Sep 10 19:00:00 plg1.plg-law.com postfix/smtpd[12591]: disconnect from localhost[127.0.0.1]

Sep 10 19:00:00 plg1.plg-law.com postfix/qmgr[7426]: 8B0581A53F79: from=<_mailman@plg1.plg-law.com>, size=1048, nrcpt=1 (queue active)

Sep 10 19:00:00 plg1.plg-law.com postfix/trivial-rewrite[12543]: warning: do not list domain plg1.plg-law.com in BOTH mydestination and virtual_alias_domains

Sep 10 19:00:00 plg1.plg-law.com postfix/smtp[12589]: 3D46E1A53F72: to=<_mailman@plg1.plg-law.com>, orig_to=<_mailman>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.42, delays=0.06/0.06/0/0.3, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as 8B0581A53F79)

Sep 10 19:00:00 plg1.plg-law.com postfix/qmgr[7426]: 3D46E1A53F72: removed

Sep 10 19:00:00 plg1.plg-law.com postfix/local[12592]: error: open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:00:00 plg1.plg-law.com postfix/local[12592]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:00:00 plg1.plg-law.com postfix/local[12592]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:00:00 plg1.plg-law.com postfix/local[12592]: 8B0581A53F79: to=<_mailman@plg1.plg-law.com>, relay=local, delay=0.08, delays=0.05/0.01/0/0.01, dsn=4.3.0, status=deferred (alias database unavailable)

B. Here is what the Server Issues on a Mail Server Restart by Server.App:

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: error: open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/qmgr[13303]: 4D73C1A5106A: from=<_mailman@plg1.plg-law.com>, size=1048, nrcpt=1 (queue active)

Sep 10 19:02:56 plg1.plg-law.com postfix/qmgr[13303]: 4DFEB1A53EF8: from=<_mailman@plg1.plg-law.com>, size=1048, nrcpt=1 (queue active)

Sep 10 19:02:56 plg1.plg-law.com postfix/qmgr[13303]: E763E1A520AE: from=<_mailman@plg1.plg-law.com>, size=1048, nrcpt=1 (queue active)

Sep 10 19:02:56 plg1.plg-law.com postfix/qmgr[13303]: E9F2C1A534A2: from=<_mailman@plg1.plg-law.com>, size=1048, nrcpt=1 (queue active)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: error: open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: 00D531A53DBF: to=<_mailman@plg1.plg-law.com>, relay=local, delay=1076, delays=1076/0.11/0/0.07, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: 159141A53BD3: to=<_mailman@plg1.plg-law.com>, relay=local, delay=2276, delays=2276/0.07/0/0.06, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: 3FEA11A52A9F: to=<_mailman@plg1.plg-law.com>, relay=local, delay=8876, delays=8875/0.19/0/0.01, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: 4D73C1A5106A: to=<_mailman@plg1.plg-law.com>, relay=local, delay=18476, delays=18475/0.19/0/0.01, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: 4DFEB1A53EF8: to=<_mailman@plg1.plg-law.com>, relay=local, delay=476, delays=475/0.18/0/0.01, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13306]: E9F2C1A534A2: to=<_mailman@plg1.plg-law.com>, relay=local, delay=4676, delays=4676/0.18/0/0, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13307]: E763E1A520AE: to=<_mailman@plg1.plg-law.com>, relay=local, delay=13074, delays=13074/0.18/0/0.02, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:02:56 plg1.plg-law.com postfix/local[13314]: error: open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:02:57 plg1.plg-law.com mail_groups[13273]: newaliases returned: postalias: fatal: open //aliases: No such file or directory

Sep 10 19:02:57 plg1.plg-law.com mail_groups[13273]: no enabled mail groups found

Sep 10 19:02:57 plg1.plg-law.com mail_groups[13273]: sleeping for: 1 hour(s)

Sep 10 19:05:00 plg1.plg-law.com postfix/pickup[13302]: 66C8B1A540C3: uid=78 from=<_mailman>

Sep 10 19:05:00 plg1.plg-law.com postfix/cleanup[13535]: 66C8B1A540C3: message-id=<20120910230500.66C8B1A540C3@plg1.plg-law.com>

Sep 10 19:05:00 plg1.plg-law.com postfix/qmgr[13303]: 66C8B1A540C3: from=<_mailman@plg1.plg-law.com>, size=645, nrcpt=1 (queue active)

Sep 10 19:05:00 plg1.plg-law.com postfix/smtp[13537]: error: open database /etc/postfix/sasl/passwd.db: No such file or directory

Sep 10 19:05:00 plg1.plg-law.com postfix/smtpd[13539]: connect from localhost[127.0.0.1]

Sep 10 19:05:00 plg1.plg-law.com postfix/smtpd[13539]: AE5EF1A540CD: client=localhost[127.0.0.1]

Sep 10 19:05:00 plg1.plg-law.com postfix/cleanup[13535]: AE5EF1A540CD: message-id=<20120910230500.66C8B1A540C3@plg1.plg-law.com>

Sep 10 19:05:00 plg1.plg-law.com postfix/qmgr[13303]: AE5EF1A540CD: from=<_mailman@plg1.plg-law.com>, size=1048, nrcpt=1 (queue active)

Sep 10 19:05:00 plg1.plg-law.com postfix/local[13540]: error: open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:05:00 plg1.plg-law.com postfix/local[13540]: warning: hash:/Library/Server/Mail/Config/postfix/aliases is unavailable. open database /Library/Server/Mail/Config/postfix/aliases.db: No such file or directory

Sep 10 19:05:00 plg1.plg-law.com postfix/local[13540]: warning: hash:/Library/Server/Mail/Config/postfix/aliases: lookup of '_mailman' failed

Sep 10 19:05:00 plg1.plg-law.com postfix/local[13540]: AE5EF1A540CD: to=<_mailman@plg1.plg-law.com>, relay=local, delay=0.06, delays=0/0.02/0/0.04, dsn=4.3.0, status=deferred (alias database unavailable)

Sep 10 19:05:00 plg1.plg-law.com postfix/smtp[13537]: 66C8B1A540C3: to=<_mailman@plg1.plg-law.com>, orig_to=<_mailman>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.41, delays=0.03/0.04/0.01/0.33, dsn=2.0.0, status=sent (250 2.0.0 from MTA(smtp:[127.0.0.1]:10025): 250 2.0.0 Ok: queued as AE5EF1A540CD)

Sep 10 19:05:00 plg1.plg-law.com postfix/qmgr[13303]: 66C8B1A540C3: removed

Thanks for your help and suggestions and insight!

Sorry for typos... long day

Well: Almost all errors are now resolved with all of the edits to Main.cf. One error remains, all incoming Internet mail through SMTP gateway to an " User Alias" fails delivery. SMTP Log reports unable to lookup alises. But mail to the full User name is delivered properly.🙂

Using a prior Tech Discussion with solutions on m,issing aliaises we tried two commands.

I tried to Run Postaliases /?library/server/Mail/Config/postfix/aliases but the command is not found. I also tried Newaliases, but it reports // Aliases not found.😕

Both /etc/postfix and /Library/Serevr/Mail/Config/postfix have a "aliases" file and its the same one that worked previously. For some reason we cannot rebuild aliases.db file. Maybe a permissions problem?

Any Suggestions? Path to Newaliases command or Postaliases Command?

Well Patience and perserverance has almost won the day.

Almost all errors are now resolved with all of the edits to Main.cf. One error remains, all incoming Internet mail through SMTP gateway to an " User Alias" fails delivery. SMTP Log reports unable to lookup alises. But mail to the full User name is delivered properly.🙂

Using a prior Tech Discussion with solutions on m,issing aliaises we tried two commands.

I tried to Run Postaliases /?library/server/Mail/Config/postfix/aliases but the command is not found. I also tried Newaliases, but it reports // Aliases not found.😕

Both /etc/postfix and /Library/Serevr/Mail/Config/postfix have a "aliases" file and its the same one that worked previously. For some reason we cannot rebuild aliases.db file. Maybe a permissions problem?

Any Suggestions? Path to Newaliases command or Postaliases Command?

Hay: Thanks. Made the edit to Main.cf.

Then trtied to run sudo /usr/bin/newaliases command as you directed....But it fails issung error that says "// aliases" not found. No aliases.db file is created.

Yet the aliases file is in both /etc/postfix and the other directory?

I tried issuing command from the root directory, from /etc/postfix and the /Library/Server/Mail/Config/postfix locations, all with the same result?

Hmm.......Permissions, rights maybe?

Yes there is an aliases file in both directories...I have checked and viewed contents and it looks normal.

Yes this server has been upgraded all the way from 10.5, although the SL server 10.6 was a clean install then datat migration.

Early in this process when I opened my Discussion, I ran the newalises command and a aliases.db file was built! That was then, this is now....Now I can't get a aliases.db file built? No Aliases.db file in either directory at present.

Hmm..

Thanks, BJP

Hay: None of this worked. But I went back to run Disk Utility to Check permissions...And Guess what? /etc/aliases is mentioned as haviong wrong permissions.

I fixed the permissions using Disk Utility then tried newaliases [ sudo /usr/bin/newaliases] again...Same result.

I re-check Disk Utility...It id's /etc/aliases as wrong pemrisisons again.... Mail server logs show same errors as manually running new aliaises command: " //aliases not found....So for some reason the aliases.db is not being built correctly. Maybe permisisons problem?

Not sure why the disk Utility can't permanently repair the permissions. Odd that the /privcate/etc/alias directory has the ..problems.and the newaliaises command is not working correctly.

Now I am booting from Recovery Partition to fix permissions and see if Fix for permissions to /Private/etc/alias sticks...