Example records for SQL AUTH

[Jorge Bastos]

Hi,

 

Where can I get examples for the records for the "users" table?

For SHA512-CRYPT, I tried:

 

replace into users values ('a at 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 at 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 at a.com>,
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=10247, secured,
session=<JIsTtvsGZwB/AAAB>