similar to: mysql query prepending

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi @ll, sorry i am new to dovecot so this may asked before i this in dovecot.conf protocols = pop3 imap ssl_disable = yes mail_extra_groups = mail valid_chroot_dirs = /usr/local/virtual/ default_mail_env = maildir:/usr/local/virtual/%d/%n disable_plaintext_auth = no protocol lda { postmaster_address = postmaster at test.de } protocol pop3 {

What are the best web interfaces for user/domain management, perhaps one that also allows individual users to edit vacation msgs? Right now I'm using a postfixadmin based mysql control panel. Curious what is the better stuff out there that people are using with dovecot/sieve these days? Are there any decent front-ends to setup/manage per-user sieve filters?

First of all excuse.. I am having an issue getting maillist responses so I may be responding to this worng No on topic I commented out the first user_quesry The second query was not copied correctly , reads 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'

Hi, People using the new OS X mail client are unable to connect to the unsigned dovecot-mkcert.sh certificate on my Dovecot installations. Turning off SSL fixes the problem. Is there any way to make it work automatically, or do I just have to get the certificates signed? Has anyone figured this one out before? Thanks, Chris

Hello! Christian Kivalo <ml+dovecot at valo.at> schrieb am 13.09.15 um 19:51:38 Uhr: > > Sep 13 11:55:49 imap(a.meyer at nimmini.de): Error: user > > a.meyer at nimmini.de: Initialization failed: Namespace '': Home > > directory not set for user. Can't expand ~/ for mail root dir in: ~/ > > Sep 13 11:55:49 imap(a.meyer at nimmini.de): Error: Invalid user

I was trying to configure postfix, mysql with dovecot. The postfix part is fine, but dovecot seems cannot cannot read the mail directory dovecot: Apr 09 16:22:37 Info: Dovecot starting up dovecot-auth: Apr 09 16:22:38 Info: MySQL: connected to localhost dovecot-auth: Apr 09 16:22:38 Info: Login process 7 connected dovecot-auth: Apr 09 16:22:38 Info: Login process 8 connected dovecot-auth: Apr 09

Hello, I've been frying my brain with quota and mysql... Here is what I do: protocol imap { mail_plugins = quota imap_quota imap_client_workarounds = outlook-idle delay-newmail } plugin { # 10 MB + 1000 messages quota limit # quota = maildir:storage=10240:messages=1000 driver = mysql connect = host=/var/lib/mysql/mysql.sock user=mail_admin password=XXXXXXXX dbname=mail

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

Christian Kivalo <ml+dovecot at valo.at> schrieb am 13.09.15 um 22:08:04 Uhr: > > I think the query-string f?r MySQL would overwrite this mail_location, > > right? But how do I define it in the query? > > yes thats how it should work but your query (looking at the query result > from your first email) overwrites the mail_location with >

Hi all, I'm testing a dovecot-2.0-beta4 and it is great so far, except that I can't get the sieve plugin for the LDA configured. It doesn't find the user's homedir and uses /tmp instead. Thus it never finds any sieve scripts. The log shows that the SQL queries return the correct home path, namely /mnt/data/vmail/example.com/me dovecot: auth: prefetch(me at example.com): passdb

Hello, Im having problems getting Dovecot to read the quota info from MySQL. My current dovecot.conf file is below. If I run the user_query of: user_query = SELECT 1000 AS uid, 1000 AS gid, maildir AS home FROM mailbox WHERE username = '%u' AND active = '1' Everything works fine but if I run the user_query of: user_query = SELECT 1000 AS uid, 1000 AS gid, maildir AS home,

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:

Hello! I'd like to setup quota for for virtualusers, i'm using both maildir++ and mdbox as storage, and i'm using postgresql to keep users. I'm keeping all users data in one table: [...] login text NOT NULL, domain text, password text, quota_mb integer NOT NULL DEFAULT 0 [... other columns ...] i'd like to keep present quota in such two columns: quota_dict_bytes integer NOT

Hi, new to dovecot I'm setting a small postfix/dovecot server for virtual domain/users in mysql dovecot is on one host, mysql on another seems to be working, but I'm concerned over performance overhead of this setup; dumb Q, is there any 'proxy mysql' or cacheing option I can use ? any suggestions appreciated also, my mail users as set as 5000/5000 virtual_gid_maps =

Hi there, I'm setting up a new email server with Dovecot(2.2.9) and MySQL. My Dovecot configuration: #/etc/dovecot/conf.d/90-quota.conf service quota-warning { executable = script /usr/local/bin/quota-warning.sh user = dovecot unix_listener quota-warning { user = vmail } } plugin { quota = maildir:User quota quota_warning = storage=95%% quota-warning 95 %u@%d

"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

Hi All, I'm new to the list and have a quota question. I am building a new server with dovecot/qmail/vpopmail/mysql and emails are sending and recieving fine when the quota is set to NOQUOTA, but when the quota is changed qmail doesn't deliver any messages. I have read the docs and still need some help understanding the process for dovecot quotas relating to the vpopmail mysql database

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

Hello folkz, Is it possible to setup in dovecot-sql.conf file to run user_query twice if its first run didn't yield any values. And likewise don't proceed with the second run if the first user_query execution produced the result. I have to query two tables which specify there email messages shall be delivered via Dovecot deliver LDA depending on the incoming email addresses. Please

Hello, Another question!! Was just trying to sort out mail delivery to subdomains. I set up my system so that I have a mail address of tim at subdomain.example.com. I've sorted out Postfix to correctly identify this and pass on to Dovecot for delivery but Dovecot doesn't seem to deliver where I want it to. Ideally I would like to have a structure so that mail is delivered to