Hi,
Where can I get examples for the records for the "users" table?
For SHA512-CRYPT, I tried:
replace into users values ('a@a.com','a.com',ENCRYPT('b', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))),'',0,0,'true');
schema is:
CREATE TABLE users (
username varchar(255) NOT NULL,
domain varchar(255) NOT NULL,
password varchar(255) NOT NULL,
home varchar(255) NOT NULL,
uid int(11) NOT NULL,
gid int(11) NOT NULL,
active enum('true','false') NOT NULL DEFAULT 'true',
PRIMARY KEY (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Password_query:
password_query = select username, domain,password from users where username='%u' and domain='%d' and active='true'
What could I be missing?
but logs says user is not found in userdb:
Nov 3 22:17:24 fastmail dovecot: auth: Error: sql(a@a.com,127.0.0.1,<JIsTtvsGZwB/AAAB>): user not found from userdb
Nov 3 22:17:24 fastmail dovecot: pop3: Error: Authenticated user not found from userdb, auth lookup id=3938844673 (client-pid=10240 client-id=1)
Nov 3 22:17:24 fastmail dovecot: pop3-login: Internal login failure (pid=10240 id=1) (internal failure, 1 successful auths): user=<a@a.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=10247, secured, session=<JIsTtvsGZwB/AAAB>