[tpop3d-discuss] Authentication Failed

[Lane Vance]

I have been wrestling with tpop3d for the past day or two and have read
and re-read the archived list but I can't find an answer to my problem.
Any help or advise is greatly welcomed!  The one thing that strikes me
as odd is the "bsd" that is returned from the MySQL query.  Is this a
reference to tpop3d trying to use the bsd style spool?  I am using the
Maildir format as I would like to get Courier IMAP working as well.
Also, I have installed vmail and used the scripts to add the domain and
popbox to the database.

Downloaded latest from CVS and built it with the following command.  Had
to get the CVS because of the same problem reported on the list about
having installed MySQL from RPMs and the libs and include files in
different directories:

./configure --enable-auth-mysql --enable-mbox-maildir --disable-auth-pam
--with-mysql-lib-dir=/usr/lib
--with-mysql-include-dir=/usr/include/mysql

Everything installed without error.  I copied the tpop3d.conf file to
/usr/local/etc/tpop3d.conf and started tpop3d without error:

Apr  3 11:10:02 incognito tpop3d[3337]: listener_new:
gethostbyaddr(0.0.0.0): cannot resolve name
Apr  3 11:10:02 incognito tpop3d[3337]: listener_new: 0.0.0.0:110:
cannot obtain domain suffix for this address
Apr  3 11:10:02 incognito tpop3d[3337]: listener_new: 0.0.0.0:110: using
fallback domain suffix `incognito.su-root.com'
Apr  3 11:10:02 incognito tpop3d[3337]: parse_listeners: listening on
address 0.0.0.0:110
Apr  3 11:10:02 incognito tpop3d[3337]: 1 authentication drivers
successfully loaded
Apr  3 11:10:02 incognito tpop3d[3337]: net_loop: tpop3d version
1.5.1pre2 successfully started

However, when I try to pop I get authentication failed errors:

# telnet localhost 110
Trying 127.0.0.1...
listeners_post_select: client [6]127.0.0.1/incognito.su-root.com:
connected to local address 127.0.0.1:110
Connected to localhost.
Escape character is '^]'.
+OK <5a1c913ff17d2f5e09a5233970106ae8@incognito.su-root.com>
user lane@heave.info
+OK Tell me your password.
pass password
auth_mysql_new_user_pass: [lane@heave.info; lane@heave.info] failed
login with wrong password
connection_do: client `[6]127.0.0.1/incognito.su-root.com': username
`lane@heave.info': 1 authentication failures
-ERR Lies! Try again!
quit
connections_post_select: client [6]127.0.0.1/incognito.su-root.com:
disconnected; 42/137 bytes read/written
+OK Fine. Be that way.
Connection closed by foreign host.

Syslog shows the following:

Apr  3 11:27:05 incognito tpop3d[3337]: listeners_post_select: client
[6]127.0.0.1/incognito.su-root.com: connected to local address
127.0.0.1:110
Apr  3 11:27:15 incognito tpop3d[3337]: auth_mysql_new_user_pass:
[lane@heave.info; lane@heave.info] failed login with wrong password
Apr  3 11:27:15 incognito tpop3d[3337]: connection_do: client
`[6]127.0.0.1/incognito.su-root.com': username `lane@heave.info': 1
authentication failures
Apr  3 11:27:20 incognito tpop3d[3337]: connections_post_select: client
[6]127.0.0.1/incognito.su-root.com: disconnected; 42/137 bytes
read/written

and my MySQL log shows the following query run:

030403 11:27:15      13 Query       SELECT concat(domain.path, '/',
popbox.mbox_name), popbox.password_hash, domain.unix_user, 'bsd' FROM
popbox, domain WHERE popbox.local_part = 'lane' AND popbox.domain_name =
'heave.info' AND popbox.domain_name = domain.domain_name

When I run the query straight from MySQL I get the following 4 fields
returned:

/var/spool/mail/domains/heave.info/lane
{crypt}xJyC6nhSJSHIk
heaveinf
bsd

The following is my tpop3d.conf file:

#
# tpop3d.conf: example config file for tpop3d
#

listen-address: 0.0.0.0:110

log-facility: local0

no-detach: yes

log-stderr: yes

max-children:           16

maildir-exclusive-lock: yes

mailbox:
maildir:/var/spool/mail/domains/$(domain)/$(localpart)

strip-domain: yes

auth-mysql-enable:      yes
auth-mysql-database:    dbname
auth-mysql-username:    username
auth-mysql-password:    password




Thanks in advance!!
-Lane