bpassan2007 Author

Level 1

0 points

Upgrade from Lion Server to ML 10.8.1 Broke Mail server!

....10.8.1 OD seems to work, files and AFP available, but Mail server not working correctly. Now users don't see mail, postfix issues numerous errors about missing system_user_maps and delivers no mail? Must recover mails! Help! Where should I look, and what to read for Diagnosis ?

After upgrade in place from SL to Lion to ML. most services did not work correctly; except for Mail and DNS and OD. Reinstalled. Now most everything seems to work including Card Services, Calendars, Wiki, Web, DNS, OD. But Mail is off and missing??? No delivery of INcoming mail, No Sending Mail, no IMAP Mail login for users.

On Mail configuration in Server.App: Turned off All Filtering. Have rebooted Server several times, Restarted Mailserver from Server,app and Terninal. Same Results. Somewhere along the line from Server 10.5 to SL to Lion to 10.8 incoming Maill started going to user@PLG1.plg-law.com rather than simply user@plg-law.com.

Is it possible that virtual domains are fuzzing up the works? The error logs use the longer virtual domain (with the sevrer name prefix) rather than the domain name?

Here are some sample Log messages:

From SYStem Log:

Sep 7 19:33:56 plg1.plg-law.com postfix/cleanup[1998]: warning: 8273B199E3F8: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 7 19:33:56 plg1.plg-law.com postfix/pickup[1324]: warning: maildrop/ECF3A196A4FE: error writing 8273B199E3F8: queue file write error

Sep 7 19:33:58 plg1.plg-law.com postfix/pickup[1324]: warning: E5AC9199E3F9: message has been queued for 1 days

Sep 7 19:33:58 plg1.plg-law.com postfix/cleanup[1998]: warning: hash:/etc/postfix/system_user_maps is unavailable. open database /etc/postfix/system_user_maps.db: No such file or directory

Sep 7 19:33:58 plg1.plg-law.com postfix/cleanup[1998]: warning: hash:/etc/postfix/system_user_maps lookup error for "_mailman@plg1.plg-law.com"

Sep 7 19:33:58 plg1.plg-law.com postfix/cleanup[1998]: warning: E5AC9199E3F9: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 7 19:33:58 plg1.plg-law.com postfix/pickup[1324]: warning: maildrop/ED4AB196A4FF: error writing E5AC9199E3F9: queue file write error

Sep 7 19:33:59 plg1.plg-law.com postfix/cleanup[1998]: warning: hash:/etc/postfix/system_user_maps is unavailable. open database /etc/postfix/system_user_maps.db: No such file or directory

Sep 7 19:33:59 plg1.plg-law.com postfix/cleanup[1998]: warning: hash:/etc/postfix/system_user_maps lookup error for "_mailman@plg1.plg-law.com"

Sep 7 19:33:59 plg1.plg-law.com postfix/cleanup[1998]: warning: 385DD199E3FB: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 7 19:33:59 plg1.plg-law.com postfix/pickup[1324]: warning: maildrop/EE2A9199B211: error writing 385DD199E3FB: queue file write error

From SMTP Log:

Sep 7 19:35:24 plg1.plg-law.com postfix/pickup[1324]: 3652E199E487: uid=78 from=<_mailman>

Sep 7 19:35:24 plg1.plg-law.com postfix/cleanup[1998]: warning: hash:/etc/postfix/system_user_maps is unavailable. open database /etc/postfix/system_user_maps.db: No such file or directory

Sep 7 19:35:24 plg1.plg-law.com postfix/cleanup[1998]: warning: hash:/etc/postfix/system_user_maps lookup error for "_mailman@plg1.plg-law.com"

Sep 7 19:35:24 plg1.plg-law.com postfix/cleanup[1998]: warning: 3652E199E487: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 7 19:35:24 plg1.plg-law.com postfix/pickup[1324]: warning: maildrop/8E82B199AD06: error writing 3652E199E487: queue file write error

Mac mini (Late 2009), OS X Server, 10.8.1

Posted on Sep 7, 2012 4:50 PM

163 replies

bpassan2007 Author

Level 1

0 points

Sep 8, 2012 1:48 PM in response to haykong

Hay: Do you think I will need to CHOWN or run something else to get the rights or permissisons correct on the Mail Data moved back? If So what settings are correct for ownership of the Mail Data?

