Ошибки Exim -system filter

EXIM, sendmail, postfix, Dovecot и прочие. Решение проблем связанных с работой электронной почты

Модератор: xM

Правила форума
Убедительная просьба юзать теги [code] при оформлении листингов.
Сообщения не оформленные должным образом имеют все шансы быть незамеченными.
Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-22 12:36:50

ошибки в exim
делал настройки по статье описаной тут
вот в логах, в чем проблема?

Код: Выделить всё

aniclog           [----]  0 L:[  7+20  27/ 28] *(9720/10095b)= 2  50 0x32
2008-09-22 12:16:32 1KgGwo-0000C5-QT Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgbnS-0000MW-HT Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgcHi-0000C5-TA Error in system filter: failed to expand "$
2008-09-22 12:16:32 1Kgbzi-0000C5-Ty Error in system filter: failed to expand "$
2008-09-22 12:16:32 1Khdit-0000C5-RV Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgPi8-0001wZ-AA Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgPi8-0001vV-30 Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgcLh-0000IU-U7 Error in system filter: failed to expand "$
2008-09-22 12:16:32 1Kgdlp-0000Jx-6F Error in system filter: failed to expand "$
2008-09-22 12:16:32 1Kgdjr-0000J4-Gj Error in system filter: failed to expand "$
2008-09-22 12:16:32 1Kgdhj-0000I6-QZ Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgmBE-0000nr-9Y Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgmBE-0000mV-5G Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgnK1-0000rx-3H Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgctW-0000C5-St Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgasW-0000C2-Um Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgVAW-0000C5-SM Error in system filter: failed to expand "$
2008-09-22 12:16:32 1Kh8eH-0001vb-2X Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KhV7y-000341-TZ Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KhV7y-00032y-PI Error in system filter: failed to expand "$
2008-09-22 12:16:32 1KgdgO-0000C5-RH Error in system filter: failed to expand "$

1Help   2Save   3Mark   4Replac 5Copy   6Move   7Search 8Delete 9PullDn 10Quit




























mainlog            [----] 374 L:[ 34+47  81/ 83] *(30018/30394b)= .  10 0x0A
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='admin@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='admin@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='admin@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='admin@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@southcoal.ru' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)
e: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: no MySQL servers defined (mysql_servers option)

1Help   2Save   3Mark   4Replac 5Copy   6Move   7Search 8Delete 9PullDn 10Quit

2008-09-22 12:46:32 1KhV7y-000341-TZ Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1KhV7y-00032y-PI Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1Kgdhj-0000I6-QZ Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1KgctW-0000C5-St Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1KgasW-0000C2-Um Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1KgVAW-0000C5-SM Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1Kgdlp-0000Jx-6F Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1KgdUR-0000C5-S5 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1Khdit-0000C5-RV Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1Kgdjr-0000J4-Gj Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 12:46:32 1KgcLh-0000IU-U7 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgFwN-0000C3-O3 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgcLh-0000IU-U7 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgbK3-0000C5-UV Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgdgO-0000C5-RH Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KhV7y-000341-TZ Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KhV7y-00032y-PI Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgHBX-0001YJ-N5 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Kgdjr-0000J4-Gj Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgbnB-0000MT-67 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgcHi-0000C5-TA Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Kgbzi-0000C5-Ty Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgGwo-0000C5-QT Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgdUR-0000C5-S5 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgbnS-0000MW-HT Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Kgdhj-0000I6-QZ Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgmBE-0000nr-9Y Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgmBE-0000mV-5G Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Kgdlp-0000Jx-6F Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgPi8-0001wZ-AA Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgPi8-0001vV-30 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgctW-0000C5-St Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgasW-0000C2-Um Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgVAW-0000C5-SM Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Kh8eG-0001uG-V8 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1KgnK1-0000rx-3H Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Kh8eH-0001vb-2X Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM
2008-09-22 13:16:32 1Khdit-0000C5-RV Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIM



Хостинговая компания Host-Food.ru
Хостинг HostFood.ru
 

Услуги хостинговой компании Host-Food.ru

Хостинг HostFood.ru

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2460 рублей (8 CPU, 8Gb RAM, 2x500Gb HDD, RAID 3ware 9750):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

