Re[2]: [Dbmail] Max_data_length for dbmail_messageblks reached (Solved)

>> Simon wrote: >> > It looks like we have reached the Max_data_length for the > dbmail_messageblks table, this is currently 4294967295 (which is 4GB > im gussing - which is about right). From the mysql docs, this can be > easliery solved by running: > > ALTER TABLE tbl_nam

Re: [Dbmail] Max_data_length for dbmail_messageblks reached

Simon, This limitation is only relevant for MyISAM tables, and your solution (MERGE engine) also applies to MyISAM only. Please note however, that MyISAM is deprecated for dbmail-2.1+ since we've stopped trying to maintain referential integrety in the database-client (dbmail). So you better start

Re[2]: [Dbmail] Max_data_length for dbmail_messageblks reached

PJS> Simon, PJS> This limitation is only relevant for MyISAM tables, and your solution PJS> (MERGE engine) also applies to MyISAM only. Please note however, that PJS> MyISAM is deprecated for dbmail-2.1+ since we've stopped trying to PJS> maintain referential integrety in the database-client (dbma

[Dbmail] archiving

Hello, I am interested in introducing dbmail into a system without modifying how the current system works. I would like to use dbmail for message archiving purposes. My MTA is postfix. I would like to setup all mail -- sent and received -- to be archived into a database. Is this possible to setup

Re: [Dbmail] archiving

On Wed, 2005-11-23 at 10:57 -0500, Rod G wrote: > Hello, > > I am interested in introducing dbmail into a system without modifying > how the current system works. I would like to use dbmail for message > archiving purposes. My MTA is postfix. I would like to setup all mail > -- sent and received -

Re: [Dbmail] archiving

I'm building this very system myself using dbmail/postfix/procmail/mysql 5.x. Here are some tips to get you started... First, my assumptions: I assume you will have an archive server (archive.example.com) running another instance of postfix and dbmail. Users will have an account on the archi

Re: [Dbmail] archiving

Thanks for sharing your information Adam. Is procmail necessary for inserting the mail into the MySQL database? I'm pretty green on procmail and how dbmail inserts into the database. Thanks, Rod On 11/23/05, Adam Kosmin <[EMAIL PROTECTED]> wrote: > I'm building this very system myself using dbma

Re: [Dbmail] archiving

I do it because I wanted to insert the mail dynamically (based on user and date). This is just my approach of course and may not be inline with your needs. Just throwing the idea out. Adam Rod G wrote: Thanks for sharing your information Adam. Is procmail necessary for inserting the mail int

Re: Re[2]: [Dbmail] Max_data_length for dbmail_messageblks reached

On 11/23/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > PJS> Simon, > > PJS> This limitation is only relevant for MyISAM tables, and your solution > PJS> (MERGE engine) also applies to MyISAM only. Please note however, that > PJS> MyISAM is deprecated for dbmail-2.1+ since we've stopped trying

Re: [Dbmail] Max_data_length for dbmail_messageblks reached

On 11/23/05, Paul J Stevens <[EMAIL PROTECTED]> wrote: > This limitation is only relevant for MyISAM tables, and your solution > (MERGE engine) also applies to MyISAM only. Please note however, that > MyISAM is deprecated for dbmail-2.1+ since we've stopped trying to > maintain referential integre

Re: [Dbmail] SquirrelMail problem

Jesse Norell wrote: Try turning dbmail log level up to 5 and forward those logs (probably in mail.log or mail.debug or something, not mail.warn). Dominic Amann wrote: I have begun a squirrelmail installation, but I get ERROR: Connection dropped by IMAP server. Query: LOGOUT when I

Re: Re[2]: [Dbmail] Max_data_length for dbmail_messageblks reached (Solved)

> S> ) TYPE=MERGE UNION(dbmail_messageblks_part1, dbmail_messageblks_part2) > S> INSERT_METHOD=LAST; > It's rather interesting decision. I wonder is it real to build > something like an array of merged dbmail_messageblks_partX tables? > In previous maillists I have asked about big dbmail_messagebl

Re: [Dbmail] Max_data_length for dbmail_messageblks reached (Solved)

You have fixed a short term problem but forgot about long term consequences. Email system is a delete/insert/update/select heavy system, if you have lots of users. Going with innodb you get concurrent reads + writes. I can do most of the dbmail-util cleanup functions without having to lock ta

Re: [Dbmail] Max_data_length for dbmail_messageblks reached (Solved)

On 11/24/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > You have fixed a short term problem but forgot about long term > consequences. > > Email system is a delete/insert/update/select heavy system, if you have > lots of users. Going with innodb you get concurrent reads + writes. I > can do mos