Thanks, Brian

haykong

Level 1

119 points

Sep 8, 2012 1:52 PM in response to bpassan2007

Well that's why's I requested you to log on as root user... which can verify everything

To enable root user

Go to system preferences

go to users and groups

click JOIN network server

click Open Directory Utility

click Unlock/lock button to make changes...

Go to edit menu and select Enable Root User

enter root user password to what you want and don't ever forget it

log out of your admin user and log in as root user...

Now you are root so don't mess anything up in the system and just use the root user to verify stuff...

you can even use root to move folders around, but just careful...

haykong

Level 1

119 points

Sep 8, 2012 1:56 PM in response to bpassan2007

yeah you want to change permissions so dovecot can access it...

At least you found the mail in Time Machine.....

Not sure if Time Machine might restores correct permissions.. It might...

bpassan2007 Author

Level 1

0 points

Sep 8, 2012 3:41 PM in response to haykong

Ok so using chown and logged in as Administrator i would execute:

Chown -R. _dovecot /Mail/data

Correct? Thanks

haykong

Level 1

119 points

Sep 8, 2012 3:53 PM in response to bpassan2007

looking back at my server folders... you want to start changing permissions at /Library/Server/Mail/Data/mail

for the owner _dovecot for read and write

group access permissions for mail (group)

anyway need to go out for a road biking ride.... I won't be available til late tonight.

Message was edited by: haykong

bpassan2007 Author

Level 1

0 points

Sep 8, 2012 4:33 PM in response to haykong

Ok so the user:group setting for chown should look like this:

CHOWN -R _dovecot:mail /[insert full path]

You have been really helpful. I totally appreciate it! Thanks again. Brian

bpassan2007 Author

Level 1

0 points

Sep 8, 2012 7:10 PM in response to haykong

Darn. After all of that, upon restart, all of the old Mail probelms and errors are back again. Cannot reach mail server from clients. No Joy. Arggh!

Is it possible the Main.cf file in the etc/postfix also needs to be modified?

Is it alos possible my OD Master is not owrking properly? I posted a separate question here about odd renaming of my OD Master in the upgrade process: https://discussions.apple.com/thread/4278481

I am backing everything up in cloned snapshot for tonight and will try again in the am. Maybe exporting all users (8 of them) via WorkGroup Manager, and demoting the OD to standalone, then repromoting OD to Master may resolve some of these problems. I can them reimport my users after the OD looks perfect.

Any more suggestions? Thanks

Mark23

Level 4

994 points

Sep 8, 2012 11:13 PM in response to bpassan2007

The main.cf file in /etc/postfix/ does not need to be modified.

Try running Disk Utility from the Utilities folder and click "repair permissions" try repair the permissions.

What do you mean you can't reach the mail server?

Do you have a screen shot of the error (cmd + shift + 4 + space)?

haykong

Level 1

119 points

Sep 8, 2012 11:38 PM in response to bpassan2007

What errors are you getting now? The log will help out alot. Is it really the same errors?

check if mail_transport = dovecot? I am really curious if it went blank again...

yeah as Mark mentioned the screen shot of the error would be great.

bpassan2007 Author

Level 1

0 points

Sep 9, 2012 10:36 AM in response to Mark23

Well mystery continues. Some positive progress. Maybe server just needed some time??? Odd that 10 hours of waiting and patience made a difference. Today, Surprisingly, users CAN sign in and get mail, but certain mailserver logged errors continue ad infinitum:

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: 29CDE1A2BE68: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 9 13:07:37 plg1.plg-law.com postfix/pickup[22292]: warning: maildrop/1225219F0271: error writing 29CDE1A2BE68: queue file write error

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: hash:/etc/postfix/system_user_maps is unavailable. open database /etc/postfix/system_user_maps.db: No such file or directory

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: hash:/etc/postfix/system_user_maps lookup error for "_mailman@plg1.plg-law.com"

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: 2A3881A2BE69: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 9 13:07:37 plg1.plg-law.com postfix/pickup[22292]: warning: maildrop/1299119FA588: error writing 2A3881A2BE69: queue file write error

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: hash:/etc/postfix/system_user_maps is unavailable. open database /etc/postfix/system_user_maps.db: No such file or directory

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: hash:/etc/postfix/system_user_maps lookup error for "_mailman@plg1.plg-law.com"

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: 2A92C1A2BE6A: recipient_canonical_maps map lookup problem for _mailman@plg1.plg-law.com

