Re: [Dbmail] Exit PostgreSQL - Make room for MySQL/InnoDB !

2002-12-03 Thread Philip Warner
At 04:23 PM 2/12/2002 +0100, Roel Rozendaal - IC&S wrote: * Speed.Postgresql is way slower than mysql. Way. Given that you staunchly refused to do a vacuum until the DB grew to 5GB, that's hardly surprising. Most benchmarks show that MySQL is substantially superior fo

[Dbmail] PostgreSQL tuning for dbmail

2002-12-03 Thread Joby Walker
Philip Warner wrote: Most benchmarks show that MySQL is substantially superior for one or a few clients, but that for high concurrency/high load PG wins. This of course assumes that both databases were configured and tuned properly... Again, this is almost certainly tuning parameters. I had

Re: [Dbmail] PostgreSQL tuning for dbmail

2002-12-03 Thread Philip Warner
At 03:30 PM 2/12/2002 -0800, Joby Walker wrote: What tuning have you done to Postgres and what is your regular maintenance schedule? Some of the basic factors from a PG point of view (these are my view on things based on using PG and the general advice found on the lists and documentation):

Re: [Dbmail] PostgreSQL tuning for dbmail

2002-12-03 Thread Philip Warner
At 05:16 PM 3/12/2002 +1100, Philip Warner wrote: set max_fsm_pages to 4 vacuum every two hours vacuum 'users' every 5 min analyze every hour dbmail-maintenance -p -d -f daily. I should have mentioned two things: (a) with the above settings, the server load is minimal (<1), CPU is 80-90%

[Dbmail] Error in dbmail-imapd

2002-12-03 Thread Hans Kula
Using dbmail-imapd with a german outlook express 6.0 makes outlook waiting forever for a response... while trying to create standard folders when initializing the imap account on first login... Log says: Dec 3 12:45:50 dnsc2 dbmail/imap4[4028]: COMMAND: [0039 CREATE "Entw&APw-rfe"] How and where

[Dbmail] Outlook Express Special Char in Foldernames solution

2002-12-03 Thread Hans Kula
Append an ampersand to the following array in imap4.c const char AcceptedMailboxnameChars[] = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-=/ _&"; Hans

Re: [Dbmail] Error in dbmail-imapd

2002-12-03 Thread
Hi hans, could you try the latest CVS? It should be fixed by now. regards roel Hans Kula heeft op dinsdag, 3 dec 2002 om 14:58 (Europe/Amsterdam) het volgende geschreven: "Entw&APw-rfe"

[Dbmail] Error in dbmail-imapd

2002-12-03 Thread Hans Kula
After testing i found one more character to add: "," and "&" It seems as if oe is escaping special chars with &xxx- and &x,x- ... so array in imap4.c must look like this: const char AcceptedMailboxnameChars[] = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-=/ _&,"; Hans

Re: [Dbmail] Error in dbmail-imapd

2002-12-03 Thread Hans Kula
Hi Roel, The latest CVS contains the following array: const char AcceptedMailboxnameChars[] = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-=/ _.&"; The char "," is missing...this is for the german &szml; char. regards hans - Original Message - From: "Roel Rozendaal

Re: [Dbmail] Error in dbmail-imapd

2002-12-03 Thread Richard Barrington
Not sure if this is what you need to reference, but http://www.faqs.org/rfcs/rfc2060.html section "5.1.3. Mailbox International Naming Convention" has a pretty good summary of acceptable mailbox name characters. On Wed, 2002-12-04 at 03:22, Hans Kula wrote: > Hi Roel, > > The latest CVS contai

Re: [Dbmail] Error in dbmail-imapd

2002-12-03 Thread Hans Kula
Hi Richard, thx for pointing to this rfc... Another point is http://www.faqs.org/rfcs/rfc2045.html which explains the base64 alphabet: 6.8. Base64 Content-Transfer-Encoding This section contians: ... 62 + 63 / (pad) = ...which means that also the "+" character is missing. As stated in http:/

[Dbmail] ANNOUNCEMENT: DBMAIL 1.0!!!

2002-12-03 Thread IC&S Helpdesk
Yes! Finally :) This is the official announcement of dbmail 1.0 stable! You can download it at our all new dbmail website (www.dbmail.org). Major updates: - imap commandline scanner is now fully RFC compatible - new server code for both imap and pop servers - many little bugfix

Re: [Dbmail] ANNOUNCEMENT: DBMAIL 1.0!!!

