ISPConfig postfix problem

[andron26]

Hi,

Each time when I enter new user to ispconfig or save ispconfig configuration I have such error in postfix:

postfix/postmap: fatal: open database /etc/postfix/virtusertable.db: No such file or directory, but this file exists.

Each time I have to run command: postmap virtusertable

This problem started when I upgraded to latest version.

[Hans]

Which Linux distribution do you use?

[andron26]

OpenSuse 10.2

[andron26]

Maybe problem is that I copied old sql tables to new installation?

[andron26]

Ok, maybe someone can explain me what ispconfig is doing with virtusertable.db file after saving configuration? Why postfix thinks that this file is missing?

[andron26]

Ok I've foung the problem:

24.05.2007 - 16:07:03 => WARN - /root/ispconfig/scripts/lib/classes/ispconfig_postfix.lib.php, Line 289: WARNING: could not postmap hash:/etc/postfix/virtusertable

But what could be the reason? What privileges should be on this file? Now are root:root

[falko]

Please run

postmap hash:/etc/postfix/virtusertable

Do you get any error messages?
What's the output of

ls -la /etc/postfix

?

[andron26]

There is no error after running postmap hash:/etc/postfix/virtusertable

Output of ls -la /etc/postfix:

total 568
drwxr-xr-x 3 root root 4096 2007-05-24 18:37 .
drwxr-xr-x 86 root root 12288 2007-05-24 16:07 ..
-rw-r--r-- 1 root root 17832 2006-11-25 19:27 access
-rw-r--r-- 1 root root 12288 2007-03-15 10:30 access.db
-rw-r--r-- 1 root root 3606 2006-11-25 19:27 bounce.cf.default
-rw-r--r-- 1 root root 11175 2006-11-25 19:27 canonical
-rw-r--r-- 1 root root 12288 2007-03-15 10:30 canonical.db
-rw-r--r-- 1 root root 449 2006-11-25 19:27 dynamicmaps.cf
-rw-r--r-- 1 root root 9920 2006-11-25 19:27 generic
-rw-r--r-- 1 root root 16838 2006-11-25 19:27 header_checks
-rw-r--r-- 1 root root 11942 2006-11-25 19:27 LICENSE
-rw-r--r-- 1 root root 991 2007-05-24 16:07 local-host-names
-rw-r--r-- 1 root root 991 2007-05-24 16:07 local-host-names~
-rw-r--r-- 1 root root 27909 2007-04-02 12:12 main.cf
-rw-r--r-- 1 root root 27779 2007-03-22 10:01 main.cf.bk
-rw-r--r-- 1 root root 122 2006-11-25 19:27 main.cf.default
-rw-r--r-- 1 root root 27909 2007-05-19 20:17 main.cf.orig
-rw-r--r-- 1 root root 27450 2007-03-15 14:51 main.cf.origin
-rw-r--r-- 1 root root 1020 2006-11-25 19:27 makedefs.out
-rw-r--r-- 1 root root 3427 2007-04-23 11:02 master.cf
-rw-r--r-- 1 root root 5076 2006-10-01 19:51 master.cf.1
-rw-r--r-- 1 root root 3942 2007-03-15 10:30 master.cf.orig
-rw-r--r-- 1 root root 3432 2007-03-15 15:09 master.cf.SuSEconfig
-rw-r--r-- 1 root root 147 2007-04-25 14:45 mynetworks
-rw-r--r-- 1 root root 2255 2006-11-25 19:27 openssl_postfix.conf.in
-rw-r--r-- 1 root root 14887 2006-11-25 19:27 postfix-files
-rwxr-xr-x 1 root root 6366 2006-11-25 19:27 postfix-script
-rwxr-xr-x 1 root root 22086 2006-11-25 19:27 post-install
-rw-r--r-- 1 root root 199 2006-11-25 19:27 relay_ccerts
-rw-r--r-- 1 root root 12288 2007-03-15 10:30 relay_ccerts.db
-rw-r--r-- 1 root root 6805 2006-11-25 19:27 relocated
-rw-r--r-- 1 root root 12288 2007-03-15 10:30 relocated.db
-rw------- 1 root root 172 2007-03-22 10:16 sasl_passwd
-rw------- 1 root root 12288 2007-03-22 10:16 sasl_passwd.db
-rw------- 1 root root 172 2006-11-25 19:27 sasl_passwd.YaST2.save
-rw-r--r-- 1 root root 413 2007-03-22 10:16 sender_canonical
-rw-r--r-- 1 root root 12288 2007-03-22 10:16 sender_canonical.db
-rw-r--r-- 1 root root 412 2006-11-25 19:27 sender_canonical.YaST2.save
drwxr-xr-x 2 root root 4096 2007-04-04 12:34 ssl
-rw-r--r-- 1 root root 1629 2006-11-25 19:27 TLS_LICENSE
-rw-r--r-- 1 root root 12081 2006-11-25 19:27 transport
-rw-r--r-- 1 root root 12288 2007-03-15 10:30 transport.db
-rw-r--r-- 1 root root 11985 2007-03-22 10:16 virtual
-rw-r--r-- 1 root root 12288 2007-03-22 10:16 virtual.db
-rw-r--r-- 1 root root 11984 2006-11-25 19:27 virtual.YaST2.save
-rw-r--r-- 1 root root 30770 2007-05-24 16:07 virtusertable
-rw-r--r-- 1 root root 30770 2007-05-24 16:07 virtusertable~
-rw-r--r-- 1 root root 77824 2007-05-24 18:36 virtusertable.db

[falko]

The permissions are ok. Mine are the same.
I see that you use SuSE. Did you turn off AppArmor?

[andron26]

AppArmor is turned off.