Здравствуйте.
Вчера обновил ПО и опять полезли проблемы с почтой
в логах
Код: Выделить всё
2014-07-30 12:31:16 H=mails.m-mail.com.ua [91.224.75.65] F=<odyag23-315-0729e@m-mail.com.ua> temporarily rejected RCPT <nick@domain.org.ua>: MYSQL: no data found
то есть опять какие то проблемы с мускулом, хотя обновился exim
Подскажите что это значит а то по MYSQL: no data found тяжело что то предположить. Не понятно почему запросы возвращают пустой результат. Кстати если в phpmyadmin выполнить этот же запрос то он тоже возвращает пустой результат.
Код: Выделить всё
exim -d -bt nick@domain.org.ua
Exim version 4.83 (FreeBSD 8.4) uid=0 gid=0 pid=15885 D=fbb95cfd
Probably Berkeley DB version 1.8x (native mode)
Support for: crypteq iconv() use_setclassresources PAM Perl Expand_dlfunc OpenSS L Content_Scanning DKIM Old_Demime PRDR
Lookups (built-in): lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmjz dbm nz dnsdb dsearch mysql nis nis0 passwd
Authenticators: cram_md5 dovecot plaintext spa
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Fixed never_users: 0
Size of off_t: 8
Compiler: GCC [4.2.1 20070831 patched [FreeBSD]]
Library version: OpenSSL: Compile: OpenSSL 0.9.8y 5 Feb 2013
Runtime: OpenSSL 0.9.8y 5 Feb 2013
: built on: date not available
Library version: PCRE: Compile: 8.34
Runtime: 8.34 2013-12-15
Total 14 lookups
Library version: MySQL: Compile: 5.5.38 [Source distribution]
Runtime: 5.5.38
WHITELIST_D_MACROS unset
TRUSTED_CONFIG_LIST unset
changed uid/gid: forcing real = effective
uid=0 gid=0 pid=15885
auxiliary group list: 0
seeking password data for user "www": cache not available
getpwnam() succeeded uid=80 gid=80
seeking password data for user "mailnull": cache not available
getpwnam() succeeded uid=26 gid=26
seeking password data for user "root": cache not available
getpwnam() succeeded uid=0 gid=0
changed uid/gid: calling tls_validate_require_cipher
uid=26 gid=6 pid=15886
auxiliary group list: 6
tls_validate_require_cipher child 15886 ended: status=0x0
configuration file is /usr/local/etc/exim/configure
log selectors = 00000ffc 002b2001
trusted user
admin user
seeking password data for user "mailnull": cache not available
getpwnam() succeeded uid=26 gid=26
seeking password data for user "mailnull": using cached result
getpwnam() succeeded uid=26 gid=26
originator: uid=0 gid=0 login=root name=Charlie Root
sender address = root@domain.org.ua
Address testing: uid=0 gid=6 euid=0 egid=6
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Testing nick@domain.org.ua
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering nick@domain.org.ua
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
routing nick@domain.org.ua
--------> dnslookup router <--------
local_part=nick domain=domain.org.ua
checking domains
search_open: mysql "NULL"
search_find: file="NULL"
key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled = '1 ' AND domain = 'domain.org.ua'" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="SELECT DISTINCT domain FROM domains WHERE type = 'local' AND e nabled = '1' AND domain = 'domain.org.ua'"
database lookup required for SELECT DISTINCT domain FROM domains WHERE type = 'l ocal' AND enabled = '1' AND domain = 'domain.org.ua'
MySQL query: SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enable d = '1' AND domain = 'domain.org.ua'
MYSQL new connection: host=localhost port=0 socket=/tmp/mysql.sock database=vexi m user=vexim
lookup yielded: domain.org.ua
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'domain.org.ua'" parti al=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="SELECT DISTINCT alias FROM domainalias WHERE alias = 'domain.org .ua'"
database lookup required for SELECT DISTINCT alias FROM domainalias WHERE alias = 'domain.org.ua'
MySQL query: SELECT DISTINCT alias FROM domainalias WHERE alias = 'domain.org.ua'
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
domain.org.ua in "@ : domain.org.ua : "? yes (matched "@")
domain.org.ua in "! +local_domains"? no (matched "! +local_domains")
dnslookup router skipped: domains mismatch
--------> mailman_router router <--------
local_part=nick domain=domain.org.ua
checking require_files
file check: /usr/local/mailman/lists/$local_part/config.pck
expanded file: /usr/local/mailman/lists/nick/config.pck
stat() yielded -1
errno = 2
mailman_router router skipped: file check
--------> ditch_maxmsgsize router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select users.maxmsgsize from users,domains where localpart = 'nick' and d omain = 'domain.org.ua' and users.maxmsgsize > 0 and users.domain_id=domains.domai n_id " partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select users.maxmsgsize from users,domains where localpart = ' nick' and domain = 'domain.org.ua' and users.maxmsgsize > 0 and users.domain_id=do mains.domain_id "
database lookup required for select users.maxmsgsize from users,domains where lo calpart = 'nick' and domain = 'domain.org.ua' and users.maxmsgsize > 0 and users.d omain_id=domains.domain_id
MySQL query: select users.maxmsgsize from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.maxmsgsize > 0 and users.domain_id=domains .domain_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
ditch_maxmsgsize router skipped: condition failure
--------> ditch_malware router <--------
local_part=nick domain=domain.org.ua
checking "condition"
ditch_malware router skipped: condition failure
--------> ditch_spam router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select users.sa_refuse * 10 from users,domains where localpart = 'nick' a nd domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.domain_id=do mains.domain_id and users.sa_refuse > 0 " partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select users.sa_refuse * 10 from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.d omain_id=domains.domain_id and users.sa_refuse > 0 "
database lookup required for select users.sa_refuse * 10 from users,domains wher e localpart = 'nick' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id and users.sa_refuse > 0
MySQL query: select users.sa_refuse * 10 from users,domains where localpart = 'n ick' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.domain _id=domains.domain_id and users.sa_refuse > 0
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
ditch_spam router skipped: condition failure
--------> ditch_hdrmailer router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'nick' and domain s.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and users.us er_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select count(*) from blocklists,users,domains where blocklists .blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id a nd users.user_id=blocklists.user_id"
database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'x-mailer' and blocklists.blockval = '' and users.localpa rt = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists. domain_id and users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where blocklists.bloc khdr = 'x-mailer' and blocklists.blockval = '' and users.localpart = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and us ers.user_id=blocklists.user_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrmailer router skipped: condition failure
--------> ditch_hdrto router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'nick' and domains.doma in = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and users.user_id= blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select count(*) from blocklists,users,domains where blocklists .blockhdr = 'to' and blocklists.blockval = '' and users.localpart = 'nick' and d omains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and use rs.user_id=blocklists.user_id"
database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'to' and blocklists.blockval = '' and users.localpart = ' nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain _id and users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where blocklists.bloc khdr = 'to' and blocklists.blockval = '' and users.localpart = 'nick' and domain s.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and users.us er_id=blocklists.user_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrto router skipped: condition failure
--------> ditch_hdrfrom router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'nick' and domains.do main = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and users.user_i d=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select count(*) from blocklists,users,domains where blocklists .blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and u sers.user_id=blocklists.user_id"
database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'from' and blocklists.blockval = '' and users.localpart = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.doma in_id and users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where blocklists.bloc khdr = 'from' and blocklists.blockval = '' and users.localpart = 'nick' and doma ins.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and users. user_id=blocklists.user_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrfrom router skipped: condition failure
--------> ditch_hdrsubject router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '' and users.localpart = 'nick' and domains .domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and users.use r_id=blocklists.user_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select count(*) from blocklists,users,domains where blocklists .blockhdr = 'subject' and blocklists.blockval = '' and users.localpart = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id an d users.user_id=blocklists.user_id"
database lookup required for select count(*) from blocklists,users,domains where blocklists.blockhdr = 'subject' and blocklists.blockval = '' and users.localpar t = 'nick' and domains.domain = 'domain.org.ua' and domains.domain_id=blocklists.d omain_id and users.user_id=blocklists.user_id
MySQL query: select count(*) from blocklists,users,domains where blocklists.bloc khdr = 'subject' and blocklists.blockval = '' and users.localpart = 'nick' and d omains.domain = 'domain.org.ua' and domains.domain_id=blocklists.domain_id and use rs.user_id=blocklists.user_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
lookup yielded: 0
ditch_hdrsubject router skipped: condition failure
--------> virtual_vacation router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select users.on_vacation from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.on_vacation = '1' and users.domain_id=domains.d omain_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select users.on_vacation from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.on_vacation = '1' and users.domain_i d=domains.domain_id"
database lookup required for select users.on_vacation from users,domains where l ocalpart = 'nick' and domain = 'domain.org.ua' and users.on_vacation = '1' and use rs.domain_id=domains.domain_id
MySQL query: select users.on_vacation from users,domains where localpart = 'nick ' and domain = 'domain.org.ua' and users.on_vacation = '1' and users.domain_id=dom ains.domain_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
virtual_vacation router skipped: condition failure
--------> virtual_forward router <--------
local_part=nick domain=domain.org.ua
checking "condition"
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select users.on_forward from users,domains where localpart = 'nick' and d omain = 'domain.org.ua' and users.on_forward = '1' and users.domain_id=domains.dom ain_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select users.on_forward from users,domains where localpart = ' nick' and domain = 'domain.org.ua' and users.on_forward = '1' and users.domain_id= domains.domain_id"
database lookup required for select users.on_forward from users,domains where lo calpart = 'nick' and domain = 'domain.org.ua' and users.on_forward = '1' and users .domain_id=domains.domain_id
MySQL query: select users.on_forward from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.on_forward = '1' and users.domain_id=domai ns.domain_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
virtual_forward router skipped: condition failure
--------> virtual_domains router <--------
local_part=nick domain=domain.org.ua
calling virtual_domains router
rda_interpret (string): ${lookup mysql{select smtp from users,domains where loca lpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql:$domain}' and d omains.enabled = '1' and users.enabled = '1' and users.domain_id = domains.domai n_id}}
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select smtp from users,domains where localpart = 'nick' and domain = 'faa f.org.ua' and domains.enabled = '1' and users.enabled = '1' and users.domain_id = domains.domain_id" partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select smtp from users,domains where localpart = 'nick' and do main = 'domain.org.ua' and domains.enabled = '1' and users.enabled = '1' and users .domain_id = domains.domain_id"
database lookup required for select smtp from users,domains where localpart = 'n ick' and domain = 'domain.org.ua' and domains.enabled = '1' and users.enabled = '1 ' and users.domain_id = domains.domain_id
MySQL query: select smtp from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and domains.enabled = '1' and users.enabled = '1' and users.doma in_id = domains.domain_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
lookup yielded: /usr/local/mail/domain.org.ua/nick/Maildir
expanded: /usr/local/mail/domain.org.ua/nick/Maildir
file is not a filter file
parse_forward_list: /usr/local/mail/domain.org.ua/nick/Maildir
extract item: /usr/local/mail/domain.org.ua/nick/Maildir
search_open: mysql "NULL"
cached open
search_find: file="NULL"
key="select users.sa_tag * 10 from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.domain_id=domai ns.domain_id " partial=-1 affix=NULL starflags=0
LRU list:
internal_search_find: file="NULL"
type=mysql key="select users.sa_tag * 10 from users,domains where localpart = 'nick' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.doma in_id=domains.domain_id "
database lookup required for select users.sa_tag * 10 from users,domains where l ocalpart = 'nick' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.domain_id=domains.domain_id
MySQL query: select users.sa_tag * 10 from users,domains where localpart = 'nick ' and domain = 'domain.org.ua' and users.on_spamassassin = '1' and users.domain_id =domains.domain_id
MYSQL using cached connection for localhost:(/tmp/mysql.sock)/vexim/vexim
MYSQL: no data found
lookup failed
virtual_domains router: defer for nick@domain.org.ua
message: virtual_domains router failed to expand "${if or { { <{$spam_score_in t}{1} } { <{$spam_score_int}{${lookup mysql{select users.sa_tag * 10 from users, domains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mys ql:$domain}' and users.on_spamassassin = 1 and users.domain_id=domains.domain_id }{$value}fail}} } { eq {0}{${lookup mysql{select users.sa_tag * 10 from users,do mains where localpart = '${quote_mysql:$local_part}' and domain = '${quote_mysql :$domain}' and users.on_spamassassin = 0 and users.domain_id=domains.domain_id}{ $value}fail}}} } {X-Spam-Score:X-Spam-Report} }": missing } at end of string ins ide "or{...}" condition
nick@domain.org.ua cannot be resolved at this time: Temporary internal error
search_tidyup called
close MYSQL connection: localhost:(/tmp/mysql.sock)/vexim/vexim
>>>>>>>>>>>>>>>> Exim pid=15885 terminating with rc=1 >>>>>>>>>>>>>>>>