[Dovecot] Cant Receive Email from dovecot pop

[Linux Advocate]

A Google result suggested to check the username. Results here ......
but no luck?

A. Telnet results - 1;
.............................

[root at wgw ~]# telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
+OK Dovecot ready.
user fizan at mesara.biz
+OK
pass asdf
-ERR Authentication failed.

B. Output from /var/log/maillog
.......................................

Feb 21 19:42:55 fwgw dovecot: auth(default): new auth connection: pid=3952
Feb 21 19:43:13 fwgw dovecot: auth(default): client in: AUTH    1       PLAIN   service=POP3    secured lip=::ffff:127.0.0.1    rip=::ffff:127.0.0.1     resp=<hidden>
Feb 21 19:43:13 fwgw dovecot: auth-worker(default): sql(fizan at mesara.biz,::ffff:127.0.0.1): query: SELECT password FROM mailbox WHERE username = 'fizan at mesara.biz'
Feb 21 19:43:13 fwgw dovecot: auth-worker(default): sql(izan at mesara.biz,::ffff:127.0.0.1): Password mismatch
Feb 21 19:43:15 fwgw dovecot: auth(default): client out: FAIL   1       user=fizan at mesara.biz

So from "unknown user" ... i have graduated to  "password mismatch"....

So this is definitely a SASL error ? How to solve?



C. /usr/lib/sasl2/smtpd.conf contents
...............................................


pwcheck_method: auxprop
mech_list: PLAIN
auxprop_plugin: sql
sql_verbose: yes
sql_engine: mysql
sql_hostnames: localhost
sql_user: postfix
sql_passwd: kasdf
sql_database: postfix
sql_select: select password from mailbox where username = '%u@%r'


D. /etc/dovecot-mysql.conf
........................................

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=kpostfix
default_pass_scheme = PLAIN
password_query = SELECT password FROM mailbox WHERE username = '%u'
user_query = SELECT maildir, 89 AS uid, 89 AS gid FROM mailbox WHERE username = '%u'


Will keep googling....




> Guys, i am new to dovecot. I am not able to retrieve email from an account that 
> i just setup.
> 
> 
> A. This is the output from /var/log.maillog. 
> ...........................................................
> 
> Feb 21 18:01:31 fwgw dovecot: auth(default): client in: AUTH    1       PLAIN  
> service=POP3    lip=::ffff:60.54.174.146        rip=::ffff:60.50.250.8        
> resp=
> Feb 21 18:01:31 fwgw dovecot: auth-worker(default): mysql: Connected to 
> localhost (postfix)
> Feb 21 18:01:31 fwgw dovecot: auth-worker(default): 
> sql(fizan,::ffff:60.50.250.8): query: SELECT password FROM mailbox WHERE 
> username = 'fizan'
> Feb 21 18:01:31 fwgw dovecot: auth-worker(default): 
> sql(fizan,::ffff:60.50.250.8): unknown user
> Feb 21 18:01:32 fwgw dovecot: auth(default): new auth connection: pid=3567
> Feb 21 18:01:32 fwgw dovecot: auth(default): client out: FAIL   1      
> user=fizan
> Feb 21 18:01:32 fwgw dovecot: pop3-login: Aborted login: user=, 
> method=PLAIN, rip=::ffff:60.50.250.8, lip=::ffff:60.54.174.146
> 
> 
> 
> B. This is my /etc/dovecont.conf
> ............................................
> 
> ## Dovecot configuration file
> 
> protocols = imap pop3
> 
> auth default {
>   userdb sql {
>     args = /etc/dovecot-mysql.conf
>   }
>   passdb sql {
>     args = /etc/dovecot-mysql.conf
>   }
> }
> 
> first_valid_uid = 89
> default_mail_env = maildir:/home/vmail/%d/%n
> 
> # Debugging options
> 
> auth_verbose = yes
> auth_debug = yes
> 
> 
> C. Error Message from the Email Client - Kmail
> ................................................................
> 
> I get a messge saying;
> 
> "Could not Login to mail.mesara.biz. 
> The password may be wrong. 
> The server said authentication failed"
> 
> D. Other info
> .............
> 
> I am running on a Centos 5.2 box , with postfix 2.3,  dovecot 1.0.7, mysql 
> 5.0.45
> 
> 
> Pls help. Much appreciated.
> 
> Regards.
> gomez