Displaying 20 results from an estimated 4000 matches similar to: "Virtual plugin and user_query"
2010 Oct 25
1
virtual plugin broken ? dovecot 2.0.6
Hi Timo,
looks like virtual plugin is broken now with my setup dovecot 2.0.6
cant say to which version it stopped working ( didnt tested it trough
all ) but has worked
i see nothing special in log why it stopped working
it should show unseen mail i.e in folder Junk too
with pop3 clients, but only shows new inbox mails
after all i am confused what using better
pop3_uidl_format = %08Xu%08Xv (
2012 Dec 09
1
imap dumps core when connecting with mutt
Hello,
I'm trying to investigate a problem with dovecot/imap dumping core when
connecting connecting mith mutt (everything else works).
imap(user at domain): Fatal: master: service(imap): child 31752 killed with
signal 11 (core dumped)
I managed to create a core file and passed that to gdb. The log is here [1].
I hope this helps - please tell me what else would be needed if not.
2010 Feb 10
1
POP3 with dovecot LDA and sieve
Hello.
I'm using Postfix with Dovecot as IMAP, POP3 and LDA.
With sieve rules I successfully move mails to specific mailboxes and
this is great if accessing the account thru IMAP.
However, when accessing thru POP3 I only get mails from Inbox. I wonder
if it's possible to get real new mails, regardless of the folder they're in.
Thanks for any thoughts.
Arthur
2014 Oct 01
1
Simply mysql quota check
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
2010 May 03
4
Dovecot SQL user_query
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
2009 May 17
2
Problem with domain part in user_query in dovecot 1.1.14
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
2008 Jan 24
2
SQL user_query question
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
2007 Jul 11
1
Fixing lda user_query error introduces new fault in mail delivery
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:
2014 Feb 02
7
[Bug 893] New: Support upstream docbook2x location
https://bugzilla.netfilter.org/show_bug.cgi?id=893
Summary: Support upstream docbook2x location
Product: nftables
Version: unspecified
Platform: All
URL: https://bugs.archlinux.org/task/38706
OS/Version: All
Status: NEW
Severity: enhancement
Priority: P5
Component: nft
AssignedTo:
2011 May 16
1
user_query and mail_plugins in database
-----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
2005 Jun 20
0
MySQL user_query ignored
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
2008 Jul 06
1
Dovecot failed with a correct sql user_query
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:
2010 Sep 25
1
password_query, user_query and unrelated userid and emails
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
2010 Jan 14
3
LDA and POP3/IMAP user_query
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
2012 Oct 11
1
iterate_query does not use userdb - mail_location not found
Hi dovecot-comminity,
can't get iterate_query working. doveadm cannot find mail_location
which comes from userdb query. dovecot itself works fine with sql.
Whats wrong? please help:
[root at glen exim]# /opt/dovecot/bin/doveadm search -A mailbox Trash savedbefore 90d
doveadm(uwe at mitmachnet.de): Error: user uwe at mitmachnet.de: Initialization failed:
2020 Mar 18
2
Headsup on feature removal
Hi Aki and Remo,
switch from vpopmail driver to SQL driver (if you are using vpopmail
with mysql as backend) is very simple.
First you need to setup the right query for vpopmail database:
# cat /etc/dovecot/dovecot-sql.conf.ext
### Vpopmail
driver = mysql
connect = host=192.168.1.2 dbname=vpopmail user=vpopmail password=Vp0pM4iL
default_pass_scheme = MD5-CRYPT
### Query to get a list of all
2010 Feb 07
2
Virtual POP3 Inbox question
Hi,
I'm having trouble implementing the virtual pop3 inbox solution in
Dovecot 1.2.x. As the following wiki page describes
(http://wiki.dovecot.org/Plugins/Virtual) one should only set the
inbox=yes flag for the virtual namespace which then flattens all
mailboxes in the realmails/ prefix.
In the above example when I set the inbox=yes flag for the virtual
namespace, the inbox in the
2013 Nov 12
1
how to make quota per user ??
I use dovecot version 1.2.15 and i put quota for all users , now i want to
give more size for some emails , i already added the quota to user database
, and i added the queries from http://wiki.dovecot.org/Quota/1.1
MySQL:
user_query = select uid, gid, home, \
concat('*:bytes=', quota_bytes) as quota_rule \
from users where userid = '%u'
# MySQL with userdb prefetch: Remember
2009 Mar 29
1
about quota in dovecot
Hi,
I?m currently try to use the dovecot quota plugin.
I use the maildir plugin ,and use mysql as to get the quota rule.
Question is:
Sometimes dovecot only count in the size of INBOX ,without other (I use imap to create some mailbox),while,sometimes it count in all.
I don?t know if there?s anything wrong with my configure.
Here is the configure of my dovecot.
2010 May 22
18
[Bug 28212] New: image corruption
https://bugs.freedesktop.org/show_bug.cgi?id=28212
Summary: image corruption
Product: xorg
Version: git
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: NEW
Severity: normal
Priority: medium
Component: Driver/nouveau
AssignedTo: nouveau at lists.freedesktop.org
ReportedBy: d.okias