Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th June 2009, 02:57
Kruser Kruser is offline
Junior Member
 
Join Date: Jun 2009
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default postfix: "unknown user" with mysql auth.

Hello,

Ive made your tutorial Virtual Users And Domains With Postfix, Courier And MySQL (Debian Etch).
First i have to say that it is a gread how-to and surly the best ive found in the internet.

But still i have some problems.

The following things are working:
  • I can send emails without any problems
  • clamav and spammasist works fine, too
  • no errors from postfix or other processes

But i cant receive emails. Postfix said that the user doesnt exist, but the user exists surly. And i can send emails with the same user.

First i post you all log and config files i have.

mail.log
Code:
Jun 18 00:20:37 kruseltech postfix/master[26171]: daemon started -- version 2.3.8, configuration /etc/postfix
Jun 18 00:20:57 kruseltech postfix/smtpd[26269]: connect from mail.gmx.net[213.165.64.20]
Jun 18 00:20:57 kruseltech postfix/smtpd[26269]: D582C34509CA: client=mail.gmx.net[213.165.64.20]
Jun 18 00:20:57 kruseltech postfix/cleanup[26274]: D582C34509CA: message-id=<20090617225254.104640@gmx.net>
Jun 18 00:20:57 kruseltech postfix/qmgr[26173]: D582C34509CA: from=<kruseltier@gmx.de>, size=1044, nrcpt=1 (queue active)
Jun 18 00:20:57 kruseltech postfix/smtpd[26269]: disconnect from mail.gmx.net[213.165.64.20]
Jun 18 00:21:00 kruseltech postfix/smtpd[26287]: connect from localhost.localdomain[127.0.0.1]
Jun 18 00:21:00 kruseltech postfix/smtpd[26287]: 4089634509CE: client=localhost.localdomain[127.0.0.1]
Jun 18 00:21:00 kruseltech postfix/cleanup[26274]: 4089634509CE: message-id=<20090617225254.104640@gmx.net>
Jun 18 00:21:00 kruseltech postfix/qmgr[26173]: 4089634509CE: from=<kruseltier@gmx.de>, size=1522, nrcpt=1 (queue active)
Jun 18 00:21:00 kruseltech amavis[11515]: (11515-02) Passed CLEAN, [213.165.64.20] [192.129.26.32] <kruseltier@gmx.de> -> <hendrik@oneclick-login.de>, Message-ID: <20090617225254.104640@gmx.net>, mail_id: nLQVAVlXrhCa, Hits: 0., queued_as: 4089634509CE, 2415 ms
Jun 18 00:21:00 kruseltech postfix/smtp[26275]: D582C34509CA: to=<hendrik@oneclick-login.de>, relay=127.0.0.1[127.0.0.1]:10024, delay=2.5, delays=0.06/0/0/2.4, dsn=2.6.0, status=sent (250 2.6.0 Ok, id=11515-02, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 4089634509CE)
Jun 18 00:21:00 kruseltech postfix/qmgr[26173]: D582C34509CA: removed
Jun 18 00:21:00 kruseltech postfix/smtpd[26287]: disconnect from localhost.localdomain[127.0.0.1]
Jun 18 00:21:00 kruseltech postfix/local[26288]: 4089634509CE: to=<hendrik@oneclick-login.de>, relay=local, delay=0.08, delays=0.06/0/0/0.01, dsn=5.1.1, status=bounced (unknown user: "hendrik")
Jun 18 00:21:00 kruseltech postfix/cleanup[26274]: 548CB34509CA: message-id=<20090618002100.548CB34509CA@oneclick-login.de>
Jun 18 00:21:00 kruseltech postfix/qmgr[26173]: 548CB34509CA: from=<>, size=3369, nrcpt=1 (queue active)
Jun 18 00:21:00 kruseltech postfix/bounce[26290]: 4089634509CE: sender non-delivery notification: 548CB34509CA
Jun 18 00:21:00 kruseltech postfix/qmgr[26173]: 4089634509CE: removed
Jun 18 00:21:00 kruseltech postfix/smtp[26291]: 548CB34509CA: to=<kruseltier@gmx.de>, relay=mx0.gmx.net[213.165.64.100]:25, delay=0.19, delays=0.03/0/0.04/0.11, dsn=2.6.0, status=sent (250 2.6.0 Message accepted {mx058})
Jun 18 00:21:00 kruseltech postfix/qmgr[26173]: 548CB34509CA: removed
/etc/postfix/mysql-virtual_domains.cf
Code:
user = mail_admin
password = password
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_email2email.cf
Code:
user = mail_admin
password = password
dbname = mail
query = SELECT email FROM users WHERE email='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_forwardings.cf
Code:
user = mail_admin
password = password
dbname = mail
query = SELECT destination FROM forwardings WHERE source='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
Code:
user = mail_admin
password = password
dbname = mail
query = SELECT quota FROM users WHERE email='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_mailboxes.cf
Code:
user = mail_admin
password = password
dbname = mail
query = SELECT query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
hosts = 127.0.0.1
/etc/postfix/mysql-virtual_transports.cf
Code:
user = mail_admin
password = password
dbname = mail
query = SELECT transport FROM transport WHERE domain='%s'
hosts = 127.0.0.1
main.cf
Code:
# See /usr/share/postfix/main.cf.dist for a commented, more complete version


