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

[Kevin Bonner]

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

On Thursday 02 September 2004 18:04, 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 use=
r,
> mailbox type Sep  3 01:12:44 gw

This error should tell you everything you need to know.

> auth-mysql-pass-query: SELECT maildir,password,uid FROM users WHERE
> email=3D'$(local_part)@$(domain)'

Your config confirms you're only selecting 3 columns.  Looks like you're=20
missing the mailbox type.  You should be able to change your query to the=20
following:

SELECT maildir,password,uid,'maildir' FROM users WHERE=20
email=3D'$(local_part)@$(domain)'

Kevin Bonner
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBN5u2/9i/ml3OBYMRAmL9AJ9MjgoHGaaKQeKYy9O1ZvjbF7o9EgCfQ5KI
+ZRTdGqpQY3I6oi3Id7HxfA=3D
=3DVKw3
=2D----END PGP SIGNATURE-----