Sep 9 13:07:37 plg1.plg-law.com postfix/pickup[22292]: warning: maildrop/14AB719DB9DE: error writing 2A92C1A2BE6A: queue file write error

Sep 9 13:07:37 plg1.plg-law.com postfix/cleanup[22294]: warning: hash:/etc/postfix/system_user_maps is unavailable. open database /etc/postfix/system_user_maps.db: No such file or directory

Not sure if this is big problem or small. Any ideas?

Mark23

Level 4

994 points

Sep 9, 2012 10:39 AM in response to bpassan2007

Does the user _mailman actually exist?

bpassan2007 Author

Level 1

0 points

Sep 9, 2012 10:41 AM in response to haykong

And here are some erros that mirror what another posting in the forum noted, in this discussion:

https://discussions.apple.com/thread/4154813:

9/9/12 1:30:15.303 PM postfix/smtpd[23629]: error: open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:30:15.303 PM postfix/smtpd[23629]: error: open /Library/Server/Mail/Config/postfix/smtpdreject.cidr: No such file or directory

9/9/12 1:30:15.755 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:30:15.755 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:30:31.294 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:30:31.294 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:30:46.439 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:30:46.439 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:32:02.370 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:32:02.370 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:33:04.668 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:33:04.668 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:34:24.126 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:34:24.126 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:34:32.100 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:34:32.100 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:35:24.147 PM postfix/smtpd[23712]: error: open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:35:24.147 PM postfix/smtpd[23712]: error: open /Library/Server/Mail/Config/postfix/smtpdreject.cidr: No such file or directory

9/9/12 1:35:26.829 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:35:26.829 PM postfix/smtpd[23629]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:35:26.833 PM postfix/smtpd[23712]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:35:26.833 PM postfix/smtpd[23712]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:35:26.942 PM postfix/smtpd[23712]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:35:26.943 PM postfix/smtpd[23712]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:37:34.461 PM postfix/smtpd[23743]: error: open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:37:34.461 PM postfix/smtpd[23743]: error: open /Library/Server/Mail/Config/postfix/smtpdreject.cidr: No such file or directory

9/9/12 1:37:34.959 PM postfix/smtpd[23743]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:37:34.959 PM postfix/smtpd[23743]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

9/9/12 1:37:35.150 PM postfix/smtpd[23743]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject is unavailable. open database /Library/Server/Mail/Config/postfix/smtpdreject.db: No such file or directory

9/9/12 1:37:35.150 PM postfix/smtpd[23743]: warning: hash:/Library/Server/Mail/Config/postfix/smtpdreject: table lookup problem

I am going to try these corrections too. Brian

Mark23

Level 4

994 points

Sep 9, 2012 10:43 AM in response to bpassan2007

I did those adjustments fairly at the beginning, I'm glad you found it 🙂

bpassan2007 Author

Level 1

0 points

Sep 9, 2012 10:56 AM in response to Mark23

Good question. How do I check on this newer 10.8 setup? Commandline? Thanks

Mark23

Level 4

994 points

Sep 9, 2012 11:02 AM in response to bpassan2007

Within the file /Library/Server/Mail/Config/postfix/main.cf you have a few lines of code that need to be altered, something you can do in terminal by entering:

sudo nano /Library/Server/Mail/Config/postfix/main.cf

In that file a few pieces of text need to be substituted, added or removed:

change:

smtpd_client_restrictions = hash:/etc/postfix/smtpdreject cidr:/etc/postfix/smtpdreject.cidr permit_mynetworks

to:

smtpd_client_restrictions = hash:/Library/Server/Mail/Config/postfix/smtpdreject cidr:/Library/Server/Mail/Config/postfix/smtpdreject.cidr permit_mynetworks

change:

alias_maps = hash:/etc/postfix/aliases

to:

alias_maps = hash:/Library/Server/Mail/Config/postfix/aliases

remove (because there's no such file):

virtual_alias_maps = $virtual_map

add:

virtual_alias_domains = hash:/Library/Server/Mail/Config/postfix/virtual_domains

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Upgrade from Lion Server to ML 10.8.1 Broke Mail server!