Здравствуйте.
В 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
Помогите пожалуйста.