OpenForum RSS: Postfix+Dovecot+Mysql ��

Postfix+Dovecot+Mysql �� (skvernobot)

Tue, 12 Apr 2016 09:16:17 GMT

>[�� ]
>
> |
> +-------------------------------------------------------------------------------------------------------------+
> 2 rows in set (0.00 sec)
> �� dovecot, �� :
> auth-worker(6354): Error: mysql(/var/run/mysqld/mysqld.sock): Connect failed to database
> (mail): Access denied for user 'mail'@'localhost' (using password: YES) - waiting
> for 25 seconds before retry
> ��, �� , ��
> �� :(

http://vladimir-stupin.blogspot.ru/2009/11/postfix-dovecot-postfixadmin.html

Postfix+Dovecot+Mysql �� (�� )

Mon, 11 Apr 2016 19:00:18 GMT

> (mail): Access denied for user 'mail'@'localhost' (using password: YES) - waiting

��

http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw

Postfix+Dovecot+Mysql �� (Dimon2016)

Mon, 11 Apr 2016 16:57:03 GMT

>[�� ]
> virtual_gid_maps = static:1981
> virtual_uid_maps = static:1981
> virtual_mailbox_base = /var/mail
> virtual_transport = dovecot
> $ cat /etc/dovecot/dovecot.conf
> mail_location = maildir:/var/mail/%u
> mail_privileged_group = virtual
> first_valid_uid = 1981
> last_valid_uid = 1981
> first_valid_gid = 1981

��, �� , �� dovecot-sql.conf �� :

driver = mysql
connect = host=/var/run/mysqld/mysqld.sock dbname=mail user=mail password='kasu8dsWsi8df2'
default_pass_scheme = MD5
password_query = SELECT `username` AS `user`, `password` FROM `mailbox` WHERE `username` = '%u' AND active = '1'
user_query = SELECT CONCAT('/home/vmail/', `maildir`) AS `home`, 150 AS uid, 8 AS gid, concat('*:bytes=', quota) as quota_rule FROM `mailbox` WHERE `username` = '%u' AND `active` = '1'

�� mail ��:

mysql> show grants for mail@localhost;
+-------------------------------------------

Postfix+Dovecot+Mysql �� (skvernobot)

Mon, 11 Apr 2016 16:14:24 GMT

>[�� ]
> quota_full_tempfail = yes
> rejection_reason = Your message to <%t> was automatically rejected:%n%r
> }
> �� dovecot-sql.conf:
> driver = mysql
> connect = host=localhost dbname=mail user=mail password='password'
> default_pass_scheme = PLAIN-MD5
> password_query = SELECT email AS user, password FROM users WHERE email =
> '%u';
> �� , �� .

driver = mysql
connect = host=/var/run/mysqld/mysqld.sock dbname=postfix user=postfix password=*****
default_pass_scheme = MD5
user_query = SELECT CONCAT('/var/spool/mail/', `maildir`) AS `home`, 1981 AS uid, 1981 AS gid, concat('*:bytes=', quota) as quota_rule FROM `mailbox` WHERE `username` = '%u' AND `active` = '1'
password_query = SELECT username as user, password FROM mailbox WHERE username = '%u' and active='1'

�� dovecot-sql.conf

�� 1981:
cat /etc/passwd | grep 1981
virtual:x:1981:19

Postfix+Dovecot+Mysql �� (�� )

Mon, 11 Apr 2016 15:29:02 GMT

> ��

�� user_query, �� password_query

�� , �� .

>> �� mail �� mail: mysql -u mail -p password.

�� , �� ݣ ��

OpenForum RSS: Postfix+Dovecot+Mysql ��������������

Postfix+Dovecot+Mysql �������������� (skvernobot)

Postfix+Dovecot+Mysql �������������� (������� ����������)

Postfix+Dovecot+Mysql �������������� (Dimon2016)

Postfix+Dovecot+Mysql �������������� (skvernobot)

Postfix+Dovecot+Mysql �������������� (������� �������)

OpenForum RSS: Postfix+Dovecot+Mysql ��

Postfix+Dovecot+Mysql �� (skvernobot)

Postfix+Dovecot+Mysql �� (�� )

Postfix+Dovecot+Mysql �� (Dimon2016)

Postfix+Dovecot+Mysql �� (skvernobot)

Postfix+Dovecot+Mysql �� (�� )