Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

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=', RE

Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

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 insta

Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

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 !

Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

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 s

Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

Hi Pablo, Roberto has it without PLAIN text, you could check that out https://notes.sagredo.eu/en/qmail-notes-185/installing-and-configuring-vpopmail-81.html I recall I used Roberto in the past, and the p

Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

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 eac

Re: SQL-AUTH driver replace for VPOPMAIL-AUTH

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/qmai

SQL-AUTH driver replace for VPOPMAIL-AUTH

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 /