2002-12-03 Thread Aaron Stone
Dont' forget to announce on freshmeat; the rc4 announcement never made it! (so, to be sly, you could announce rc4 today, and announce 1.0 later this week... just to get a bit more "front page time" to spread the word ;-) Aaron On Tue, 3 Dec 2002, IC&S Helpdesk wrote: > Yes! Finally :) > > This

Re: [Dbmail] ANNOUNCEMENT: DBMAIL 1.0!!!

2002-12-03 Thread
hehehe well, unfortuanatly, i already announced it :) Best regards, eelco On dinsdag, dec 3, 2002, at 19:34 Europe/Amsterdam, Aaron Stone wrote: Dont' forget to announce on freshmeat; the rc4 announcement never made it! (so, to be sly, you could announce rc4 today, and announce 1.0 later th

[Dbmail] The Future

2002-12-03 Thread
Hi everybody, Some patches are not yet incorporated in dbmail 1.0. That doesn't mean that they are not good enough. We tried to compile a stable package which should be quick easy to setup. All new features (and a lot of patches) will be added to the new 1.1 branch. 1.0 will only be used for

Re: [Dbmail] ANNOUNCEMENT: DBMAIL 1.0!!!

2002-12-03 Thread Bret Baptist
On Tuesday 03 December 2002 11:38 am, IC&S Helpdesk wrote: > Yes! Finally :) > > This is the official announcement of dbmail 1.0 stable! > You can download it at our all new dbmail website (www.dbmail.org). > > Major updates: > - imap commandline scanner is now fully RFC compatible > - new

Re: [Dbmail] The Future

2002-12-03 Thread Ryan Butler
On Tue, 2002-12-03 at 12:49, Eelco van Beek - IC&S wrote: > Hi everybody, > > Some patches are not yet incorporated in dbmail 1.0. That doesn't mean > that they are not good enough. We tried to compile a stable package > which should be quick easy to setup. All new features (and a lot of > patc

Re: [Dbmail] ANNOUNCEMENT: DBMAIL 1.0!!!

2002-12-03 Thread
Ummm the dbmail-1.0/sql/mysql/* files are all empty in the dbmail-1.0.tgz file. I would assume that they are supposed to have the sql descriptions in them. :-) argghhh... thanks a lot. I've fixed it right away. Only the innodb files and the autoreply are missing. Roel, can you send them to

Re: [Dbmail] The Future

2002-12-03 Thread
The autoconf fixes should have went in before 1.0, as it is now the autconf stuff shipped with 1.0 doesn't coexist well with non autoconf builds and is partially broken. They definately need to go in botht he 1.0 and 1.1 branches. They really should have went in at 1.0 or had autoconf removed be

Re: [Dbmail] The Future

2002-12-03 Thread Ryan Butler
On Tue, 2002-12-03 at 14:05, Eelco van Beek - IC&S wrote: > Hi Ryan, > > We tried to incorporate autoconf in 1.0 but unfortunatly our autoconf > guy is on a 6 month leave and Roel and I are working on other stuff. To > fill in for the miss we incorporated a build script which should be > suffi

[Dbmail] All empty document

2002-12-03 Thread Jacques-Beaudoin
I just did a CVS update of dbmail 1.0 and all files in /dbmail/sql/mysql are empty there is a small typing error in the INSTALL file the line mysql -u root -p < sql/mysql/create_tables.sql ( IS ) mysql -u root -p < sql/mysql/create_tables.mysql( SHOULD BE )

Re: [Dbmail] Error in dbmail-imapd

2002-12-03 Thread Sam Przyswa
Hans Kula ([EMAIL PROTECTED]) écrivait: > > >After testing i found one more character to add: "," and "&" > >It seems as if oe is escaping special chars with &xxx- and &x,x- ... > >so array in imap4.c must look like this: > >const char AcceptedMailboxnameChars[] = >"abcdefghijklmnopqrstuvwxyzABCDEF

Re: [Dbmail] ANNOUNCEMENT: DBMAIL 1.0!!!

2002-12-03 Thread Bret Baptist
On Tuesday 03 December 2002 2:04 pm, Eelco van Beek - IC&S wrote: > argghhh... > thanks a lot. I've fixed it right away. Only the innodb files and the > autoreply are missing. Roel, can you send them to me? > When do you expect to have these up? I was going to switch over to 1.0 but I wanted to