The OpenNET Project / Index page

[ новости /+++ | форум | теги | ]

форумы  помощь  поиск  регистрация  майллист  ВХОД  слежка  RSS
"exim. Помогите понять в чем проблема."
Вариант для распечатки  
Пред. тема | След. тема 
Форумы OpenNET: Виртуальная конференция (Public)
Изначальное сообщение [Проследить за развитием треда]

"exim. Помогите понять в чем проблема."  
Сообщение от visitor (ok) on 25-Июн-07, 18:46 
Здравствуйте.
В messages постоянно сыпяться записи:
Jun 25 17:40:31 mail exim[49244]: failed to expand "${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}" while checking a list: lookup of "SELECT `domain` FROM `domain` WHERE `domain`='mail.mydomain.com' AND `active`='1'" gave DEFER: MYSQL connection failed: Lost connection to MySQL server during query
Jun 25 17:40:31 mail exim[49242]: failed to expand "${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}" while checking a list: lookup of "SELECT `domain` FROM `domain` WHERE `domain`='mail.mydomain.com' AND `active`='1'" gave DEFER: MYSQL connection failed: Lost connection to MySQL server during query

вот конфиг екзима:
primary_hostname = mail.mydomain.com
hide mysql_servers = localhost/exim/exim/exim

domainlist local_domains = ${lookup mysql{SELECT `domain` \
                            FROM `domain` WHERE \
                            `domain`='${domain}' AND \
                            `active`='1'}}

domainlist relay_to_domains = ${lookup mysql{SELECT `domain` \
                            FROM `domain` WHERE \
                            `domain`='${domain}' AND \
                            `active`='1'}}

hostlist   relay_from_hosts = localhost:127.0.0.0/8
acl_smtp_rcpt = acl_check_rcpt
acl_smtp_data = acl_check_data
#av_scanner = clamd:/var/run/clamav/clamd
#av_scanner = clamd:/usr/sbin/clamd
#spamd_address = 127.0.0.1 783
qualify_domain = mail.mydomain.com
qualify_recipient = mail.mydomain.com
allow_domain_literals = false
exim_user = mailnull
exim_group = mail
never_users = root
rfc1413_query_timeout = 0s
ignore_bounce_errors_after = 45m
timeout_frozen_after = 7d
freeze_tell = admin@mail.mydomain.com
helo_accept_junk_hosts = 194.xxx.xxx.x/24
auto_thaw = 1h
smtp_banner = "$primary_hostname, ESMTP EXIM $version_number"
smtp_accept_max = 180
smtp_accept_max_per_connection = 25
smtp_connect_backlog = 30
smtp_accept_max_per_host = 20
split_spool_directory = true
remote_max_parallel = 15
return_size_limit = 70k
message_size_limit = 15M
helo_allow_chars = _
smtp_enforce_sync = true

log_selector = \
    +all_parents \
    +connection_reject \
    +incoming_interface \
    +lost_incoming_connection \
    +received_sender \
    +received_recipients \
    +smtp_confirmation \
    +smtp_syntax_error \
    +smtp_protocol_error \
    -queue_run
syslog_timestamp = no
system_filter = /usr/local/etc/exim/copy_mail.conf

#########################################################
begin acl
#########################################################
acl_check_rcpt:

accept  hosts = :
deny    message       = "Not permit simbols in address"
        domains       = +local_domains
        local_parts   = ^[.] : ^.*[@%!/|]

deny    message       = "Not permit simbols in address"
        domains       = !+local_domains
        local_parts   = ^[./|] : ^.*[@%!] : ^.*/\\.\\./

#  accept  local_parts   = postmaster
#          domains       = +local_domains

#require verify        = sender

deny    message       = "HELO/EHLO must be SMTP RFC"
        condition     = ${if eq{$sender_helo_name}{}{yes}{no}}

accept  authenticated = *

deny    message       = "Dont use your IP as HELO!"
        hosts         =  *:!+relay_from_hosts
        condition     = ${if eq{$sender_helo_name}\
                         {$sender_host_address}{true}{false}}

deny    condition     = ${if eq{$sender_helo_name}\
                          {$interface_address}{yes}{no}}
        hosts         = !127.0.0.1 : !localhost : *
        message       = "Its my IP-address! Go away!"

deny    condition     = ${if match{$sender_helo_name}\
                          {\N^\d+$\N}{yes}{no}}
        hosts         = !127.0.0.1:!localhost:*
        message       = "HELO dont have only digits!"

deny    message       = "Dont like your host ..."
        condition     = ${if match{$sender_host_name} \
                               {adsl|dialup|pool|peer|dhcp} \
                               {yes}{no}}

deny    message       = "host in blacklist - $dnslist_domain \n $dnslist_text"
        dnslists      =   opm.blitzed.org : \
                          proxies.blackholes.easynet.nl : \
                          cbl.abuseat.org : \
                          bl.spamcop.net : \
                          bl.csma.biz : \
                          dynablock.njabl.org

