Administrace komentářů

# cat /etc/dovecot/mysql.conf
#default_pass_scheme = PLAIN
default_pass_scheme = CRAM-MD5
driver = mysql
connect = host=/var/run/mysqld/mysqld.sock dbname=mailhosting user=dovecot password=blabla

password_query = SELECT mb_password AS password, '%u' AS user \
FROM Mailboxes NATURAL JOIN Domains \
WHERE mb_enabled=1 AND dom_enabled=1 AND mb_user='%n' AND dom_name='%d'


user_query = SELECT 114 AS uid, 112 AS gid, '/var/mail/virtual/%d/%n' AS home \
        FROM Mailboxes NATURAL JOIN Domains \
        WHERE mb_enabled=1 AND dom_enabled=1 AND mb_user='%n' AND dom_name='%d'

# tail /var/log/mail.err
Sep 29 10:16:48 server dovecot: Auth process died too early - shutting down
Sep 29 10:26:27 server dovecot: auth(default): Error in configuration file /etc/dovecot/mysql.conf line 7: Expecting '='
Sep 29 10:26:27 server dovecot: child 8519 (auth) returned error 89
Sep 29 10:26:27 server dovecot: Auth process died too early - shutting down
Sep 29 10:27:59 server dovecot: auth(default): Error in configuration file /etc/dovecot/mysql.conf line 7: Expecting '='
Sep 29 10:27:59 server dovecot: child 8633 (auth) returned error 89
Sep 29 10:27:59 server dovecot: Auth process died too early - shutting down
Sep 29 10:28:15 server dovecot: auth(default): Error in configuration file /etc/dovecot/mysql.conf line 7: Expecting '='
Sep 29 10:28:15 server dovecot: child 8659 (auth) returned error 89
Sep 29 10:28:15 server dovecot: Auth process died too early - shutting down

# netstat -tapn
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      6154/mysqld
tcp        0      0 0.0.0.0:51983           0.0.0.0:*               LISTEN      1861/rpc.statd
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1850/portmap
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      2104/sshd
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      8612/master
tcp        0      0 192.168.1.2:22          blabla                  ESTABLISHED 7375/1
tcp        0    248 192.168.1.2:22          blabla                  ESTABLISHED 6533/sshd: administ
tcp6       0      0 :::80                   :::*                    LISTEN      8280/apache2
tcp6       0      0 :::22                   :::*                    LISTEN      2104/sshd