[trouble] exim+dovecot
Добавлено: 2008-07-19 8:53:03
Решил, наконец таки перейти на exim (чтобы не утруждать свой мозг - зря, надо было утруждать, делал по-статье: http://www.lissyara.su/?id=1173), с CommuniGate, всё настроил верно, но есть ошибка, которая всё запарывает:
с правами и грантами всё ок:
делал также и:
не помогает, конфиг dovecot-sql-conf:
Заводил юзера exim, и через insert и через grant и так и сяк, ошибка не исчезает, сначала предположил, что проблема в mysql51, перешел на mysql41, не помогло. Подскажите, где еще может быть, косяк? (К утру плохо соображаю).
Код: Выделить всё
2008-07-19 08:17:08 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`='zingel.dubki.ru' AND `active`='1'" gave DEFER: MYSQL connection failed: Access denied for user 'exim'@'localhost' (using password: YES)
2008-07-19 08:17:08 H=(wa-out-1112.google.com) [209.85.146.177] I=[192.168.0.189]:25 F=<666.root@gmail.com> temporarily rejected RCPT <admin@zingel.dubki.ru>: MYSQL connection failed: Access denied for user 'exim'@'localhost' (using password: YES)Код: Выделить всё
[root@zingel /]# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select Process_priv, Grant_priv,Select_priv,Insert_priv, Delete_priv, Update_priv, Drop_priv, Alter_priv, Super_priv from user where user='exim';
+--------------+------------+-------------+-------------+-------------+-------------+-----------+------------+------------+
| Process_priv | Grant_priv | Select_priv | Insert_priv | Delete_priv | Update_priv | Drop_priv | Alter_priv | Super_priv |
+--------------+------------+-------------+-------------+-------------+-------------+-----------+------------+------------+
| Y | Y | Y | Y | Y | Y | Y | Y | Y |
+--------------+------------+-------------+-------------+-------------+-------------+-----------+------------+------------+
1 row in set (0.00 sec)
mysql> quit;
Bye
[root@zingel /]# mysql -uexim -pxxxxxx exim
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit
ByeКод: Выделить всё
mysql> show grants;
+---------------------------------------------------------------------------------------------------------------+
| Grants for exim@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'exim'@'localhost' IDENTIFIED BY PASSWORD '1e7935fa5cc6ca8a' WITH GRANT OPTION |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `exim`.* TO 'exim'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> show variables like '%version%';
+-------------------------+-------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-------------------------------------------------------------+
| protocol_version | 10 |
| version | 4.1.22 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (November 3, 2006) |
| version_comment | FreeBSD port: mysql-server-4.1.22 |
| version_compile_machine | i386 |
| version_compile_os | portbld-freebsd7.0 |
+-------------------------+-------------------------------------------------------------+
6 rows in set (0.00 sec)
Код: Выделить всё
mysql> SET PASSWORD FOR 'exim'@'localhost' = OLD_PASSWORD('password');
Код: Выделить всё
connect = host=/tmp/mysql.sock dbname=exim user=exim password=password
...