Postfix virtual.db Permission Denied

[German Wider]

Dear Colleagues, dear Support!

I'm seeing the following quite a lot recently in my maillogs.

Apr 23 08:33:48 xxxxxxx postfix/postalias[3630]: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied
Apr 23 10:33:48 xxxxxxx qmail-queue-handlers[3621]: handlers_stderr: postalias: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied

I can recreate the error reliably by sending an email to two addresses: Address A (which is on the server and forwards to Address B) and to Address B directly. In this case only one email is being delivered.
But I'm not sure if this is necessarily related to the issue.

Is anyone experiencing similar issues and could point me towards a solution?
Thanks a lot!

 

[IgorG]

Make sure that you have the same permissions there:

# stat /var/spool/postfix/plesk/virtual.db
File: `/var/spool/postfix/plesk/virtual.db'
Size: 12288 Blocks: 24 IO Block: 4096 regular file
Device: 2dh/45d Inode: 30362616 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 0/ root) Gid: ( 0/ root)

 

[Michael Wa.]

Yes they are the same as far as I can see:

# stat /var/spool/postfix/plesk/virtual.db
File: `/var/spool/postfix/plesk/virtual.db'
Size: 339968 Blocks: 640 IO Block: 4096 regular file
Device: 2fh/47d Inode: 46268545 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2012-01-05 13:43:24.000000000 +0100
Modify: 2012-02-17 10:43:11.000000000 +0100
Change: 2012-02-17 10:43:11.000000000 +0100

 

[Singular]

I am having this problem as well. Is there a fix for this yet? It started after the most recent automatic update.

 

[IgorG]

Can someone fill template http://forum.parallels.com/showthread.php?t=106113 with all necessary details, logs. steps to reproduce, etc of this problem?

UPD: http://forum.parallels.com/showpost.php?p=622546&postcount=8

 

[Michael Wa.]

---------------------------------------------------------------
Plesk Panel, 10.4.4 Update #27, Linux 2.6.18-028stab095.1 - CentOS release 5.8 (Final) , x86_64

PROBLEM DESCRIPTION

You can recreate the error reliably by sending an email to two addresses: Address A (which is on the server and forwards to Address B) and to Address B directly. In this case only one email is being delivered.

Error Log:
Apr 23 08:33:48 xxxxxxx postfix/postalias[3630]: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied
Apr 23 10:33:48 xxxxxxx qmail-queue-handlers[3621]: handlers_stderr: postalias: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied

--------------------------------------------------------------

 

[IgorG]

---------------------------------------------------------------
Plesk Panel, 10.4.4 Update #27, Linux 2.6.18-028stab095.1 - CentOS release 5.8 (Final) , x86_64

PROBLEM DESCRIPTION

You can recreate the error reliably by sending an email to two addresses: Address A (which is on the server and forwards to Address B) and to Address B directly. In this case only one email is being delivered.

Error Log:
Apr 23 08:33:48 xxxxxxx postfix/postalias[3630]: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied
Apr 23 10:33:48 xxxxxxx qmail-queue-handlers[3621]: handlers_stderr: postalias: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied

--------------------------------------------------------------

Did you try - http://forum.parallels.com/showpost.php?p=622546&postcount=8 ?

 

[German Wider]

Hi Igor,

yes we tried reinstalling the mail drivers. Apparently that didn't help.

What strikes me as odd is the reference to Postfix in this path "Apr 23 08:33:48 xxxxxxx postfix/postalias[3630]: fatal: open database /var/spool/postfix/plesk/virtual.db: Permission denied".
We're using Qmail.
Initially we had Postfix running, but then switched back to Qmail. Is it possible that some configuration wans't replaced properly?

Thanks for your help!
German

 

[German Wider]

Sorry, please ignore.
It seems the problem was resolved, after all, as the error messages are no longer being displayed.
The failed mail delivery must have had a different cause in this case.
Apologies!

 

[Flachzange]

As I had the same problem: Check the file permission of the parent folder "plesk". I had to assign 771 to make it work. Don't know why the user is not in group postfix. Sending of mails is now a bit faster.

File: `plesk/'
Size: 4096 Blocks: 8 IO Block: 4096 directory
Device: 1dh/29d Inode: 81674248 Links: 2
Access: (0771/drwxrwx--x) Uid: ( 108/ postfix) Gid: ( 119/ postfix)
Access: 2012-03-27 00:13:37.000000000 +0200
Modify: 2012-10-17 13:17:48.000000000 +0200
Change: 2012-10-17 15:03:19.000000000 +0200