Hi friends,
I am migrating imap-courier to dovecot, I use openbsd+postfix+imap-courier, and now I'm trying to run openbsd+opensmtpd+dovecot.
In the beginning it was a little traumante but it works OpenSMTPD correctly.
Now I have configured dovecot, and I hope that your backend authorization is the same database that was used imap-courier.
In /var/log/maillog receipt the following error
auth-worker(2915): Error: sql(user@domain.tld,199.254.238.134): Invalid password in passdb: Not a valid MD5-CRYPT or PLAIN-MD5 password
My /etc/dovecot/dovecot-sql.conf.ext
password_query =
SELECT login, password
FROM users WHERE login = '%u'
My database MySQL to start as well
mysql> CREATE DATABASE mail; Query OK, 1 row affected (0.01 sec)
mysql> use mail Database changed mysql> CREATE TABLE domains ( -> id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, -> domain VARCHAR(255) NOT NULL UNIQUE); Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE users ( -> id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, -> login VARCHAR(255) NOT NULL UNIQUE, -> name VARCHAR(255) NOT NULL, -> password CHAR(13) NOT NULL, -> uid SMALLINT NOT NULL DEFAULT 2000, -> gid SMALLINT NOT NULL DEFAULT 2000, -> home VARCHAR(255) NOT NULL DEFAULT '/var/vmail', -> maildir VARCHAR(255) NOT NULL, -> quota VARCHAR(10) NOT NULL DEFAULT '10000000S'); Query OK, 0 rows affected (0.01 sec)
mysql> CREATE TABLE alias_maps ( -> id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, -> account VARCHAR(255) NOT NULL UNIQUE, -> alias VARCHAR(255) NOT NULL); Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT ON mail.* to 'vmail'@'localhost' IDENTIFIED BY 'vmail'; Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
Not for me this past this error to insert data in the database, I do this:
mysql> INSERT INTO users (login, name, password, maildir) -> VALUES ('name@domain.tld', 'name lastname', ENCRYPT('pass'), -> 'domain.tld/name/');
Which helps me is well received
Thanks for all
editor de sueños