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 mechanism )
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([email protected],::ffff:60.50.250.8): query: SELECT password FROM mailbox
WHERE usern ame = '[email protected]'
Feb 21 21:16:23 fwgw dovecot: auth(default): client out: OK 1
[email protected]
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([email protected],::ffff:60.50.250.8): SELECT maildir, 89 AS uid, 89 AS gid
FROM mailb ox WHERE username = '[email protected]'
Feb 21 21:16:23 fwgw dovecot: auth(default): master out: USER 4
[email protected] [email protected]/ uid=89 gid=89
Feb 21 21:16:23 fwgw dovecot: pop3-login: Login: user=<[email protected]>,
method=PLAIN, rip=::ffff:60.50.250.8, lip=::ffff:60.54.174.146
Feb 21 21:16:23 fwgw dovecot: POP3([email protected]): Disconnected: Logged out
top=0/0, retr=0/0, del=0/0, size=0
no more authentication issues.
No idea what the above means though..... " Disconnected "
B. Kmail - No errors
...............................
There are no more authentication error messages.....Kmail just says that there
are no more new messages.
Any ideas?
>
> 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=
> Feb 21 21:16:23 fwgw dovecot: auth-worker(default):
> sql([email protected],::ffff:60.50.250.8): query: SELECT password FROM mailbox
> WHERE usern ame = '[email protected]'
> Feb 21 21:16:23 fwgw dovecot: auth(default): client out: OK 1
> [email protected]
> 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([email protected],::ffff:60.50.250.8): SELECT maildir, 89 AS uid, 89 AS
> gid
> FROM mailb ox WHERE username = '[email protected]'
> Feb 21 21:16:23 fwgw dovecot: auth(default): master out: USER 4
> [email protected] [email protected]/ uid=89 gid=89
> Feb 21 21:16:23 fwgw dovecot: pop3-login: Login: user=,
> method=PLAIN, rip=::ffff:60.50.250.8, lip=::ffff:60.54.174.146
> Feb 21 21:16:23 fwgw dovecot: POP3([email protected]): 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;
> > .............................
> >
> > [r...@wgw ~]# telnet localhost 110
> > Trying 127.0.0.1...
> > Connected to localhost.localdomain (127.0.0.1).
> > Escape character is '^]'.
> > +OK Dovecot ready.
> > user [email protected]
> > +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([email protected],::ffff:127.0.0.1): query: SELECT password FROM mailbox
> > WHERE username = '[email protected]'
> > Feb 21 19:43:13 fwgw dovecot: auth-worker(default):
> > sql([email protected],::ffff:127.0.0.1): Password mismatch
> > Feb 21 19:43:15 fwgw dovecot: auth(default): client out: FAIL 1
> > [email protected]
> >
> > 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 = '%...@%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