Аватара пользователя
Alex Keda
стреляли...
Сообщения: 35046
Зарегистрирован: 2004-10-18 14:25:19
Откуда: Made in USSR
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение Alex Keda » 2008-09-22 13:16:48

он в приведённом логе как минимум полсотни раз написал причину...

Код: Выделить всё

no MySQL servers defined (mysql_servers option)
Убей их всех! Бог потом рассортирует...

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-22 13:43:05

lissyara писал(а):он в приведённом логе как минимум полсотни раз написал причину...

Код: Выделить всё

no MySQL servers defined (mysql_servers option)
ну и, где рыть?
mysql работает у меня, и свзяка php+mysql+apache тоже работает

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-22 13:43:29

lissyara писал(а):он в приведённом логе как минимум полсотни раз написал причину...

Код: Выделить всё

no MySQL servers defined (mysql_servers option)
ну и, где рыть?
какие опцие нужны ?
mysql работает у меня, и свзяка php+mysql+apache тоже работает

Аватара пользователя
dikens3
подполковник
Сообщения: 4856
Зарегистрирован: 2006-09-06 16:24:08
Откуда: Нижний Новгород
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение dikens3 » 2008-09-22 14:20:54

Код: Выделить всё

no MySQL servers defined (mysql_servers option)
ну и, где рыть?
mysql_servers соответственно.. (либо собрать exim с поддержкой mysql)
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-22 14:26:12

dikens3 писал(а):

Код: Выделить всё

no MySQL servers defined (mysql_servers option)
ну и, где рыть?
mysql_servers соответственно.. (либо собрать exim с поддержкой mysql)
он у меня и собран exim-mysql

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-22 16:07:54

кто нибудь может помочь?

Аватара пользователя
dikens3
подполковник
Сообщения: 4856
Зарегистрирован: 2006-09-06 16:24:08
Откуда: Нижний Новгород
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение dikens3 » 2008-09-22 20:45:27

опция mysql_servers как выглядит у тебя?

Код: Выделить всё

hide mysql_servers = localhost/exim/exim/exim
???
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-23 8:02:03

dikens3 писал(а):опция mysql_servers как выглядит у тебя?

Код: Выделить всё

hide mysql_servers = localhost/exim/exim/exim
???
такая:

hide mysql_servers = localhost/exim/exim/exim

Аватара пользователя
Alex Keda
стреляли...
Сообщения: 35046
Зарегистрирован: 2004-10-18 14:25:19
Откуда: Made in USSR
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение Alex Keda » 2008-09-23 8:04:55

Код: Выделить всё

mysql -uexim -pexim --database=exim --execute="SHOW TABLES"
что кажет?
Убей их всех! Бог потом рассортирует...

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-23 10:18:01

lissyara писал(а):

Код: Выделить всё

mysql -uexim -pexim --database=exim --execute="SHOW TABLES"
что кажет?
вот

Код: Выделить всё

free# mysql -uexim -pexim --database=exim --execute="SHOW TABLES"
+----------------+
| Tables_in_exim |
+----------------+
| admin          |
| alias          |
| domain         |
| domain_admins  |
| log            |
| mailbox        |
| vacation       |
+----------------+
free#

Аватара пользователя
dikens3
подполковник
Сообщения: 4856
Зарегистрирован: 2006-09-06 16:24:08
Откуда: Нижний Новгород
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение dikens3 » 2008-09-23 10:28:35

Давай определись в чём у тебя проблема, а то логи у тебя про одно (про mysqlserver), а проблема в другом (system_filter).

Про систем-фильтер сразу можно сказать что неправильно кавычки или скобки какие-то стоят в запросе и вследствие этого выдаёт failed to expand "$.

P.S. Даю совет, набери руками всё, а не копируй с сайта.
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-23 11:00:45

dikens3 писал(а):Давай определись в чём у тебя проблема, а то логи у тебя про одно (про mysqlserver), а проблема в другом (system_filter).

Про систем-фильтер сразу можно сказать что неправильно кавычки или скобки какие-то стоят в запросе и вследствие этого выдаёт failed to expand "$.

