Timo Sirainen wrote:
On Thu, 2009-12-31 at 11:18 -0600, Anthony Nedland wrote:
sql(rakka,64.33.164.10): query: SELECT username as user, password, '/var/vmail//rakka' as userdb_home,'maildir:/var/vmail//rakka' as userdb_mail, 150 as userdb_uid, 8 as userdb_gid FROM mailbox WHERE username = 'rakka' AND active = 1 Dec 31 11:06:34 mail dovecot: auth-worker(default): sql(rakka,64.33.164.10): unknown user
Run the SQL query in mysql. Apparently there's no such row with username='rakka' and active=1.
I guess you should be logging in as rakka@domain, not rakka..
I noticed that the statement has /var/vmail//rakka. Is the // ok? I'm not sure what else could be wrong with the SQL part. Postfixadmin should have populated the database right? It said it did on the setup.
I tried with rakka@domain and this is my log on that attempt
Dec 31 11:42:50 mail dovecot: auth(default): new auth connection: pid=5575 Dec 31 11:42:59 mail dovecot: auth(default): client in: AUTH#0111#011PLAIN#011service=pop3#011lip=192.168.1.9#011rip=64.33.164.10#011lport=110#011rport=50836#011resp=AHJha2thIAhAYmFsZHRlbC5jb20AcmFra2E= Dec 31 11:42:59 mail dovecot: auth(default): auth(?,64.33.164.10): Invalid username: rakka ?@baldtel.com Dec 31 11:42:59 mail dovecot: auth(default): plain(?,64.33.164.10): Username contains disallowed character: 0x20 Dec 31 11:43:01 mail dovecot: auth(default): client out: FAIL#0111 Dec 31 11:43:03 mail dovecot: pop3-login: Aborted login (auth failed, 1 attempts): method=PLAIN, rip=64.33.164.10, lip=192.168.1.9
Now that was the output of mail.log. I am having an issue in mail.err also I guess. Here's the most recent output of that.
Dec 31 11:33:29 mail postfix/master[5377]: fatal: /etc/postfix/master.cf: line 82: field "private": bad value: "--n"
And this is the statement on 82.
dovecot unix - n n - - pipe flags=DRhu user=vmail:mail argv=/usr/lib/dovecot/deliver -c /etc/dovecot/dovecot-postfix.conf -f ${sender} -d $(recipient)
--
