HowTo. Почтовый сервер Postfix, Courier, MySQL и SquirrelMail (Ubuntu 8,04)

[alex101]

Запросы SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='fill.mydomen.ru'
и
SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='alex@fill.mydomen.ru'
выдали
в первом случае Emty set (0.00 sec)
во втором mysql> SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='alex@fill.mydomen.ru';
+----------------------------------------------------------------------------+
| CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') |
+----------------------------------------------------------------------------+
| fill.mydomen.ru/alex/                                                  |
+----------------------------------------------------------------------------+
1 row in set (0.01 sec)
mail.log

(Нажмите, чтобы показать/скрыть)

Nov  2 12:52:20 fill postfix/pickup[22150]: 929FC1E474: uid=0 from=<root>
Nov  2 12:52:20 fill postfix/cleanup[22166]: 929FC1E474: message-id=<20091102095220.929FC1E474@fill.mydomen.ru>
Nov  2 12:52:20 fill postfix/qmgr[22148]: 929FC1E474: from=<root@fill.mydomen.ru>, size=324, nrcpt=1 (queue active)
Nov  2 12:52:34 fill postfix/smtpd[22177]: connect from localhost[127.0.0.1]
Nov  2 12:52:34 fill postfix/smtpd[22177]: 817AD1E471: client=localhost[127.0.0.1]
Nov  2 12:52:34 fill postfix/cleanup[22166]: 817AD1E471: message-id=<20091102095220.929FC1E474@fill.mydomen.ru>
Nov  2 12:52:34 fill postfix/qmgr[22148]: 817AD1E471: from=<root@fill.mydomen.ru>, size=792, nrcpt=1 (queue active)
Nov  2 12:52:34 fill postfix/smtpd[22177]: disconnect from localhost[127.0.0.1]
Nov  2 12:52:34 fill amavis[32581]: (32581-08) Passed CLEAN, <root@fill.mydomen.ru> -> <alex@fill.mydomen.ru>, Message-ID: <20091102095220.929FC1E474@fill.mydomen.ru>, mail_id: 5DaHjV3rPrSt, Hits: 0.662, size: 324, queued_as: 817AD1E471, 13904 ms
Nov  2 12:52:34 fill postfix/smtp[22170]: 929FC1E474: to=<alex@fill.mydomen.ru>, relay=127.0.0.1[127.0.0.1]:10024, delay=14, delays=0.05/0.01/0/14, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=32581-08, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 817AD1E471)
Nov  2 12:52:34 fill postfix/qmgr[22148]: 929FC1E474: removed
Nov  2 12:52:34 fill postfix/smtp[22181]: 817AD1E471: to=<alex@fill.mydomen.ru>, relay=none, delay=0.03, delays=0.01/0.02/0.01/0, dsn=5.4.6, status=bounced (mail for fill.mydomen.ru loops back to myself)
Nov  2 12:52:34 fill postfix/cleanup[22166]: 8C8581E475: message-id=<20091102095234.8C8581E475@fill.mydomen.ru>
Nov  2 12:52:34 fill postfix/bounce[22182]: 817AD1E471: sender non-delivery notification: 8C8581E475
Nov  2 12:52:34 fill postfix/qmgr[22148]: 8C8581E475: from=<>, size=2703, nrcpt=1 (queue active)
Nov  2 12:52:34 fill postfix/qmgr[22148]: 817AD1E471: removed
Nov  2 12:52:34 fill postfix/smtp[22181]: 8C8581E475: to=<root@fill.mydomen.ru>, relay=none, delay=0.01, delays=0.01/0/0/0, dsn=5.4.6, status=bounced (mail for fill.mydomen.ru loops back to myself)
Nov  2 12:52:34 fill postfix/qmgr[22148]: 8C8581E475: removed

mail.err - пуст
Посылаю на письма alex@fill.mydomen.ru т.к. имеется два почтовых сервера (на qmail) с более высоким приоритетом в ДНС

[Bambr]

Alex101, давайте вывод команды postconf в спойлер.

По логам mysql.log есть запрос вида

Код: [Выделить]

SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='user@fill.mydomen.ru'или только такой

Код: [Выделить]

SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='fill.mydomen.ru'

[vadim-nsk]

Alex101, давайте вывод команды postconf в спойлер.

обратите внимание на петлю. тут скорее всего в таблице транспорты что либо вбито, либо подкачали альясы.

[Bambr]

vadimka, петля у alex101 образовалась, только после того как он по совету crazydavids исправил mydestination
и mynetworks

В логе  loops back to myself указывает на петлю, но где она образовалась я уже понять не могу.
Только исправил  mydestination = localhost, localhost.localdomain
mynetworks = 127.0.0.0/8 и получил петлю. Не понимаю зачем писать localhost.localdomain - локального домена у меня нет.

