[Dbmail] Typo in INSTALL

2003-03-04 Thread Matthew T. O'Connor
Hello, I'm just getting started trying out dbmail. I have been looking for just such an application for a while, so I'm excited to use it. On to the typo: I was following the directions to setup the postgresql database and this line is wrong: psql -U dbmail dbmal < sql/postgresql/create_tables.p

[Dbmail] TRACE and Performance

2003-03-05 Thread Matthew T. O'Connor
. Especially for a stable release. I could understand keeping the settings high in CVS, but not in a release. Thanks Matthew T. O'Connor

[Dbmail] Procmail

2003-03-05 Thread Matthew T. O'Connor
message sorting that happens at delivery time. Thanks much, Matthew T. O'Connor

Re: [Dbmail] Procmail

2003-03-06 Thread Matthew T. O'Connor
t create mailboxes > automagically. Unless you > run a dbmail installation patched to do this. Vanilla 1.1 doesn't > autocreate mailboxes. > > > > Matthew T. O'Connor wrote: > > >My current mail setup (not dbmail which I am still learning) uses > >pr

Re: [Dbmail] mysql or postgresql

2003-03-08 Thread Matthew T. O'Connor
I am very surprised to think that you would actually need to vacuum that often. More likely, you need to just do an analyze to keep the statistical information for the tables up to date, and only vacuum a few times a day. On Friday 07 March 2003 15:59, Eelco van Beek - IC&S wrote: > We're runni

[Dbmail] Fw: From Display Problems

2003-03-14 Thread Matthew T. O'Connor
st Anyone else see this before? Anything I can do? Is it a config problem, or a bug in dbmail. Thanks much, Matthew T. O'Connor

Re: [Dbmail] DBmail v1.1 takes 90% CPU - SOLUTION

2003-03-28 Thread Matthew T. O'Connor
ZprávaNot trying to start a pg/mysql flame war here but I know everyone says mysql outperforms postgres, but is this still true if you enable innodb and isam? Is postgres faster than mysql when innodb and isam are enabled? Anyone know of some benchmarks making this comparison? Most of the

Re: [Dbmail] DBmail v1.1 takes 90% CPU - SOLUTION

2003-03-30 Thread Matthew T. O'Connor
Not true, postgres never suffered that limitation since it always has (and still does) split files at the 1GB mark. So postgres can have tables well in excess of 2GB even on kernels that do not support large files. As for the mysql test tools, I know postgres used to have a problem running the cr

Re: [Dbmail] More on the bizzare '@@' problem

2003-04-04 Thread Matthew T. O'Connor
On Fri, 2003-04-04 at 10:25, [EMAIL PROTECTED] wrote: > Hi, > > I've solved the problem. Dbmail tranfered the email address using the from > (username) (@domain) > instead of > (username) (domain) > > The patch to imaputil.c is very simple. Will this also solve the problem I reported a few weeks

Re: [Dbmail] dbmail-smtp "recipes"

2003-04-15 Thread Matthew T. O'Connor
Not sure if this is what you mean, but I use Redhat, and the default sendmail config is to use procmail to do the local message delivery. So in testing out dbmail, all I did was add to my procmail config file to use procmail to deliver mail. A procmail entry that uses dbmail looks like this: :0

Re: [Dbmail] Postgresql errors

2003-04-22 Thread Matthew T. O'Connor
On Mon, 2003-04-21 at 16:30, Paul Stevens wrote: > Christopher Petrilli wrote: > > I just converted from MySQl to PostgreSQL for DBMail v1.1, and I'm going > > to write up some things on the conversion, because it didn't go smoothly > > on a FreeBSD box. > > Hi Christopher, > > I hope you do. A

[Dbmail] Status of DBMail CVS

2003-06-06 Thread Matthew T. O'Connor
I'm getting ready to install dbmail for a client. I am wondering what the general consensus is about using dbmail from CVS right now. Is it stable? I know there have been a lot of changes since 1.1. I use dbmail 1.1 and it works but I have some issues where email addresses don't display correct

Re: [Dbmail] Status of DBMail CVS

2003-06-06 Thread Matthew T. O'Connor
te, none of the above seem to happen > with Mozilla Mail, KMail or Evolution or any webmail system I've set up. > > Hope this is of some help. > > All debate welcome! > > Regards, > > Chris > > Matthew T. O'Connor wrote: > > >I'm getting ready

Re: [Dbmail] CVS update: weird From: names

2003-06-08 Thread Matthew T. O'Connor
YEAH Roel, I just updated from cvs, recompiled and things are better. I tested with OE and while there are still some issues (quoting and the like) the "weird From: names" showing the time problem is fixed.Thank you! BTW, what is the best way to get small things fixed? For example when

