Displaying 20 results from an estimated 20000 matches similar to: "sqlite quota dict"
2009 Aug 19
1
expire plugin: columns not uniq
Hello list,
My dovecot setup have expire plugin enabled. It is working fine: new records added to database(sqlite), expire-tool successfully expunges old mail, but when expire-tool try to update database record for processed user, I get error in logs:
root at mail dovecot 0:0 # /usr/sbin/dovecot --exec-mail ext /usr/libexec/dovecot/expire-tool.sh --test
Info: koshikov.n at domain.com/Spam:
2013 Jul 12
0
A sqlite-based quota dict
Hello,
While experimenting with the sqlite backend, I noticed a big vacuum wrt its use for a quota dict.
This is thus an opportunity to share a solution I managed to devise after some trials and errors and a (very quick and unscientific) look at the code.
And also the opportunity to ask the community to check for possible flaws.
Yes, nothing comes for free... ;-)
TIA,
Axel
This is the SQL
2009 Jul 20
3
[Bug] dovecot deliver v1.2.1 segfaults
Hello list,
I have noticed strange dovecot behavior with exim system-filter.
I'm using exim+dovecot setup. My exim configuration have system filter enable, which restrict some attachments, like exe, vbs etc. When message with forbidden attachment received, exim accept the message, then construct bounce-message(Reject reason + original message) and returns it to sender. Trying to deliver such
2019 Feb 01
2
Crash when using dict quotas with sqlite database
Hello,
After I configured a SQLite backed dict quota backend, the dict process
crashes every time a quota operation is happening.
SQLite: 3.26.0
Dovecot: 2.3.4 (0ecbaf23d)
Linux: 4.20.4.a-1-hardened #1 SMP PREEMPT Fri Jan 25 01:24:51 CET 2019
x86_64 GNU/Linux (Arch Linux)
Filesystem: BTRFS
I can't get any debug output from Dovecot, even after setting log_debug
= cat:* event:* source:*
2019 Feb 03
0
Crash when using dict quotas with sqlite database
On 01/02/2019 20:40, Marcel Menzel wrote:
> Hello,
>
>
> After I configured a SQLite backed dict quota backend, the dict process
> crashes every time a quota operation is happening.
>
> SQLite: 3.26.0
>
> Dovecot: 2.3.4 (0ecbaf23d)
>
> Linux: 4.20.4.a-1-hardened #1 SMP PREEMPT Fri Jan 25 01:24:51 CET 2019
> x86_64 GNU/Linux (Arch Linux)
>
> Filesystem:
2019 Feb 03
0
Crash when using dict quotas with sqlite database
All I did was
??? - create a sqlite database with: # sqlite3 /tmp/storage.db (/run
only to test for perm issues in other folders)
??? - change it's owner to mail (that's the user owning the mail files):
# chown mail:mail /tmp/storage.db
??? - point dovecot to the file in "dovecot-dict-sql.conf.ext" with
"connect = /tmp/storage.db"
??? - enable quota in
2019 Feb 03
0
Crash when using dict quotas with sqlite database
...and then I found the commit I was looking for. It's fixed in https://github.com/dovecot/core/commit/ab80122c68bfe5c3dbae2b4d782f4181122710a1.patch
Aki
> On 03 February 2019 at 20:06 Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
>
>
> Can you try out the attached patch?
>
> Aki
>
> > On 03 February 2019 at 17:17 Marcel Menzel <mail at mcl.gg>
2019 Feb 03
2
Crash when using dict quotas with sqlite database
Can you try out the attached patch?
Aki
> On 03 February 2019 at 17:17 Marcel Menzel <mail at mcl.gg> wrote:
>
>
> All I did was
>
> ??? - create a sqlite database with: # sqlite3 /tmp/storage.db (/run
> only to test for perm issues in other folders)
>
> ??? - change it's owner to mail (that's the user owning the mail files):
> # chown mail:mail
2019 Feb 03
2
Crash when using dict quotas with sqlite database
Hello Aki,
Arch Linux doesn't have install-able debug symbols for Dovecot. That's
why I just compiled the package for myself with enabled debug symbols
(by editing the makepkg.conf).
I've attached the output from gdb's bt full.
- Marcel
Am 03.02.2019 um 14:45 schrieb Aki Tuomi:
> You need to install debug symbols. Not sure how this is done in arch
> linux though.
>
2019 Feb 03
2
Crash when using dict quotas with sqlite database
Hello John,
I tried (until now) to get a valuable backtrace, but it seems that GDB
can't resolve all symbols.
This is what systemd-coredump is giving me:
Stack trace of thread 22359:
#0? 0x0000638167eaf062 event_unref (libdovecot.so.0)
#1? 0x000004a58a212151 n/a (dict)
#2? 0x000004a58a211333 n/a (dict)
#3? 0x000004a58a20514d n/a (dict)
#4? 0x0000638167e556f2 dict_transaction_begin
2019 Feb 03
0
Crash when using dict quotas with sqlite database
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
You need to install debug symbols. Not sure how this is done in arch linux though.
</div>
<div>
<br>
</div>
<div>
Aki
</div>
<blockquote type="cite">
<div>
On 03 February 2019 at
2019 Feb 03
0
Crash when using dict quotas with sqlite database
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Right it was already in 2.3.4. Looking more closely this looks like use after free. We'll look into this.
</div>
<div>
<br>
</div>
<div>
Aki
</div>
<blockquote type="cite">
<div>
2019 Feb 03
2
Crash when using dict quotas with sqlite database
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Can you provide steps on how to reproduce this? Tracked as DOP-899
</div>
<blockquote type="cite">
<div>
On 03 February 2019 at 16:50 Aki Tuomi <
<a
2012 Jul 11
1
MySQL dict issues
Testing using the mysql dict for quota storage
(dovecot-2.0.12-2_127.el5), and ran into a couple issues. First is a
permissions issue:
dovecot: lmtp(26786, dude at test.tld): Error:
net_connect_unix(/var/run/dovecot/dict) failed: Permission denied
(euid=5000(<unknown>) egid=5000(<unknown>) missing +r perm:
/var/run/dovecot/dict, euid is not dir owner)
The file
2019 Feb 03
2
Crash when using dict quotas with sqlite database
Hello Aki,
unfortunately, this patch is already in my source files, as patch
refuses to apply it:
? -> Applying patch fix-sqlite.patch
patching file src/lib-sql/driver-sqlite.c
Reversed (or previously applied) patch detected!? Skipping patch.
2 out of 2 hunks ignored -- saving rejects to file
src/lib-sql/driver-sqlite.c.rej
I verified it by looking in the source code and indeed, this patch
2019 Feb 03
0
Crash when using dict quotas with sqlite database
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Can you try if applying
</div>
<div>
<br>
</div>
<div>
<a
2009 Oct 28
3
expire plugin + --exec-mail in 1.2.6 version
Hello list,
After upgrade to dovecot version 1.2.6 I have noticed some quota malfunctions(users become often overquota). Looking at logs closely I have found that quota value resets to general dovecot-config(
quota = maildir:Mailbox quota
quota_rule = *:storage=500M
quota_rule2 = Trash:storage=10%%
), after dovecot --exec-mail ext /usr/libexec/dovecot/expire-tool.sh command. The problem that
2014 Jul 08
1
Trigger for using an sqlite dictionary for quota
Hi,
I'm using Dovecot 2.0.9, and was trying to set up a dictionary process
to use an sqlite database for quota management.
The wiki page has examples for MySQL and PostgreSQL:
http://wiki2.dovecot.org/Quota/Dict
For sqlite, a trigger needs to be created to get it to work. But I was
not sufficiently skilled in sqlite to adapt the PostgreSQL trigger
(given on the above URL) for use. Nor
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 Jul 13
1
dovecot v1.2.1 expire-tool with mail_log enabled
Hello list,
Sorry, if it has been asked, but searching throught list not give possitive answers.
After upgrade to dovecot version 1.2.1 expire-tool stoped working. I have changed database format and config file to appropriative 1.2 version but:
expire-tool.sh fails with:
# dovecot -c /etc/dovecot/dovecot.conf --exec-mail ext /usr/libexec/dovecot/expire-tool.sh
Info: Loading modules from