forum.lissyara.su

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

[b]#cat /var/log/maillog[/b]
Nov  8 08:48:46 da1ver exim[6084]: 2006-11-08 08:48:46 failed to expand "${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}" while checking a list: lookup of "SELECT `domain` FROM `domain` WHERE `domain`='bigmir.net' AND `active`='1'" gave DEFER: MYSQL connection failed: Host 'da1ver.jail' is not allowed to connect to this MySQL server
Nov  8 08:48:46 da1ver exim[6084]: 2006-11-08 08:48:46 failed to expand "${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}" while checking a list: lookup of "SELECT `domain` FROM `domain` WHERE `domain`='bigmir.net' AND `active`='1'" gave DEFER: MYSQL connection failed: Host 'da1ver.jail' is not allowed to connect to this MySQL server
Nov  8 08:48:46 da1ver exim[6084]: 2006-11-08 08:48:46 H=(dr) [217.66.000.00] I=[10.0.0.4]:25 F=<111@111.kiev.ua> temporarily rejected RCPT <111@bigmir.net>: MYSQL connection failed: Host 'da1ver.jail' is not allowed to connect to this MySQL server
Nov  8 08:48:46 da1ver exim[6084]: 2006-11-08 08:48:46 H=(dr) [217.66.000.00] I=[10.0.0.4]:25 F=<111@111.kiev.ua> temporarily rejected RCPT <111@bigmir.net>: MYSQL connection failed: Host 'da1ver.jail' is not allowed to connect to this MySQL server

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

[b]# sockstat[/b]
mysql    mysqld     763   3  tcp4   10.0.0.4:3306         *:*
mysql    mysqld     763   4  stream /tmp/mysql.sock

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

hide mysql_servers = 10.0.0.4/exim/(my_login)/(my_password)
domainlist local_domains = ${lookup mysql{SELECT `domain` \
                            FROM `domain` WHERE \
                            `domain`='${domain}' AND \
                            `active`='1'}}
domainlist relay_to_domains = ${lookup mysql{SELECT `domain` \
                            FROM `domain` WHERE \
                            `domain`='${domain}' AND \
                            `active`='1'}}
hostlist   relay_from_hosts = localhost:127.0.0.0/8:10.0.0.0/16

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

USE mysql;
INSERT INTO `user` (`Host`, `User`, `Password`)
VALUES ('localhost','my_login',password('my_password'));
INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`)
VALUES ('localhost','exim','my_login','Y');
FLUSH PRIVILEGES;
GRANT USAGE ON exim.* TO exim@localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON exim.* TO exim@localhost;
CREATE DATABASE `exim`;
USE `exim`;

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

hide pgsql_servers = (/tmp/.s.PGSQL.5432)/mail/exim/eximpassword

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

ALL: 127.0.0.1/255.0.0.0 : allow