Displaying 2 results from an estimated 2 matches for "mls_user".
2017 Oct 04
3
moving from mysql to pgsql
...y existing dovecot installation from mysql to
pgsql. But I have problems with the passwords when using pgsql.
The existing and working mysql-based installation looks like this:
dovecot-sql.conf.ext:
driver = mysql
default_pass_scheme = SHA512-CRYPT
Users are created like this:
INSERT INTO mls_user (idx,domain,password,email)
VALUES (1,99,ENCRYPT('Test'),'mws at alpenjodel.de');
This setup is working, which I can verify like this:
$ telnet localhost 143
* OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID
ENABLE IDLE AUTH=PLAIN AUTH=LOGIN AUTH=DIGEST-MD5
AUTH=...
2017 Oct 04
0
moving from mysql to pgsql
...l. But I have problems with the passwords when using pgsql.
>
> The existing and working mysql-based installation looks like this:
>
> dovecot-sql.conf.ext:
>
> driver = mysql
> default_pass_scheme = SHA512-CRYPT
>
> Users are created like this:
>
> INSERT INTO mls_user (idx,domain,password,email)
> VALUES (1,99,ENCRYPT('Test'),'mws at alpenjodel.de');
>
> This setup is working, which I can verify like this:
>
> $ telnet localhost 143
> * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID
> ENABLE IDLE AUTH=PLAIN AU...