On 03/11/2014 22:29, Jorge Bastos wrote:
Password_query:
password_query = select username, domain,password from users where
username='%u' and domain='%d' and active='true'
Try ... username='%n' ... not %u
From doc/dovecot/example-config/dovecot-sql.conf
# Commonly used available
On 11/3/2014 4:29 PM, Jorge Bastos wrote:
Hi,
Where can I get examples for the records for the users table?
If I understand your question properly and you're looking for examples
of creating new virtual users, then this guide covers that:
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,