similar to: Mail Alias Stores in mySQL Not working

This apparently was a problem that i was not aware since i redid my mail server configuration to make use of Postfixadmin. I have update the conf files using the postfix document fromthe down load. The download document seems to be fpr an early version of dovecot (I am using 2.2.4) as it focuse of dovecot.conf which is now broken into file in the conf.d subdirectory I get "dovecot:

"Do you have an SQL entry for abuse at kasdivi.com <mailto:abuse at kasdivi.com> ? Bill? One of my first thoughts mysql> SELECT `address`, `domain`, `goto` FROM `alias` LIMIT 8; +-------------------------------+--------------------+--------------------------+ | address | domain | goto |

"In an earlier post you said your user_query was: user_query = SELECT CONCAT('/var/vmail/mail/', maildir) AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active=?1' Last post you said: mail is stored at /var/mail/vhosts and: mail_location = maildir:/var/mail/vhosts/%d/%n These don't agree

"With that query, it appears everyone is sharing the same mail directory.? It, of course, depends on the value of `maildir`.? It doesn't look right.? stored by domain or at least it was until i started messing with mysql "Have you checked your MySQL log file to see the actual query?? hmm found out i had never enabled that log?. another tangent I need to follow "We don't

Hello So what i have: centos 5.6 postfix 2.3.3 dovecot 2.0.13 postfixadmin 2.3.3 roundcube 0.5.3 All general things are working right now i can send receive email with ssl connections etc... Now i'm trying to configure additional options like quota and some other plugins like sieve, trash, expire and deleted-to-trash. Configuration of quota is on first place. I have read wiki regarding quota

Hi, I'm quite new to dovecot but already quite satisfied. Your documentation in the wiki is great but on quota + mysql it is not very clear. Because of the previously mentioned I have got the following note to make which you will hopefully use to adjust your wiki documentation on per-user-quota + mysql. I've searched your mail archive as good as possible and found no messages on this. If

Hi all, i am asking myself how quota is done with dbox in a virtual setup with having quotas in sql dove 1.1.1 says quota maildir: No maildir storages, ignoring quota lda means quota maildir: No maildir storages, ignoring quota which is right i dont wanna use dict , i only wanna use the qutoas out of sql crated by postfixadmin has someone used this ever ? -- Best Regards MfG Robert

Hi all, I'm setting up a new email server based on the softwares list below: * Postfix * Dovecot 2.0.9 * MySQL * Postfixadmin 2.3.6 My current problem is I'm unsure whether quota feature is well configured or not. In order to test and validate, I use Roundcubemail GUI which provides percentage of the space used by the mailbox (quota should be applied per mailbox). Here, my

Hi there, I have a postfix/postfixadmin/mysql/dovecot install that was using 'virtual' for the LDA. I tried the 'dovecot' LDA to enable Sieve but ran into trouble with aliases. With domain "some-domain.com" being an alias to "somedomain.com", mail sent to *@somedomain.com would be delivered to the Maildir fine, but the 'dovecot' LDA tossed

Hi, ? need some help setting per-user quota and postfixadmin.?Setup is working on 1.2 dovecot. Tryin 2.1 dovecot now,? quota is working but overriden quota rule set by 'user_query =' in /etc/dovecot/dovecot-sql.conf.ext takes no efffekt. What's wrong here? ? Greets ? Haris -------------- next part -------------- # 2.1.rc1: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-amd64 x86_64

Hi, I have a working Installation with: Ubuntu 16.04 LTS Dovecot 2.2.22 MySql 5.7.24 Postfixadmin 3.2 Apache 2.4.18 Rainloop 1.12.1 I manage the E-Mail Accounts with postfixadmin in a MySql-DB. Also I use quotas with Quota Backend postfixadmin-DB (dict). Everything works fine. Now I installed a new Server with the following Versions and migrate the Configs to the new System. Ubuntu 18.04 LTS

Dear all, On a new server (postfix dovecot postfixadmin Centos) I did define quota=0 in postfixadmin However suddenly a user with more than 9Gb of mail got his mailbox new/cur empty and maillog shows: Sep 3 15:43:56 mail16 dovecot: lda(brouwerb at scholarium.nl): Error: sieve: msgid=<alpine.LRH.2.20.1509031543050.16381 at streaming2.antenna.nl>: failed to store into mailbox

With quota count and quota_clone it works, but can I use noenforcing with quota count? quota = count:User quota:noenforcing When I test this config, I receive no quota-warning E-Mail: service quota-warning { executable = script /usr/local/bin/quota-warning.sh # user = dovecot user = vmail unix_listener quota-warning { user = vmail group = vmail mode = 0660 } } plugin {

Hello! I need to configure Quota on Roundcubemail with Dovecot2. So, I did: 90-quota.conf: # SQL backend: quota = dict:User quota::proxy::sqlquota quota_rule = *:storage=20M:messages=1000 } dict { sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } OK, works! but, My webmail shows me 20M of quota. But on my Postfixadmin I configured 200M. How can I fix this? Att; *Lucas

Hello, I,m using Dovecot 1.2.9, now finishing a migration from Courier IMAP. Documentation (http://wiki.dovecot.org/VirtualUsers/Home) says that home directory should not be the same as mail directory. When I create new user accounts with PostfixAdmin the mail directory is not a problem but is there some smart way to create the home directory as well (locating it for instance in

I have installed dovecot-postfix and postfixadmin on an Ubuntu 9.10 machine. The userdb and passdb are both mysql. If I set up a user in postfixadmin they are able to send. I can successfully telnet into the server remotely by name on 110 and 25. I'm not looking for any authentication encryption/ssl any of that, just POP3/SMTP. When I telnet into 110 I can enter a username with user

I want to use a separate passed for the unix_listener (postfix smtp-auth) so i can limit access to the smtp server by user/domain using the postfixadmin database. I want to let users access map to receive email but not be able to send. Any ideas? Thanks Damon

I have trying to find how to set the dovecot-sql.conf for using SHA256/512.? I am going to start clean with the stronger format, not migrate from the old MD5.? It seems all I need is: driver = mysql connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=$Postfix_Database_Password default_pass_scheme = SHAxxx-CRYPT # following should all be on one line. password_query =

Hi All, Relatively new to Dovecot - converting from courier-imap. So far, I've got it working with virtual users (postfixadmin tables), and it seems to be working. I'm trying to get sieve working. It's not, so I tried turning up the logging, and putting it into a separate log file to get it out of the syslog for now. I can get the main dovecot to log, but I cannot get any log

Hello, My setup consists of the following: * Freebsd 6.2 system with software installed from ports tree: * Postfix 2.3.8,1 * postfixadmin 2.1.0_7 * mysql 5.0.33 * dovecot-1.0.r25 * dovecot-sieve 1.0.1 * clamav 0.90_3 * SpamAssassin 3.1.8_1 * amavisd-new 2.4.5_1,1 My mail setup is a virtual user setup with all users/domains sharing same UID:GID. Postfix and dovecot get their