[Dbmail] Migrating to DBMail

Hi all! I have two questions for everyone. Both questions have the following common content: The two servers mentioned are currently running Mandrake 8.1 with the funky ReiserFS filesystem. They both have all passwords and things in /etc/passwd + /etc/shadow (i.e. All users are real). Additio

[Dbmail] Massive, massive mailboxes?

Hi all! I am going to migrate a Cyrus IMAP setup to DBMail (I hope) and have but one main concern. Does anyone know how DBMail will handle a mail store where each user has between 1 GB - 4.3 GB of stuff stored in their mailbox (including subfolders etc). That's the amount that's being stored

[Dbmail] Migration of user details?

Hi again all! I've been doing some thinking, and was hoping to pass this by everyone. Currently, almost every mail system out there supports some means or another of authentication. If you change systems, things can suck majorly. I am looking at writing a daemon that will do the following: 1

[Dbmail] Migration + Load testing???

Hi all, I am looking to migrate a fairly large mail-site (currently, users have Cyrus mailboxes between 1 GB - 5 GB) to DBMail. I've decided on MySQL + InnoDB for the backend (anyone had success with MySQL 4.0 for this sort of thing?) but the migration is what I'm currently stuck on. I want

[Dbmail] IMAP folder problems

Hi all, I've setup DBMail from CVS on MySQL 4.0.6 with InnoDB tables and have noticed a few interesting bits of behaviour. 1. Using either Outlook Express 6 or Mozilla Mail 1.2, selecting a folder that hasn't had something put in it previously will result in the client just sitting there and then

[Dbmail] Re: IMAP Folder problems

Hi everyone! Regarding those IMAP folder problems, I also found that I couldn't get DBMail to work on the standard IMAP port unless I made the daemons run as root. Sound right or am I just openning up far too many security holes without need? Chris

[Dbmail] Inserting messages into specific IMAP folders

Hi all, I've tried this myself but I always manage to get a SIGSEGV whenever I call the appropriate functions. I need to follow this process: 1. See if a folder exists. 1a. If it doesn't, create it. 2. Insert a whole bunch of messages into that folder. 1a I can easily accomplish. As for 1 and

[Dbmail] Feature suggestion

Hi again all. I was thinking (all run in terror!). Considering MySQL has a "read-only" table type that supports compression, would it make sense to offer the option of archiving a whole bunch of messages into a seperate table? I've heard that PostgreSQL has something similar. It might allow

[Dbmail] Bynari Insight Connector + DBMail

Hi all, Anyone have experience with the above combination? Any opinions on whether or not this unholy union would work? I have a very impatient client (their weird) who wants Outlook functionality yesterday. They were going to buy Exchange, so money isn't a big deal for them it seems. Chris

[Dbmail] MySQL - mysqldump & MySQL replication

Hi all! I have two questions - please keep in mind that I am using InnoDB tables. 1. If I use "mysqldump --single-transation" to backup my DBMail database, will the result be a database that I can restore without any consistancy issues? I'm looking for a way to back everything up without having

[Dbmail] More on the bizzare "@@" problem

Hi all, More on the problem of "@@" appearing in all mail addresses in the "From" column in Outlook Express 6. 1. It isn't just Outlook Express 6.0. Mozilla Mail 1.3 and KMail 1.5 see the same thing. 2. The message is actually fine once you pull it down! 3. It happens even if the message is inj

[Dbmail] Ugly, ugly load averages

Hi, I've set up DBMail with Postfix and the load averages are damned ugly, as in 6.00 - 11.00 on an Athlon XP 1900+ with 256MB memory. The load average drops to 0.34 when I stop Postfix though. I've noticed that there are heaps of instances of dbmail-smtp running all the time and thus think t

Re: [Dbmail] Ugly, ugly load averages

instances running, you must be receiving a lot of mail. You might want to find out what is all this incoming mail.. normal traffic? spam? outlook viruses? Le 4 Avril 2003 23:43, Chris Nolan a écrit : Hi, I've set up DBMail with Postfix and the load averages are damned ugly, as in

