EXIM, sendmail, postfix, Dovecot и прочие. Решение проблем связанных с работой электронной почты
Модератор: xM
Правила форума
Убедительная просьба юзать теги [code] при оформлении листингов.
Сообщения не оформленные должным образом имеют все шансы быть незамеченными.
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
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
Sanyh
-
Хостинг HostFood.ru
-
Хостинг HostFood.ru
Тарифы на хостинг в России, от 12 рублей:
https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.:
https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах:
https://www.host-food.ru/domains/
-
Alex Keda
- стреляли...
- Сообщения: 35477
- Зарегистрирован: 2004-10-18 14:25:19
- Откуда: Made in USSR
-
Контактная информация:
Непрочитанное сообщение
Alex Keda » 2008-09-22 13:16:48
он в приведённом логе как минимум полсотни раз написал причину...
Код: Выделить всё
no MySQL servers defined (mysql_servers option)
Убей их всех! Бог потом рассортирует...
Alex Keda
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-22 13:43:05
lissyara писал(а):он в приведённом логе как минимум полсотни раз написал причину...
Код: Выделить всё
no MySQL servers defined (mysql_servers option)
ну и, где рыть?
mysql работает у меня, и свзяка php+mysql+apache тоже работает
Sanyh
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-22 13:43:29
lissyara писал(а):он в приведённом логе как минимум полсотни раз написал причину...
Код: Выделить всё
no MySQL servers defined (mysql_servers option)
ну и, где рыть?
какие опцие нужны ?
mysql работает у меня, и свзяка php+mysql+apache тоже работает
Sanyh
-
dikens3
- подполковник
- Сообщения: 4856
- Зарегистрирован: 2006-09-06 16:24:08
- Откуда: Нижний Новгород
-
Контактная информация:
Непрочитанное сообщение
dikens3 » 2008-09-22 14:20:54
Код: Выделить всё
no MySQL servers defined (mysql_servers option)
ну и, где рыть?
mysql_servers соответственно.. (либо собрать exim с поддержкой mysql)
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.
dikens3
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-22 14:26:12
dikens3 писал(а):Код: Выделить всё
no MySQL servers defined (mysql_servers option)
ну и, где рыть?
mysql_servers соответственно.. (либо собрать exim с поддержкой mysql)
он у меня и собран exim-mysql
Sanyh
-
dikens3
- подполковник
- Сообщения: 4856
- Зарегистрирован: 2006-09-06 16:24:08
- Откуда: Нижний Новгород
-
Контактная информация:
Непрочитанное сообщение
dikens3 » 2008-09-22 20:45:27
опция mysql_servers как выглядит у тебя?
Код: Выделить всё
hide mysql_servers = localhost/exim/exim/exim
???
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.
dikens3
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-23 8:02:03
dikens3 писал(а):опция mysql_servers как выглядит у тебя?
Код: Выделить всё
hide mysql_servers = localhost/exim/exim/exim
???
такая:
hide mysql_servers = localhost/exim/exim/exim
Sanyh
-
Alex Keda
- стреляли...
- Сообщения: 35477
- Зарегистрирован: 2004-10-18 14:25:19
- Откуда: Made in USSR
-
Контактная информация:
Непрочитанное сообщение
Alex Keda » 2008-09-23 8:04:55
Код: Выделить всё
mysql -uexim -pexim --database=exim --execute="SHOW TABLES"
что кажет?
Убей их всех! Бог потом рассортирует...
Alex Keda
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
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#
Sanyh
-
dikens3
- подполковник
- Сообщения: 4856
- Зарегистрирован: 2006-09-06 16:24:08
- Откуда: Нижний Новгород
-
Контактная информация:
Непрочитанное сообщение
dikens3 » 2008-09-23 10:28:35
Давай определись в чём у тебя проблема, а то логи у тебя про одно (про mysqlserver), а проблема в другом (system_filter).
Про систем-фильтер сразу можно сказать что неправильно кавычки или скобки какие-то стоят в запросе и вследствие этого выдаёт failed to expand "$.
P.S. Даю совет, набери руками всё, а не копируй с сайта.
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.
dikens3
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
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
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
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
Sanyh
-
dikens3
- подполковник
- Сообщения: 4856
- Зарегистрирован: 2006-09-06 16:24:08
- Откуда: Нижний Новгород
-
Контактная информация:
Непрочитанное сообщение
dikens3 » 2008-09-23 11:42:16
Не может обработать запрос, ищи неправильные кавычки и т.д. Думай, у меня такого использования нет.
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.
dikens3
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-23 11:44:49
dikens3 писал(а):Не может обработать запрос, ищи неправильные кавычки и т.д. Думай, у меня такого использования нет.
у меня 5 mysql
Sanyh
-
dikens3
- подполковник
- Сообщения: 4856
- Зарегистрирован: 2006-09-06 16:24:08
- Откуда: Нижний Новгород
-
Контактная информация:
Непрочитанное сообщение
dikens3 » 2008-09-23 11:46:38
Не mysql виноват (до него даже не доходит дело), синтаксис.
Лучше установить FreeBSD, чем потратить 30 лет на Linux'ы и выяснить какой из них хуже.
dikens3
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-23 11:51:46
dikens3 писал(а):Не mysql виноват (до него даже не доходит дело), синтаксис.
и что сделать можно?
я так понел в статье синтаксис для MySQL 4 версии у меня же 5-ой, поэтому видимо есть небольшая разница в синтаксисе
но я в mysql синтаксисе не разбараюсь , может кто может?
конфигу я тут выложил
Sanyh
-
Alex Keda
- стреляли...
- Сообщения: 35477
- Зарегистрирован: 2004-10-18 14:25:19
- Откуда: Made in USSR
-
Контактная информация:
Непрочитанное сообщение
Alex Keda » 2008-09-24 13:17:17
да. могу дать ссылку на документацию.
www.mysql.com
========
делать ЗА вас - никто не будет.
вам дали направление куда смотреть. смотрите.
Убей их всех! Бог потом рассортирует...
Alex Keda
-
Sanyh
- сержант
- Сообщения: 152
- Зарегистрирован: 2008-02-13 8:42:54
Непрочитанное сообщение
Sanyh » 2008-09-25 14:25:02
все разобрался, вчера читая книжку о линуксе, вычитал оказывается в юниксе/линуксе бывает 3 вида кавычек и тут меня осенило, что, и я везде вместо ` ставил '
вообщем глупость новичка
Sanyh
-
Alex Keda
- стреляли...
- Сообщения: 35477
- Зарегистрирован: 2004-10-18 14:25:19
- Откуда: Made in USSR
-
Контактная информация:
Непрочитанное сообщение
Alex Keda » 2008-09-25 15:27:58
да и в винде, их тоже три...
Убей их всех! Бог потом рассортирует...
Alex Keda