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(u...@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,
-loginVARCHAR(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,
-quotaVARCHAR(10) NOT NULL DEFAULT '1000S');
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,
-aliasVARCHAR(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 ('n...@domain.tld', 'name lastname', ENCRYPT('pass'),
- 'domain.tld/name/');
Which helps me is well received
Thanks for all
--
editor de sueños
