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

[Kevin Bonner]

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

On Thursday 02 September 2004 18:04, 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

This error should tell you everything you need to know.

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

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

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

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

iD8DBQFBN5u2/9i/ml3OBYMRAmL9AJ9MjgoHGaaKQeKYy9O1ZvjbF7o9EgCfQ5KI
+ZRTdGqpQY3I6oi3Id7HxfA=
=VKw3
-----END PGP SIGNATURE-----