# Debian specific:  Specifying a file name will cause the first
# line of that file to be used as the name.  The Debian default
# is /etc/mailname.
#myorigin = /etc/mailname

smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

# TLS parameters
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
smtpd_tls_session_cache_database = btree:${queue_directory}/smtpd_scache
smtp_tls_session_cache_database = btree:${queue_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

myhostname = oneclick-login.de
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
mydestination = oneclick-login.de, localhost, localhost.localdomain
relayhost =
mynetworks = 127.0.0.0/8
mailbox_size_limit = 0
recipient_delimiter = +
inet_interfaces = all
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_mailbox_base = /home/vmail
virtual_uid_maps = static:5000
virtual_gid_maps = static:5000
smtpd_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
virtual_create_maildirsize = yes
virtual_maildir_extended = yes
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
content_filter = amavis:[127.0.0.1]:10024
receive_override_options = no_address_mappings
master.cf
Code:
#
# Postfix master process configuration file.  For details on the format
# of the file, see the master(5) manual page (command: "man 5 master").
#
# ==========================================================================
# service type  private unpriv  chroot  wakeup  maxproc command + args
#               (yes)   (yes)   (yes)   (never) (100)
# ==========================================================================
smtp      inet  n       -       -       -       -       smtpd
#submission inet n       -       -       -       -       smtpd
#  -o smtpd_enforce_tls=yes
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#smtps     inet  n       -       -       -       -       smtpd
#  -o smtpd_tls_wrappermode=yes
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#628      inet  n       -       -       -       -       qmqpd
pickup    fifo  n       -       -       60      1       pickup
cleanup   unix  n       -       -       -       0       cleanup
qmgr      fifo  n       -       n       300     1       qmgr
#qmgr     fifo  n       -       -       300     1       oqmgr
tlsmgr    unix  -       -       -       1000?   1       tlsmgr
rewrite   unix  -       -       -       -       -       trivial-rewrite
bounce    unix  -       -       -       -       0       bounce
defer     unix  -       -       -       -       0       bounce
trace     unix  -       -       -       -       0       bounce
verify    unix  -       -       -       -       1       verify
flush     unix  n       -       -       1000?   0       flush
proxymap  unix  -       -       n       -       -       proxymap
smtp      unix  -       -       -       -       -       smtp
# When relaying mail as backup MX, disable fallback_relay to avoid MX loops
relay     unix  -       -       -       -       -       smtp
        -o fallback_relay=
#       -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq     unix  n       -       -       -       -       showq
error     unix  -       -       -       -       -       error
discard   unix  -       -       -       -       -       discard
local     unix  -       n       n       -       -       local
virtual   unix  -       n       n       -       -       virtual
lmtp      unix  -       -       -       -       -       lmtp
anvil     unix  -       -       -       -       1       anvil
scache    unix  -       -       -       -       1       scache
#
# ====================================================================
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
#
# Many of the following services use the Postfix pipe(8) delivery
# agent.  See the pipe(8) man page for information about ${recipient}
# and other message envelope options.
# ====================================================================
#
# maildrop. See the Postfix MAILDROP_README file for details.
# Also specify in main.cf: maildrop_destination_recipient_limit=1
#
maildrop  unix  -       n       n       -       -       pipe
  flags=DRhu user=vmail argv=/usr/bin/maildrop -d ${recipient}
#
# See the Postfix UUCP_README file for configuration details.
#
uucp      unix  -       n       n       -       -       pipe
  flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
#
# Other external delivery methods.
#
ifmail    unix  -       n       n       -       -       pipe
  flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp     unix  -       n       n       -       -       pipe
  flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix  -       n       n       -       2       pipe
  flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman   unix  -       n       n       -       -       pipe
  flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
  ${nexthop} ${user}

amavis unix - - - - 2 smtp
        -o smtp_data_done_timeout=1200
        -o smtp_send_xforward_command=yes

127.0.0.1:10025 inet n - - - - smtpd
        -o content_filter=
        -o local_recipient_maps=
        -o relay_recipient_maps=
        -o smtpd_restriction_classes=
        -o smtpd_client_restrictions=
        -o smtpd_helo_restrictions=
        -o smtpd_sender_restrictions=
        -o smtpd_recipient_restrictions=permit_mynetworks,reject
        -o mynetworks=127.0.0.0/8
        -o strict_rfc821_envelopes=yes
        -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
        -o smtpd_bind_address=127.0.0.1
/etc/default/saslauthd
Code:
#
# Settings for saslauthd daemon
#

# Should saslauthd run automatically on startup? (default: no)
START=yes

# Which authentication mechanisms should saslauthd use? (default: pam)
#
# Available options in this Debian package:
# getpwent  -- use the getpwent() library function
# kerberos5 -- use Kerberos 5
# pam       -- use PAM
# rimap     -- use a remote IMAP server
# shadow    -- use the local shadow password file
# sasldb    -- use the local sasldb database file
# ldap      -- use LDAP (configuration is in /etc/saslauthd.conf)
#
# Only one option may be used at a time. See the saslauthd man page
# for more information.
#
# Example: MECHANISMS="pam"
MECHANISMS="pam"

# Additional options for this mechanism. (default: none)
# See the saslauthd man page for information about mech-specific options.
MECH_OPTIONS=""

# How many saslauthd processes should we run? (default: 5)
# A value of 0 will fork a new process for each connection.
THREADS=5

# Other options (default: -c)
# See the saslauthd man page for information about these options.
#
# Example for postfix users: "-c -m /var/spool/postfix/var/run/saslauthd"
# Note: See /usr/share/doc/sasl2-bin/README.Debian
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd -r"
/etc/pam.d/smtp
Code:
auth    required   pam_mysql.so user=mail_admin passwd=password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1
account sufficient pam_mysql.so user=mail_admin passwd=password host=127.0.0.1 db=mail table=users usercolumn=email passwdcolumn=password crypt=1
/etc/default/saslauthd
Code:
#
# Settings for saslauthd daemon
#

# Should saslauthd run automatically on startup? (default: no)
START=yes

# Which authentication mechanisms should saslauthd use? (default: pam)
#
# Available options in this Debian package:
# getpwent  -- use the getpwent() library function
# kerberos5 -- use Kerberos 5
# pam       -- use PAM
# rimap     -- use a remote IMAP server
# shadow    -- use the local shadow password file
# sasldb    -- use the local sasldb database file
# ldap      -- use LDAP (configuration is in /etc/saslauthd.conf)
#
# Only one option may be used at a time. See the saslauthd man page
# for more information.
#
# Example: MECHANISMS="pam"
MECHANISMS="pam"

# Additional options for this mechanism. (default: none)
# See the saslauthd man page for information about mech-specific options.
MECH_OPTIONS=""

# How many saslauthd processes should we run? (default: 5)
# A value of 0 will fork a new process for each connection.
THREADS=5

# Other options (default: -c)
# See the saslauthd man page for information about these options.
#
# Example for postfix users: "-c -m /var/spool/postfix/var/run/saslauthd"
# Note: See /usr/share/doc/sasl2-bin/README.Debian
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd -r"
/etc/postfix/sasl/smtpd.conf
Code:
pwcheck_method: saslauthd
mech_list: plain login
allow_plaintext: true
auxprop_plugin: mysql
sql_hostnames: 127.0.0.1
sql_user: mail_admin
sql_passwd: password
sql_database: mail
sql_select: select password from users where email = '%u'
/etc/courier/authdaemonrc
Code:
##VERSION: $Id: authdaemonrc.in,v 1.13 2005/10/05 00:07:32 mrsam Exp $
#
# Copyright 2000-2005 Double Precision, Inc.  See COPYING for
# distribution information.
#
# authdaemonrc created from authdaemonrc.dist by sysconftool
#
# Do not alter lines that begin with ##, they are used when upgrading
# this configuration.
#
# This file configures authdaemond, the resident authentication daemon.
#
# Comments in this file are ignored.  Although this file is intended to
# be sourced as a shell script, authdaemond parses it manually, so
# the acceptable syntax is a bit limited.  Multiline variable contents,
# with the \ continuation character, are not allowed.  Everything must
# fit on one line.  Do not use any additional whitespace for indentation,
# or anything else.

##NAME: authmodulelist:2
#
# The authentication modules that are linked into authdaemond.  The
# default list is installed.  You may selectively disable modules simply
# by removing them from the following list.  The available modules you
# can use are: authuserdb authpam authpgsql authldap authmysql authcustom authpipe

authmodulelist="authmysql"

##NAME: authmodulelistorig:3
#
# This setting is used by Courier's webadmin module, and should be left
# alone

authmodulelistorig="authuserdb authpam authpgsql authldap authmysql authcustom authpipe"

##NAME: daemons:0
#
# The number of daemon processes that are started.  authdaemon is typically
# installed where authentication modules are relatively expensive: such
# as authldap, or authmysql, so it's better to have a number of them running.
# PLEASE NOTE:  Some platforms may experience a problem if there's more than
# one daemon.  Specifically, SystemV derived platforms that use TLI with
# socket emulation.  I'm suspicious of TLI's ability to handle multiple
# processes accepting connections on the same filesystem domain socket.
#
# You may need to increase daemons if as your system load increases.  Symptoms
# include sporadic authentication failures.  If you start getting
# authentication failures, increase daemons.  However, the default of 5
# SHOULD be sufficient.  Bumping up daemon count is only a short-term
# solution.  The permanent solution is to add more resources: RAM, faster
# disks, faster CPUs...

daemons=5

##NAME: authdaemonvar:2
#
# authdaemonvar is here, but is not used directly by authdaemond.  It's
# used by various configuration and build scripts, so don't touch it!

authdaemonvar=/var/run/courier/authdaemon

##NAME: DEBUG_LOGIN:0
#
# Dump additional diagnostics to syslog
#
# DEBUG_LOGIN=0   - turn off debugging
# DEBUG_LOGIN=1   - turn on debugging
# DEBUG_LOGIN=2   - turn on debugging + log passwords too
#
# ** YES ** - DEBUG_LOGIN=2 places passwords into syslog.
#
# Note that most information is sent to syslog at level 'debug', so
# you may need to modify your /etc/syslog.conf to be able to see it.

DEBUG_LOGIN=0

##NAME: DEFAULTOPTIONS:0
#
# A comma-separated list of option=value pairs. Each option is applied
# to an account if the account does not have its own specific value for
# that option. So for example, you can set
#   DEFAULTOPTIONS="disablewebmail=1,disableimap=1"
# and then enable webmail and/or imap on individual accounts by setting
# disablewebmail=0 and/or disableimap=0 on the account.

DEFAULTOPTIONS=""

##NAME: LOGGEROPTS:0
#
# courierlogger(1) options, e.g. to set syslog facility
#

LOGGEROPTS=""

##NAME: LDAP_TLS_OPTIONS:0
#
# Options documented in ldap.conf(5) can be set here, prefixed with 'LDAP'.
# Examples:
#
#LDAPTLS_CACERT=/path/to/cacert.pem
#LDAPTLS_REQCERT=demand
#LDAPTLS_CERT=/path/to/clientcert.pem
#LDAPTLS_KEY=/path/to/clientkey.pem
/etc/courier/authmysqlrc
Code:
##NAME: DEBUG_LOGIN:0
#
# Dump additional diagnostics to syslog
#
# DEBUG_LOGIN=0   - turn off debugging
# DEBUG_LOGIN=1   - turn on debugging
# DEBUG_LOGIN=2   - turn on debugging + log passwords too
#
# ** YES ** - DEBUG_LOGIN=2 places passwords into syslog.
#
# Note that most information is sent to syslog at level 'debug', so
# you may need to modify your /etc/syslog.conf to be able to see it.

DEBUG_LOGIN=0

##NAME: DEFAULTOPTIONS:0
#
# A comma-separated list of option=value pairs. Each option is applied
# to an account if the account does not have its own specific value for
# that option. So for example, you can set
#   DEFAULTOPTIONS="disablewebmail=1,disableimap=1"
# and then enable webmail and/or imap on individual accounts by setting
# disablewebmail=0 and/or disableimap=0 on the account.

DEFAULTOPTIONS=""

##NAME: LOGGEROPTS:0
#
# courierlogger(1) options, e.g. to set syslog facility
#

LOGGEROPTS=""

##NAME: LDAP_TLS_OPTIONS:0
#
# Options documented in ldap.conf(5) can be set here, prefixed with 'LDAP'.
# Examples:
#
#LDAPTLS_CACERT=/path/to/cacert.pem
#LDAPTLS_REQCERT=demand
#LDAPTLS_CERT=/path/to/clientcert.pem
#LDAPTLS_KEY=/path/to/clientkey.pem
kruseltech:/home/henze# cat /etc/courier/authmysqlrc
MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD password
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
MYSQL_QUOTA_FIELD quota
/etc/aliases
Code:
# See man 5 aliases for format
postmaster:    root
root: kruseltier@gmx.de

clamav: root
amavis: root
mysql query log
Code:
090618  2:20:57     185 Connect     mail_admin@localhost on mail
                    185 Query       SELECT transport FROM transport WHERE domain='*'
                    185 Query       SELECT transport FROM transport WHERE domain='*'
                    186 Connect     mail_admin@localhost on mail
                    186 Query       SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='kruseltier@gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='.de'
                    186 Query       SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='hendrik@oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='.de'
                    187 Connect     mail_admin@localhost on mail
                    187 Query       SELECT destination FROM forwardings WHERE source='hendrik@oneclick-login.de'
                    188 Connect     mail_admin@localhost on mail
                    188 Query       SELECT email FROM users WHERE email='hendrik@oneclick-login.de'
090618  2:21:00     186 Query       SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='kruseltier@gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='.de'
                    186 Query       SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='hendrik@oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='.de'
                    187 Query       SELECT destination FROM forwardings WHERE source='hendrik@oneclick-login.de'
                    189 Connect     mail_admin@localhost on mail
                    189 Query       SELECT email FROM users WHERE email='hendrik@oneclick-login.de'
                    186 Query       SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='hendrik@oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='oneclick-login.de'
                    185 Query       SELECT transport FROM transport WHERE domain='.de'
                    187 Query       SELECT destination FROM forwardings WHERE source='kruseltier@gmx.de'
                    189 Query       SELECT email FROM users WHERE email='kruseltier@gmx.de'
                    187 Query       SELECT destination FROM forwardings WHERE source='@gmx.de'
                    189 Query       SELECT email FROM users WHERE email='@gmx.de'
                    186 Query       SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='kruseltier@gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='gmx.de'
                    185 Query       SELECT transport FROM transport WHERE domain='.de'
090618  2:21:57     188 Quit
In the query log i think something is strange. Only one of these querys going to domain oneclick-login.de

CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='oneclick-login.de'

and no one selects something like this (full email with username):
CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='hendrik@oneclick-login.de'

Here are the queries of our mysql tables:

mysql> select * from users;
+---------------------------+---------------+-----------+
| email | password | quota |
+---------------------------+---------------+-----------+
| henze@oneclick-login.de | lP50XA0aT54Mk | 104857600 |
| hendrik@oneclick-login.de | qZhwbWd0W5Kck | 10485760 |
+---------------------------+---------------+-----------+
2 rows in set (0.00 sec)

mysql> select * from domains;
+-------------------+
| domain |
+-------------------+
| oneclick-login.de |
+-------------------+
1 row in set (0.00 sec)


If you need other config or logfiles please tell me and i will post them.

We try to get it work for a few full days !!

Please can you help us ?

bye and thanks

Kruser
Reply With Quote
Sponsored Links
  #2  
Old 18th June 2009, 04:33
Kruser Kruser is offline
Junior Member
 
Join Date: Jun 2009
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

I ve just realized that ive forgotten following line in the main.cf

virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf

but the failure is still the same.
Still the mysql query log has changed. Here the new version:

Code:
090618  4:48:21      29 Connect     mail_admin@localhost on mail
                     29 Query       SELECT transport FROM transport WHERE domain='*'
                     29 Query       SELECT transport FROM transport WHERE domain='*'
                     30 Connect     mail_admin@localhost on mail
                     30 Query       SELECT domain AS virtual FROM domains WHERE domain='gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='kruseltier@gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='.de'
                     30 Query       SELECT domain AS virtual FROM domains WHERE domain='oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='hendrik@oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='.de'
                     31 Connect     mail_admin@localhost on mail
                     31 Query       SELECT destination FROM forwardings WHERE source='hendrik@oneclick-login.de'
                     32 Connect     mail_admin@localhost on mail
                     32 Query       SELECT email FROM users WHERE email='hendrik@oneclick-login.de'
090618  4:48:23      30 Query       SELECT domain AS virtual FROM domains WHERE domain='gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='kruseltier@gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='.de'
                     30 Query       SELECT domain AS virtual FROM domains WHERE domain='oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='hendrik@oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='.de'
                     31 Query       SELECT destination FROM forwardings WHERE source='hendrik@oneclick-login.de'
                     33 Connect     mail_admin@localhost on mail
                     33 Query       SELECT email FROM users WHERE email='hendrik@oneclick-login.de'
                     30 Query       SELECT domain AS virtual FROM domains WHERE domain='oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='hendrik@oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='oneclick-login.de'
                     29 Query       SELECT transport FROM transport WHERE domain='.de'
                     31 Query       SELECT destination FROM forwardings WHERE source='kruseltier@gmx.de'
                     33 Query       SELECT email FROM users WHERE email='kruseltier@gmx.de'
                     31 Query       SELECT destination FROM forwardings WHERE source='@gmx.de'
                     33 Query       SELECT email FROM users WHERE email='@gmx.de'
                     30 Query       SELECT domain AS virtual FROM domains WHERE domain='gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='kruseltier@gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='gmx.de'
                     29 Query       SELECT transport FROM transport WHERE domain='.de'
090618  4:49:21      32 Quit
090618  4:49:23      31 Quit
                     30 Quit
                     29 Quit
                     33 Quit
Reply With Quote
  #3  
Old 18th June 2009, 15:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

The problem is that you're using oneclick-login.de in the domains table and in mydestination/myhostname in /etc/postfix/main.cf. This doesn't work. Domains that are in the domains table must not be in main.cf.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
Kruser (18th June 2009)
  #4  
Old 18th June 2009, 19:20
Kruser Kruser is offline
Junior Member
 
Join Date: Jun 2009
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko View Post
The problem is that you're using oneclick-login.de in the domains table and in mydestination/myhostname in /etc/postfix/main.cf. This doesn't work. Domains that are in the domains table must not be in main.cf.
Thanks falko. That was the problem! Now it works great

bye
Kruser
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix not responding to telnet CarbonCopy Server Operation 6 8th May 2009 06:39
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 22:12
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 16:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 16:36


All times are GMT +2. The time now is 10:24.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.