[Dbmail] searchable archive

2005-10-20 Thread Alex Krohn
Hi, We recently started a project using DBMail, and we added it to our searchable mailing list archive here: http://www.gossamer-threads.com/lists/dbmail/ to help us track down some problems. If you have any problems or questions about it, please feel free to contact me off-list. Thank

Re: [Dbmail] Ldap configuration for distribution lists/groups

2005-10-20 Thread Kevin Baker
Paul J Stevens wrote: This can be done in 2.1.x, which however is not advisable yet for production installs. [EMAIL PROTECTED] wrote: So I am considering using LDAP for auth with DBMail. Can someone explain how distribution lists would work with DBMail/LDAP? i.e. [EMAIL PROTECTED] to all

[Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-20 Thread kost
Hi all! After 1-2 months testing dbmail I have installed it on our main mail server. Now everything is ALMOST fine, but some questions still not resolved. The first question about dbmail-util. If we run dbmail-util -arf our database starts performing OPTIMIZE TABLE procedure. Everything Ok, except

Re: [Dbmail] Ldap configuration for distribution lists/groups

2005-10-20 Thread Paul J Stevens
Kevin Baker wrote: > Paul J Stevens wrote: > >>This can be done in 2.1.x, which however is not advisable yet for >>production installs. >> >>[EMAIL PROTECTED] wrote: >> >> >>>So I am considering using LDAP for auth with DBMail. >>> >>>Can someone explain how distribution lists would work with

Re: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-20 Thread Paul J Stevens
[EMAIL PROTECTED] wrote: > -rw-rw 1 mysql4 mysql4 23995613184 Oct 20 11:47 dbmail_messageblks.ibd he! are those innodb table spaces? Been reading about them, but haven't used them yet.. > Table "dbmail_messageblks" has almost 24Gb size (we have about 45000 > emails each day!). So when "O

[Dbmail] IMAP QUOTA

2005-10-20 Thread Martin Strand
Hi. Does this mean dbmail doesn't support the QUOTA extension at all? * OK dbmail imap (protocol version 4r1) server 2.0.7 ready to run A0 CAPABILITY * CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE SORT A0 OK CAPABILITY completed --Martin

Re: [Dbmail] IMAP QUOTA

2005-10-20 Thread Paul J Stevens
Not yet. Quota are implemented at the account root level, and the framework is in place for full QUOTA capabilities. But currently the mailbox size is not being tracked at all, which is a requirement for this to work. Martin Strand wrote: > Hi. > Does this mean dbmail doesn't support the QUOTA ext

Re: [Dbmail] IMAP QUOTA

2005-10-20 Thread Martin Strand
Ok, will it be implemented in 2.2? I'm asking cause I'm developing a simple IMAP client - if dbmail won't support QUOTA within the near future, I'll just skip that part in the client since everyone who'll use that client will also use our IMAP server. But currently the mailbox size is not b

Re: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-20 Thread Eugene Prokopiev
If anybody now how to do optimize MySQL tables in such hard terms - please answer. I'm open to suggestions and ideas here. I've been having this very same problem. http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.html Big RDBMS (Sybase, Oracle) have advanced table partitioning fea

Re: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-20 Thread Paul J Stevens
Ah, that'll help. Looks like mysql-5 will have what we need: http://dev.mysql.com/doc/refman/5.1/en/partitioning.html I see it's on the TODO list for postgresql http://www.postgresql.org/docs/faqs.TODO.html Eugene Prokopiev wrote: >>> If anybody now how to do optimize MySQL tables in such ha

Re: [Dbmail] IMAP QUOTA

2005-10-20 Thread Paul J Stevens
Martin Strand wrote: > Ok, will it be implemented in 2.2? Not likely. In 2.3+. > I'm asking cause I'm developing a simple IMAP client - if dbmail won't > support QUOTA within the near future, I'll just skip that part in the > client since everyone who'll use that client will also use our IMAP

Re: [Dbmail] IMAP QUOTA

2005-10-20 Thread Martin Strand
On Thu, 20 Oct 2005 15:20:00 +0200, Paul J Stevens <[EMAIL PROTECTED]> wrote: Martin Strand wrote: Ok, will it be implemented in 2.2? Not likely. In 2.3+. I'm asking cause I'm developing a simple IMAP client - if dbmail won't support QUOTA within the near future, I'll just skip that part

Re: [Dbmail] IMAP QUOTA

2005-10-20 Thread Paul J Stevens
Martin Strand wrote: > It's just that I had this user once who received a message which was 3 > times bigger than her maxmail_size. The message only appeared in > 'messages' but not in 'messageblks'. This was on dbmail 1.2.x though. If that is still the case in 2.0+, that would indeed be a bug

[Dbmail] sticky messages in physmessages...

2005-10-20 Thread Kertész Viktor
Hi! I am currently developing a small web based managing tool for dbmail. I use dbmail with MySQL. I realized that messages from physmessage table and so messageblks table are not deleted after deleting a user from users table. I cannot found any constraint that would do the job. I have had a

Re: [Dbmail] sticky messages in physmessages...

2005-10-20 Thread Jesse Norell
On Thu, 2005-10-20 at 17:28 +0200, Kertész Viktor wrote: > Hi! > > I am currently developing a small web based managing tool for dbmail. I > use dbmail with MySQL. I realized that messages from physmessage table > and so messageblks table are not deleted after deleting a user from > users table

Re: [Dbmail] OPTIMIZE TABLE dbmail_messageblks in MySQL

2005-10-20 Thread Steven Lynn
Merge tables are mainly based for having two identical tables then 'merging' them together with a third. I am guessing that he wants RAID chucks in the 'create table' statement. Also, InnoDB has built in functionality to create new files and roll over... http://dev.mysql.com/doc/refman/4.1/en/i