[Dovecot] Cant Receive Email from dovecot pop

[Linux Advocate]

Aha.. some progress at least. i solved the "password mismatch" errror. In postfixadmin config, i had accidentally set the passwd type to md5crypt instead of cleartext ( i am using the plain mechnasim )


BUT....

A. Still can't retrieve mail..... the mailliog shows.....
...................................................................

Feb 21 21:16:23 fwgw dovecot: auth(default): client in: AUTH    1       PLAIN   service=POP3    lip=::ffff:60.54.174.146        rip=::ffff:60.50.250.8   resp=<hidden>
Feb 21 21:16:23 fwgw dovecot: auth-worker(default): sql(fizan at mesara.biz,::ffff:60.50.250.8): query: SELECT password FROM mailbox WHERE usern       ame = 'fizan at mesara.biz'
Feb 21 21:16:23 fwgw dovecot: auth(default): client out: OK     1       user=fizan at mesara.biz
Feb 21 21:16:23 fwgw dovecot: auth(default): master in: REQUEST 4       4763    1
Feb 21 21:16:23 fwgw dovecot: auth-worker(default): sql(fizan at mesara.biz,::ffff:60.50.250.8): SELECT maildir, 89 AS uid, 89 AS gid FROM mailb       ox WHERE username = 'fizan at mesara.biz'
Feb 21 21:16:23 fwgw dovecot: auth(default): master out: USER   4       fizan at meswara.biz    maildir=haifizan at meswara.biz/   uid=89  gid=89
Feb 21 21:16:23 fwgw dovecot: pop3-login: Login: user=<fizan at mesara.biz>, method=PLAIN, rip=::ffff:60.50.250.8, lip=::ffff:60.54.174.146
Feb 21 21:16:23 fwgw dovecot: POP3(fizan at mesara.biz): Disconnected: Logged out top=0/0, retr=0/0, del=0/0, size=0


No idea what the above means though.....

B. Kmail - No errors
...............................

There are no more authentication error messages.....Kmail just says that there are no more new messages.


Any ideas?




> 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=
> 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