similar to: help with MYSQL and dovecot

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

dovecot 1.0.15 Hello, i try to set quota settings for my users. currentyl i use a mysql table for auth process and now i want to add quotasettings for each individual user. at the moment i have the problem that only global quota is effective and no userquota which is stored in usertable. This is my mysql-usertable: login varchar(255) password varchar(64) home varchar(128) uid int(11) gid

Hello dovecot mailing list, I have a server running postfix and dovecot. I havea configuration on dovecot that allows me to provide imap4/pop3 messages for local hosted users as well as for proxied users on other servers. Basically, i have a simple MySQL table (imapproxy) with two fields, 'domain' and 'host'. My password_query isa 'UNION' query, exactly like:

I have a replication set up with two dovecot 2.3.4 servers. Messages appear to be replicating fine between them, however there is an oddity when I run doveadm replicator status '*' and I'm worried work is being carried out needlessly. Both machines have identical configs and have a mysql backend for username/passwords.? Both machines point to the same mysql server and same

Quoting Rick Romero <rick at havokmon.com>: > Quoting Eric Broch <ebroch at whitehorsetc.com>: > >> On 10/4/2018 7:27 AM, Rick Romero wrote: >>> Quoting Eric Broch <ebroch at whitehorsetc.com >>> <mailto:ebroch at whitehorsetc.com>>: >>> >>>> On 10/4/2018 6:34 AM, Rick Romero wrote: >>>>> ? >>>

hi: I was using scientific linux 6 and had cache problem. I upgrade to scientific linux 7 but the problem is the same, so I try to find out why. dovecot version: 2.2.10. postfix + postfixadmin environment. use dovecot-lda to deliver local mail. if I enable cache with "auth_cache_size = 102400" and enable cram-md5 with "auth_mechanisms = plain login

Hello, I'm trying to setup a dovecot imap server. version is 2.0.9 I've setup a mysql database using: user_query = \ SELECT home, uid, gid, home as userdb_home, uid as userdb_uid, gid as userdb_gid, \ FROM user WHERE username = '%n' AND domain = '%d' AND active = 'Y' password_query = \ SELECT username AS user, password, home as userdb_home, uid as

Hi I try to use expire plugin with mysql When i use my thunderbird client to delete a message, nothing is write in the mysql database. My maildir is look like /home/vmail/homes/arnaud2 at xxx.xxxx.xxx/ and /etc/dovecot/dovecot-dict-expire.conf : connect = host=localhost user=xxxxxx password=xxxxxxxxx dbname=postfixadmin map { pattern = /home/vmail/homes/$user/$mailbox

Problem described: I am trying to get Postfix + Dovecot + MySQL setup to work together in a virtual mail hosting platform. I am running Postfix 2.3.x, and MySQL 5.0.x. I am trying to use Dovecot's LDA for delivery to the users vmail home directory -- usually under /var/vmail/domain.com/j/jdoe for home and /var/vmail/domain.com/j/jdoe/.maildir for mail location, using MAILDIR format.

> > I use postfx 2.3.5 + dovecot (pop3/imap/lda/auth daemon for postfix) rc15. > > root at post /etc/postfix# grep dovecot main.cf > smtpd_sasl_type = dovecot > virtual_transport = dovecot > dovecot_destination_recipient_limit = 1 > > root at post /etc/dovecot# grep password_query dovecot-sql.conf > password_query = SELECT mail as user, cryptp as password, >

Hi, I am having trouble with the quota plugin with deliver. In the auth logs, I see that dovecot is able to get the attribute value just fine: *** Sep 21 17:49:30 dawnone dovecot: auth(default): ldap(cot,127.0.0.1): result: uid(user)=cot uidNumber(userdb_uid)=1011 gidNumber(userdb_gid)=1011 homeDirectory(userdb_home)=/home/cot mailQuotaSize(userdb_quota_rule=*:bytes=%$)=*:bytes=1000000 *** But

Hello, I'm trying to set up, as explained in the wiki, shared mailboxes with symlink. I'm running dovecot-1.1.8 with LDAP pass/userdb. The Maildir layout goes like this : /courriel/boites/foobar : Maildir of user foobar (nfs) /courriel/meta/foobar : control files of user foobar (nfs) /var/dovecot/indexes : indexes (locally stored) I created : /courriel/boites/doveshared/.box/ :

Hello All! I use postfx 2.3.5 + dovecot (pop3/imap/lda/auth daemon for postfix) rc15. root at post /etc/postfix# grep dovecot main.cf smtpd_sasl_type = dovecot virtual_transport = dovecot dovecot_destination_recipient_limit = 1 root at post /etc/dovecot# grep password_query dovecot-sql.conf password_query = SELECT mail as user, cryptp as password,

Hello, let me re-state, hopefully in clearer terms, what I tried to described in a previous thread : With dovecot-1.1.8/Maildir/LDAP pass/userdb (prefetch), I'm trying to set up a Maildir ".box" shared in rw between 2 users in a "Public" namespace. I can't get it to work unless I chmod 777 everything, which obiously is not what I want. 1) am I correct thinking that

Hey, all, I am trying to setup DoveCot with Plesk. But I could not go through the last step. Setup: MySQL 5.0.22 Qmail Plesk 7.5 DoveCot v1.0 RC15 The problem: I setup sql.conf for user query and password query. I tried different ways, DoveCot always says "Authentication failed". Here are my two SQLs. user_query = SELECT concat('/var/qmail/mailnames/', d.name, '/',

Quoting Eric Broch <ebroch at whitehorsetc.com>: > On 10/4/2018 7:27 AM, Rick Romero wrote: >> >> Quoting Eric Broch <ebroch at whitehorsetc.com >> <mailto:ebroch at whitehorsetc.com>>: >> >>> >>> On 10/4/2018 6:34 AM, Rick Romero wrote: >>>> >> Quoting Aki Tuomi <aki.tuomi at open-xchange.com >>

Hi, Maybe I am missing something simple, but I can't get users authenticated using password lookups, as opposed to auth_bind. This is how the log looks like when using password lookup: dovecot: auth(default): new auth connection: pid=2449 dovecot: auth(default): client in:

This is the configuration... ------- $ sudo doveconf -n # 2.2.15: /etc/dovecot/dovecot.conf # Pigeonhole version 0.4.6 (3e924b1b6c5c+) # OS: Linux 3.16.0-31-generic x86_64 Ubuntu 14.04.2 LTS auth_debug = yes auth_mechanisms = plain login auth_verbose = yes first_valid_uid = 1000 mail_debug = yes mail_location = maildir:~/Maildir namespace inbox { inbox = yes location = mailbox Drafts {

I am trying to get Postfix, Dovecot, Postfixadmin, and MySQP all working together. I'm using 1.0.5 atm. I've hit a point where I can't seem top get dovecot to auth to the MySQL password database It seems to see the user OK, but I can't seem to get a password match. MySQL has password stored as MD5, as per Postfixadmin. When I add plain-md5 to the auth mechanisms dovecot

Hi, I am trying to set up a proxy between two dovecot servers. I have the following set up here. Dovecot version: 1.0.rc15 dovecot -n: # /etc/dovecot/dovecot.conf info_log_path: /var/log/dovecot.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: pop3 imap login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap):