SQL-AUTH driver replace for VPOPMAIL-AUTH

[steve at keptprivate.com]

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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20210210/75c8af31/attachment.html>