[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss]pop3d+Mysql - Mail does not get
From: |
Kevin Bonner |
Subject: |
Re: [tpop3d-discuss]pop3d+Mysql - Mail does not get |
Date: |
Thu, 2 Sep 2004 18:16:18 -0400 |
User-agent: |
KMail/1.6.2 |
-----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-----