<html><head>
</head>
<body>
<div style="font-size: 10pt;"><div dir="auto"><br></div><div dir="auto">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.</div><div dir="auto"><br></div><div><div dir="auto" style="font-size:9pt;"><i>Sent from my T-Mobile 4G LTE device</i></div></div></div><div style="font-size: 10pt;"><div id="LGEmailHeader" dir="auto"><div dir="auto"><br></div><div dir="auto">------ Original message------</div><div dir="auto"><b>From: </b>Eric Broch<ebroch@whitehorsetc.com></ebroch@whitehorsetc.com></div><div dir="auto"><b>Date: </b>Wed, Feb 10, 2021 2:58 PM</div><div dir="auto"><b>To: </b><a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>;</div><div dir="auto"><b>Cc: </b></div><div
dir="auto"><b>Subject:</b>Re: SQL-AUTH driver replace for VPOPMAIL-AUTH</div><div dir="auto"><br></div></div><pre>Pablo,
Can you share your <a href="http://dovecot-sql.co">dovecot-sql.co</a>nf.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 <a href="http://dovecot-sql.co">dovecot-sql.co</a>nf.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 <info@pablomurillo.com.ar> 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.
>>> <a href="https://www.avg.com">https://www.avg.com</a>
</info@pablomurillo.com.ar></pre></div>
</body></html>