[tpop3d-discuss] auth_mysql trouble

[Chris Lightfoot]

On Wed, Dec 19, 2001 at 03:39:13PM +0300, Dmitry Nemtchinov wrote:
> 
> > -----Original Message-----
> > From: Chris Lightfoot [mailto:chris@ex-parrot.com]
> > Sent: Wednesday, December 19, 2001 3:16 PM
> > >
> > > 	I am using "dmitry.nemtchinov" as login and, for
> > example "dnlogin" as
> > > password.
> > >
> > > 	I can give you an answer for a query, that was in my
> > tpop3d.conf file from
> > > MySQL. It's a result of typing this query in mysql shell:
> > >
> > > mysql> SELECT
> > >
> > '','/var/mail/$(localpart)',CONCAT('{plaintext}',user.Password
> > ),user.User
> > > FROM user WHERE user.User='dmitry.nemtchinov';
> >
> > Ah. Are you trying to use this in a virtual domains
> > setting?
> 
> No. I don't want to use virual domains. I have to made logins consistinng
> of two parts, name and surname, like 'dmitry.nemtchinov' in my case. I want
> to use only one domain. For example 'nival.com'. But there are no domains
> defined in my tpop3d.conf.

OK. The best idea is probably to assign a domain to the
listening address and switch on append-domain. This will
make tpop3d try the authentication with
`dmitry.nemtchinov@some.domain', which means that
auth-mysql will actually have a go at authenticating that
way. The SQL statement need not actually reference the
domain.

Since you're not using virtual domains, it might be easier
just to use Unix user authentication. Or you could write a
perl authenticator to do what you want.

-- 
 ``If one is sailing on the Titanic, it is best to live in a lifeboat.''
 (Danish minister, on exchange-rate policy)