Добрый вечер!

 Консоль:
cat /var/log/mailog.log

 Консоль:
Aug 11 08:36:09 mx dovecot: Dovecot v1.2.17 starting up (core dumps disabled)
Aug 11 08:36:10 mx dovecot: auth-worker(default): mysql: Connected to localhost (mail)
Aug 11 08:36:10 mx postgrey[2383]: Process Backgrounded
Aug 11 08:36:10 mx postgrey[2383]: 2011/08/11-08:36:10 postgrey (type Net::Server::Multiplex) starting! pid(2383)
Aug 11 08:36:10 mx postgrey[2383]: Using default listen value of 128
Aug 11 08:36:10 mx postgrey[2383]: Binding to UNIX socket file /var/spool/postfix/postgrey/socket using SOCK_STREAM 
Aug 11 08:36:10 mx postgrey[2383]: Setting gid to "104 104"
Aug 11 08:36:10 mx postgrey[2383]: Setting uid to "103"
Aug 11 08:36:11 mx dovecot: auth(default): new auth connection: pid=2424
Aug 11 08:36:11 mx dovecot: auth(default): new auth connection: pid=2423
Aug 11 08:36:11 mx dovecot: auth(default): new auth connection: pid=2425
Aug 11 08:36:11 mx dovecot: auth(default): new auth connection: pid=2426
Aug 11 08:36:11 mx dovecot: auth(default): new auth connection: pid=2431
Aug 11 08:36:11 mx dovecot: auth(default): new auth connection: pid=2432
Aug 11 08:36:11 mx postfix/postfix-script[2470]: starting the Postfix mail system
Aug 11 08:36:11 mx postfix/master[2471]: daemon started -- version 2.8.4, configuration /etc/postfix
Aug 11 08:36:54 mx dovecot: auth(default): client in: AUTH    1    PLAIN    service=pop3    secured    lip=10.168.50.42    rip=10.168.50.42    lport=110    rport=43119    resp=AGFkbWluQHBvaW50LmxvY2FsADFRMnczZTRy
Aug 11 08:36:54 mx dovecot: auth-worker(default): sql(admin@point.local,10.168.50.42): query: SELECT username as user, password, '/var/vmail/point.local/admin' asuserdb_home, 'maildir:/var/vmail/point.local/admin' as userdb_mail, 1151 as \ userdb_uid, 12 asuserdb_gid FROM mailbox WHERE username = 'admin@point.local' AND active = '1'
Aug 11 08:36:54 mx dovecot: auth-worker(default): sql(admin@point.local,10.168.50.42): Password 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 '\ userdb_uid, 12 asuserdb_gid FROM mailbox WHERE username = 'admin@point.local' ' at line 1
Aug 11 08:36:55 mx dovecot: auth(default): new auth connection: pid=3361
Aug 11 08:36:56 mx dovecot: auth(default): client out: FAIL    1    user=admin@point.local    temp

Сам dovecot-sql.conf

 Консоль:
cat /etc/dovecot-sql.conf

 Консоль:
driver = mysql
connect = host=localhost dbname=mail user=postfix password=password
default_pass_scheme = MD5
user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'as mail, 1151 AS uid, 12 AS gid, concat('dirsize:storage=', quota) AS quota \ FROMmailbox WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, '/var/vmail/%d/%n' asuserdb_home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 1151 as \ userdb_uid, 12 asuserdb_gid FROM mailbox WHERE username = '%u' AND active = '1'

Не подскажите как подправить dovecot-sql.conf чтобы он нормально работал с базой MySQL

2

Первый запрос проходит  -

user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n'as mail, 1151 AS uid, 12 AS gid, concat('dirsize:storage=', quota) AS quota \ FROMmailbox WHERE username = '%u' AND active = '1'

А второй запрос, не проходит -

password_query = SELECT username as user, password, '/var/vmail/%d/%n' asuserdb_home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 1151 as \ userdb_uid, 12 asuserdb_gid FROM mailbox WHERE username = '%u' AND active = '1'

3

Насколько я помню, dovecot очень плохо воспринимает переносы строк в конфиге. Попробуйте строку с запросом SQL не разбивать, а просто в одну строку запрос писать, без \

4

Что-то не заработало. Убирал знак \