It seems like it would be possible to use a view table (with a union query) to "make" the many domain style table out of the tables by domain. You wouldn't want to do that if you were adding domains often... but it should make the dovecot auth for many domains work on top of the old tables instantly.Sent from my T-Mobile 4G LTE device------ Original message------From: Eric BrochDate: Wed, Feb 10, 2021 2:58 PMTo: dovecot@dovecot.org;Cc: Subject:Re: SQL-AUTH driver replace for VPOPMAIL-AUTHPablo,

Can you share your dovecot-sql.conf.ext file for 'one table for each domain'.

Eric

On 2/10/2021 9:24 AM, Pablo Murillo wrote:

Hi Aki

Don't work, but you give me a new idea I set default_pass_scheme = PLAIN on dovecot-sql.conf.ext anda I send the pass encrypted and now is working !

On 2/10/2021 3:34 AM, Aki Tuomi wrote:

...

Return the password with {CRAM-MD5} or {MD5-CRYPT} prefix, then dovecot will know the password scheme.

Aki

...

On 10/02/2021 05:04 Pablo Murillo wrote:

  Hi

I'm made a lot of test trying to get SLQ auth driver work with vpopmail/mysql configured with many domains (one table for each domain) Finally I made it work, but ... only with PLAIN password Is there a way to make SQL auth work with vpopmail/mysql tables with encrypted password (CRAM-MD5 / MD5-CRYPT) ?

Thanks Pablo Murillo

-- This email has been checked for viruses by AVG. https://www.avg.com