Aleksander wrote:
Jonathan Feally wrote:
snip
As far as getting what your want done, I would suggest using a script
driven via cron every half hour or so.
Yes, I know of such a possibility but there's always the chance, that
the user deletes the mails before the cron shedule. And you
On Fri, 2005-02-11 at 11:01, Aaron Stone wrote:
On Fri, Feb 11, 2005, Hans Kristian Rosbach [EMAIL PROTECTED] said:
[snip]
2. We can use a tempfile
Now, this would lead to more database calls depending on block size
and it would probably lead to worse performance.
So wait -- the
Hello,
I agree fully with Paul. There are a lot of things to develop within
DBMail. MTAs are well documented and have done aliasing well for many
years, the MTAs also communicate with a lot of databases for alias lookup.
Is it really worth the effort to develop the aliasing in dbmail, with all
Aaron Stone wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] said:
Just want to add my take on this subject. It's related to the IMAP
access control but more in a global way and not on a per-user basis.
It would be real nice if there was a way to disable IMAP search
capability within dbmail
Jesse Norell wrote:
SELECT DISTINCT(physmessage_id) FROM dbmail_messageblks WHERE
messageblk LIKE '%Aaron%';
19066 rows in set (12.81 sec)
So it takes about 35% of the time, but returned 190% of the rows. We'll
have to combine this time trial with the header parser to see which adds
more
Hans Kristian Rosbach wrote:
Well, this sucks.. But I guess it's nice for IMAP users. But does
people actually copy messages that much? I've never done so myself,
and I don't really see any big use for it. In my openion it is not
worth it to make everything else slow and complex in order to
As has been mentioned elsewhere in this mail discussion,
We want a robust solution without upgrading scripts. The
application should take care of speed improvements.
What about placing all the headers in a RAM table type, dbmail
builds this table at startup. The content in this table should
Hello list,
I stumbled on the failure to deliver mail to external recipients,
when the local user was over quota.
Is dbmail the correct place to do the alias expansion?
Shouldn't this be done better in the MTA?
Postfix and Sendmail supports connection with some work to both
postgreSQL and
Ilja Booij wrote:
On Tue, 14 Sep 2004 16:47:37 +0200, Magnus Sundberg
[EMAIL PROTECTED] wrote:
Hello list,
I stumbled on the failure to deliver mail to external recipients,
when the local user was over quota.
Is dbmail the correct place to do the alias expansion?
Shouldn't this be done
You can implement this in the MTA.
One way is to have one server for receiving all SMTP traffic.
This server has each user defined as a mailinglist in the
aliasfile. My aliasline would look like
magnus: [EMAIL PROTECTED], [EMAIL PROTECTED]
Magnus
Barak Bejerano wrote:
Hi List.
I was
Hi,
Is Seive unsuitable for implementation of vacation? Why?
Magnus
Paul J Stevens wrote:
Ilja Booij wrote:
Good idea about the database structure having to be fixed before 2.0.
We should compile a list of features that auto replies should have.
I'm not too familiar with the features of
Hi,
From what I have read is MySQL cluster really fast. It is geared
toward telecom applications. There is only one drawback, the
complete database currently resides in the computer RAM.
Magnus
Christian G. Warden wrote:
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
If you want
Well,
I beleive a flag on the messageblock would be a good start, since
it is not that intrusive.
But I am very unsusre about how much performance we would gain by
searching directly in heavily optimized fast-header tables. Is
the pain worth the gain?
Small installations do not need the extra
Well,
I like your idea, but why not fill the title table automagically
as you find new headers? Then you don't need the title_id 3 in
your example.
But I am still not sure how much the performance gain is by
putting it into separate tables compared to searching on the
message blocks.
Ilja Booij wrote:
Hi,
MySQL = 4.0.14 does not seem like very bad thing to require.
Of course, we're using debian stable here, which still has 3.23.x as its
MySQL version.. But that shouldn't be too much of a problem :). We could
just install from source or the binary tarballs at mysql.com
Ilja Booij wrote:
well, after some more reading, I guess it's a bit different:
IMAP RFC3501 takes no position on case sensitivity in mailbox names. So,
we can support either case sensitive or case insensitive mailbox names.
Currently, mailboxes are case sensitive when using PostgreSQL, and
Kaspersky anti-virus contains an LMTP communication port.
You can probably design a delivery chain like
postfix--LMTP--kaspersky--LMTP--DBmail-lmtp
/Magnus
Roel Rozendaal - ICS wrote:
Op 6-feb-04 om 22:25 heeft Rene Bartsch het volgende geschreven:
I thought DBmail would provide a complete
Jesse Norell wrote:
Hello,
Probably the best place to rebuild the header cache (because
you added more headers you're interested in or whatever other
reason) would be with dbmail-maintenance. The message injectors
would keep it up to date for new messages, of course.
One thing you need to
Brian Blood wrote:
Perhaps if we started with a few really basic headers to base the
implementation on, then peope could extend it on their own past there.
Like From: and Subject:
Actually, now that I think about this, shouldn't these headers just be added
into the messages table?
How
Matthew T. O'Connor wrote:
I don't think this will work well. I think you will wind up with alot
of headers that you don't want, which translates to a lot of unnecesary
work for the mail injectors. 95% of the time you just need the basic
headers, every once in a while you want to search
Mark Mackay - Orcon wrote:
Suppose we stored the headers in a separate table and used the
database indexing facilities.
We could then do without a separate header cache, by just using
well formulated queries.
I did that previously, and the speed hit was quite profound each time
someone did
One silly question,
How do we know which headers to cache?
The headers are stored in the first messageblock in for the message.
Suppose we stored the headers in a separate table and used the
database indexing facilities.
We could then do without a separate header cache, by just using
well
Bill Hacker wrote:
Aaron Stone wrote:
Writing an MTA something like opening Pandora's box. Well, except that
Pandora's box will ravage humanity quickly and if you survive that,
you're OK.
snip
The problem that I have with DBMail goes beyond inaccurate (dare I say
broken?) Postgresql setup
Bill Hacker wrote:
Magnus Sundberg wrote:
snip
What about a standard package like postfix-dbmail, that depends on
both postfix and dbmail for this or that distribution? Which contains
the `manual´ changes you need to do to the configuration files.
Still incomplete. I want the full set
Isn't sieve a solution to this?
/Magnus
Christian G. Warden wrote:
On Fri, Nov 21, 2003 at 01:19:56PM +0800, Bill Hacker wrote:
That is a whole lot easier to implement that the approach I just posted.
But may have to be re-implemented as the external MTA or toolsets change..
- It also tends
Christian G. Warden wrote:
A database can perform well at easier tasks too. In my experience,
dbmail is already faster at updating a large folder than uw-imapd with
mbox. Ilja's recent changes make copying messages very fast. If we
index some of the headers, we can also get improved
Christian G. Warden wrote:
Headers are already stored in their own messageblk. Simply adding a
header flag to messageblks would allow selecting multiple headers in a
single select. We've talked about actually storing common headers,
such as To, From, Subject, Date, etc. in their own fields.
Eric Soroos wrote:
Why can't you store the msg_block fingerprint in the msg_block table?
Like (with mysql syntax)
CREATE TABLE messageblks (
messageblk_idnr bigint(21) NOT NULL auto_increment,
physmessage_id bigint(21) NOT NULL default '0',
messageblk longtext NOT NULL,
Eric Soroos wrote:
You can. That's effectively what I was doing in my message, except
that you're not seeing it in the messageblk view. You probably don't
want a unique constraint on messageblk, since the idea of the
fingerprint is that it's a 1:1 mapping of the messageblk down to 128
bits.
Eric Soroos wrote:
On Nov 20, 2003, at 8:28 AM, Magnus Sundberg wrote:
Eric Soroos wrote:
You can. That's effectively what I was doing in my message, except
that you're not seeing it in the messageblk view. You probably
don't want a unique constraint on messageblk, since the idea
Eric Soroos wrote:
I believe your choice is better, in that, it requires many less
changes to
the underlying db_ methods, so I'll back mine out and proceed with
yours. I
may need one new db_ method to add a user mailbox to an existing message.
I think there's a way to do this entirely
Chris Mason wrote:
On Thu, 2003-10-16 at 10:15, Matthew T. O'Connor wrote:
On Thu, 2003-10-16 at 09:57, Chris Mason wrote:
Ok, here's a patch for dbmail 1.2 cvs that implements the transaction
begin/commit for mysql during pipe.c:insert_messages, and the imap
copy/append message commands.
Hi,
I remember a discussion earlier about new database scheme and
public folders.
I am still a bit curious.
/Magnus
Paul J Stevens wrote:
Ilja,
I've just build and uploaded experimental debian packages for dbmail-2
deb http://debian.nfgd.net/debian experimental/
packages:
dbmail-mysql
dbmail-pgsql
dbmail-mysql-ldap
dbmail-pgsql-ldap
Maybe a silly idea; Would it be feasable to implement the database and
Christian G. Warden wrote:
Dbmail works fine with exim too, and I am having exim do alias expansion
because I prefer to not have dbmail generate new messages.
Dbmail should remain mta agnostic, but of course, there could be a
recommended setup.
Well it was something along the line about a
Hi,
John Kyle wrote:
I would like to use a spam filter with dbmail, I was wondering if anyone has
any links to any open source spam filters and if / how they have set them up
with dbmail.
You know, there are plenty of spam filtering applications to use
together with postfix MTA (Mail Transfer
Try looking for spamassasin
http://www.spamassassin.org/index.html
/Magnus
John Kyle wrote:
I am using postfix, can you recommend an open source spam filtering system
for this?
Best Regards
John Kyle
- Original Message -
From: Magnus Sundberg [EMAIL PROTECTED]
To: dbmail@dbmail.org
Hello,
I agree about splitting the message into parts that fit MIME/POP
standard queries. This will speed up the database.
Is there any alysis done on the mail system database query types?
Do we have any data on the typical message size?
The subject of storing part of the message as a file
Gianni Mariani wrote:
lou wrote:
snip
b) dbmail could also use stored procedures in Postgresql. This
would eliminate a bunch of processing on the server.
[...]
why? it will break portability with other servers like mysql. Also
that means all the
load to be pushed to the database
Hi,
As stated earlier in some communication on this list.
The SMTP server only accepts SMTP connections for local delivery!
You could/should instead configure the DBMAIL server to listen to
another port than 25.
You could then run sendmail/postfix on the same host and instead of
sending mail
OK,
I think I understand what you are aiming for.
But how do I configure my mail clients.
Usually you have your sendmail SMARTHOST that routes all the mail.
Then you have the sendmail NULLCLIENT Configuration on all the mail
clients, that route all the mail to the SMARTHOST for further delivery
Hi,
It is on the roadmap that has been discussed earlier this month
/Magnus
http://mailman.fastxs.net/pipermail/dbmail/2003-April/002662.html
Jacques Beaudoin wrote:
Why are all thoses mysql indexes not created in
the dbmail cvs package
Jacques
Paul Stevens a écrit :
Aaron Stone wrote:
Hello Jeff,
From your database design it looks like that you change the
mailbox_idnr record in the messages table when you move mail from one
mailbox folder to another. I hope this is possible at least by the IMAP
protocoll?
The problem as I see it is the relational database structure
Exchange servers,
Running Exchange servers in big corporations is from the user
perspective quite nice.
If you want to send a mail to me from the outlook client, you just type
`Magnus Sundberg´ in the adresse field. Outlook then automagically looks
up my name from the server
Aaron Stone wrote:
Magnus has an important point: don't check for an OS, check for what its
behavior is. I believe that in this case, we're talking about activating
parts of a system-dependent header with this flag. That the flag is system
dependent is not at issue; it's how we test that.
If
Hi,
Is this really whise?
I remember the old time when you should compile emacs. You had to look
in the README file and change something in a configuration file with a
text editor and then write make.
A few years later, the way of compiling emacs was
./configure
make
Where the configure script
. This includes all mailboxes.
Any suggestions on how to scan the messages in the dbmail database?
regards,
Magnus Sundberg
Well,
Server side scanning is the preferred method. But I can still get
viruses into your database since the virus is not contained in the virus
scanners database, there are a lot of reasons to this, including the
human factor(=administrator error).
I do remember Melissa and others. These
48 matches
Mail list logo