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