P.S. Даю совет, набери руками всё, а не копируй с сайта.
так я все и набирал руками, а не копировал
делал по статье http://www.lissyara.su/?id=1175

copy_mail.conf - тут все как в статье
вот мой

Код: Выделить всё

#!/bin/sh

if $recipients is "${lookup mysql{SELECT 'address' FROM 'alias' WHERE \
                    'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}"

then
    unseen deliver mail-copy-mailbox@southcoal.ru
endif


if $sender_address is "${lookup mysql{SELECT 'address' FROM 'alias' WHERE \
                        'address'='$sender_address' AND 'copy_mail'='1' LIMIT 1}}"


then

    unseen deliver mail-copy-mailbox@southcoal.ru

endif


а вот мой configure

Код: Выделить всё

primary_hostname =free.southcoal.local
hide mysql_servers = localhost/exim/exim/exim
domainlist local_domains = ${lookup mysql{SELECT 'domain' \
			    FROM 'domain' WHERE \
			    'domain'='${domain}' AND \
			    'actice'='1'}}
			    
domainlist relay_to_domains =${lookup mysql{SELECT 'domain' \
			    FROM 'domain' WHERE \
			    'domain'='${domain}' AND \
			    'actice'='1'}}
			
hostlist   relay_from_hosts = localhost:127.0.0.0/8:192.168.1.0/16
acl_smtp_rcpt = acl_check_rcpt
acl_smtp_data = acl_check_data
av_scanner = clamd:/var/run/clamav/clamd
qualify_domain =free.southcoal.local
qualify_recipient =free.southcoal.local
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 = 15d
freeze_tell = spirit@southcoal.ru
helo_accept_junk_hosts=192.168.1.0/16
auto_thaw = 1h
smtp_banner = "primary_hostname, ESMTP EXIM $version_number"
smtp_accept_max = 50
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 = 24M
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       = "оЕДПРХУФЙНЩЕ УЙНЧПМЩ Ч БДТЕУЕ"
          domains       = +local_domains
          local_parts   = ^[.] : ^.*[@%!/|]


  deny    message       = "оЕДПРХУФЙНЩЕ УЙНЧПМЩ Ч БДТЕУЕ"
          domains       = !+local_domains
          local_parts   = ^[./|] : ^.*[@%!] : ^.*/\\.\\./

    deny	message		= "HELO/EHLO ПВСЪБОП ВЩФШ РП SMTP RFC" 
		condition	= ${if q{sender_helo_name}{}{yes}{no}}



 accept  authenticated = *


    deny	message		= "оЕ ОБДП РЙИБФШ УЧПК IP Ч ЛБЮЕУФЧЕ HELO!"
		hosts		= *:!+relay_from_hosts
		condition	=${if eq{$sender_helo_name}\
				{$sender_host_address}{true}{false}}

    deny	message		= "ьФП НПК IP-БДТЕУ!рЫЕМ РТПЮШ!"
		hosts		= !127.0.0.1 : !localhost : *
		condition	=${if eq{$sender_helo_name}\
				{$interface_address}{yes}{no}}



    deny	message		= "ч HELO ОЕ НПЗХФ ВЩФШ ФПЛП ГЙЖТЩ"
		hosts		= !127.0.0.1:!localhost:*
		condition	=${if match{$sender_helo_name}\
				{\N^\d+$\N}{yes}{no}}



    deny	message		= "оЕ ОТБЧЙФУС НОЕ чБЫ ИПУФ..."
		condition	=${if match{$sender_helo_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.abuseseat.org : \
				bl.spamcop.net : \
				bl.csma.biz : \
				dynablock.njabl.org : \

    warn
	    set acl_m0 = 20s
	    
    warn
	    hosts = +relay_from_hosts : 80.254.120.230
	    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@doamin.
	    delay = $acl_m0
 
 
 accept domains		=+local_domains
	endpass
	message		="ч ЬФПН ДПНЕОЕ ОЕФ ФБЛПЗП РПМШЪПЧБФЕМС"
	verify		=recipient
 
 accept domains		=+relay_to_domains
	endpass
	message		="нПС УЕТЧЕТБ ОЕ ЪОБФШ НБТЫТХФ ОБ ЬФПФ ИПУФ..."
	verify		=recipient
	
 accept hosts		=+relay_from_hosts
 deny message	=	"уЧПВПДЕО. ьФП ФЕВЕ ОЕ пРЕОтЕМЕК."
 acl_check_data:
    deny malware = *
    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'='${quote_mysql:$local_part@$domain}'}}}{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}@${domain}'}}
    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:$1}' AND 'password' = \
			'${quote_mysql:$2}'}{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:$1}' AND '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:$1}'}{$value}fail}
    server_set_id = $1






Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-23 11:17:58