Re: [Dbmail] CVS update: weird From: names

2003-06-09 Thread Matthew T. O'Connor
Sorry put the ^^^'s in the wrong place, should have read: > psql -U dbmail dbmal < sql/postgresql/create_tables.pgsql ^ > which should read: > > psql -U dbmail dbmail < sql/postgresql/create_tables.pgsql ^

Re: [Dbmail] Deleting a users does not delete is messages

2003-06-17 Thread Matthew T. O'Connor
> If i delete a user is aliases are not deleted thats not a big problem i > just delete via a script is aliases (dbmail-aduser c user -a aliases) > before i delete that user. > > But what about is old mailboxes and messages in the > mailboxes, messages, messageblks tables. I would think this is be

Re: [Dbmail] Nice tool to clean unconnect alias

2003-06-18 Thread Matthew T. O'Connor
Again this issue would be solved with referential integrity constraints setup. When an account is removed all associated data (mailboxes, aliases, messages, message_blks etc...) would be removed at the same time without any workarounds and extra code. > Hi. I have a nice workaround to the unconne

Re: [Dbmail] Deleting a users does not delete is messages

2003-06-18 Thread Matthew T. O'Connor
hand, it wouldn't take a lot of code or any significant >> overhead to run a few queries to see what the user has in the >> database. Further, I believe that in a data-destroying operation >> like this, there should be a warning message by default and a >> --force option

Re: [Dbmail] HELP : DBMAIL error on Outlook Express for Mac OS/X

2003-07-02 Thread Matthew T. O'Connor
On Wed, 2003-07-02 at 07:33, lou wrote: > Magnus, > all this sounds great, that means the codebase will create a barrier between > both APIs also a gap which will limit the whole idea for one generic API, > which would save time and resources writing more code and more code and more > code.. Do

Re: [Dbmail] HELP : DBMAIL error on Outlook Express for Mac OS/X

