Displaying 20 results from an estimated 11000 matches similar to: "Error: sql dict iterate question"
2012 Jun 24
2
dict Panic after upgrade to 2.1.7
Hello,
after upgrade my mailsystem to dovecot version 2.1.7, dovecot doesn't work
properly. something went wrong in dict service connecting the postgres
backend. that happens not on every connection. the db connection data are
correct, no difference connecting via tcp or linux socket.
dovecot log entries:
Jun 23 23:19:10 mx dovecot: dict: Panic: file driver-pgsql.c: line 84
2009 Apr 07
2
Is there any more detailed docs about dict configuration
Hi,
I am looking for some help on dict configration. I'm trying to config
shared and public mailbox, and use sql as acl backend.
Here is my config:
table:
CREATE TABLE `shared_dict` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`from_user` char(50) NOT NULL,
`to_user` char(50) NOT NULL,
`status` int(10) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `from_user` (`from_user`),
2008 Sep 24
2
dovecot 1.2.alpha1 quota dict driver mysql broken
Hi Timo,
quota dict seems to be broken with 1.2.alpha1
MAP(robert at schetterer.com): read(/var/run/dovecot/dict-server) failed:
Remote disconnected
dovecot: Sep 24 18:43:16 Error: dict: Error in configuration file
/etc/dovecot/dovecot-dict-quota.conf line 1: Unknown setting: driver
dovecot: Sep 24 18:43:16 Error: dict: Failed to initialize dictionary
'quotadict'
2010 Jun 17
1
Shared mailboxes errors
Hello list,
I'm implementing shared mailboxes on live system and after enabling acl plugin I got errors in my log:
Jun 17 15:50:33 dict: Error: sql dict iterate: Invalid/unmapped path: shared/shared-boxes/anyone/
I have no clue why this happening, users don't know about new functionality they just use imap as before. Also dict database begin to fill up by records like:
select * from
2009 May 17
3
example sql acl_shared_dict wiki
Hi Timo,
wiki says
---------
Shared mailbox listing
.....
You could use any dictionary backend, such as SQL or Berkeley DB, but a
simple flat file should work pretty well too:
plugin {
acl_shared_dict = file:/var/lib/dovecot/shared-mailboxes.db
}
....
--------
could you include an example for having
acl_shared_dict in sql ?
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
2018 Mar 28
1
Dovecot quota
Hello,
I'm running Dovecot on a FreeBSD system with Postfix in a virtual user
setup, with Mysql. I am trying to understand the quota configuration.
I've got a Mysql database with an accounts table with a quota field.
I've also got two other tables one quota (currently has nothing in it
an empty set), and quota2 messages and bytes which has one entry. My
goal is to have different
2009 Jul 10
2
Relative home directory paths not supported 1.2.1 broke my setup
Hi Timo,guess
this patch break my setup
http://hg.dovecot.org/dovecot-1.2/rev/dd49cf3fd2c9
the log entry does not look very right cause i dont use relative paths
or i missinterpreted somthing here
Jul 10 21:12:29 dovecot: Error: Relative home directory paths not
supported (user robert at schetterer.com):
maildir:/usr/local/virtual/schetterer.com/robert at schetterer.com/
how can i get my old
2009 Jan 06
2
dovecot 1.2 shared namespace/mailboxes %%u expands only to %
Hi Timo,
with
dovecot --version
1.2.alpha5
namespace shared {
separator = /
prefix = "shared/%d/%%u/"
subscriptions = yes
list = yes
}
and dovecot-acl
authenticated lr
in /usr/local/virtual/schetterer.com
%%u seems not expand to other existing users instead it expands to %
i expected showing all other maildir beyond
dovecot: Jan 06 23:53:14 Info: IMAP(robert at
2007 Feb 13
2
trash plugin sql
Hi @ll,
with dovecot latest
following
http://wiki.dovecot.org/DovecotLDAPostfixAdminMySQL
i have defined
plugin {
quota = maildir
acl = vfile:/etc/dovecot/acls
trash = /etc/dovecot/dovecot-trash.conf
}
Example dovecot-trash.conf file
1 Spam
2 Trash
3 Sent
from wiki
The Trash plugin. When saving a message would make user go over quota,
this plugin automatically deletes the oldest mails from
2008 Jul 12
3
dbox and quota question
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
2009 Jun 25
2
Dovecot v1.2rc6 dict-server socket path problem & pgsql crash
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
I find this in the logs:
2009-06-25 14:10:37 IMAP(dvtest) [29566]: Error:
net_connect_unix(/usr/local/dovecot-1.2.rc6acl-hook2/var/run/dovecot/dict-server)
failed: Permission denied
2009-06-25 14:10:37 IMAP(dvtest) [29566]: Error: acl: dict iteration
failed, can't update dict
although base_dir is just /var/run/dovecot/ .
Dovecot v1.2
2010 Jan 13
0
Re-2: Allow POP3 per Domain
<snip />
-------- Original Message --------
Subject: Re: [Dovecot] Allow POP3 per Domain (13-Jan-2010 13:24)
From: Robert Schetterer <robert at schetterer.org>
To: hagedorn at mediaciety.de
> Am 13.01.2010 12:19, schrieb Hauke Hagedorn:
> Hi I have pop3 and/or imap allowed per sql
>
> i.e
>
> password_query = SELECT username as user, password, \
> 1001
2010 Mar 12
1
nosql (it was mogilefs)
Yes,
I?ve read these doc. I was just considering if someone had any experience with Mogile in email environment.
Well, actually I?m trying to figure out if one of those nosql systems can store and scale email systems (ie, mailboxes - instead of maildir). I know mysql is always quoted as an option and discussed sometimes in the list. I think it?s an unnecessary overhead and bottleneck.
As
2009 Sep 19
3
sieve security problem
hi , anybody knows more about this ?
http://secunia.com/advisories/36698/
http://secunia.com/advisories/36629/
http://secunia.com/advisories/36713/
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
2007 Feb 13
2
lda quota in sql works but is ignored
Hi,
(dovecot latest vers)
i have lda deliver up with quota and sql,
but it seems that deliver simply ignores it,
normally it should bounce the message
deliver(tester at example.de): Feb 13 15:31:32 Info: auth input: gid=1001
deliver(tester at example.de): Feb 13 15:31:32 Info: auth input:
quota=dirsize:storage=3072000
deliver(tester at example.de): Feb 13 15:31:32 Info: Home dir not found:
2008 Jun 20
2
acl imap_capability ? 1.1.rc12
Hi all, is acl ( with acl plugin enabled )
anounced in imap_capability list by dovecot
i cant find it in telnet tests, so is it my fault or
is it default beavior using 1.1.rc12
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
2009 Aug 14
2
xtreemfs
Hi @ll,
has anybody tried this with dovecot yet ?
http://www.xtreemfs.org/
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
2008 Jul 11
2
dovecot 1.1.1 dbox public namespace problem
Hi @ll
i have somthing like
namespace public {
separator = /
prefix = "public/"
location = dbox:/usr/local/virtual/%d/public
inbox = no
list = yes
subscriptions = yes
hidden = no
}
which works nice if i set
location = maildir:/usr/local/virtual/%d/public
%d expansion works right with maildir
but if user mailboxes are on dbox with public namespace
too, dovecot
2008 Jul 13
3
folder deletion fails dbox
Hi Timo,
playing a lot with dbox
but folder deletion seems to me broken,
whatever setting i tested i cant delete subfolders
with thunderbird, i first thought about acls
but deactivate acl didnt helped
splitting control an index files from dbox also didnt work,
i cant find any failure message in the logs,
but there is also no entry for delete trys
all debug level are in the highest stage on this
2011 Feb 08
1
pop3 index virtual question
Hi @ll, Timo, on 2.0.9
i have a user reporting pop3 leaving mails on the server does not work
as desired
i have
namespace default {
# type = private
separator = /
prefix = ""
list = yes
# hidden = no
subscriptions = yes
}
namespace virtual {
# type = private
prefix = "virtual/"
separator = /
location = virtual:/etc/dovecot/virtual:LAYOUT=maildir++
#location