Dotaz: Dovecot ma problem

[ziki18]

Ahojte, davam dokopy?. Postupoval som podla navodu ktory je na abclinux.cz.

# 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'

po restarte dovecotu

# 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

A tam je probelem...

A nebezi...

# 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

Odpovědi

[ext3fs]

Funguji ty sql dotazy kdyz je zadas rucne?

Jsou OK prava na /var/run/mysqld/mysqld.sock pro dovecot?

[ziki18]

Ahoj prava mam defaul na :

srwxrwxrwx 1 mysql mysql    0 2010-09-29 07:29 mysqld.sock

O tej databaze :

# mysql -u dovecot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 135
Server version: 5.0.51a-24+lenny4 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mailhosting        |
| mysql              |
+--------------------+
3 rows in set (0.00 sec)

mysql>

[ziki18]

Sep 29 11:11:07 server postfix/proxymap[8880]: fatal: /etc/postfix/mysql/virtual.cf, line 6: missing '=' after attribute name: "FROM Mailboxes NATURAL JOIN Domains"
Sep 29 11:11:08 server postfix/master[8612]: warning: process /usr/lib/postfix/proxymap pid 8880 exit status 1
Sep 29 11:11:08 server postfix/master[8612]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling
Sep 29 11:11:08 server postfix/smtpd[8718]: warning: private/proxymap socket: service dict_proxy_open: Success

[Alf]

U password_query odtabujte ty dva řádky pod tím (FROM a WHERE).

[ziki18]

Dakujem. Ked budes v TT zastav sa na pivo.. Cele rano sa tym trapim :DD

[Alf]

Není zač ;)