[postfix]550 ..: Recipient address rejected: User unknown in virtual mailbox table

[RdeWilde]

Don't I need something like

submission:localhost:25

Somewhere as transport?

[RdeWilde]

Anyone still out there to help me?

[RdeWilde]

I got this from the logs when trying to send a mail from info [aet} sove.nl to wilde825 [aet} planet.nl (sove.nl is local):

/var/log/maillog

Jul 28 13:08:41 dewildevds2 postfix/qmgr[6425]: E90463FDF1: from=<info@sove.nl>, size=2430, nrcpt=1 (queue active)
Jul 28 13:08:41 dewildevds2 postfix/pipe[6443]: E90463FDF1: to=<wilde825@planet.nl>, relay=dovecot, delay=0.1, delays=0.08/0.01/0/0.01, dsn=5.1.1, status=bounced (user unknown)
Jul 28 13:08:41 dewildevds2 postfix/cleanup[6442]: 078F03FDF3: message-id=<20080728110841.078F03FDF3@sove.nl>
Jul 28 13:08:41 dewildevds2 postfix/bounce[6445]: E90463FDF1: sender non-delivery notification: 078F03FDF3
Jul 28 13:08:41 dewildevds2 postfix/qmgr[6425]: E90463FDF1: removed

/var/log/dovecot.info.log

dovecot: 2008-07-28 13:08:41Info: auth(default): master in: USER 1 wilde825[EDIT]planet.nl service=deliver
dovecot: 2008-07-28 13:08:41Info: auth-worker(default): sql(wilde825[EDIT]planet.nl): SELECT 8 AS uid, 12 AS gid, home FROM users WHERE username = 'wilde825' AND domain = 'planet.nl'
dovecot: 2008-07-28 13:08:41Info: auth-worker(default): sql(wilde825[EDIT]planet.nl): User not found
dovecot: 2008-07-28 13:08:41Info: auth(default): master out: NOTFOUND 1

It looks like it's trying to auth my receipts, but it should only auth the sender. Is this some SASL setting?

My postconf -n if needed:

broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
html_directory = no
inet_interfaces = all
mail_owner = postfix
mailbox_command =
mailbox_transport = virtual
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = dewildevds2.jronline.nl, localhost.$mydomain, localhost
myhostname = sove.nl
mynetworks = 87.249.107.0/24 127.0.0.0/8
mynetworks_style = host
newaliases_path = /usr/bin/newaliases.postfix
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES
sample_directory = /usr/share/doc/postfix-2.3.3/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_banner = $myhostname ESMTP $mail_name
smtpd_recipient_restrictions = permit_sasl_authenticated, permit_mynetworks, reject_unauth_destination
smtpd_reject_unlisted_recipient = no
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_path = /var/run/dovecot/auth-client
smtpd_sasl_security_options = nonanonymous
smtpd_sasl_type = dovecot
unknown_local_recipient_reject_code = 450
virtual_gid_maps = static:12
virtual_mailbox_base = /var/www/client/
virtual_mailbox_domains = mysql:/etc/postfix/mysql_mailbox_domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_mailbox_maps.cf
virtual_minimum_uid = 8
virtual_transport = dovecot
virtual_uid_maps = static:8

Any help is very very welcome.

[falko]

Can you post your dovecot configuration?

[RdeWilde]

I've put it online:
http://sove.nl/dovecot.conf

## Dovecot configuration file

# If you're in a hurry, see http://wiki.dovecot.org/QuickConfiguration

# Base directory where to store runtime data.
base_dir = /var/run/dovecot/

# Protocols we want to be serving: imap imaps pop3 pop3s
# If you only want to use dovecot-auth, you can set this to "none".
protocols = imap pop3

listen = [::]

##
## Logging
##

log_path = /var/log/dovecot.log

info_log_path = /var/log/dovecot.info.log

log_timestamp = "%Y-%m-%d %H:%M:%S"

syslog_facility = mail


##
## Mailbox locations and namespaces
##

mail_location = maildir:/var/www/client/%d/mail/%n/


mail_extra_groups = mail

##
## Mail processes
##

# Enable mail process debugging. This can help you figure out why Dovecot
# isn't finding your mails.
mail_debug = yes

first_valid_uid = 4

# Default umask to use for mail files and directories.
umask = 0077

##
## Mailbox handling optimizations
##

##
## IMAP specific settings
##

protocol imap {
}
  
##
## POP3 specific settings
##

protocol pop3 {
}

##
## LDA specific settings
##

protocol lda {
  postmaster_address = postmaster@sove.nl

  #hostname = 

  #mail_plugins = 
  #mail_plugin_dir = /usr/lib/dovecot/lda

  # Binary to use for sending mails.
  sendmail_path = /usr/lib/sendmail

  # UNIX socket path to master authentication server to find users.
  auth_socket_path = /var/run/dovecot/auth-master
}



auth_verbose = yes
auth_debug = yes

auth default {

  # SQL database
  # http://wiki.dovecot.org/AuthDatabase/SQL
  passdb sql {
    # Path for SQL configuration file, see doc/dovecot-sql.conf for example
    args = /etc/dovecot.mysql.conf
  }

  # SQL database
  # http://wiki.dovecot.org/AuthDatabase/SQL
  userdb sql {
    # Path for SQL configuration file, see doc/dovecot-sql.conf for example
    args = /etc/dovecot.mysql.conf
  }

  # It's possible to export the authentication interface to other programs:
  socket listen {
    master {
      path = /var/run/dovecot/auth-master
      mode = 0660
      # Default user/group is the one who started dovecot-auth (root)
      user = dovecot
      group = mail
    }
    client {
      path = /var/run/dovecot/auth-client
      mode = 0660
      user=postfix
      group=mail
    }
  }
}

#auth external {
#  socket connect {
#    master {
#      path = /var/run/dovecot/auth-master
#    }
#  }
#}

dict {
  #quota = mysql:/etc/dovecot-dict-quota.conf 
}

##
## Plugin settings
##

plugin {
}

Part of the postfix-logfile:
http://www.sove.nl/maillog.txt

[falko]

What's in /etc/dovecot.mysql.conf?

[RdeWilde]

driver = mysql
connect = host=/var/lib/mysql/mysql.sock dbname=mail user=user password=password

password_query = SELECT NULL AS password,    CONCAT(username,'@',domain) AS user 
   FROM users 
      WHERE username = '%n' AND domain = '%d' AND mysql_pass = MD5('%w')

user_query = SELECT 8 AS uid, 12 AS gid, home 
   FROM users 
      WHERE username = '%n' AND domain = '%d'

[falko]

You might want to play around with the variables in that file: http://wiki.dovecot.org/Variables

This link could be useful as well: http://wiki.dovecot.org/AuthDatabase/SQL

[RdeWilde]

Hello Falko,

Thanks again for your help. I've looked at the url's you gave me in your previous post and i must say i'd already used many aspects of it. I can't find anything new that'll fix the problem.

Thereforer I'll give up fixing this system, and start all over from scratch with some other software. Hopefully this time I'll have some more 'luck'.