[tpop3d-discuss] [tpop3d] invallid mysql-popper.conf?

[Kevin Bonner]

=2D----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.  =3D)

> exim puts mail in /var/mail/domain.com/username
> 'tpop3d' doesn't seem to pick up mail from there, instead it uses another
> folder.

=2D From your email earlier this month, here's part of the config you poste=
d:
mailbox: bsd:/var/mail/$(user)
auth-mysql-enable: yes

The auth-mysql mechanism doesn't use the mailbox config option since it=20
queries the database for the proper path.  Here's the query from the manpag=
e:

auth-mysql-pass-query: \
	SELECT CONCAT('/path/to/', '$(domain)', \
			'/', '$(local_part)'), \
		CONCAT('{crypt}, cryptpw), \
		'mail', 'maildir' \
  	FROM users \
	WHERE login =3D '$(local_part)' \
	AND domain =3D '$(domain)'

So...this query returns the path, password, username to run as, and the=20
mailbox type.  Just connect  to your sql server via the mysql client and=20
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,=20
there is a default query used.  You can see this query by looking for the=20
variable named user_pass_query_template in auth_mysql.c.

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

iD8DBQE/E2x//9i/ml3OBYMRAmQXAKCbNXeM6VtM9SwaKudo3DRj3E/wGgCgiLvf
vzhCb2iLIE3MkkQnYewNlkM=3D
=3DwoS9
=2D----END PGP SIGNATURE-----