Re: Re[2]: [tpop3d-discuss]pop3d+Mysql - Mail does not get

[Kevin Bonner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 02 September 2004 18:51, address@hidden wrote:
> >> error:
> >> Sep  3 01:12:44 gw tpop3d[20428]: auth_mysql_new_user_pass: 3 fields
> >> returned by query, should be 4: mailbox location, password hash, unix
> >> user, mailbox type Sep  3 01:12:44 gw
>
> KB> This error should tell you everything you need to know.
>
> Sorry but I cannot understand, that is necessary.
> I so understand tpop3d searches
> 1) Passwords in hash, but at me in db they in plain text.
> 2) Unix users in /etc/passwd, but at me they there no.
> All users are only in db
>
> KB> Your config confirms you're only selecting 3 columns.  Looks like
> you're KB> missing the mailbox type.  You should be able to change your
> query to the KB> following:
> KB> SELECT maildir,password,uid,'maildir' FROM users WHERE
> email='$(local_part)@$(domain)'
>
>
> I have made as you have advised
> Change of select, has not helped.
> Only messages in warnings have disappeared
>
>
> listen-address: 0.0.0.0
> max-children: 5
> timeout-seconds: 600
> mailbox: maildir:/var/spool/vmail/$(domain)/$(user)/Maildir
> auth-mysql-enable: yes
> auth-mysql-mail-group: mail
> auth-mysql-hostname: localhost
> auth-mysql-database: mail
> auth-mysql-username: postfix
> auth-mysql-password: ......
> auth-mysql-pass-query: SELECT maildir,password,uid,'maildir' FROM users
> WHERE email='$(local_part)@$(domain)'
>
>
> Mail
>
> error
> Sep  3 02:25:59 gw tpop3d[20428]: auth_mysql_new_user_pass: 3 fields
> returned by query, should be 4: mailbox location, password hash, unix user,
> mailbox type Sep  3 02:25:59 gw tpop3d[20428]: connection_do: client
> `[6]192.168.11.4/gw.domain1.ru': username address@hidden': 1
> authentication failures
>
> info
> Sep  3 02:25:56 gw tpop3d[20428]: listeners_post_select: client
> [6]192.168.11.4/gw.domain1.ru: connected to local address 192.168.11.1:110
> Sep  3 02:26:02 gw tpop3d[20428]: ioabs_tcp_post_select: client
> [6]192.168.11.4/gw.domain1.ru: connection closed by peer Sep  3 02:26:02 gw
> tpop3d[20428]: connections_post_select: client
> [6]192.168.11.4/gw.domain1.ru: disconnected; 36/107 bytes read/written
>
> warnings
>
> MySQL
> 040903 2:25:59 8992 Query  SELECT maildir,password,uid FROM users WHERE
> email='address@hidden'

The default password hash type is md5.  Since you have cleartext passwords in 
your MySQL db, you'll need to append the string '{plaintext}' to it.  You can 
do this by using
 CONCAT('{plaintext}',password)
in your query instead of just the password field.

As for the auth failures, it looks like the query still isn't using the extra 
maildir column from your config.  Make sure you restart tpop3d (or run it in 
debug mode) after you make changes to the tpop3d.conf file.

Kevin Bonner

P.S.  I'm leaving tonight for vacation, so if you want a quicker response, 
please hit Reply All to send to the tpop3d mailing list.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBN8K3/9i/ml3OBYMRAkX1AJ98uPLZhKDf6raMZueo9euZ1bsidgCeIBmn
v8OxykAn8kY3wZj3dXea/to=
=49RK
-----END PGP SIGNATURE-----