Re: [Exim] MySQL config

Page principale
Supprimer ce message
Répondre à ce message
Auteur: James Harr
Date:  
À: Clive Goodhead
CC: exim-users
Sujet: Re: [Exim] MySQL config
Hi,

I've decided to go with a plain jane clear field. We do it at work and it
goes fine (although we use mssql [gag]). So I think I should be safe. As far
as that md5 stuff, I was talking like on the backend. Sort of like encrypt
it once it gets here. When I looked at CRAM (Challenge/Response Auth
Method), I realized "Oh yeah, that's a protocol deal, not backend."

Clear would work for me, if I were to do md5 in the database, I'd have to
get courier-imap (more specifically authmysql) to work with it.

Right now I have my computer set up to grab imap email from my old server
and my new one. The old one running wu-imapd. The funny thing is that
courier runs really fast with all my messages in that, but wu-imap (with no
messages) runs like a dog. Same sync settings too :)

Funny eh?

Thanks everyone, especially the exim-dev team, for the help...

Later,
James Harr
----- Original Message -----
From: "Clive Goodhead" <clive@???>
To: "James Harr" <james@???>
Cc: <exim-users@???>
Sent: Thursday, July 18, 2002 3:42 AM
Subject: Re: [Exim] MySQL config


>
>
> > Got that going,
> >
> > is there anyway I could get this to use md5 encryption on passwords? I'm
> > guessing it would be a pain to configure.
> >
> > I'm guessing Cram-MD5 is more on the SMTP side than backend..
> >
> > Any clues?
> >
>
> I don't think that you can do it for Outlook Express, but I believe that
> it can be achieved with a mail client that supports it. However, I have
> never done it myself so my only clues are:
>
> 1) sections 32 and 34 of the exim 4 spec; and
> 2) search of the exim-users mailing list for md5.
>
> Hope this helps.
>
> Regards
>
> Clive Goodhead
> Cornwall Internet Limited
> --------------------------------------------------------------------------
> Cornwall Internet Limited
> Registered office: Montaza, Fore Street, Goldsithney, Penzance, Cornwall.
> Registered in England, registered number 3387326.
> --------------------------------------------------------------------------
>
> >
> >
> > > ######################################################################
> > > #                   AUTHENTICATION CONFIGURATION                     #
> > > ######################################################################

> > >
> > > begin authenticators
> > >
> > > fixed_login:
> > >  driver = plaintext
> > >  public_name = LOGIN
> > >  server_prompts = "Username:: : Password::"
> > >  server_condition = \
> > >    ${lookup mysql{select if(count(*), "1", "0") \
> > >    from ciusers where email = '${quote_mysql:$1}' and \
> > >    password = '${quote_mysql:$2}'}}
> > >  server_set_id = $1

> >
> >
>
>