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

[Kevin Bonner]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 02 September 2004 18:51, gladko@inbox.ru 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=3D'$(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=3D'$(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 use=
r,
> mailbox type Sep  3 02:25:59 gw tpop3d[20428]: connection_do: client
> `[6]192.168.11.4/gw.domain1.ru': username `kropov@domain1.ru': 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=3D'kropov@domain1.ru'

The default password hash type is md5.  Since you have cleartext passwords =
in=20
your MySQL db, you'll need to append the string '{plaintext}' to it.  You c=
an=20
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 ext=
ra=20
maildir column from your config.  Make sure you restart tpop3d (or run it i=
n=20
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,=
=20
please hit Reply All to send to the tpop3d mailing list.
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBN8K3/9i/ml3OBYMRAkX1AJ98uPLZhKDf6raMZueo9euZ1bsidgCeIBmn
v8OxykAn8kY3wZj3dXea/to=3D
=3D49RK
=2D----END PGP SIGNATURE-----