similar to: Dovecot, mysql, and quota

Hi, I'm using a SQL database to store the usernames and passwords of my users. However, I have found that I must explicitly return the uid and gid with every query, even though all virtual users use the same uid and gid. The query, that works, is: user_query = SELECT mail, 'vmail' AS uid, 'vmail' AS gid, home, CONCAT('*:storage=', quota_MB*1024) AS quota_rule \

I tried to set a quota setting. I installed dovecot with newest version, patched it and started it. dovecot -n: # 1.2.15: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-amd64 x86_64 Debian 6.0.3 ext4 log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3 pop3s ssl_listen: 143 ssl_cipher_list: ALL:!LOW:!SSLv2 disable_plaintext_auth: no login_dir: /var/run/dovecot/login

Hello, I've got dovecot going with postfix and MySQL database for user and domain storage. Dovecot handles the authentication. My last login is not working, does anyone have a table example and configs? I looked at the wiki page on the lastlogin plugin but obviously what I'm doing isn't working, I keep getting message write was unsuccessful for the lastlogin ip. I'd appreciate

Hello, I am trying to get per-user quotas working. My thanks to all who have helped so far. To recap I am running Dovecot 2.1 and Mysql where I've got my virtual users. All virtual users are under the system user vmail with a UID and GID of 5000. Looking over the wiki docs I've added a quota table and got the dict service working, I am not having problems with permissions or the login

Hi everybody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; +----+-----------+----------------------------------+---------------------------+----------+----------------+ | id | domain_id | password | email | quota_kb | quota_messages |

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I have a problem with mail_plugins in dovecot-2.0.x. I will use mail_plugins within a database, so that I can define plugins for users in the database. But I get errors like this. - -----------------------------%<------------------------------------ lmtp(3933): Error: Can't load plugin imap_quota_plugin: Plugin is intended to be

Running postfix+dovecot+mysql on a mac-mini, and trying to solve this puzzle. Is this a Mac issue?, a MySQL issue? or something I haven't configured in? You can see from the output of the samples shows in the first case, that SHA512-CRYPT seems to be Unknown. The code I used is from a Linux based tutorial on setting up Postfix+Dovecot+MySQL on a site. Everything is generally going ok, apart

In order to deal with case-sensitive issues, I am thinking to use the variable %L (adding it to my current configs --as suggested before by other users in this list) in the configuration files in this way: In Dovecot.conf: mail_location = maildir:/vmail/%Ld/%Ln/Maildir:INDEX=/indexes/%Ld/%Ln auth default: username_format: %Lu passdb: driver: sql args:

Hello, I have two installations of dovecot configured to replicate mailboxes between them. recently, i upgraded the operating system on one of them (mx2.example.com) and now i'm running one installation on version 2.2.27 (debian stretch) and another on version 2.3.4.1 (mx1.example.com debian buster). My setup includes 3 shared namespaces that point to the mailboxes of 3 accounts. these

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I use this user_query: - -------------------------------%<-------------------------------- user_query = SELECT LOWER(CONCAT(t2.login,'@',t1.name)) AS user,t2.home,t2.mail,5000 AS uid,5000 AS gid,CONCAT('*:storage=',quota_mb,'MB') AS quota_rule,t2.acl_groups,case when '%s'='lda' then 'acl quota

Has anybody noticed this behavior when using maildir quota with Version 1.2.4: # 1.2.4: /etc/dovecot/dovecot.conf # OS: Linux 2.6.26-2-686-bigmem i686 Debian 5.0.3 xfs My default configurations quota configurations: plugin: quota: maildir:User quota quota_rule: *:storage=2G Customized Use Configurations at the Mysql level: user_query = SELECT 5000 AS uid,5000 AS gid,'/vmail/%d/%n'

Hello, Can I get a sanity check on this configuration? It's a database setup of Dovecot 2.2 with Postfix. I'm having issues and i'd like to know if there's anything glaringly wrong with my configuration? With the password hash situation, should I go with SHA512, SHA512-CRYPT or the SSHA512-CRYPT? Thanks. Dave. # 2.2.29.1 (e0b76e3): /usr/local/etc/dovecot/dovecot.conf #

Hello, Dovecot does not fill expires table when moving messages to Trash or Junk folder. I looked all over mailing list and googled around and cannot find what could be wrong - pleas help :) Dict works for quota, so I presume connection to mysql is not a problem - mailuser has Select,Insert,Update,Delete privileges over quota and expires table (log below for deleting message) dovecot

Hello, Trying to implement lastlogin via mysql. I'm getting an unknown column username which I don't get. Here's the log: Apr 28 17:18:15 ohio dovecot: imap-login: Login: user=<user at example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=16257, secured, session=<KxiSnEBOwUx/AAAB> Apr 28 17:18:15 ohio dovecot: dict(17099): Error: sql dict: commit failed: Unknown

Hello, I''m a puppet newbie and I''m having trouble getting my virtual user setup to work. Can someone please tell me what''s wrong with this setup? # virtual.pp # class virtual_users::virtual { @group { "users": gid => "100", ensure => present } @user { "lmoore": password =>

Hello, I've got quotas set up on an all-user basis on my system, it's a Postfix, Dovecot, Mysql virtual users setup. Currently I have each user getting a 1GB quota with these settings in 90-quota.conf: plugin { quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M } plugin { quota = maildir:User quota } While this works it's not what I want for all users. Say I add a

Version: Dovecot 2.0 rc2 I'm testing Dovecot with MySQL quotas but I get always this error for incoming mails: tux dovecot: lmtp(4928): Error: user testuser at dlutt.de: Auth USER lookup failed tux dovecot: auth: Error: mysql: Query failed, retrying: Unknown column 'username' in 'where clause' I dont' know where the field "username" should come from because I

So I believe I generated a key successfully with: 'doveadm mailbox cryptokey generate -u user -UR' because I got the output with the check mark and the Public ID string of characters. However I still can't read the CRYPTED emails when logging in with IMAP.. i'm still getting the following error in the mail log: Error: read() failed: read(/var/vmail/[domain .

I've been mucking about, experimenting with the expire plugin and using a dictionary. I've got the iteration query working when I do a normal expunge using: doveadm expunge -A mailbox "INBOX.Trash" savedbefore 1w and expunging works as expected. However, I've got over 12,000 accounts on this server, so I was hoping using the expire plugin to could help out. I've

Hello, I have a few questions on password schemes. Is SHA512 the most secure? Is there a difference between SHA512 and SHA512-CRYPT? What about SSHA512 and SSH512-CRYPT? Is there a problem with this sql statement: UPDATE virtual_users SET password=CONCAT(?{SHA256-CRYPT}?, ENCRYPT (?Password Goes Here?, CONCAT(?$5$?, SUBSTRING(SHA(RAND()), -16)))) WHERE user=?user at example.com?; I'm