сейчас ошибка

такая пишется

Код: Выделить всё

2008-09-23 11:47:56 1KgbnS-0000MW-HT Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='spirit@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='spirit@free.southcoal.local' AND 'copy_mail'='1' LIMIT ' at line 1\n
2008-09-23 11:47:56 1KgnK1-0000rx-3H Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1Kh8eG-0001uG-V8 Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1Kh8eH-0001vb-2X Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1Kgdlp-0000Jx-6F Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1KgdgO-0000C5-RH Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1KgctW-0000C5-St Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1KgasW-0000C2-Um Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n
2008-09-23 11:47:56 1KgVAW-0000C5-SM Error in system filter: failed to expand "${lookup mysql{SELECT 'address' FROM 'alias' WHERE 'address'='$recipients' AND 'copy_mail'='1' LIMIT 1}}" in filter file: lookup of "SELECT 'address' FROM 'alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alias' WHERE 'address'='root@free.southcoal.local' AND 'copy_mail'='1' LIMIT 1' at line 1\n



Аватара пользователя
dikens3
подполковник
Сообщения: 4856
Зарегистрирован: 2006-09-06 16:24:08
Откуда: Нижний Новгород
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение dikens3 » 2008-09-23 11:42:16

Не может обработать запрос, ищи неправильные кавычки и т.д. Думай, у меня такого использования нет.
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-23 11:44:49

dikens3 писал(а):Не может обработать запрос, ищи неправильные кавычки и т.д. Думай, у меня такого использования нет.

у меня 5 mysql

Аватара пользователя
dikens3
подполковник
Сообщения: 4856
Зарегистрирован: 2006-09-06 16:24:08
Откуда: Нижний Новгород
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение dikens3 » 2008-09-23 11:46:38

Не mysql виноват (до него даже не доходит дело), синтаксис.
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-23 11:51:46

dikens3 писал(а):Не mysql виноват (до него даже не доходит дело), синтаксис.
и что сделать можно?
я так понел в статье синтаксис для MySQL 4 версии у меня же 5-ой, поэтому видимо есть небольшая разница в синтаксисе
но я в mysql синтаксисе не разбараюсь , может кто может?
конфигу я тут выложил

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-24 13:00:16

кто нибудь может помочь?

Аватара пользователя
Alex Keda
стреляли...
Сообщения: 35046
Зарегистрирован: 2004-10-18 14:25:19
Откуда: Made in USSR
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение Alex Keda » 2008-09-24 13:17:17

да. могу дать ссылку на документацию.
www.mysql.com
========
делать ЗА вас - никто не будет.
вам дали направление куда смотреть. смотрите.
Убей их всех! Бог потом рассортирует...

Sanyh
сержант
Сообщения: 152
Зарегистрирован: 2008-02-13 8:42:54

Re: Ошибки Exim -system filter

Непрочитанное сообщение Sanyh » 2008-09-25 14:25:02

все разобрался, вчера читая книжку о линуксе, вычитал оказывается в юниксе/линуксе бывает 3 вида кавычек и тут меня осенило, что, и я везде вместо ` ставил '
вообщем глупость новичка

Аватара пользователя
Alex Keda
стреляли...
Сообщения: 35046
Зарегистрирован: 2004-10-18 14:25:19
Откуда: Made in USSR
Контактная информация:

Re: Ошибки Exim -system filter

Непрочитанное сообщение Alex Keda » 2008-09-25 15:27:58

да и в винде, их тоже три...
Убей их всех! Бог потом рассортирует...