[Postfixbuch-users] Virtuelle Domains: MySQL Verständnisproblem (leider schon wieder)

Mi Nov 5 12:52:35 CET 2003

Hallo geduldige Liste,

ich bins schon wieder mit einem Verständnisproblem:

Ich habe eine domain kommtech.uni-wuppertal.de als mydomain angegeben und 2 weitere virtuelle 
domains mit dmt und pmt anstelle des kommtech

Wenn ich verusche, an user prock at dmt.uni-wuppertal.de kommt ein

Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: recipient: prock at dmt.uni-wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: user: prock at dmt.uni-wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: delivered: prock at dmt.uni-wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: relay: virtual
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: deliver_mailbox[2]: recip prock at dmt.uni-
wuppertal.de deliver prock at dmt.uni-wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql_lookup using sql query: select 
maildir from mailbox where username = 'prock at dmt.uni-wuppertal.de' 
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql: attempting to connect to host 
localhost
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql: successful connection to host 
localhost
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql: successful query from host 
localhost
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql_lookup: retrieved 0 rows
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: maps_find: virtual_mailbox_maps: 
prock at dmt.uni-wuppertal.de: not found
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql_lookup using sql query: select 
maildir from mailbox where username = '@dmt.uni-wuppertal.de' 
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql: successful query from host 
localhost
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: dict_mysql_lookup: retrieved 0 rows
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: maps_find: virtual_mailbox_maps: @dmt.uni-
wuppertal.de: not found
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: deliver_unknown[2]: recip prock at dmt.uni-
wuppertal.de deliver prock at dmt.uni-wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: connect to subsystem private/bounce
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: send attr nrequest = 0
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: send attr flags = 0
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: send attr queue_id = A7A95139B31
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: send attr original_recipient = prock at dmt.uni-
wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: send attr recipient = prock at dmt.uni-
wuppertal.de
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: send attr reason = unknown user: 
"prock at dmt.uni-wuppertal.de"
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: private/bounce socket: wanted attribute: 
status
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: input attribute name: status
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: input attribute value: 0
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: private/bounce socket: wanted attribute: (list 
terminator)
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: input attribute name: (end)
Nov  5 13:09:03 wd-diplomand2 postfix/virtual[1118]: A7A95139B31: to=<prock at dmt.uni-
wuppertal.de>, relay=virtual, delay=0, status=bounced (unknown user: "prock at dmt.uni-
wuppertal.de")

im Log. Eine Mailbox für prock at kommtech.uni-wuppertal.de existiert, mail wird auch dorthin 
ausgeliefert, und da ist denke ich auch der Fehler. Es müsste besser nur prock lauten, da dann der 
alias greifen würde. Wenn ich aber prock als user definiere, dann kommt auch das kommtech nicht 
mehr an. "user unknown" heisst es dann! Wie kann ich das ganze lösen, was braucht ihr noch für 
Infos? Gruß und Danke, Jan

Ein postconf -v ergibt folgendes:

2bounce_notice_recipient = postmaster
access_map_reject_code = 554
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases, nis:mail.aliases
allow_mail_to_commands = alias,forward
allow_mail_to_files = alias,forward
allow_min_user = no
allow_percent_hack = yes
allow_untrusted_routing = no
alternate_config_directories = 
always_bcc = 
append_at_myorigin = yes
append_dot_mydomain = yes
authorized_verp_clients = $mynetworks
berkeley_db_create_buffer_size = 16777216
berkeley_db_read_buffer_size = 131072
best_mx_transport = 
biff = yes
body_checks = 
body_checks_size_limit = 51200
bounce_notice_recipient = postmaster
bounce_service_name = bounce
bounce_size_limit = 50000
broken_sasl_auth_clients = no
canonical_maps = 
cleanup_service_name = cleanup
command_directory = /usr/sbin
command_expansion_filter = 1234567890!@%-_=+:,./
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
command_time_limit = 1000s
config_directory = /etc/postfix
content_filter = 
daemon_directory = /usr/lib/postfix
daemon_timeout = 18000s
debug_peer_level = 2
debug_peer_list = 
default_database_type = hash
default_delivery_slot_cost = 5
default_delivery_slot_discount = 50
default_delivery_slot_loan = 3
default_destination_concurrency_limit = 20
default_destination_recipient_limit = 50
default_extra_recipient_limit = 1000
default_minimum_delivery_slots = 3
default_privs = nobody
default_process_limit = 100
default_rbl_reply = $rbl_code Service unavailable; $rbl_class [$rbl_what] blocked using 
$rbl_domain${rbl_reason?; $rbl_reason}
default_recipient_limit = 10000
default_transport = smtp
default_verp_delimiters = +=
defer_code = 450
defer_service_name = defer
defer_transports = 
delay_notice_recipient = postmaster
delay_warning_time = 0h
deliver_lock_attempts = 20
deliver_lock_delay = 1s
disable_dns_lookups = no
disable_mime_input_processing = no
disable_mime_output_conversion = no
disable_verp_bounces = no
disable_vrfy_command = no
dont_remove = 0
double_bounce_sender = double-bounce
duplicate_filter_limit = 1000
empty_address_recipient = MAILER-DAEMON
error_notice_recipient = postmaster
error_service_name = error
expand_owner_alias = no
export_environment = TZ MAIL_CONFIG
extract_recipient_limit = 10240
fallback_relay = 
fallback_transport = 
fast_flush_domains = $relay_domains
fast_flush_purge_time = 7d
fast_flush_refresh_time = 12h
fault_injection_code = 0
flush_service_name = flush
fork_attempts = 5
fork_delay = 1s
forward_expansion_filter = 1234567890!@%-_=+:,./
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
forward_path = $home/.forward${recipient_delimiter}${extension},$home/.forward
hash_queue_depth = 1
hash_queue_names = incoming,active,deferred,bounce,defer,flush,hold
header_address_token_limit = 10240
header_checks = 
header_size_limit = 102400
helpful_warnings = yes
home_mailbox = 
hopcount_limit = 50
ignore_mx_lookup_error = no
import_environment = MAIL_CONFIG MAIL_DEBUG MAIL_LOGTAG TZ XAUTHORITY DISPLAY
in_flow_delay = 1s
inet_interfaces = all
initial_destination_concurrency = 5
invalid_hostname_reject_code = 501
ipc_idle = 100s
ipc_timeout = 3600s
line_length_limit = 2048
lmtp_cache_connection = yes
lmtp_connect_timeout = 0s
lmtp_data_done_timeout = 600s
lmtp_data_init_timeout = 120s
lmtp_data_xfer_timeout = 180s
lmtp_lhlo_timeout = 300s
lmtp_mail_timeout = 300s
lmtp_quit_timeout = 300s
lmtp_rcpt_timeout = 300s
lmtp_rset_timeout = 300s
lmtp_sasl_auth_enable = no
lmtp_sasl_password_maps = 
lmtp_sasl_security_options = noplaintext, noanonymous
lmtp_skip_quit_response = no
lmtp_tcp_port = 24
local_command_shell = 
local_destination_concurrency_limit = 2
local_destination_recipient_limit = 1
local_recipient_maps = proxy:unix:passwd.byname $alias_maps
local_transport = local:$myhostname
luser_relay = 
mail_name = Postfix
mail_owner = postfix
mail_release_date = 20030913
mail_spool_directory = /var/mail
mail_version = 2.0.16
mailbox_command = 
mailbox_command_maps = 
mailbox_delivery_lock = fcntl, dotlock
mailbox_size_limit = 51200000
mailbox_transport = 
mailq_path = /usr/bin/mailq
manpage_directory = /usr/share/man
maps_rbl_domains = 
maps_rbl_reject_code = 554
masquerade_classes = envelope_sender, header_sender, header_recipient
masquerade_domains = 
masquerade_exceptions = 
max_idle = 100s
max_use = 100
maximal_backoff_time = 4000s
maximal_queue_lifetime = 5d
message_size_limit = 10240000
mime_boundary_length_limit = 2048
mime_header_checks = $header_checks
mime_nesting_limit = 100
minimal_backoff_time = 1000s
mydestination = $myhostname, localhost.$mydomain
mydomain = kommtech.uni-wuppertal.de
myhostname = wd-diplomand2.kommtech.uni-wuppertal.de
mynetworks = 132.195.0.0/16, 127.0.0.0/8
mynetworks_style = subnet
myorigin = $myhostname
nested_header_checks = $header_checks
newaliases_path = /usr/bin/newaliases
non_fqdn_reject_code = 504
notify_classes = resource,software
owner_request_special = yes
parent_domain_matches_subdomains = 
debug_peer_list,fast_flush_domains,mynetworks,permit_mx_backup_networks,qmqpd_authorized_cli
ents,relay_domains,smtpd_access_maps
permit_mx_backup_networks = 
pickup_service_name = pickup
prepend_delivered_header = command, file, forward
process_id_directory = pid
program_directory = /usr/libexec/postfix
propagate_unmatched_extensions = canonical, virtual
proxy_interfaces = 
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
qmgr_clog_warn_time = 300s
qmgr_fudge_factor = 100
qmgr_message_active_limit = 20000
qmgr_message_recipient_limit = 20000
qmgr_message_recipient_minimum = 10
qmqpd_authorized_clients = 
qmqpd_error_delay = 1s
qmqpd_timeout = 300s
queue_directory = /var/spool/postfix
queue_file_attribute_count_limit = 100
queue_minfree = 0
queue_run_delay = 1000s
queue_service_name = qmgr
rbl_reply_maps = 
readme_directory = /usr/share/doc/packages/postfix/README_FILES
recipient_canonical_maps = 
recipient_delimiter = 
reject_code = 554
relay_domains = $mydestination, dmt.uni-wuppertal.de, pmt.uni-wuppertal.de
relay_domains_reject_code = 554
relay_recipient_maps = 
relay_transport = relay
relayhost = 
relocated_maps = 
require_home_directory = no
resolve_dequoted_address = yes
rewrite_service_name = rewrite
sample_directory = /usr/share/doc/packages/postfix/samples
sender_canonical_maps = 
sendmail_path = /usr/sbin/sendmail
service_throttle_time = 60s
setgid_group = maildrop
show_user_unknown_table_name = yes
showq_service_name = showq
smtp_always_send_ehlo = yes
smtp_bind_address = 
smtp_connect_timeout = 30s
smtp_data_done_timeout = 600s
smtp_data_init_timeout = 120s
smtp_data_xfer_timeout = 180s
smtp_destination_concurrency_limit = $default_destination_concurrency_limit
smtp_destination_recipient_limit = $default_destination_recipient_limit
smtp_helo_name = $myhostname
smtp_helo_timeout = 300s
smtp_line_length_limit = 990
smtp_mail_timeout = 300s
smtp_never_send_ehlo = no
smtp_pix_workaround_delay_time = 10s
smtp_pix_workaround_threshold_time = 500s
smtp_quit_timeout = 300s
smtp_randomize_addresses = yes
smtp_rcpt_timeout = 300s
smtp_sasl_auth_enable = no
smtp_sasl_password_maps = 
smtp_sasl_security_options = noplaintext, noanonymous
smtp_skip_4xx_greeting = yes
smtp_skip_5xx_greeting = yes
smtp_skip_quit_response = yes
smtpd_banner = $myhostname ESMTP $mail_name
smtpd_client_restrictions = 
smtpd_data_restrictions = 
smtpd_delay_reject = yes
smtpd_error_sleep_time = 1s
smtpd_etrn_restrictions = 
smtpd_expansion_filter = \t\40!"#$%&'()*+,-./
0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~
smtpd_hard_error_limit = 20
smtpd_helo_required = no
smtpd_helo_restrictions = 
smtpd_history_flush_threshold = 100
smtpd_junk_command_limit = 100
smtpd_noop_commands = 
smtpd_null_access_lookup_key = <>
smtpd_recipient_limit = 1000
smtpd_recipient_restrictions = permit_mynetworks, reject_unauth_destination
smtpd_restriction_classes = 
smtpd_sasl_auth_enable = no
smtpd_sasl_local_domain = 
smtpd_sasl_security_options = noanonymous
smtpd_sender_login_maps = 
smtpd_sender_restrictions = 
smtpd_soft_error_limit = 10
smtpd_timeout = 300s
soft_bounce = no
stale_lock_time = 500s
strict_7bit_headers = no
strict_8bitmime = no
strict_8bitmime_body = no
strict_mime_encoding_domain = no
strict_rfc821_envelopes = no
sun_mailtool_compatibility = no
swap_bangpath = yes
syslog_facility = mail
syslog_name = postfix
transport_maps = mysql:/etc/postfix/mysql_virtual_transport_maps.cf
transport_retry_time = 60s
trigger_timeout = 10s
undisclosed_recipients_header = To: undisclosed-recipients:;
unknown_address_reject_code = 450
unknown_client_reject_code = 450
unknown_hostname_reject_code = 450
unknown_local_recipient_reject_code = 450
unknown_relay_recipient_reject_code = 550
unknown_virtual_alias_reject_code = 550
unknown_virtual_mailbox_reject_code = 550
verp_delimiter_filter = -=+
virtual_alias_domains = $virtual_alias_maps
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:1008
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_lock = fcntl
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 1001
virtual_transport = virtual
virtual_uid_maps = static:1008

________________________________________________________________
Mit der Grupppen-SMS von WEB.DE FreeMail können Sie eine SMS an alle 
Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179