similar to: user_query and mail_plugins in database

Hello Thank for adding mail_log plugin in Dovecot POP3/IMAP server. But when I am use "mail_log" in pop3 secction Dovecot getting the following log message: ... Jan 26 15:34:11 rtr dovecot: pop3-login: Login: user=<gk2>, method=PLAIN, rip=8x.xx.xx.xx, lip=8x.xx.xx.xxx Jan 26 15:34:11 rtr dovecot: POP3(gk2): dlopen(/opt/dovecot/v1.0rc19/lib/dovecot/pop3/lib20_mail_log_plugin.so)

Dovecot 2.2.36 + Pigeonhole 0.4.24 Is this an intended behavior? ``` # service dovecot status dovecot is stopped # doveconf mail_plugins mail_plugins = stats # ls foo.* foo.sieve # sievec foo.sieve sievec(root): Error: stats: open(/var/run/dovecot/stats-mail) failed: No such device or address # echo $? 0 # ls foo.* foo.sieve foo.svbin ``` -- -- Name: SATOH Fumiyasu @ OSS Technology Corp.

I have installed debian lenny, postfix 2.5.5 and dovecot 1.0.15 and can't send emails locally. this is the error in the log Error: auth-worker(default): sql(xxx at yyy.com): User query failed: Unknown column 'mail_plugins' in 'field list'

-----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

Hi all, i installed Dovecot 0.99.14. Everything works fine except that the mysql setup directive "user_query" seems to be ignored - however the password_query works. Instead the default user query in db-mysql.c always takes effect. Might this be a bug or is something worng wit my setup below? (To keep on working i changed the default query in db-mysql.c..) Helmut

Hi, I am working through setting up a virtual hosting system using Dovecot, Postfix and Postgres on a CentOS 5 box running an install of the dovecot-1.0-1.2.rc15.el5 RPM. The question I have is, given this password_query SELECT clause, which all return valid values from the database: user password domain can I use a %d in the WHERE clause of my user_query? The reason I ask is that the

Hello, As per a previous reply regarding POP3 I'm now trying to configure the virtual plugin. However I don't really understand how to modify the sql user_query to properly indicate inbox=yes. I created 3 namespaces as per wiki instructions and I've modified the password and user queries as bellow: password_query = \ SELECT email, password, login , concat('*:bytes=',

Let's say one has a SQL table with following fields for John Doe: login: u0007 password: {SHA1}... mailhome: /path/to/joeshome email: john.doe at example.com To log in, for internal policy reasons, John MUST make use of his userid "u0007". So, in the password_query, one would need something like: ... WHERE login = '%u' ... On the other hand, for receiving mail thru

Dovecot (1.1.1) criticises a sql user_query that's working on the sql console and thats correct. DOVECOT-LOG: "dovecot: Jul 06 22:58:29 Error: auth(default): sql(nti): User query failed: ERROR: syntax error at or near "mbox" dovecot: Jul 06 22:58:29 Error: auth(default): LINE 1: ...gid, home, (CASE WHEN smtp like '/var/pop3/ THEN 'mbox:' || ..." QUERY:

Hi. I'm using dovecot 1.1.14 with pgsql. I tried to configure dovecot to get the domain part in user_query by specifying different variants of auth_username_format variable such as %Lu, %Lu@%Ld, %Lu-at-%Ld and so on... So dovecot gets domain part in password_query, but not in user_query. I noticed the username is changed like this: kostas at mgupb.net->kostas in log. For some reason it

I was getting these errors below and after fixing it delivery errors were introduced dovecot/error_log ============== dovecot: Jul 11 06:19:28 Error: auth-worker(default): sql(user at domain.com): User query failed: Table 'postfix.users' doesn't exist deliver(user at domain.com): Jul 11 06:19:28 Error: BUG: Unexpected input from auth master: FAIL 1 dovecot: Jul 11 06:21:41 Error:

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

How do I get IMAP+POP3 vs. LDA to use different user_query statements? The problem is that the input fields are different. IMAP/POP3 is an email address LDA is a username I have written a long statement to try and cater for both however it still only works 99% of the time, and the remaining 1% fails. The 1% that fails sees the mail being delivered to the wrong mbox. In this particular case