Hi Remo

I check Roberto page, but I'm using a complete different configuration I use one table per domain, he use only one table for everything

Pablo

On 2/10/2021 1:13 AM, Remo Mattei wrote:

Hi Pablo, Roberto has it without PLAIN text, you could check that out

https://notes.sagredo.eu/en/qmail-notes-185/installing-and-configuring-vpopm... https://notes.sagredo.eu/en/qmail-notes-185/installing-and-configuring-vpopm...

I recall I used Roberto in the past, and the pass is encrypted.

Remo

...

On Feb 9, 2021, at 19:04, Pablo Murillo mailto: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. https://www.avg.com https://www.avg.com

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 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. https://www.avg.com

The query, using SLQ for limits too

password_query = \

  SELECT
CONCAT(vpopmail.pw_name,'@','%L{domain_first}') AS user,
vpopmail.pw_clear_passwd AS password,
vpopmail.pw_dir AS userdb_home,
89 AS userdb_uid,
89 AS userdb_gid,
CONCAT('*:bytes=', REPLACE(SUBSTRING_INDEX(vpopmail.pw_shell, 'S', 1), 'NOQUOTA', '0')) AS quota_rule
FROM
%L{domain_last} AS vpopmail
LEFT JOIN
aliasdomains ON aliasdomains.alias='%L{domain_first}'
LEFT JOIN
limits ON limits.domain = '%L{domain_first}'
WHERE
vpopmail.pw_name='%n'
AND
(('[WEBMAIL-IP]'!='%l' AND limits.disable_imap = 0)
OR 
('[WEBMAIL-IP]'='%l' AND limits.disable_webmail = 0))

IMPORTANT !!!

The user mas be sent as :

USER @ DOMAIN @ DOMAIN_WITH_UNDERSCORES

Example:

info@pablomurillo.com.ar@pablomurillo_com_ar

If you use roundcube, must be modified too,  rcube_imap.php on connect function $user .= "@" . preg_replace(array("/\./","/\-/"), "_", $host);

The table aliasdomains and the changes on vpopmail could be found on https://notes.sagredo.eu/en/qmail-notes-185/dovecot-vpopmail-auth-driver-rem...

On 2/10/2021 3:02 PM, Eric Broch wrote:

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 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. https://www.avg.com