[Dbmail] Load problems solved

Hi all, My load is now less than 0.1 . Uninstalling Postfix and letting the RPM script take care of it's directory permissions solved the problem. I guess the only thing my fumbling can teach anyone is that Postfix+chroot (Mandrake 9.0 does this by default) requires a bit more thought. Chris

Re: [Dbmail] migrations issues and table contraints

Hi everyone, The indexes and foreign key statements below are great - just make sure you run dbmail-maintanence -f first! You'll probably get plenty of complaints about unconnected messages otherwise. Chris Richard Houston wrote: All, First off I love what the developers are doing with db

[Dbmail] Interesting alias problem

Hi all, My DBMail alias table has just recently gotten into a mess, with some aliases appearing 3 times, all pointing to different users (for instance, the username that I use has been removed and added three times, explaining that). Has anyone else encountered this? If so, I might build a to

[Dbmail] Documentation for DBMail!

Hi all, I've seen the wishlist that's been posted to the list for DBMail and one of those wishes was documentation. Anyone want to get together and get started? Chris

[Dbmail] Cyrus->DBMail converter link

Hi everyone, It's done, it's available and it's online. Please, be honest in all opinions of this code. I've used it and it works but there is plenty to be added to it. I'm posting this to the dev list as well as I needed to modify the DBMail source very slightly to get this tool to work.

[Dbmail] dbmail-imapd loves to gobble CPU time

Hi all, After dbmail-imapd (1.1 with the "@@" patch), has been running for a while (24 hours roughly) the load average goes up to 1.5 - 2.5 while no imap connections are hitting the box. The load doesn't get this high when everyone in the office is using it. Killing dbmail-imapd solves the p

[Dbmail] Two DBMail bugs?

Hi all, Since rolling out DBMail, I've noticed two possible bugs. These bugs may simply be limited to when Outlook Express is used as the client, but I've noticed similar behaviour to point 1 in Mozilla Mail 1.3 1. Often, the mail client (OE or Mozilla Mail) will report that new mail is in o

[Dbmail] Another DBMail bug??

Hi again all! I've found another weirdness about DBMail - once again concerning Outlook Express users. When any of my OE users save a message as a Draft, it gets stuck in the drafts folder alright, but the message is recorded as being like a message in any other folder - opening it doesn't p

Re: [Dbmail] Two DBMail bugs?

is correct; all other IMAP servers I know of automatically handle removing \Recent if the message is \Seen or \Read. On point 2, I have heard rumors that this is being fixed? Aaron On Thu, 10 Apr 2003, Chris Nolan wrote: Hi all, Since rolling out DBMail, I've noticed two possible bugs.

[Dbmail] Alias housekeeping issues

Hi again all, When I was setting up DBMail, various user accounts got deleted and recreated. Because of this, I had to go through the alias table by hand and clean it up as mail wasn't being delivered correctly. The archive at my DBMail tools site contains a version of dbmail-user with a "t"

Re: [Dbmail] Query on Database Stability in DB Mail

Kiran N S wrote: Hi All, I am not an out and out techie, but would still like to know more about the stability of the PostgreSQL / MySQL database used in case of say, 10 / 25 / 50 / 100 / 500 / 1000 users. What are the db restoration processes executed and how, in case of PostgreSQL or say, M

Re: [Dbmail] Query on Database Stability in DB Mail

Not at all! http://www.mysql.com/doc/en/mysqldump.html Chris Philip Warner wrote: At 12:38 AM 23/04/2003 +1000, Chris Nolan wrote: make sure that you've got your isolation level set to READ_COMMITED in your my.cnf file though In which case I think you will lose the point-in

Re: [Dbmail] Query on Database Stability in DB Mail

news and even it will use MySQL at the backend. I've gone on long enough, now back to your regularly scheduled discussion. Curtis On Tuesday 22 April 2003 10:38, Chris Nolan wrote: Kiran N S wrote: Hi All, I am not an out and out techie, but would still like to know more about