#warn
#        set acl_m0 = 20s
#warn
#        hosts = +relay_from_hosts : 193.232.248.0/24
#        set acl_m0 = 0s
#warn
#        logwrite = Delay $acl_m0 for $sender_host_name \
#       [$sender_host_address] with HELO=$sender_helo_name. Mail \
#       from $sender_address to $local_part.
#        delay = $acl_m0

accept  domains       = +local_domains
        endpass
        message       = "Dont have user in this domain"
        verify        = recipient

accept  domains       = +relay_to_domains
        endpass
        message       = "I dont know route to this host..."
        verify        = recipient

accept  hosts         = +relay_from_hosts
deny    message       = "My server is not an open relay"

#####################################################################
acl_check_data:

deny message = "this is spam - denied"
   condition = ${if match{$message_body} \
              {105[-_]*51[-_]*86|778[-_]*98[-_]*94} \
              {yes}{no}}

#deny malware = *                                       # UNCOMMENT THESE LINES WHEN INSTALL AV
#  message = "In e-mail found VIRUS - $malware_name"

accept
#######################################################################
begin routers

dnslookup:
  driver = dnslookup
  domains = ! +local_domains
  transport = remote_smtp
  ignore_target_hosts = 0.0.0.0 : 127.0.0.0/8
  no_more

system_aliases:
    driver      = redirect
    allow_fail
    allow_defer
    data = ${lookup mysql{SELECT `goto` FROM `alias` WHERE \
           `address`='${quote_mysql:$local_part@$domain}' OR \
           `address`='${quote_mysql:@$domain}'}}

mysqluser:
  driver = accept
  condition = ${if eq{}{${lookup mysql{SELECT `maildir` FROM `mailbox` \
              WHERE `username`='$local_part'}}}{no}{yes}}
  transport = mysql_delivery

#############################################################################
begin transports

remote_smtp:
    driver = smtp

mysql_delivery:
    driver = appendfile
    check_string = ""
    create_directory
    delivery_date_add
    directory = ${lookup mysql{SELECT CONCAT('/var/mail/exim/', `maildir`) \
                FROM `mailbox` WHERE `username`='${local_part}'}}
    directory_mode = 770
    envelope_to_add
    group = mail
    maildir_format
    maildir_tag = ,S=$message_size
    message_prefix = ""
    message_suffix = ""
    mode = 0600

address_file:
    driver = appendfile
    delivery_date_add
    envelope_to_add
    return_path_add

address_pipe:
  driver = pipe
  return_output

address_reply:
  driver = autoreply
#####################################################################
begin retry

*                    *       F,2h,15m; G,16h,1h,1.5; F,4d,6h
#####################################################################
begin rewrite
#####################################################################
begin authenticators


auth_plain:
  driver = plaintext
  public_name = PLAIN
  server_condition = ${lookup mysql{SELECT `username` FROM \
                     `mailbox` WHERE `username` = \
                     '${quote_mysql:${local_part:$2}}' AND `password` = \
                     OLD_PASSWORD('${quote_mysql:$3}')}{yes}{no}}
  server_prompts = :
  server_set_id = $2

auth_login:
  driver = plaintext
  public_name = LOGIN
  server_condition = ${lookup mysql{SELECT `username` FROM \
                     `mailbox` WHERE `username` = \
                     '${quote_mysql:${local_part:$1}}' AND `password` = \
                     OLD_PASSWORD('${quote_mysql:$2}')}{yes}{no}}
  server_prompts = Username:: : Password::
  server_set_id = $1

#auth_cram_md5:
#  driver = cram_md5
#  public_name = CRAM-MD5
#  server_secret = ${lookup mysql{SELECT `password` FROM \
#                        `mailbox` WHERE `username` \
#                        = '${quote_mysql:${local_part:$1}}'}{$value}fail}
#  server_set_id = $1

вот my.cnf:

[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock

# If you want to logging queries, uncomment next line
#log

skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
set-variable = max_connections=1024

server-id       = 1


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


Помогите пожалуйста.

Высказать мнение | Ответить | Правка | Наверх | Cообщить модератору

 Оглавление

Сообщения по теме [Сортировка по времени, UBB]


1. "exim. Помогите понять в чем проблема."  
Сообщение от visitor (ok) on 25-Июн-07, 18:57 
увеличил connect_timeout с 5 до 60.
Минут 20 пока в messages пусто.
Высказать мнение | Ответить | Правка | Наверх | Cообщить модератору

Архив | Удалить

Индекс форумов | Темы | Пред. тема | След. тема
Оцените тред (1=ужас, 5=супер)? [ 1 | 2 | 3 | 4 | 5 ] [Рекомендовать для помещения в FAQ]




Партнёры:
PostgresPro
Inferno Solutions
Hosting by Hoster.ru
Хостинг:

Закладки на сайте
Проследить за страницей
Created 1996-2025 by Maxim Chirkov
Добавить, Поддержать, Вебмастеру