forum.lissyara.su

Код: Выделить всё

protocol imap {
  mail_plugins = quota imap_quota
}
protocol pop3 {
  mail_plugins = quota
}
# In case you're using deliver:
protocol lda {
  mail_plugins = quota
} 

Код: Выделить всё

driver = mysql
connect = host=localhost dbname=mailexim user=root password=*********
default_pass_scheme = MD5-CRYPT
password_query = SELECT `username` as `user`, `password` FROM  `mailbox` WHERE `username` = '%n@%d' AND `active`='1'

user_query = SELECT `maildir` AS `home`, 26 AS `uid`, 26  AS `gid`, concat('*:storage=', quota, 'B') AS quota_rule FROM  `mailbox` WHERE `username` = '%n@%d' AND `active`='1'

Код: Выделить всё

protocol imap {
.....
  mail_plugins = quota imap_quota
}
protocol pop3 {
.....
  mail_plugins = quota
}
protocol lda {
  mail_plugins = quota
.....
}
.....
plugin {
	quota = maildir
	quota_rule=*:storage=10240
}

Код: Выделить всё

user_query = SELECT 26 AS uid, 26 AS gid, concat('*:storage=', q.quota) AS quota_rule FROM users u, quotas q WHERE u.login = '%n' AND u.domain = '%d' AND q.type=u.quota

Код: Выделить всё

DROP TABLE IF EXISTS `quotas`;
CREATE TABLE `quotas` (
  `type` char(10) character set cp1251 NOT NULL default 'user',
  `quota` int(10) NOT NULL default '0',
  PRIMARY KEY  (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `quotas` VALUES ('user', '20480');
INSERT INTO `quotas` VALUES ('admin', '0');

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `login` varchar(64) NOT NULL default '',
  `passwd` varchar(64) NOT NULL default '',
  `domain` varchar(128) NOT NULL default 'domain.com',
  `quota` char(10) default 'user',
  `status` enum('0','1') default '1',
  PRIMARY KEY  (`login`,`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `users` VALUES ('user', 'pass', 'domain.com', 'admin', '1');

Код: Выделить всё

Jan  1 01:40:24 kino dovecot: auth-worker(default): mysql: Connected to localhost (mailexim)
Jan  1 01:40:35 kino dovecot: auth-worker(default): sql(users@domain.com.ua,193.269.258.1): User query failed: Table 'mailexim.users' doesn't exist
Jan  1 01:40:36 kino dovecot: imap-login: Internal login failure (auth failed, 1 attempts): user=<users@domein.com.ua>, method=PLAIN, rip=193.239.254.187, lip=193.239.254.187, secured