2003-07-02 Thread Matthew T. O'Connor
On Wed, 2003-07-02 at 10:50, Jesse Norell wrote: > I think that last idea, the whole message in one record, is > probably not a good idea on postgres because of the way it handles > updates and free space. Every time you update a message (set seen > flag, change status, etc... happens numerous t

Re: [Dbmail] HELP : DBMAIL error on Outlook Express for Mac OS/X

2003-07-03 Thread Matthew T. O'Connor
On Wed, 2003-07-02 at 11:44, Jesse Norell wrote: > With upcoming schema changes (cached headers, etc.), it'd > probably be worth stepping back and looking at the best way to > handle message storage, and see what improvements can be made. > Even something as simple as a messageblk flag as to whet

Re: [Dbmail] HELP : DBMAIL error on Outlook Express for Mac OS/X

2003-07-03 Thread Matthew T. O'Connor
On Thu, 2003-07-03 at 09:39, Magnus Sundberg wrote: > The subject of storing part of the message as a file has been > covered a couple of months before. > > I strongly beleive that we shall follow the path of improving > functionality and keeping the source code as clean and simple as > possible

Re: [Dbmail] HELP : DBMAIL error on Outlook Express for Mac OS/X

2003-07-03 Thread Matthew T. O'Connor
On Thu, 2003-07-03 at 05:28, Gianni Mariani wrote: > Matthew T. O'Connor wrote: > >Where is the schmea changes are being discussed? I haven't seen any > >mention of it anywhere, I would like to be part of the discussion. > > > >A quick design: perhaps somethin

Re: [Dbmail] HELP : DBMAIL error on Outlook Express for Mac OS/X

2003-07-04 Thread Matthew T. O'Connor
From: "Aaron Stone" <[EMAIL PROTECTED]> > The reason for a new headers table is not so that the headers are taken > out of the messageblks table, but rather because we want some of those > headers to be pulled out and stored in columns of their own. > > The new table would have just a messageid and

Re: [Dbmail] feature solicitation

2003-10-11 Thread Matthew T. O'Connor
Personally, I think all dbmail configuration information should be stored in the database, the only exception being, bootstrap info required to connect to the database. - Original Message - From: "Jesse Norell" <[EMAIL PROTECTED]> To: Sent: Friday, October 10, 2003 2:55 PM Subject: [Dbma

Re: [Dbmail] PostgreSQL tables.

2003-10-14 Thread Matthew T. O'Connor
From: "Ted Rolle" <[EMAIL PROTECTED]> > Ilja: fix the tables for PostgreSQL perhaps ? > > That would be nice. :-> Would you mind elaborating on this pleaes? Fix the tables is not very instructive or helpful. Matthew

Re: [Dbmail] Wow 1.2 is nice but found a few things.

2003-10-15 Thread Matthew T. O'Connor
On Wed, 2003-10-15 at 09:37, Patrick Giagnocavo +1.717.201.3366 wrote: > I think that (depending on PG version) adding a primary key will > create a unique index on that field. A primary key has to be unique, > so creating a unique index enforces that requirement. It is, when you make a column a

Re: [Dbmail] Wow 1.2 is nice but found a few things.

2003-10-15 Thread Matthew T. O'Connor
On Wed, 2003-10-15 at 09:25, Paul J Stevens wrote: > Caveat: I'm no sql guru. > Rule of thumb: all fields used in where clauses should be indexed. Not exactly true... Every time you create an index it slows down inserts and updates (again something that will be helped with the new phy_message tab

Re: [Dbmail] Wow 1.2 is nice but found a few things.

2003-10-15 Thread Matthew T. O'Connor
From: "Jesse Norell" <[EMAIL PROTECTED]> > Having said that, I think it was dbmail-smtp performance we > improved by removing those indexes (ie. because the database doesn't > have as many indexes to maintain). I think we did do some optimizing > for pop3 too, though, but I don't know that it (i

Re: [Dbmail] Wow 1.2 is nice but found a few things.

2003-10-15 Thread Matthew T. O'Connor
From: "Jesse Norell" <[EMAIL PROTECTED]> > Having said that, I think it was dbmail-smtp performance we > improved by removing those indexes (ie. because the database doesn't > have as many indexes to maintain). I think we did do some optimizing > for pop3 too, though, but I don't know that it (i

Re: [Dbmail] Wow 1.2 is nice but found a few things.

2003-10-16 Thread Matthew T. O'Connor
On Wed, 2003-10-15 at 17:12, Eelco van Beek - IC&S wrote: > none of the dbmail processes does a DELETE. Only maintenance does that True, but it does do an update to the messages table, which is worse. An update is equivalent to performing a delete and an insert (I think).

RE: [Dbmail] dos attack

2003-10-21 Thread Matthew T. O'Connor
On Mon, 2003-10-20 at 17:10, Matt Dickinson wrote: > When the initial design was done, was it looked at writing the pop3d from a > point of view of being spawned from xinetd? It would then be possible to > take advantage of the protection that xinetd offers with regards to DOS > attacks, rather tha

RE: [Dbmail] Installing DBMAIL 1.2 in RedHat 9.0 with Postfix

2003-10-23 Thread Matthew T. O'Connor
I tried to do the same recently. I got everything working except procmail. RH9 defaults to using sendmail, runs your email through procmail before delivery, I use this to do all my mail sorting server side. I couldn't figure out how to use postfix + dbmail + procmail. Any thoughts?

Re: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

2003-10-23 Thread Matthew T. O'Connor
On Thu, 2003-10-23 at 11:00, Ilja Booij wrote: > On Thursday, Oct 23, 2003, at 16:56 Europe/Amsterdam, Matt Dickinson > > I have a feeling that it wouldn't be too difficult to modify the > > dbmail-ipop3d that I wrote that launches from xinetd to function for > > the imapd too, this might allevia

RE: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

2003-10-23 Thread Matthew T. O'Connor
On Thu, 2003-10-23 at 12:49, Matt Dickinson wrote: > Matthew T. O'Connor wrote: > > In short, just because there can be a performance hit is not a reason > > not to allow this functionality into dbmail. I think it would be a > > welcome and useful addition. > > Try

RE: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

2003-10-23 Thread Matthew T. O'Connor
On Thu, 2003-10-23 at 13:09, Matt Dickinson wrote: > Matthew T. O'Connor wrote: > > I can play with / test it, but I don't normally use pop3, just IMAP. > > I would imagine that making imap use xinetd would require almost > > identical changes, any chance that ca

RE: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

2003-10-23 Thread Matthew T. O'Connor
On Thu, 2003-10-23 at 14:16, Matt Dickinson wrote: > Matt Dickinson wrote: > > The 2 Makefile patches include my dbmail-ipop3 patch too, so you'll > > probably need to have that source laying around in the directory when > > you build. > > Here's some patches with hopefully the dbmail-ipop3 stuff

RE: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

2003-10-24 Thread Matthew T. O'Connor
On Thu, 2003-10-23 at 17:25, Matt Dickinson wrote: > Matthew T. O'Connor wrote: > > I assume these patches are all against CVS (aka 2.0 branch). > > No, sorry. 1.2 branch. > I'll take a look @ 2.0 branch tomorrow. Good as, I would assume that these changes would not

Re: [Dbmail] memory problem on RedHat 9 and dbmail 1.1

2003-10-24 Thread Matthew T. O'Connor
On Fri, 2003-10-24 at 03:20, Paul J Stevens wrote: > I for one would vote against having those patches be accepted into CVS, > and I imagine Ilja wont commit them as they are. > > Don't get me wrong though; inetd functionality is a valuable attribute, > but I don't think they should be acquired

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-05 Thread Matthew T. O'Connor
Christian G. Warden wrote: On Wed, Nov 05, 2003 at 08:04:02PM +0100, Chris Carter wrote: 3. How does DBMail's IMAP support compare to other packages? Does M$Lookout work? Can I use Ximian Evolution? Or Kmail? I presume that POP works just fine (but I am interested in IMAP). I've only

Re: [Dbmail] DBMail: diff between 1.x and 2.x and other questions

2003-11-06 Thread Matthew T. O'Connor
Eric Soroos wrote: Maybe it's just my setup, but I've found that synching a 18k item mailbox gets me a message or two a seconds. Smaller mailboxes are damn fast. I'm on debian/stable, updated as of yesterday, running postgresql. The client is mail.app. Have you added all the recommended in

Re: [Dbmail] IMAP + dbmail

2003-11-10 Thread Matthew T. O'Connor
On Mon, 2003-11-10 at 08:59, Tim Gurney wrote: > dbmail-imapd seems to die the instant a connection is made. So there is no > way to retreive the emails. Has anyone else had a similiar problem. What does the log say is happening? If there isn't anything in the log, edit the dbmail.conf file and t

Re: [Dbmail] Stripping Attachments.

2003-11-11 Thread Matthew T. O'Connor
On Tue, 2003-11-11 at 09:50, Tim Gurney wrote: > > > > But why do it on the server? Isn't that part of the point of having the data store in a database? So that searches can be done server side? I have often considered setting up full text searching with postgresql so that I can efficiently do s

Re: [Dbmail] Assign email address to a shared mailbox

2003-12-01 Thread Matthew T. O'Connor
On Mon, 2003-12-01 at 07:08, Ilja Booij wrote: > On Dec 1, 2003, at 12:55 PM, Simon Gray wrote: > No, that wouldn't work. Shared mailboxes as they are implemented now > only work on IMAP-level. That is, you can use your IMAP client to > copy/move messages into a shared > mailbox that you have acc

Re: [Dbmail] trackrecord + (Scalability REPOST)

2003-12-03 Thread Matthew T. O'Connor
Eelco van Beek - IC&S wrote: hi Mark, The thing i can tell you about scalability is this: - you need a clusterable database (For 2.0 you should be able to write a oracle driver in about 4 hours). (real clustered databases partition automatically). ok - you'll need the LMTP daemon, not d

Re: [Dbmail] 2.0 and header-cache

2003-12-08 Thread Matthew T. O'Connor
Magnus Sundberg wrote: I beleive in automatic addition to the header cache, 1 Start with an empty table of headers_to_cache. 2 Client asks for "From:" and "Subject:" headers Then add these to the headers_to_cache Add the headers "From:" and "Subject:" to the header cache 3

Re: [Dbmail] 2.0 and header-cache

2003-12-08 Thread Matthew T. O'Connor
Magnus Sundberg wrote: Maybe, but I beleive that the mail clients are quite simpleminded. Please broaden my view and give me more examples of when the client requests unusual headers. I beleive it requests the headers when it displays the content of the mailbox. When else does it request the

Re: [Dbmail] does dbmail-imap support server side sorting?

2004-02-02 Thread Matthew T. O'Connor
I'm not sure you answered his question. I read his question as, "When viewing the messages in a mailbox, does the imap client have to do the message sorting (by date, by sender etc...) or is this done server side. I would imagine this would benefit web based clients the most such as Squirrell

Re: [Dbmail] Bug in user.c is still in version 2.0

2004-02-11 Thread Matthew T. O'Connor
I was wondering why a dbmail 2.0 branch was created before release? Seems to me that all we have done is complicate things while we stabilize 2.0 by requiring patches to be applied to two trees. I know some projects will create a tags before release, but won't branch until after they know things

Re: [Dbmail] CAP domain results in "no such user" mail bounce

2004-03-03 Thread Matthew T. O'Connor
On Wednesday 03 March 2004 09:57 am, Ilja Booij wrote: > The solution I can think of now is the following: > > make sure all aliases (or at least their domain part) go into the > database in lowercase. Whenever we check a domain alias, we first > convert the domain string to lowercase. We can then

Re: [Dbmail] CAP domain results in "no such user" mail bounce

2004-03-03 Thread Matthew T. O'Connor
On Wednesday 03 March 2004 09:32 am, Ilja Booij wrote: > Just when I was ready to commit the changes, I found out that MySQL > cannot have an index like: > > INDEX (lower(alias)), because it cannot have expressions in an index.. > > So, the whole plan is a no-go. Unless we can come up with some oth

Re: [Dbmail] Large sites using dbmail?

2004-03-26 Thread Matthew T. O'Connor
Mark Mackay - Orcon wrote: Biggest problem for me at the moment is MySQL tuning. We keep 'running out of thread memory' and I can't seem to find the right mysql config settings to solve it. I'm certain MySQL will handle more connections; but I suspect I'm going to have to pay for the mysql.com t

Re: [Dbmail] Stopping imapd, pop3d

2004-05-05 Thread Matthew T. O'Connor
Cool! Ilja, any chance we can have these included in the source tree somewhere? Matthew John M. Brown wrote: Looks like "mailman" doesn't like "TGZ" files...so either rename the ".bin" file to "tgz" or download the attached text files (the contents of the TGZ file) Found them...but no a

Re: [Dbmail] Authentication problem

2004-05-05 Thread Matthew T. O'Connor
Jason Jorgensen wrote: I just setup DBMail 2.0rc5 using the deb packages from the dbmail apt source. I am using postfix as my MTA. Mail is being delivered correctly from postfix to dbmail using dbmail-smtp. When I connect to dbmail-imap with Mozilla Thunderbird I get authenticated one time a

Re: [Dbmail] Stopping imapd, pop3d

2004-05-05 Thread Matthew T. O'Connor
I think the init scripts that John M. Brown posted are for RedHat only, and should be put in some redhat specific folder, or made available from the dbmail website or something. I several distros have their own way of doing things and we shouldn't try to write a one size fits all init script.

Re: [Dbmail] dbmail-imapd in malloc(): warning: recursive call

2004-08-03 Thread Matthew T. O'Connor
Rick Morris wrote: Hi Paul, Thanks for responding. Unfortunately, I don't think the database connection is the problem. The system has no trouble connecting to PostgreSQL to add users. The message you are seeing mentions that dbmail "could not connect to database", but that is because of the

[Dbmail] DBMail Change Password Plugin for Squirrelmail

2004-08-11 Thread Matthew T. O'Connor
Hello all, I am setting up a new dbmail install for someone. The primary interface for most of the users will be Squirrelmail. I want the users to be able to change their own passwords, and figured it would be best if they could do it directly from within Squirrelmail so I created a ne

Re: [Dbmail] DbMail Administrator (DBMA V2.0.2) is RC8 Compatible -- need steer on PSQL Encrypt

2004-08-19 Thread Matthew T. O'Connor
md5() was added to core postgresql as of 7.4, so it may be to new for dbmail to require it, but as of 7.4 contrib is not required. Jesse Norell wrote: Hello, DBMA 2.0.2 uses MD5-Digest (md5sum) by default for MySQL which is a built-in since around v4.0 but I am in a quandary with PostgreSQL

Re: [Dbmail] Re: dbmail 2.0 RC8 performance and such.....

2004-09-10 Thread Matthew T. O'Connor
Richard Barrington wrote: A DBMail native patch would indeed be sweet, but it seems that the root of the problem is DBMail's lack of support for the Sort extension and server-side threading. Leif Jackson made a patch for the 2.0 series to support the Sort extension. I'm unaware of any patches fo

Re: [Dbmail] Re: dbmail 2.0 RC8 performance and such.....

2004-09-10 Thread Matthew T. O'Connor
Robert Tom wrote: Richard Barrington freedomwigs.com> writes: A DBMail native patch would indeed be sweet, but it seems that the root of the problem is DBMail's lack of support for the Sort extension and server-side threading. So you mean that Dbmail with Sort extension and server-side thre

Re: [Dbmail] running as non-root?

2004-10-22 Thread Matthew T. O'Connor
I only run dbmail as non root, feel much safer that way. I'm not sure why you are having problems here are a couple of thoughts. Are you launching as root, or is the effective user executing the programs? Does that user have the required permissions to get to the dbmail.conf file? Mikhail

[Dbmail] DBMail Article

2004-11-17 Thread Matthew T. O'Connor
I thought some of you might find this interesting. http://www.onlamp.com/pub/a/onlamp/2004/07/22/datamining_email.html Matthew

[Dbmail] Can't Move Email - 2.0.1

2004-11-29 Thread Matthew T. O'Connor
Hello, I haven't had time to look into this yet, so it could be something stupid on my side, but just in case others have seen this. I have been successfully running DBMail 2.0.0 against PostgreSQL 7.4 on Linux for quite some time. I recently upgraded to 2.0.1 since there are several performance

Re: [Dbmail] How many Users (Accounts) can DBmail handle ?

2005-01-13 Thread Matthew T. O'Connor
[EMAIL PROTECTED] wrote: i use an emailsystem which saves the emails in maildirs. actually i'm thinking about to switch the accounts to dbmail with mysql-db. In the moment i've round about 2 users. How many Users can dbmail handle and which version should i take. The version question

Re: [Dbmail] Change dbmail passwords

2005-01-14 Thread Matthew T. O'Connor
I did, and sent to to the dbmail mailing lists, so search the mail archives and you will find it. The plugin was written before dbmail added table prefixes so you will have to make a small change to teh sql statemetns but that is all. Enjoy, Matthew O'Connor Nate Zabaldo wrote: Has anyon

[Dbmail] DBMail related Postfix question

2005-03-24 Thread Matthew T. O'Connor
Sorry, if this is a silly question, but I don't know the answer to it. I'm running a simple Postfix/DBMail/Postgresql dbmail setup. While I was working on my dbmail setup (testing a patch that Paul sent me) and I accidentally made dbmail-smtp unavailable for a few minutes on my mail server.

Re: [Dbmail] DBMail related Postfix question

2005-03-25 Thread Matthew T. O'Connor
Check your master.cf and then your main.cf to make sure it knows only dbmail-smtp or dbmail-lmtp:127.0.0.1:24 for transport. and a good suggestion would be to use lmtpd for primary delivery and dbmail-smtp for your exceptions if you have any. best... Mike - Original Messag

Re: [Dbmail] Using newer version to insert into older db?

2005-03-30 Thread Matthew T. O'Connor
I believe that somewhere along the line, someone submitted a sql script to the mailing list that adds the dbmail prefix to a 2.0.rcX schema. Robert Andersson wrote: Robert Andersson wrote: I'll get back when I know how it turns out. A minor problem. The new version (2.0.3) has a dbmail_

Re: [Dbmail] Dbmail 2 and postfix

2005-05-04 Thread Matthew T. O'Connor
Curtis Maurand wrote: in your main.cf local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf the contents of sql-recipients.cf look like: # For the local transport map. user=dbmail password= hosts= dbname=dbmail table=dbmail_aliases select_field=alias where_field=alias # end sql-recipi

Re: [Dbmail] DbMail in a ISP Cluster

2005-05-18 Thread Matthew T. O'Connor
Postgresql does support replication, in fact there are several different varieties of it available, check out slony1 among others. What it doesn't support is automatic failover. Simon Lange wrote: pgsql does not support replication. thats why we do use mysql - clustering is announced for my

Re: [Dbmail] DbMail in a ISP Cluster

2005-05-18 Thread Matthew T. O'Connor
6090300077 CELL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew T. O'Connor Sent: Wednesday, May 18, 2005 5:58 PM To: DBMail mailinglist Subject: Re: [Dbmail] DbMail in a ISP Cluster Postgresql does support replicatio

Re: [Dbmail] DBMail + PostgreSQL Problem

2005-07-16 Thread Matthew T. O'Connor
Niblett, David A wrote: I'm in serious need of help here. I'm about at my whits end of dealing with dbmail and getting it to work. I've had a couple of database crashes now and found things like if I run dbmail-util my DB process load skyrockets and the server becomes unusable. This sound

[Dbmail] dbmail-imap problem

2005-08-14 Thread Matthew T. O'Connor
Hello, I have been using dbmail very successfully for a few years now and despite the occasional problem here and there, it has been quite good. I just ran into something this morning that I haven't seen before. I tried check my email using Thunderbird as I always do, it was very slow to con

Re: [Dbmail] dbmail-imap problem

2005-08-15 Thread Matthew T. O'Connor
Paul J Stevens wrote: Matthew T. O'Connor wrote: [root]# ps auxww |grep dbmail-imapd |wc -l 6812 Matt, I've recently fixed a race condition in the preforking code that would allow process-leakage. Please try a snapshot and let me know if you hit this again. Thanks, w

Re: [Dbmail] dbmail-imap problem

2005-08-25 Thread Matthew T. O'Connor
Danil V. Gerun wrote: I can tell you that I updated to 2.0.5 as soon as it was release, and I'm not running 2.0.6 (On Linux not FreeBSD). I have not seen the same problem yet, but I had never seen it before either so. Whoops... I meant to say that I am *now* running 2.0.6, bad type

Re: [Dbmail] Size, vacuum, performance, etc

2005-11-17 Thread Matthew T. O'Connor
I don't think there is any need to take this off list, I think there are lot of people who would like to hear this discussion. Anyway I don't run a dbmail site with that much load, however I to have a fair amount of experience running PostgreSQL. 1) Never vacuum FULL: If you are vacuuming oft

Re: [Dbmail] Size, vacuum, performance, etc

2005-11-17 Thread Matthew T. O'Connor
Niblett, David A wrote: Wow, then I'm completely lost looking at your numbers. I set my shmall and shmmax to 805306368, so that the DB (which is the only thing using memory on the box) could have 800M of shared RAM. Am I crazy here? PostgreSQL uses it's shared buffers for some internal ope

Re: [Dbmail] change password plugin for squirrelmail

2005-12-31 Thread Matthew T. O'Connor
zamri wrote: Is there any (official) plugin to change password for dbmail ? I found one written by Matthew O'Connor but apparently it was not listed on SM plugin page. http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin

Re: [Dbmail] SPAM folder

2006-01-03 Thread Matthew T. O'Connor
Dominic Amann wrote: I have just configured a postfix -> spamassassin -> anomy/sanitizer setup myself. It seems to be working very well (only up since 21st Dec). I have been able to turn _off_ my Mozilla junk mail controls, and use message filtering (based on X-Spam-Status begins with YES) to

Re: [Dbmail] "Horde/imp search" not working with dbmail-imapd

2006-02-21 Thread Matthew T. O'Connor
Jacques Beaudoin wrote: When you say "All this has been fixed in svn-trunk" Do you meen that i should download 2.0 from svn-trunk ? No, these thing's won't (*can't*) be changed in the 2.0 code base. They have been fixed in the 2.1 code, but that is a development branch and isn't really stab

Re: [Dbmail] Terrible Load Issues With 2.0.9

2006-03-06 Thread Matthew T. O'Connor
Try PostgreSQL. Not to start a flame-war, but it's been my experience that Postgres does better in highly concurrent environments like what you have described. Greg Hellings wrote: We've been having terrible load issues with 2.0.9 and only about 300 users. We've got dual 3.6ghz Xeons with

Re: [Dbmail] Postfix

2006-05-04 Thread Matthew T. O'Connor
I would think so, one thing to note however is that real PostgreSQL support wasn't built-in until at least Postfix 2.1, I run 2.0 on a server and had to apply a PostgreSQL patch and compile by hand. Marc Dirix wrote: Does smtp-auth like described in the howto on dbmail.org's wiki also work wi

Re: [Dbmail] Dbmail-2.1.6 released

2006-05-05 Thread Matthew T. O'Connor
This is great news! I've been waiting for 2.1.6 before I started testing. Paul, Aaron and everyone else, thanks for the great work! Matt Paul J Stevens wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, We're happy to announce the release of dbmail-2.1.6. After extensive testin

Re: [Dbmail] Is dbmail-2.1.6 production ready ?

2006-05-25 Thread Matthew T. O'Connor
Jacques Beaudoin wrote: I just migrated all my 2500 users from dbmail-1.2.11 to dbmail-2.1.6 on my future mail server. To me everyting looks good Is dbmail-2.1.6 production ready ? I just asked a similar question the other day. It seems the consensus is that the 2.1 branch is now fairly

Re: [Dbmail] sieve fileinto command

2006-08-15 Thread Matthew T. O'Connor
+1 I missed it too the first time I tried to compile 2.1 from SVN. Jake Anderson wrote: ahh could that perhaps go into the docs somewhere? on the website perhaps? i didn't see anything in the install or readme about it. Jorge Bastos wrote: for svn use autoreconf -i configure make make ins

Re: [Dbmail] bash script to manage ACLs

2006-08-16 Thread Matthew T. O'Connor
Can you post them to the list, or perhaps on the wiki, or better yet, make a source forge project out of them? These all sound very useful. Paul J Stevens wrote: Adam, I'd like a copy please. Adam Kosmin wrote: Hello everyone, I've written a bash script that accomplishes the following tas

Re: [Dbmail] sieve fileinto command

2006-08-16 Thread Matthew T. O'Connor
Paul J Stevens wrote: Jake Anderson wrote: ahh could that perhaps go into the docs somewhere? on the website perhaps? i didn't see anything in the install or readme about it. People who don't read dbmail-dev and don't know about the autotools toolchain should not use svn-trunk, maybe? Seriousl

Re: [Dbmail] Mail Time script from 1.x to 2.x

2006-08-16 Thread Matthew T. O'Connor
Jonathan Lindsey wrote: I don't know about other people on the list but we tie a ton of things back to our dbmail users table, it's easy to do for our clients and other things. Plus having dbmail_ in front of every table in the database dbmail kinda seems ... unnecessarily redundant. I would lik

Re: [Dbmail] sieve fileinto command

2006-08-17 Thread Matthew T. O'Connor
Looks good to me. A little mysql and debian specific, but that's OK. One thing that might be nice to add is a quick description of all the DBMail specific configure options. Good work! BTW, I added a wiki page yesterday that shows how to setup imap under xinet.d, take a look and see if I'm m

[Dbmail] Webmail

2006-08-18 Thread Matthew T. O'Connor
Just curious to do an informal survey on the list. What open source Web based IMAP clients are people using? I have been using Squirrelmail for quite a while, but in my mind it looks a bit dated. Roundcube looks nice, but I've never used it. Comments? What else are people using? Matt

Re: [Dbmail] Webmail

2006-08-18 Thread Matthew T. O'Connor
Behalf Of Matthew T. O'Connor Sent: Friday, August 18, 2006 10:22 AM To: dbmail@dbmail.org Subject: [Dbmail] Webmail Just curious to do an informal survey on the list. What open source Web based IMAP clients are people using? I have been using Squirrelmail for quite a while, but in my mi

[Dbmail] Sieve Auto-Reply

2006-08-18 Thread Matthew T. O'Connor
OK, so now that I have Sieve working I'm trying to do an auto-reply type thing but using Sieve. I want to send an auto-reply to emails sent to a particular email address, but only of they match certain criteria (Certain words in the subject, certain other header values etc...). I thought the

Re: [Dbmail] Two instances of Dbmail, two ports, Howto?

2006-08-29 Thread Matthew T. O'Connor
Kevin Baker wrote: Is it possible to run two instances of dbmail on the same machine on two ports by specifying different config files at startup? Yes, but it takes a little work. What I do is run ./configure --prefix=/some/dir Then I edit the dbmail.h file and modify the default location of

Re: [Dbmail] Postfix or dbmail error?

2006-09-21 Thread Matthew T. O'Connor
If there isn't a separate postfix-mysql package (and I don't think there is) the SRPM does support it. download the SRPM for Postfix and rpm -i postfix.src.rpm modify the spec file to enable mysql support (should be located in /usr/src/redhat/SPECS or somethign like that and rebuild the RPM fro

Re: [Dbmail] Possible new DBMail User

2006-11-11 Thread Matthew T. O'Connor
This all sounds like it works just fine. The PostgreSQL support in DBMail is great (I prefer PostgreSQL too). And yes, I would assume you would use Mutt via IMAP. Opening large folders is one of the main reasons I moved to DBMail also. Kevin Monceaux wrote: DBMail enthusiasts, While sear

Re: [Dbmail] postgresql migrate 2.0 to 2.2

2006-12-02 Thread Matthew T. O'Connor
Paul J Stevens wrote: Jesse Norell wrote: Does the 2.2 imapd handle missing header caches (and eg. dynamically look up the message and fill the cache)? If not, that would be a substantial problem, though pop3 would probably work fine, afaik. No. There's no graceful degradation in the

Re: [Dbmail] postgresql migrate 2.0 to 2.2

2006-12-02 Thread Matthew T. O'Connor
Rod K wrote: I'll be running a test conversion on a duplicate DB today and will report back. I'm wondering if there isn't a better way to run the conversion. Perhaps a model like this: 1) Create NEW DB with 2.2 schema 2) Upgrade daemons. stop 2.0 3) Copy minimal tables (at least users/alias

Re: [Dbmail] Can someone give me php script for creating new user for dbmail?

2006-12-02 Thread Matthew T. O'Connor
zamri wrote: Can you someone give me a php script for creating a new user for dbmail ? I have this block of code in one of my PHP scripts, it works for me. Anyone care to comment if I'm missing anything? function CreateEmailAddress() { if(strlen($this->new_tocr_email) > 2)

Re: [Dbmail] dbmail/libsieve packages submitted to Fedora-Extras

2006-12-08 Thread Matthew T. O'Connor
I'm not involved so I can't sponsor, but I will say kudos to you for working on this, I will be very happy when I don't have to hand compile DBMail for CentOS anymore. Thanks! Matt Bernard Johnson wrote: A while back, I submitted dbmail/libsieve to Fedora-Extras for package review and inclu

Re: [Dbmail] ANNOUNCE: DBMail 2.2.2 released

2007-01-31 Thread Matthew T. O'Connor
Aaron Stone wrote: The next big project is multithreading the daemons. Even if that's the only change that is made, I think it will take a while to get right. Of course I'm open to different ideas, and I'm researching threading frameworks that we can leverage to reduce our development time. Anywa

  1   2   >