Re: [Dbmail] maildir to dbmail?

Hi, Maildir is somewhat similar to Cyrus, so my Cyrus->DBMail converter might be of some use to you. You can grab it at www.itoperations.com.au/dbmail.html . If you want a hand at all, or if it doesn't work, I'd be happy to work with you on getting things working. Chris shon wrote: does

Re: [Dbmail] maildir to dbmail?

All well and good, but your original message dates will not show correctly in clients such as Microsoft Outlook / Outlook Express. My Cyrus->DBMail converter does preserve dates however and works from the command line without requiring either daemon to be running. Tim Triche wrote: 1) maildi

Re: [Dbmail] Literal date not implemented in the db_imap_append_msg() function. (dbmysql.c/dbpgsql.c)

This bug hit me as well. I got around it through writing my own conversion software that does set the internal date. A bug has been logged on this issue though, and the guys at IC&S will give me the code layout info I need to be able to fix it very soon. Chris Jeroen Hendriks wrote: Hi, W

[Dbmail] "From" address quoting issue in OE

Hi all, I originally posted this to the dbmail-dev list, but it seems that the dev list is dead! My users are slowly driving me insane due to the following problems with DBMail (please laugh, as they are using Outlook Express): 1. Some (but not all) of the senders in the "From" field in folde

Re: [Dbmail] "From" address quoting issue in OE

Thanks for the response. I *am* using DBMail 1.1 Chris On Mon, 2003-05-12 at 20:27, Craig Whitmore wrote: > > > > 1. Some (but not all) of the senders in the "From" field in folder view > > have double quotes around their names. This wouldn't be a problem if all > > messages were like this, but

Re: [Dbmail] PHP interface to dbmail

Curtis Maurand wrote: If anyone wants a hand on this sort of thing (or someone to start a general DBMail documentation project), count me in! Chris Here, here. documentation would be helpful. Curtis On Thu, 8 May 2003, Ketil Myhre Ring wrote: I could maybe write up a HOWTO for Linux /

[Dbmail] IMAP commands

