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