[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] [tpop3d] invallid mysql-popper.conf?
From: |
Kevin Bonner |
Subject: |
Re: [tpop3d-discuss] [tpop3d] invallid mysql-popper.conf? |
Date: |
Mon, 14 Jul 2003 22:52:47 -0400 |
User-agent: |
KMail/1.5.1 |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Monday 14 July 2003 22:24, Dan Clark wrote:
> I have tried that, my appolagies, I seem to have posted to the incorrect
> mailing list, however now that I have you on the phone (so to speak) could
> you assist with my config if I go back to tpop3d?
I'll try my best. =)
> exim puts mail in /var/mail/domain.com/username
> 'tpop3d' doesn't seem to pick up mail from there, instead it uses another
> folder.
- From your email earlier this month, here's part of the config you posted:
mailbox: bsd:/var/mail/$(user)
auth-mysql-enable: yes
The auth-mysql mechanism doesn't use the mailbox config option since it
queries the database for the proper path. Here's the query from the manpage:
auth-mysql-pass-query: \
SELECT CONCAT('/path/to/', '$(domain)', \
'/', '$(local_part)'), \
CONCAT('{crypt}, cryptpw), \
'mail', 'maildir' \
FROM users \
WHERE login = '$(local_part)' \
AND domain = '$(domain)'
So...this query returns the path, password, username to run as, and the
mailbox type. Just connect to your sql server via the mysql client and
create a query to return this information based on your current schema.
If you don't have auth-mysql-pass-query set (or disabled) in your config,
there is a default query used. You can see this query by looking for the
variable named user_pass_query_template in auth_mysql.c.
Kevin Bonner
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE/E2x//9i/ml3OBYMRAmQXAKCbNXeM6VtM9SwaKudo3DRj3E/wGgCgiLvf
vzhCb2iLIE3MkkQnYewNlkM=
=woS9
-----END PGP SIGNATURE-----