Hi all, I am trying to debug a problem where my Outlook Express users sometimes see quotes (") around the sender's name in the "From" field when viewing message headers. I've written to this list a few times and haven't gotten a response so I was hoping that if I put the question differently,

Re: [Dbmail] High Load Average and dbmail-pop3d ?

Hi all, I am having an extremely similar problem with dbmail-imapd (running dbmail 1.1). And, to simplify things somewhat, I can tell you a bit about the problem. 1. MySQL is *not* the cause of this problem. I am using MySQL 4.0.12 and killing dbmail-imapd very quickly brings the load averag

Re: [Dbmail] dbmail-pop3d hogging cpu - reproducable

Hi Eelco, Have you looked at RT POSIX signals? Admittedly, they are quite dependent on a very new 2.4 kernel but they are very standard and seem to behave properly on my Linux boxes, as in just like the Solaris 7 and 8 boxes at uni. Regards, Chris Eelco van Beek - IC&S wrote: yeah, Linux

Re: [Dbmail] Status of DBMail CVS

It's stable...but... If your clients use Outlook Express (for whatever reason) the following limitations apply. I am using a very recent CVS checkout of the DBMail source 1. Some messages will have their sender's name appear in quotes ("). This screws up sorting 2. Mailboxes don't get automa

Re: [Dbmail] Status of DBMail CVS

EMAIL PROTECTED]" Becomes: From ""[EMAIL PROTECTED]"" This is the problem. This is what breaks client side sorting. I think the code is in imaputil.c in the envelope-related functions. Anyone want to give me a clue and tell me where to set my breakpoints and attach GDB

Re: [Dbmail] Status of DBMail CVS

yed. Weird huh... This is with DBMail 1.1, have not tried it with CVS. Here agains is a link to the screen capture. http://www.tenokies.com/images/OE_bad_addresses.jpg Thanks for the fast reply! Matthew On Fri, 2003-06-06 at 11:37, Chris Nolan wrote: It's stable...but... If your

Re: [Dbmail] Documentation project for dbmail?

Hi all, With regard to this, LaTeX is one of my pet tools and I have server space available for hosting this sort of thing if we want something other than the standard SourceForge setup. I'd like to be involved. I wrote the tool Cyrus2DBMail (that everyone is sick of hearing about) and have s

Re: [Dbmail] Documentation project for dbmail?

I think we really need to plan this properly, with a general document structure and a recognised maintainer. Additionally, deciding on what sections will be included needs consideration. Chris On Wed, 2003-06-18 at 20:28, lou wrote: > In some email I received from Roel Rozendaal - IC&S <[EMAIL PR

Re: [Dbmail] Documentation project for dbmail?

Unlike my clients (who love programs like ACT! and Outlook with reasons I can't even begin to understand), I will happily be involved in this regardless of the chosen language for the documentation (as long as no one suggests Wordsuggest Word and I will inflict the hell of FoxPro upon you!) If

Re: [Dbmail] Temporarily pausing mail processing?

Hi! Really, MySQL upgrades are pretty seamless. Install your MySQL binaries and libraries and recompile DBMail if you really want to and restart MySQL and DBMail! Done! Regards, Chris =?ISO-2022-JP?B?UGF3ZWwgU3p5bWN6eWtvd3NraQ==?= wrote: >Hi there! > >I just started using dbmail recently and w

Re: [Dbmail] using dbmail as a mail archive

Hi! You could hack the source an add a "has_attachments" column. :-) Regards, Chris Giorgio70165 wrote: * subhasis Gupta <[EMAIL PROTECTED]> [151203, 14:27]: try ripmime, works fine except sometimes with large file names, subhasis thanks subhasis, it seems to be right. I am test

[Dbmail] DBMail with MySQL and MyISAM tables

Hi all, I've been using DBMail since version 1.0 with great success in an environment with about 10 users and about 20 GB of mail (stored permanently and pulled down via IMAP) all up. I'm looking to deploy DBMail for a much larger installation (about 200 users) with a minimum of mail each (r

Re: [Dbmail] DbMail Outlook Received Date

I encountered this very problem ages ago. At the time, my users were running Cyrus. To solve the problem, I wrote a program in C that took the Cyrus files and pushed them over to DBMail (www.itoperations.com.au), setting internal_date such that the Outlook and Outlook Express clients saw the

Re: [Dbmail] Backing up dbmail mysql innodb with mysqldump

[EMAIL PROTECTED] wrote: I use the command mysqldump --quick --single-transaction -uroot > /backup/dbmail.sql to backup my dbmail database. It works fine but im wondering if any sql gouru have any opinions about this. I dont stop any of my services (postfix,dbmail,amavis) will i backup.

Re: [Dbmail] Backing up dbmail mysql innodb with mysqldump

[EMAIL PROTECTED] wrote: Selon Chris Nolan <[EMAIL PROTECTED]>: [EMAIL PROTECTED] wrote: I use the command mysqldump --quick --single-transaction -uroot > /backup/dbmail.sql to backup my dbmail database. It works fine but im wondering if any sql gouru have any opini

[Dbmail] Postfix 2.0 + DBMail + SMTP AUTH

Hi all! I'm looking to migrate the dodgy setup from hell to DBMail. Here's the problem: * The current setup is: Postfix 1.x + UW-IMAP (ugh...) + SASL + PWCheck I want to move this across to: Postfix 2.x + DBMail Migrating existing mail isn't a problem, but migrating existing usernames and

Re: [Dbmail] Postfix 2.0 + DBMail + SMTP AUTH

On Mon, 2004-03-01 at 04:38, Paul J Stevens wrote: > Chris Nolan wrote: > > Hi all! > > > > I'm looking to migrate the dodgy setup from hell to DBMail. Here's the > > problem: > > > > * The current setup is: > > > > Postfix 1.x + U