:) Another thing, the content of add_filter_tables.* file shouldn't be in the migration script from 2.3.5 to 2.3.6? People may not know that they have to execute that.
Or the ideia you had was, if people want to use global filters, add that content? > -----Original Message----- > From: [email protected] [mailto:dbmail-dev- > [email protected]] On Behalf Of Paul J Stevens > Sent: sexta-feira, 30 de Janeiro de 2009 22:54 > To: DBMAIL Developers Mailinglist > Subject: Re: [Dbmail-dev] [SCM]Paul's DBMail tree branch, master, > updated. becf2ef1cd8c7bea77a4c37dbdd4956f73643a70 > > > The mailbox will be created and subscribed during delivery through a > pipe (dbmail-deliver), as well as through lmtp. Normal rules apply. > > Good point though. Delivery through dbmail-deliver -m should not be > passed through this filter. Will fix. > > > Jorge Bastos wrote: > > Paul, > > For the global scripts, when a fileinto is set, and the users doesn't > have > > the mailbox, what will happen, the operation stay's with no effect? > > > > Just curius. > > > >> -----Original Message----- > >> From: [email protected] [mailto:dbmail-dev- > >> [email protected]] On Behalf Of Paul J Stevens > >> Sent: sexta-feira, 30 de Janeiro de 2009 22:40 > >> To: DBMAIL Developers Mailinglist > >> Subject: Re: [Dbmail-dev] [SCM]Paul's DBMail tree branch, master, > >> updated. becf2ef1cd8c7bea77a4c37dbdd4956f73643a70 > >> > >> This changeset adds two interesting new features: > >> > >> - single-instance header storage. The migration will flush out > >> all cache tables - except envelopes. These will need refilling with > >> dbmail-util -by. > >> > >> - sql-based 'file-into' style delivery filter. Filters assigned to > the > >> 'anyone' user are globally applied. For now, this feature has it's > own > >> migration script. > >> > >> happy testing. > >> > >> > >> Paul J Stevens wrote: > >>> This is an automated email from the git hooks/post-receive script. > It > >> was > >>> generated because a ref change was pushed to the repository > >> containing > >>> the project "Paul's DBMail tree". > >>> > >>> The branch, master has been updated > >>> via becf2ef1cd8c7bea77a4c37dbdd4956f73643a70 (commit) > >>> via 6b31363bccc1c76718853eb5cea6b683950c477a (commit) > >>> via bc3f6239665c34dbb83c8b25a21ba71d3daec943 (commit) > >>> via 64fbf547597a0a249cb5658ba642e5062beec2b7 (commit) > >>> via 7552bc38e85502662776de5b86fc915690f9cb66 (commit) > >>> via 7d8fb32be589cb4baeede2749b80a444805a3a06 (commit) > >>> via 2c324ba40459f8ffd31a6efc71ea5d9e062bb018 (commit) > >>> via b695e9b64d6c4e87fdd9573fd1556048130fa341 (commit) > >>> via d38261c3fe797ce3b3e8432f1f009d64b5ddaabf (commit) > >>> via ba65a86bf5772cf881afe5d5a4be7e6e5901a495 (commit) > >>> via 42eaa2808f03ed77c27b17f99b0e6ea17ca027f1 (commit) > >>> via a2f90b05ff88ac863e0e02e605c787f252cd25ab (commit) > >>> from e0101f6faae6c5e09dfb164d76370103b322be83 (commit) > >>> > >>> Those revisions listed above that are new to this repository have > >>> not appeared on any other notification email; so we list those > >>> revisions in full, below. > >>> > >>> - Log ------------------------------------------------------------- > -- > >> -- > >>> commit becf2ef1cd8c7bea77a4c37dbdd4956f73643a70 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Fri Jan 30 19:44:11 2009 +0100 > >>> > >>> merge filter branch > >>> > >>> commit 6b31363bccc1c76718853eb5cea6b683950c477a > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Wed Jan 28 17:19:55 2009 +0100 > >>> > >>> fix single-instance-storage for pgsql > >>> > >>> commit bc3f6239665c34dbb83c8b25a21ba71d3daec943 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Tue Jan 27 21:46:31 2009 +0100 > >>> > >>> fixes missed edit in query > >>> > >>> commit 64fbf547597a0a249cb5658ba642e5062beec2b7 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Tue Jan 27 17:05:42 2009 +0100 > >>> > >>> minor edit > >>> > >>> commit 7552bc38e85502662776de5b86fc915690f9cb66 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Tue Jan 27 16:50:21 2009 +0100 > >>> > >>> add sqlite migration > >>> > >>> commit 7d8fb32be589cb4baeede2749b80a444805a3a06 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Tue Jan 27 16:25:24 2009 +0100 > >>> > >>> add mysql migration > >>> > >>> also rename the postgresql migration, and leave the > >> dbmail_headername > >>> table intact > >>> > >>> commit 2c324ba40459f8ffd31a6efc71ea5d9e062bb018 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Tue Jan 27 15:40:18 2009 +0100 > >>> > >>> fix typo > >>> > >>> commit b695e9b64d6c4e87fdd9573fd1556048130fa341 > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Tue Jan 27 15:18:06 2009 +0100 > >>> > >>> update single instance header storage > >>> > >>> cleanup migration > >>> add hash digest to quickly lookup headervalues > >>> > >>> commit d38261c3fe797ce3b3e8432f1f009d64b5ddaabf > >>> Author: Niki Guldbrand <[email protected]> > >>> Date: Sun Jan 25 15:25:57 2009 +0100 > >>> > >>> WIP: Fixup the migration script. > >>> > >>> During conversion of my setup, I noticed that during > >>> migration of my own setup. > >>> > >>> commit ba65a86bf5772cf881afe5d5a4be7e6e5901a495 > >>> Author: Niki Guldbrand <[email protected]> > >>> Date: Sun Jan 25 13:03:48 2009 +0100 > >>> > >>> WIP: Fixed up headervalue storage. > >>> > >>> The header values was stored multiple times. > >>> > >>> commit 42eaa2808f03ed77c27b17f99b0e6ea17ca027f1 > >>> Author: Niki Guldbrand <[email protected]> > >>> Date: Sat Jan 24 22:30:00 2009 +0100 > >>> > >>> WIP: Adding single instance header storage. > >>> > >>> This patch adds single instance storage for headers, > >>> in an attempt to save storage space, and to make > >>> lookups faster (Based on a request/idea from > >>> Michael Monnerie). > >>> > >>> At this time storage of new mail is working, > >>> fetching af headers is working, and > >>> dbmail-util -ay will fill the tables with data. > >>> > >>> NOTE: Only tested on postgres 8.3 so far. > >>> > >>> commit a2f90b05ff88ac863e0e02e605c787f252cd25ab > >>> Author: Paul J Stevens <[email protected]> > >>> Date: Fri Jan 30 10:14:02 2009 +0100 > >>> > >>> add large file support on 32bit systems > >>> > >>> this will allow dbmail-export to handle mailboxes > >>> larger than 2 GB > >>> > >>> ------------------------------------------------------------------- > -- > >> -- > >>> Summary of changes: > >>> doc/README.filters | 40 +++++++ > >>> sql/mysql/2_3_5-2_3_6.mysql | 41 ++++++++ > >>> sql/mysql/add_filter_tables.mysql | 13 +++ > >>> sql/mysql/create_tables.mysql | 38 ++++--- > >>> sql/postgresql/2_3_5-2_3_6.pgsql | 46 +++++++++ > >>> sql/postgresql/add_filter_tables.pgsql | 12 ++ > >>> sql/postgresql/create_tables.pgsql | 40 ++++--- > >>> sql/sqlite/2_3_5-2_3_6.sqlite | 175 > >> ++++++++++++++++++++++++++++++++ > >>> sql/sqlite/add_filter_tables.sqlite | 57 ++++++++++ > >>> sql/sqlite/create_tables.sqlite | 120 ++++++++++++++------ > -- > >>> src/dbmail-imapsession.c | 15 ++-- > >>> src/dbmail-mailbox.c | 43 ++++---- > >>> src/dbmail-message.c | 175 > >> +++++++++++++++++++++++++++++--- > >>> src/dbmail.h.in | 2 + > >>> src/dm_db.c | 25 +++-- > >>> 15 files changed, 714 insertions(+), 128 deletions(-) > >>> create mode 100644 doc/README.filters > >>> create mode 100644 sql/mysql/2_3_5-2_3_6.mysql > >>> create mode 100644 sql/mysql/add_filter_tables.mysql > >>> create mode 100644 sql/postgresql/2_3_5-2_3_6.pgsql > >>> create mode 100644 sql/postgresql/add_filter_tables.pgsql > >>> create mode 100644 sql/sqlite/2_3_5-2_3_6.sqlite > >>> create mode 100644 sql/sqlite/add_filter_tables.sqlite > >>> > >>> > >>> hooks/post-receive > >>> -- > >>> Paul's DBMail tree > >>> _______________________________________________ > >>> Dbmail-dev mailing list > >>> [email protected] > >>> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > >>> > >> > >> -- > >> ________________________________________________________________ > >> Paul Stevens paul at nfg.nl > >> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > >> The Netherlands________________________________http://www.nfg.nl > >> _______________________________________________ > >> Dbmail-dev mailing list > >> [email protected] > >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > _______________________________________________ > > Dbmail-dev mailing list > > [email protected] > > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
