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>