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

[Dan Clark]

ah that answers my other question of why that mailbox: line seems  to do
nothing, so I removed it :)
ok I will try the default query and let you know :)
thanks awfully


----- Original Message ----- 
From: "Kevin Bonner" <keb@pa.net>
To: "Dan Clark" <dan@scarfies.net>
Cc: <tpop3d-discuss@lists.beasts.org>
Sent: Tuesday, July 15, 2003 2:52 PM
Subject: Re: [tpop3d-discuss] [tpop3d] invallid mysql-popper.conf?


> -----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-----
>
>
>