ISPConfig postfix problem

Discussion in 'Installation/Configuration' started by andron26, May 23, 2007.

  1. andron26

    andron26 New Member

    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.
     
  2. Hans

    Hans Moderator ISPConfig Developer

    Which Linux distribution do you use?
     
  3. andron26

    andron26 New Member

    OpenSuse 10.2
     
  4. andron26

    andron26 New Member

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

    andron26 New Member

    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?
     
  6. andron26

    andron26 New Member

    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
     
  7. falko

    falko Super Moderator ISPConfig Developer

    Please run
    Code:
    postmap hash:/etc/postfix/virtusertable
    Do you get any error messages?
    What's the output of
    Code:
    ls -la /etc/postfix
    ?
     
  8. andron26

    andron26 New Member

    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
     
  9. falko

    falko Super Moderator ISPConfig Developer

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

    andron26 New Member

    AppArmor is turned off.
     
  11. andron26

    andron26 New Member

    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.
     
  12. falko

    falko Super Moderator ISPConfig Developer

    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.
     
  13. andron26

    andron26 New Member

    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.
     

Share This Page