ISPConfig postfix problem

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.

 

Which Linux distribution do you use?

 

OpenSuse 10.2

 

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

 

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?

 

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

 

Please run

Code:

postmap hash:/etc/postfix/virtusertable

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

Code:

ls -la /etc/postfix

?

 

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

 

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

 

AppArmor is turned off.

 

After upgrade to latest version this problem disapeared.
Now I have another problem.
When I send message with cc and bcc it isn't delivered to cc and bcc.
I have such log entry each time I send such messages:

Jun 11 18:22:01 arka postfix/qmgr[28416]: 8F5D1BB43C3: from=<avi###@###.###.lt>, size=352, nrcpt=1 (queue active)
Jun 11 18:22:01 arka postfix/local[3699]: 8F5D1BB43C3: to=<[email protected]>, relay=local, delay=0.49, delays=0.44/0.02/0/0.04, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-)
Jun 11 18:22:01 arka postfix/qmgr[28416]: 8F5D1BB43C3: removed

I am not very good in postfix. Maybe someone one can explain me what this message means? Message is delivered only to recipient in fiel 'to'.

Sorry for my english.

 

This message appaers whenever you send a mail. It means that a message containing the size of the sent mail was sent to admispconfig so that ISPConfig can calculate email traffic statistics. That's the usual behaviour and nothing to worry about.

 

There is such problem with mail. When I send with outlook it delivers cc and bcc ok. When I send from web crm it sends only to person in field to. When I analyze postfix log I have such results:

1: from outlook:

Jun 13 13:46:02 arka postfix/smtpd[14560]: 14A21BB43B3: client=unknown[84.15.53.23]
Jun 13 13:46:02 arka postfix/cleanup[14109]: 14A21BB43B3: message-id=<000601c7ada8$0278ca50$076a5ef0$@lt>
Jun 13 13:46:02 arka postfix/qmgr[31939]: 14A21BB43B3: from=<[email protected]>, size=4215, nrcpt=2 (queue active)
Jun 13 13:46:03 arka postfix/smtp[14780]: 14A21BB43B3: to=<[email protected]>, relay=gmail-smtp-in.l.google.com[66.249.93.114]:25, delay=1.6, delays=0.44/0/0.39/0.72, dsn=2.0.0, status=sent (250 2.0.0 OK 1181731552 q56si1130050ugq)
Jun 13 13:46:03 arka postfix/local[12849]: 14A21BB43B3: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=1.6, delays=0.44/0/0/1.1, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-)
Jun 13 13:46:03 arka postfix/qmgr[31939]: 14A21BB43B3: removed

2) When I send from web crm:

/var/log/mail/mail:Jun 13 13:52:14 arka postfix/pickup[14918]: 47CE2BB4384: uid=30 from=<[email protected]>
/var/log/mail/mail:Jun 13 13:52:14 arka postfix/cleanup[14109]: 47CE2BB4384: message-id=<[email protected]>
/var/log/mail/mail:Jun 13 13:52:14 arka postfix/qmgr[31939]: 47CE2BB4384: from=<[email protected]>, size=735, nrcpt=1 (queue active)
/var/log/mail/mail:Jun 13 13:53:45 arka postfix/local[5403]: 47CE2BB4384: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=92, delays=0.44/0/0/91, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-)
/var/log/mail/mail:Jun 13 13:53:45 arka postfix/qmgr[31939]: 47CE2BB4384: removed

So when I send from web crm nrcpt=1. Recipient gets mail with info that this mail was also send with cc. Why this happenig? Maybe someone will tell me where I should start to find the reason of such behavior. The developer of crm told me that their code is allright.