P.S. Вопрошающие, хотите получить быструю помощь, предоставьте содержимое всех конфигов и таблиц в спойлере .
Касательно postfix`а, полный конфиг можно получить по команде postconf.

[alex101]

Postconf

(Нажмите, чтобы показать/скрыть)

2bounce_notice_recipient = postmaster
access_map_reject_code = 554
address_verify_default_transport = $default_transport
address_verify_local_transport = $local_transport
address_verify_map =
address_verify_negative_cache = yes
address_verify_negative_expire_time = 3d
address_verify_negative_refresh_time = 3h
address_verify_poll_count = 3
address_verify_poll_delay = 3s
address_verify_positive_expire_time = 31d
address_verify_positive_refresh_time = 7d
address_verify_relay_transport = $relay_transport
address_verify_relayhost = $relayhost
address_verify_sender = $double_bounce_sender
address_verify_sender_dependent_relayhost_maps = $sender_dependent_relayhost_maps
address_verify_service_name = verify
address_verify_transport_maps = $transport_maps
address_verify_virtual_transport = $virtual_transport
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/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 =
anvil_rate_time_unit = 60s
anvil_status_update_time = 600s
append_at_myorigin = yes
append_dot_mydomain = no
application_event_drain_time = 100s
authorized_flush_users = static:anyone
authorized_mailq_users = static:anyone
authorized_submit_users = static:anyone
backwards_bounce_logfile_compatibility = yes
berkeley_db_create_buffer_size = 16777216
berkeley_db_read_buffer_size = 131072
best_mx_transport =
biff = no
body_checks =
body_checks_size_limit = 51200
bounce_notice_recipient = postmaster
bounce_queue_lifetime = 5d
bounce_service_name = bounce
bounce_size_limit = 50000
bounce_template_file =
broken_sasl_auth_clients = yes
canonical_classes = envelope_sender, envelope_recipient, header_sender, header_recipient
canonical_maps =
cleanup_service_name = cleanup
command_directory = /usr/sbin
command_execution_directory =
command_expansion_filter = 1234567890!@%-_=+:,./abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
command_time_limit = 1000s
config_directory = /etc/postfix
connection_cache_protocol_timeout = 5s
connection_cache_service_name = scache
connection_cache_status_update_time = 600s
connection_cache_ttl_limit = 2s
content_filter = amavis:[127.0.0.1]:10024
cyrus_sasl_config_path =
daemon_directory = /usr/lib/postfix
daemon_timeout = 18000s
data_directory = /var/lib/postfix
debug_peer_level = 2
debug_peer_list = mydomen.ru
default_database_type = hash
default_delivery_slot_cost = 5
default_delivery_slot_discount = 50
default_delivery_slot_loan = 3
default_destination_concurrency_failed_cohort_limit = 1
default_destination_concurrency_limit = 20
default_destination_concurrency_negative_feedback = 1
default_destination_concurrency_positive_feedback = 1
default_destination_rate_delay = 0s
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 = 20000
default_recipient_refill_delay = 5s
default_recipient_refill_limit = 100
default_transport = smtp
default_verp_delimiters = +=
defer_code = 450
defer_service_name = defer
defer_transports =
delay_logging_resolution_limit = 2
delay_notice_recipient = postmaster
delay_warning_time = 0h
deliver_lock_attempts = 20
deliver_lock_delay = 1s
destination_concurrency_feedback_debug = no
detect_8bit_encoding_header = yes
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
empty_address_relayhost_maps_lookup_key = <>
enable_original_recipient = yes
error_notice_recipient = postmaster
error_service_name = error
execution_directory_expansion_filter = 1234567890!@%-_=+:,./abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ
expand_owner_alias = no
export_environment = TZ MAIL_CONFIG LANG
fallback_transport =
fallback_transport_maps =
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
frozen_delivered_to = yes
hash_queue_depth = 1
hash_queue_names = deferred, defer
header_address_token_limit = 10240
header_checks =
header_size_limit = 102400
helpful_warnings = yes
home_mailbox =
hopcount_limit = 50
html_directory = /usr/share/doc/postfix/html
ignore_mx_lookup_error = no
import_environment = MAIL_CONFIG MAIL_DEBUG MAIL_LOGTAG TZ XAUTHORITY DISPLAY LANG=C
in_flow_delay = 1s
inet_interfaces = all
inet_protocols = ipv4
initial_destination_concurrency = 5
internal_mail_filter_classes =
invalid_hostname_reject_code = 501
ipc_idle = 5s
ipc_timeout = 3600s
ipc_ttl = 1000s
line_length_limit = 2048
lmtp_bind_address =
lmtp_bind_address6 =
lmtp_body_checks =
lmtp_cname_overrides_servername = no
lmtp_connect_timeout = 0s
lmtp_connection_cache_destinations =
lmtp_connection_cache_on_demand = yes
lmtp_connection_cache_time_limit = 2s
lmtp_connection_reuse_time_limit = 300s
lmtp_data_done_timeout = 600s
lmtp_data_init_timeout = 120s
lmtp_data_xfer_timeout = 180s
lmtp_defer_if_no_mx_address_found = no
lmtp_destination_concurrency_failed_cohort_limit = $default_destination_concurrency_failed_cohort_limit
lmtp_destination_concurrency_limit = $default_destination_concurrency_limit
lmtp_destination_concurrency_negative_feedback = $default_destination_concurrency_negative_feedback
lmtp_destination_concurrency_positive_feedback = $default_destination_concurrency_positive_feedback
lmtp_destination_rate_delay = $default_destination_rate_delay
lmtp_destination_recipient_limit = $default_destination_recipient_limit
lmtp_discard_lhlo_keyword_address_maps =
lmtp_discard_lhlo_keywords =
lmtp_enforce_tls = no
lmtp_generic_maps =
lmtp_header_checks =
lmtp_host_lookup = dns
lmtp_initial_destination_concurrency = $initial_destination_concurrency
lmtp_lhlo_name = $myhostname
lmtp_lhlo_timeout = 300s
lmtp_line_length_limit = 990
lmtp_mail_timeout = 300s
lmtp_mime_header_checks =
lmtp_mx_address_limit = 5
lmtp_mx_session_limit = 2
lmtp_nested_header_checks =
lmtp_pix_workaround_delay_time = 10s
lmtp_pix_workaround_maps =
lmtp_pix_workaround_threshold_time = 500s
lmtp_pix_workarounds = disable_esmtp,delay_dotcrlf
lmtp_quit_timeout = 300s
lmtp_quote_rfc821_envelope = yes
lmtp_randomize_addresses = yes
lmtp_rcpt_timeout = 300s
lmtp_rset_timeout = 20s
lmtp_sasl_auth_cache_name =
lmtp_sasl_auth_cache_time = 90d
lmtp_sasl_auth_enable = no
lmtp_sasl_auth_soft_bounce = yes
lmtp_sasl_mechanism_filter =
lmtp_sasl_password_maps =
lmtp_sasl_path =
lmtp_sasl_security_options = noplaintext, noanonymous
lmtp_sasl_tls_security_options = $lmtp_sasl_security_options
lmtp_sasl_tls_verified_security_options = $lmtp_sasl_tls_security_options
lmtp_sasl_type = cyrus
lmtp_send_xforward_command = no
lmtp_sender_dependent_authentication = no
lmtp_skip_5xx_greeting = yes
lmtp_starttls_timeout = 300s
lmtp_tcp_port = 24
lmtp_tls_CAfile =
lmtp_tls_CApath =
lmtp_tls_cert_file =
lmtp_tls_dcert_file =
lmtp_tls_dkey_file = $lmtp_tls_dcert_file
lmtp_tls_enforce_peername = yes
lmtp_tls_exclude_ciphers =
lmtp_tls_fingerprint_cert_match =
lmtp_tls_fingerprint_digest = md5
lmtp_tls_key_file = $lmtp_tls_cert_file
lmtp_tls_loglevel = 0
lmtp_tls_mandatory_ciphers = medium
lmtp_tls_mandatory_exclude_ciphers =
lmtp_tls_mandatory_protocols = SSLv3, TLSv1
lmtp_tls_note_starttls_offer = no
lmtp_tls_per_site =
lmtp_tls_policy_maps =
lmtp_tls_scert_verifydepth = 9
lmtp_tls_secure_cert_match = nexthop
lmtp_tls_security_level =
lmtp_tls_session_cache_database =
lmtp_tls_session_cache_timeout = 3600s
lmtp_tls_verify_cert_match = hostname
lmtp_use_tls = no
lmtp_xforward_timeout = 300s
local_command_shell =
local_destination_concurrency_failed_cohort_limit = $default_destination_concurrency_failed_cohort_limit
local_destination_concurrency_limit = 2
local_destination_concurrency_negative_feedback = $default_destination_concurrency_negative_feedback
local_destination_concurrency_positive_feedback = $default_destination_concurrency_positive_feedback
local_destination_rate_delay = $default_destination_rate_delay
local_destination_recipient_limit = 1
local_header_rewrite_clients = permit_inet_interfaces
local_initial_destination_concurrency = $initial_destination_concurrency
local_recipient_maps = proxy:unix:passwd.byname $alias_maps
local_transport = local:$myhostname
luser_relay =
mail_name = Postfix
mail_owner = postfix
mail_release_date = 20080902
mail_spool_directory = /var/mail
mail_version = 2.5.5
mailbox_command =
mailbox_command_maps =
mailbox_delivery_lock = fcntl, dotlock
mailbox_size_limit = 0
mailbox_transport =
mailbox_transport_maps =
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_reject_characters =
message_size_limit = 10240000
message_strip_characters =
milter_command_timeout = 30s
milter_connect_macros = j {daemon_name} v
milter_connect_timeout = 30s
milter_content_timeout = 300s
milter_data_macros = i
milter_default_action = tempfail
milter_end_of_data_macros = i
milter_end_of_header_macros = i
milter_helo_macros = {tls_version} {cipher} {cipher_bits} {cert_subject} {cert_issuer}
milter_macro_daemon_name = $myhostname
milter_macro_v = $mail_name $mail_version
milter_mail_macros = i {auth_type} {auth_authen} {auth_author} {mail_addr}
milter_protocol = 2
milter_rcpt_macros = i {rcpt_addr}
milter_unknown_command_macros =
mime_boundary_length_limit = 2048
mime_header_checks = $header_checks
mime_nesting_limit = 100
minimal_backoff_time = 300s
multi_recipient_bounce_reject_code = 550
mydestination = localhost
mydomain = mydomen.ru
myhostname = fill.mydomen.ru
mynetworks = 127.0.0.0/8 192.168.11.0/24 78.137.29.0/24
mynetworks_style = subnet
myorigin = /etc/mailname
nested_header_checks = $header_checks
newaliases_path = /usr/bin/newaliases
non_fqdn_reject_code = 504
non_smtpd_milters =
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_clients,smtpd_access_maps
permit_mx_backup_networks =
pickup_service_name = pickup
plaintext_reject_code = 450
prepend_delivered_header = command, file, forward
process_id_directory = pid
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 $virtual_mailbox_limit_maps
proxy_write_maps = $smtp_sasl_auth_cache_name $lmtp_sasl_auth_cache_name
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_client_port_logging = no
qmqpd_error_delay = 1s
qmqpd_timeout = 300s
queue_directory = /var/spool/postfix
queue_file_attribute_count_limit = 100
queue_minfree = 0
queue_run_delay = 300s
queue_service_name = qmgr
rbl_reply_maps =
readme_directory = /usr/share/doc/postfix
receive_override_options = no_address_mappings
recipient_bcc_maps =
recipient_canonical_classes = envelope_recipient, header_recipient
recipient_canonical_maps =
recipient_delimiter = +
reject_code = 554
relay_clientcerts =
relay_destination_concurrency_failed_cohort_limit = $default_destination_concurrency_failed_cohort_limit
relay_destination_concurrency_limit = $default_destination_concurrency_limit
relay_destination_concurrency_negative_feedback = $default_destination_concurrency_negative_feedback
relay_destination_concurrency_positive_feedback = $default_destination_concurrency_positive_feedback
relay_destination_rate_delay = $default_destination_rate_delay
relay_destination_recipient_limit = $default_destination_recipient_limit
relay_domains = $mydestination
relay_domains_reject_code = 554
relay_initial_destination_concurrency = $initial_destination_concurrency
relay_recipient_maps =
relay_transport = relay
relayhost =
relocated_maps =
remote_header_rewrite_domain =
require_home_directory = no
resolve_dequoted_address = yes
resolve_null_domain = no
resolve_numeric_domain = no
rewrite_service_name = rewrite
sample_directory = /usr/share/doc/postfix/examples
send_cyrus_sasl_authzid = no
sender_bcc_maps =
sender_canonical_classes = envelope_sender, header_sender
sender_canonical_maps =
sender_dependent_relayhost_maps =
sendmail_path = /usr/sbin/sendmail
service_throttle_time = 60s
setgid_group = postdrop
show_user_unknown_table_name = yes
showq_service_name = showq
smtp_always_send_ehlo = yes
smtp_bind_address =
smtp_bind_address6 =
smtp_body_checks =
smtp_cname_overrides_servername = no
smtp_connect_timeout = 30s
smtp_connection_cache_destinations =
smtp_connection_cache_on_demand = yes
smtp_connection_cache_time_limit = 2s
smtp_connection_reuse_time_limit = 300s
smtp_data_done_timeout = 600s
smtp_data_init_timeout = 120s
smtp_data_xfer_timeout = 180s
smtp_defer_if_no_mx_address_found = no
smtp_destination_concurrency_failed_cohort_limit = $default_destination_concurrency_failed_cohort_limit
smtp_destination_concurrency_limit = $default_destination_concurrency_limit
smtp_destination_concurrency_negative_feedback = $default_destination_concurrency_negative_feedback
smtp_destination_concurrency_positive_feedback = $default_destination_concurrency_positive_feedback
smtp_destination_rate_delay = $default_destination_rate_delay
smtp_destination_recipient_limit = $default_destination_recipient_limit
smtp_discard_ehlo_keyword_address_maps =
smtp_discard_ehlo_keywords =
smtp_enforce_tls = no
smtp_fallback_relay = $fallback_relay
smtp_generic_maps =
smtp_header_checks =
smtp_helo_name = $myhostname
smtp_helo_timeout = 300s
smtp_host_lookup = dns
smtp_initial_destination_concurrency = $initial_destination_concurrency
smtp_line_length_limit = 990
smtp_mail_timeout = 300s
smtp_mime_header_checks =
smtp_mx_address_limit = 5
smtp_mx_session_limit = 2
smtp_nested_header_checks =
smtp_never_send_ehlo = no
smtp_pix_workaround_delay_time = 10s
smtp_pix_workaround_maps =
smtp_pix_workaround_threshold_time = 500s
smtp_pix_workarounds = disable_esmtp,delay_dotcrlf
smtp_quit_timeout = 300s
smtp_quote_rfc821_envelope = yes
smtp_randomize_addresses = yes
smtp_rcpt_timeout = 300s
smtp_rset_timeout = 20s
smtp_sasl_auth_cache_name =
smtp_sasl_auth_cache_time = 90d
smtp_sasl_auth_enable = no
smtp_sasl_auth_soft_bounce = yes
smtp_sasl_mechanism_filter =
smtp_sasl_password_maps =
smtp_sasl_path =
smtp_sasl_security_options = noplaintext, noanonymous
smtp_sasl_tls_security_options = $smtp_sasl_security_options
smtp_sasl_tls_verified_security_options = $smtp_sasl_tls_security_options
smtp_sasl_type = cyrus
smtp_send_xforward_command = no
smtp_sender_dependent_authentication = no
smtp_skip_5xx_greeting = yes
smtp_skip_quit_response = yes
smtp_starttls_timeout = 300s
smtp_tls_CAfile =
smtp_tls_CApath =
smtp_tls_cert_file =
smtp_tls_dcert_file =
smtp_tls_dkey_file = $smtp_tls_dcert_file
smtp_tls_enforce_peername = yes
smtp_tls_exclude_ciphers =
smtp_tls_fingerprint_cert_match =
smtp_tls_fingerprint_digest = md5
smtp_tls_key_file = $smtp_tls_cert_file
smtp_tls_loglevel = 0
smtp_tls_mandatory_ciphers = medium
smtp_tls_mandatory_exclude_ciphers =
smtp_tls_mandatory_protocols = SSLv3, TLSv1
smtp_tls_note_starttls_offer = no
smtp_tls_per_site =
smtp_tls_policy_maps =
smtp_tls_scert_verifydepth = 9
smtp_tls_secure_cert_match = nexthop, dot-nexthop
smtp_tls_security_level =
smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache
smtp_tls_session_cache_timeout = 3600s
smtp_tls_verify_cert_match = hostname
smtp_use_tls = no
smtp_xforward_timeout = 300s
smtpd_authorized_verp_clients = $authorized_verp_clients
smtpd_authorized_xclient_hosts =
smtpd_authorized_xforward_hosts =
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
smtpd_client_connection_count_limit = 50
smtpd_client_connection_rate_limit = 0
smtpd_client_event_limit_exceptions = ${smtpd_client_connection_limit_exceptions:$mynetworks}
smtpd_client_message_rate_limit = 0
smtpd_client_new_tls_session_rate_limit = 0
smtpd_client_port_logging = no
smtpd_client_recipient_rate_limit = 0
smtpd_client_restrictions =
smtpd_data_restrictions =
smtpd_delay_open_until_valid_rcpt = yes
smtpd_delay_reject = yes
smtpd_discard_ehlo_keyword_address_maps =
smtpd_discard_ehlo_keywords =
smtpd_end_of_data_restrictions =
smtpd_enforce_tls = no
smtpd_error_sleep_time = 1s
smtpd_etrn_restrictions =
smtpd_expansion_filter = \t\40!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~
smtpd_forbidden_commands = CONNECT GET POST
smtpd_hard_error_limit = 20
smtpd_helo_required = no
smtpd_helo_restrictions =
smtpd_history_flush_threshold = 100
smtpd_junk_command_limit = 100
smtpd_milters =
smtpd_noop_commands =
smtpd_null_access_lookup_key = <>
smtpd_peername_lookup = yes
smtpd_policy_service_max_idle = 300s
smtpd_policy_service_max_ttl = 1000s
smtpd_policy_service_timeout = 100s
smtpd_proxy_ehlo = $myhostname
smtpd_proxy_filter =
smtpd_proxy_timeout = 100s
smtpd_recipient_limit = 1000
smtpd_recipient_overshoot_limit = 1000
smtpd_recipient_restrictions = permit_mynetworks,permit_sasl_authenticated, reject_unauth_destination
smtpd_reject_unlisted_recipient = yes
smtpd_reject_unlisted_sender = no
smtpd_restriction_classes =
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_exceptions_networks =
smtpd_sasl_local_domain =
smtpd_sasl_path = smtpd
smtpd_sasl_security_options = noanonymous
smtpd_sasl_tls_security_options = $smtpd_sasl_security_options
smtpd_sasl_type = cyrus
smtpd_sender_login_maps =
smtpd_sender_restrictions =
smtpd_soft_error_limit = 10
smtpd_starttls_timeout = 300s
smtpd_timeout = 300s
smtpd_tls_CAfile =
smtpd_tls_CApath =
smtpd_tls_always_issue_session_ids = yes
smtpd_tls_ask_ccert = no
smtpd_tls_auth_only = no
smtpd_tls_ccert_verifydepth = 9
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_dcert_file =
smtpd_tls_dh1024_param_file =
smtpd_tls_dh512_param_file =
smtpd_tls_dkey_file = $smtpd_tls_dcert_file
smtpd_tls_exclude_ciphers =
smtpd_tls_fingerprint_digest = md5
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_loglevel = 0
smtpd_tls_mandatory_ciphers = medium
smtpd_tls_mandatory_exclude_ciphers =
smtpd_tls_mandatory_protocols = SSLv3, TLSv1
smtpd_tls_received_header = no
smtpd_tls_req_ccert = no
smtpd_tls_security_level =
smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
smtpd_tls_session_cache_timeout = 3600s
smtpd_tls_wrappermode = no
smtpd_use_tls = yes
soft_bounce = no
stale_lock_time = 500s
stress =
strict_7bit_headers = no
strict_8bitmime = no
strict_8bitmime_body = no
strict_mailbox_ownership = yes
strict_mime_encoding_domain = no
strict_rfc821_envelopes = no
sun_mailtool_compatibility = no
swap_bangpath = yes
syslog_facility = mail
syslog_name = postfix
tls_daemon_random_bytes = 32
tls_export_cipherlist = ALL:+RC4:@STRENGTH
tls_high_cipherlist = ALL:!EXPORT:!LOW:!MEDIUM:+RC4:@STRENGTH
tls_low_cipherlist = ALL:!EXPORT:+RC4:@STRENGTH
tls_medium_cipherlist = ALL:!EXPORT:!LOW:+RC4:@STRENGTH
tls_null_cipherlist = eNULL:!aNULL
tls_random_bytes = 32
tls_random_exchange_name = ${data_directory}/prng_exch
tls_random_prng_update_period = 3600s
tls_random_reseed_period = 3600s
tls_random_source = dev:/dev/urandom
trace_service_name = trace
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.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 = 550
unknown_relay_recipient_reject_code = 550
unknown_virtual_alias_reject_code = 550
unknown_virtual_mailbox_reject_code = 550
unverified_recipient_reject_code = 450
unverified_sender_reject_code = 450
verp_delimiter_filter = -=+
virtual_alias_domains =
virtual_alias_expansion_limit = 1000
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_forwardings.cf,          mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_alias_recursion_limit = 1000
virtual_destination_concurrency_failed_cohort_limit = $default_destination_concurrency_failed_cohort_limit
virtual_destination_concurrency_limit = $default_destination_concurrency_limit
virtual_destination_concurrency_negative_feedback = $default_destination_concurrency_negative_feedback
virtual_destination_concurrency_positive_feedback = $default_destination_concurrency_positive_feedback
virtual_destination_rate_delay = $default_destination_rate_delay
virtual_destination_recipient_limit = $default_destination_recipient_limit
virtual_gid_maps = static:5000
virtual_initial_destination_concurrency = $initial_destination_concurrency
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = $virtual_mailbox_maps
virtual_mailbox_limit = 51200000
virtual_mailbox_limit_inbox = no
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_mailbox_lock = fcntl, dotlock
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_maildir_extended = no
virtual_maildir_filter = no
virtual_maildir_filter_maps =
virtual_maildir_limit_message = "The user you are trying to reach is over quota"
virtual_maildir_limit_message_maps =
virtual_maildir_suffix =
virtual_minimum_uid = 100
virtual_overquota_bounce = yes
virtual_transport = virtual
virtual_trash_count = no
virtual_trash_name = .Trash
virtual_uid_maps = static:5000

по логам mysql.log  есть запрос только вида:
SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='fill.mydomen.ru'

[vadim-nsk]

 alex101 пожалуйста покажи содержимое таблицы траспорт

[getrix]

Уф... Поехали

Результат отправки на ящик больше шести символов. Кстати, непонятно откуда взялись www-data@ и некий василий@mail.ru - что это?)

(Нажмите, чтобы показать/скрыть)

Nov  2 14:56:55 server postfix/qmgr[21798]: C73F061A1C: from=<>, size=9446, nrcpt=1 (queue active)
Nov  2 14:56:57 server postfix/smtp[22546]: C73F061A1C: to=<lj_notify@livejournal.com>, relay=mail.livejournal.com[208.93.0.48]:25, delay=63437, delays=63435/0.05/1.5/0.3, dsn=4.7.1, status=deferred (host mail.livejournal.com[208.93.0.48] said: 450 4.7.1 <amirtat85.static.corbina.ru[95.31.6.207]>: Client host rejected: domain check, be patient (in reply to RCPT TO command))
getrix@server:~$ tail -40 /var/log/mail.log
Nov  2 14:56:39 server postfix/qmgr[21798]: B4ABC61A9F: removed
Nov  2 14:56:39 server postfix/local[22424]: B111C61A99: to=<someshit@sergpetrenko.ru>, relay=local, delay=0.14, delays=0.07/0.01/0/0.06, dsn=5.1.1, status=bounced (unknown user: "someshit")
Nov  2 14:56:39 server postfix/cleanup[22413]: D3C5C61A9F: message-id=<20091102115639.D3C5C61A9F@sergpetrenko.ru>
Nov  2 14:56:39 server postfix/qmgr[21798]: D3C5C61A9F: from=<>, size=2582, nrcpt=1 (queue active)
Nov  2 14:56:39 server postfix/trivial-rewrite[22534]: warning: do not list domain sergpetrenko.ru in BOTH mydestination and virtual_mailbox_domains
Nov  2 14:56:39 server postfix/bounce[22425]: B111C61A99: sender non-delivery notification: D3C5C61A9F
Nov  2 14:56:39 server postfix/qmgr[21798]: B111C61A99: removed
Nov  2 14:56:40 server postfix/local[22424]: D3C5C61A9F: to=<getrix@sergpetrenko.ru>, relay=local, delay=0.14, delays=0.08/0.01/0/0.06, dsn=2.0.0, status=sent (delivered to mailbox)
Nov  2 14:56:40 server postfix/qmgr[21798]: D3C5C61A9F: removed
Nov  2 14:56:40 server postfix/pickup[21065]: A71E061A9F: uid=33 from=<www-data>
Nov  2 14:56:40 server postfix/cleanup[22413]: A71E061A9F: message-id=<20091102115640.A71E061A9F@sergpetrenko.ru>
Nov  2 14:56:40 server postfix/qmgr[21798]: A71E061A9F: from=<www-data@sergpetrenko.ru>, size=1035, nrcpt=1 (queue active)
Nov  2 14:56:44 server postfix/smtpd[22421]: connect from localhost[127.0.0.1]
Nov  2 14:56:44 server postfix/trivial-rewrite[22534]: warning: do not list domain sergpetrenko.ru in BOTH mydestination and virtual_mailbox_domains
Nov  2 14:56:44 server postfix/smtpd[22421]: 1C21961A99: client=localhost[127.0.0.1]
Nov  2 14:56:44 server amavis[8320]: (08320-14) INFO: removed bare CR from 2 header line(s)
Nov  2 14:56:44 server postfix/cleanup[22413]: 1C21961A99: message-id=<20091102115640.A71E061A9F@sergpetrenko.ru>
Nov  2 14:56:44 server postfix/qmgr[21798]: 1C21961A99: from=<www-data@sergpetrenko.ru>, size=1610, nrcpt=1 (queue active)
Nov  2 14:56:44 server postfix/smtpd[22421]: disconnect from localhost[127.0.0.1]
Nov  2 14:56:44 server amavis[8320]: (08320-14) Passed BAD-HEADER, <www-data@sergpetrenko.ru> -> <wasulij@mail.ru>, quarantine: m/badh-m7cX+jB4ookV, Message-ID: <20091102115640.A71E061A9F@sergpetrenko.ru>, mail_id: m7cX+jB4ookV, Hits: 5.677, size: 1034, queued_as: 1C21961A99, 3527 ms
Nov  2 14:56:44 server postfix/smtp[22416]: A71E061A9F: to=<wasulij@mail.ru>, relay=127.0.0.1[127.0.0.1]:10024, delay=3.7, delays=0.19/0/0.01/3.5, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=08320-14, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 1C21961A99)
Nov  2 14:56:44 server postfix/qmgr[21798]: A71E061A9F: removed
Nov  2 14:56:44 server postfix/smtp[22546]: 1C21961A99: to=<wasulij@mail.ru>, relay=mxs.mail.ru[94.100.176.20]:25, delay=0.54, delays=0.14/0.03/0.05/0.33, dsn=2.0.0, status=sent (250 OK id=1N4vWd-000Bcp-00)
Nov  2 14:56:44 server postfix/qmgr[21798]: 1C21961A99: removed
Nov  2 14:56:55 server postfix/qmgr[21798]: C73F061A1C: from=<>, size=9446, nrcpt=1 (queue active)
Nov  2 14:56:57 server postfix/smtp[22546]: C73F061A1C: to=<lj_notify@livejournal.com>, relay=mail.livejournal.com[208.93.0.48]:25, delay=63437, delays=63435/0.05/1.5/0.3, dsn=4.7.1, status=deferred (host mail.livejournal.com[208.93.0.48] said: 450 4.7.1 <amirtat85.static.corbina.ru[95.31.6.207]>: Client host rejected: domain check, be patient (in reply to RCPT TO command))
Nov  2 14:57:38 server postfix/pickup[21065]: 1C06D61A9F: uid=33 from=<www-data>
Nov  2 14:57:38 server postfix/cleanup[22413]: 1C06D61A9F: message-id=<20091102115738.1C06D61A9F@sergpetrenko.ru>
Nov  2 14:57:38 server postfix/qmgr[21798]: 1C06D61A9F: from=<www-data@sergpetrenko.ru>, size=1183, nrcpt=1 (queue active)
Nov  2 14:57:42 server postfix/smtpd[22421]: connect from localhost[127.0.0.1]
Nov  2 14:57:42 server postfix/smtpd[22421]: 6E5DB61A99: client=localhost[127.0.0.1]
Nov  2 14:57:42 server amavis[7409]: (07409-17) INFO: removed bare CR from 2 header line(s)
Nov  2 14:57:42 server postfix/cleanup[22413]: 6E5DB61A99: message-id=<20091102115738.1C06D61A9F@sergpetrenko.ru>
Nov  2 14:57:42 server postfix/qmgr[21798]: 6E5DB61A99: from=<www-data@sergpetrenko.ru>, size=1758, nrcpt=1 (queue active)
Nov  2 14:57:42 server postfix/smtpd[22421]: disconnect from localhost[127.0.0.1]
Nov  2 14:57:42 server amavis[7409]: (07409-17) Passed BAD-HEADER, <www-data@sergpetrenko.ru> -> <wasulij@mail.ru>, quarantine: Z/badh-Z4RGPdFv47t9, Message-ID: <20091102115738.1C06D61A9F@sergpetrenko.ru>, mail_id: Z4RGPdFv47t9, Hits: 5.677, size: 1181, queued_as: 6E5DB61A99, 4301 ms
Nov  2 14:57:42 server postfix/smtp[22416]: 1C06D61A9F: to=<wasulij@mail.ru>, relay=127.0.0.1[127.0.0.1]:10024, delay=4.6, delays=0.29/0/0.01/4.3, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=07409-17, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 6E5DB61A99)
Nov  2 14:57:42 server postfix/qmgr[21798]: 1C06D61A9F: removed
Nov  2 14:57:42 server postfix/smtp[22546]: 6E5DB61A99: to=<wasulij@mail.ru>, relay=mxs.mail.ru[94.100.176.20]:25, delay=0.54, delays=0.14/0.02/0.02/0.35, dsn=2.0.0, status=sent (250 OK id=1N4vXZ-000Jo4-00)
Nov  2 14:57:42 server postfix/qmgr[21798]: 6E5DB61A99: removed

2. Домен в MySQL добавлен

(Нажмите, чтобы показать/скрыть)

SELECT *
FROM `mail_domains`
LIMIT 0 , 30

domain sergpetrenko.ru

не заставляйте getrix искать черную кошку в темной комнате ..., вы неправильно поняли данное предупреждение postfix'а, если перевести на русский, то получится "Предупреждение: не указывайте домен sergpetrenko.ru ОДНОВРЕМЕННО В ОБЕИХ переменных mydestination и virtual_mailbox_domains"

Ну это предупреждение, а не ошибка, на работу оно влиять вроде не должно, но тем не менее поправил.

Включите подробное логирование, сразу все будет видно кто, куда и зачем.

:-D это как? Я не умею

postconf > http://sergpetrenko.ru/postconf.txt

Логи MYSQL почему-то найти не смог.. Может в убунте они где-то в другом месте хранятся или логгинг выключен?

(Нажмите, чтобы показать/скрыть)

root@server:~# tail -20 /var/log/mysql
mysql/          mysql.err       mysql.log       mysql.log.1.gz  mysql.log.2.gz
root@server:~# tail -20 /var/log/mysql.log
root@server:~# tail -20 /var/log/mysql.log
root@server:~# tail -20 /var/log/mysql.err
root@server:~# tail -20 /var/log/
apache2/                 ConsoleKit/              dmesg.3.gz               lastlog                  mysql.log.1.gz           syslog.2.gz
apparmor/                cups/                    dmesg.4.gz               lpr.log                  mysql.log.2.gz           udev
apt/                     daemon.log               dpkg.log                 mail.err                 news/                    unattended-upgrades/
aptitude                 dcc/                     dpkg.log.1               mail.info                pycentral.log            user.log
aptitude.1.gz            debug                    faillog                  mail.log                 samba/                   wpa_supplicant.log
auth.log                 dist-upgrade/            fontconfig.log           mail.warn                scrollkeeper.log         wpa_supplicant.log.1.gz
boot                     dmesg                    fsck/                    messages                 scrollkeeper.log.1       wpa_supplicant.log.2.gz
btmp                     dmesg.0                  installer/               mysql/                   syslog                   wtmp
btmp.1                   dmesg.1.gz               kern.log                 mysql.err                syslog.0                 wtmp.1
clamav/                  dmesg.2.gz               landscape/               mysql.log                syslog.1.gz
root@server:~# tail -20 /var/log/mysql
mysql/          mysql.err       mysql.log       mysql.log.1.gz  mysql.log.2.gz
root@server:~# tail -20 /var/log/mysql
mysql/          mysql.err       mysql.log       mysql.log.1.gz  mysql.log.2.gz
root@server:~# tail -20 /var/log/mysql.log
root@server:~# tail -20 /var/log/mysql.log.1.gz

Состояние таблиц в SQL такое:

(Нажмите, чтобы показать/скрыть)

   Действие    Записи    Тип   Сравнение   Размер   Накладные расходы
   mail_domains                      1   MyISAM   latin1_swedish_ci   2.0 КБ   -
   mail_forwardings                      0   MyISAM   latin1_swedish_ci   1.0 КБ   -
   mail_transport                      0   MyISAM   latin1_swedish_ci   1.0 КБ   -
   mail_users                      2   MyISAM   latin1_swedish_ci   2.1 КБ   -

Вроде, постфикс работает более менее стабильно. Может, с Courier что-то, т.к. POP3 не авторизовывается ни в какую, но юзеров определяет (см выше)

[Bambr]

alex101 пожалуйста покажи содержимое таблицы траспорт

Не только этой, alex101, давайте содержимое всех таблиц, тогда можно предметно разговаривать.

P.S. Подредактировал свой пост по включению расширенных логов, добавил логирование транспорта virtual.

[alex101]

Содержимое таблицы транспорт:
 Хост: localhost
База данных: mail
Время создания: Ноя 02 2009 г., 15:35
Создан: phpMyAdmin 2.11.8.1deb5+lenny3 / MySQL 5.0.51a-24+lenny2+spu1-log
SQL-запрос: SELECT `domain`, `transport` FROM `transport` LIMIT 0, 30 ;
Строки: 1
domain    transport
mydomen.ru    smtp:fill.mydomen.ru

[getrix]

может какие конфиги courier'а показать?

[Bambr]

alex101, вот вам и петля. postfix всю пришедшую почту пытается переслать самому себе. Закомментируйте пока переменную transport_maps
Пользователь решил продолжить мысль 02 Ноября 2009, 16:18:33:qetrix, по-моему, судя по логам, у вас кто-то усиленно спамит, но я могу ошибаться.

[alex101]

Закоментировал transport_maps пергрузил постфикс, но логи не изменились

(Нажмите, чтобы показать/скрыть)

Nov  2 16:13:51 fill postfix/master[9995]: reload configuration /etc/postfix
Nov  2 16:14:15 fill postfix/pickup[22421]: B0C8E1E474: uid=0 from=<root>
Nov  2 16:14:15 fill postfix/cleanup[22425]: B0C8E1E474: message-id=<20091102131415.B0C8E1E474@fill.mydomen.ru>
Nov  2 16:14:15 fill postfix/qmgr[22419]: B0C8E1E474: from=<root@fill.mydomen.ru>, size=323, nrcpt=1 (queue active)
Nov  2 16:14:25 fill postfix/smtpd[22434]: connect from localhost[127.0.0.1]
Nov  2 16:14:25 fill postfix/smtpd[22434]: DEC661E471: client=localhost[127.0.0.1]
Nov  2 16:14:25 fill postfix/cleanup[22425]: DEC661E471: message-id=<20091102131415.B0C8E1E474@fill.mydomen.ru>
Nov  2 16:14:25 fill postfix/smtpd[22434]: disconnect from localhost[127.0.0.1]
Nov  2 16:14:25 fill postfix/qmgr[22419]: DEC661E471: from=<root@fill.mydomen.ru>, size=791, nrcpt=1 (queue active)
Nov  2 16:14:25 fill amavis[32581]: (32581-09) Passed CLEAN, <root@fill.mydomen.ru> -> <alex@fill.mydomen.ru>, Message-ID: <20091102131415.B0C8E1E474@fill.mydomen.ru>, mail_id: 91JBBRsxIe1Z, Hits: 0.67, size: 323, queued_as: DEC661E471, 10172 ms
Nov  2 16:14:25 fill postfix/smtp[22428]: B0C8E1E474: to=<alex@fill.mydomen.ru>, relay=127.0.0.1[127.0.0.1]:10024, delay=10, delays=0.04/0.01/0/10, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=32581-09, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as DEC661E471)
Nov  2 16:14:25 fill postfix/qmgr[22419]: B0C8E1E474: removed
Nov  2 16:14:25 fill postfix/smtp[22438]: DEC661E471: to=<alex@fill.mydomen.ru>, relay=none, delay=0.03, delays=0.01/0.02/0/0, dsn=5.4.6, status=bounced (mail for fill.mydomen.ru loops back to myself)
Nov  2 16:14:25 fill postfix/cleanup[22425]: E94EF1E475: message-id=<20091102131425.E94EF1E475@fill.mydomen.ru>
Nov  2 16:14:25 fill postfix/bounce[22439]: DEC661E471: sender non-delivery notification: E94EF1E475
Nov  2 16:14:25 fill postfix/qmgr[22419]: E94EF1E475: from=<>, size=2702, nrcpt=1 (queue active)
Nov  2 16:14:25 fill postfix/qmgr[22419]: DEC661E471: removed

[getrix]

qetrix, по-моему, судя по логам, у вас кто-то усиленно спамит, но я могу ошибаться.

вполне возможно, но с этим я потом разберусь :-D что мне делать то?((


О боже! Все заработало!!!! Спасибо огромное всем кто мне помогал! Видимо, косяк был в mydestination :-)

[vadim-nsk]

Закоментировал transport_maps пергрузил постфикс, но логи не изменились

вообщем то это относится к виртуал траспорт, но лучше обратно раскоментируйте и очистите таблицу, удалите запись, пусть она останется пустой.

[alex101]

Раскоментировал, очистил таблицы отправил пробное письмо - результат тот же loops back to myself
(лог приводить не имеет смысла он такой же)