similar to: Trigger for using an sqlite dictionary for quota

Hi, I've not found the answer to this question anywhere - please forgive me if I overlooked. I'd like to be able to be automatically alerted if process limits are hit (e.g. max POP3 logins). Is there a way that I can configure a script to be run, in the same way that I can with quota warnings? I can of course use logwatch, but this alerts me the next day, and logwatch can be noisy

I've set up Dovecot 2.0 with the expire plugin using an SQLite DB, and when mail is delivered via dovecto-lda, the DB gets updated as expected. However, when I use Thunderbird 3.1.2 for Mac OS X to move a message to any of the folders known to the expire plugin (e.g. the 'tmp' folder), the SQLite DB is not updated. Here is an excerpt of my current configuration: #

Hello Timo, and list followers, Sqlite supports good feature like mysql 'ON DUPLICATE KEY UPDATE' - it calls REPLACE/INSERT OR REPLACE This clause can be added to INSERT query, like: INSERT OR REPLACE INTO table VALUES() REPLACE INTO table VALUES() // alias to previous one Also this can be done during CREATE TABLE syntax, like so: CREATE TABLE quota ( username text not null, bytes

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

CentOS Errata and Security Advisory 2015:1634 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2015-1634.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 2764e452be02a51c8b3d271be95f244637de6d9bb673f767854cffe7bac683bb lemon-3.6.20-1.el6_7.2.i686.rpm

Hello, list! I am in the midst of configuring a new Dovecot IMAP server, and I'm preparing to setup shard mailboxes as part of the ocnfiguration. In order to get these setup the way I want, I've figured out that I'm going to have to setup an acl_shared_dict. This is where things start to get confusing for me, as I have had difficulty finding thorough explanations of dictionary

Bear with me, this is CentOS related. :) I have a python CGI that's behaving weirldy on Whitebox systems that've been switched over to CentOS 4 (ages ago, no other problems to speak of aside from this one). I've broken the problem down to a minimal test case... 1. Create a small database # sqlite3 /tmp/testcase.db 'CREATE TABLE testtable ( date date primary key unique, name

I''ve been editing a rails app on Windows for a little while now. I just checked it into source control and started editing on my iMac. Everything seems to run normally, except that when I attempt to modify the database in any way (I''m running sqlite), I get a weird error: "cannot start a transaction within a transaction"

Dear list, i have installed SQLiteDF (and SQlite 3.5.3 too) After the suggested dataframe generation iris.sdf <- sqlite.data.frame(iris) i have close R and than restart it for verify the correct load of dataframe : the file data1 is saved in the usual folder .SQLiteDF after the command : attachSdf("c:/R/Report/.SQLiteDF/data1.db","iris.sdf") R give this error

CentOS Errata and Bugfix Advisory 2013:1091 Upstream details at : https://rhn.redhat.com/errata/RHBA-2013-1091.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) i386: 96179f02c850f97259618f1dd3a80cc6d12b80660625dcbd6e089ccf51e50d6c sqlite-3.3.6-7.i386.rpm d78c3b102a7508754ecb5052b1da6a86de47a7b23590e3eef56164d9f3b74566

CentOS Errata and Security Advisory 2015:1635 Moderate Upstream details at : https://rhn.redhat.com/errata/RHSA-2015-1635.html The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: 172f48aba58c71b0a3c41bd8c0a459ec91a8b01f619cf118c4e64549b7e6776b lemon-3.7.17-6.el7_1.1.x86_64.rpm

CentOS Errata and Security Advisory 2020:0227 Important Upstream details at : https://access.redhat.com/errata/RHSA-2020:0227 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: 4e7b3e26e7960631fa1b70b58d3d363b51b0f9bee514cdd277c377750d976dd1 lemon-3.7.17-8.el7_7.1.x86_64.rpm

CentOS-5.7 SQLite-3.6.6 Ruby on Rails 3.1 Ruby-1.8.7 I have a situation wherein the version of SQLite-3 on CentOS-5 is too 'old' for the Ruby language sqlite3 DBMS adapter to successfully build against. I managed to obtain an rpm for ruby-1.8.7 but I cannot find one for sqlite-3.6.16 or later. Does anyone here have a lead on where such a beast, including the sqlite development headers,

Is there any reason (besides upstream does it) to compile php5 with --without-sqlite in CentOS5 ? Would it conflict with the sqlite that yum needs? Is there a repo (centosplus, rpmforge...) having a php5 and sqlite enabled ? I can only find older mails that seem to imply it does not harm to include sqlite (and some which seem to imply the contrary as well, but without any facts) but I can find

I've got a CentOS 6.1 x86_64 VM running atop CentOS 6.1 x86_64 KVM host. The VM is in production, so any fix needs to be fairly non-intrusive. In the VM, yum consistently segfaults when reading non-base repositories. The problem appears to be related to the faulty creation of /var/cache/yum/x86_64/<<reponame>>/primary.xml.gz.sqlite The latest installment of this problem

I believe that Asterisk 1.8 and older uses the BerkeleyDB for Asterisk's internal database (AKA the Astdb) and in newer versions use SQLite. However, the basic functionality is the same. Whether you use the Astdb or MySQL really depends on what you want to do with it. The AstDB is not a relational database like MySQL, it simply a key/value store. If you can get away with that, and you need

Hello, I will use expire like described within wiki2.dovecot.org/Plugins/Expire with sqlite for a folder AutoCleanSpam. If I copy a message (with TB) into that folder, I get an error if there exists no entry for that user and that folder within the database: dict: Error: sqlite: exec(INSERT INTO expires (expire_stamp,username,mailbox) VALUES

How can I change SQLite cache size for R session? SQLite cache size can be set by a pragma, for the duration of the session - or by default. .pragma cache_size .pragma default_cache_size my questions are about RSQLite, version 0.4, running on Windows: - what is the cache size set to when SQLite is invoked from R? - if the page_size is set to 4096 what will be the cache size in bytes

Hi all, I'm updating a customised CentOS 5.2 repo to 5.4. After running createrepo, I find all the usual .xml.gz files updated, but the sqlite.bz2 files have not been touched. What is the significance of these files? If they need to be updated, how is it done? -r--r--r-- 1 user group 1811 Oct 1 2009 TRANS.TBL -rw-r--r-- 1 user group 1050329 May 12 11:04 comps.xml -rw-r--r-- 1 user

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