[Dbmail] Restore deleted mails from backup

Hi, We use for now Courier-IMAP because for us it's easy to restore deleted mail from our backups into the home Maildir. How can we do that with DBmail ? Thanks in advance for your reply. Sam. -- Ce message a été vérifié par MailScanner pour des virus ou des polluriels et rien de suspect n'a

[Dbmail] Restoration of deleted mails

Hi, We use for now Courier-IMAP because for us it's easy to restore deleted mail from our backups into the home Maildir. How can we do that with DBmail ? Thanks in advance for your reply. Sam. -- Ce message a été vérifié par MailScanner pour des virus ou des polluriels et rien de suspect n

Re: [Dbmail] Slow...

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >Could you verify the performance by opening a telnet session to the >IMAP server and issue some commands (SELECT, FETCH, STORE etc.) ? I will do that and tell you more later, thanks for your help. Sam.

Re: [Dbmail] Slow...

ect SQL queries on the dbmail tables to find the mailboxes messages it's very fast... At this time our customer ask to back to Courier-IMAP. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 0

Re: [Dbmail] Slow...

Sam Przyswa ([EMAIL PROTECTED]) écrivait: > >Hi, > >We have installed DBmail CVS on a machine 2 X 1.3Ghz with 1.5Go RAM on MySQL >and >it's two time slower than an old P233 with Courier-IMAP. We use a Webmail in >PHP4 >(PHPgroupWare). > >Have you an idea to opt

[Dbmail] Slow...

Hi, We have installed DBmail CVS on a machine 2 X 1.3Ghz with 1.5Go RAM on MySQL and it's two time slower than an old P233 with Courier-IMAP. We use a Webmail in PHP4 (PHPgroupWare). Have you an idea to optimize the IMAP logic or SQL queries in DBmail. Sam. -- Sam Przyswa - Chef de p

Re: [Dbmail] Virus Scanning

a virus scan would take several hours. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] DB change

This would be faster for native SQL webmail, and the imap >protocol. Hi, I already make that suggestion several month ago, it's a big change to do and I think it will be a big improvement espcially for native SQL webmail. I hope this will be done in the nest future release. Sam. -- Sam P

Re: [Dbmail] Error in dbmail-imapd

Craig Whitmore ([EMAIL PROTECTED]) écrivait: > >See the patch below that Klas patched yesterday. It fixes this problem. The >bug occurs in quoted_string_out in imaputil.c which quotes strings. Quite a >number of email clients (like outlook express) doesn't like how dbmail was >quoting it. This mea

Re: [Dbmail] Error in dbmail-imapd

whole message. The same mail on Courier-IMAP appear without problem in Outlook Express ?! >Sam Przyswa heeft op woensdag, 4 dec 2002 om 11:50 (Europe/Amsterdam) >het volgende geschreven: >> This bug appear only with Outlook 2000, we have found an other bug >> with Outlook

[Dbmail] DBmail stats

Hi everybody, There is a PHP script able to list the mailboxes grouped by clientid with the amount of mail and the mailboxe size by users. It must be installed into the Apache htdocs. PS. The script is in french, sorry, but very easy to translate. Sam. -- Sam Przyswa - Chef de projet Arial

Re: [Dbmail] Error in dbmail-imapd

ve found an other bug with Outlook Express, if you have a mail with accentued characters in the Subject: field as "éèà" this mail don't appear in Outlook Express, we don't know why ??? Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 750

Re: [Dbmail] Error in dbmail-imapd

mpatibility, I'm very interested ? Thanks again for the dbmail improvements. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] Error in dbmail-imapd

Outlook 2000 with the INBOX name in foreign languages, for me french, I write a patch for french language but easy to convert in other language. Let me know if you want to use dbmail with Outlook 2000 I will send you the patch. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Int

Re: [Dbmail] Last CVS don't compile

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >BTW: the other programs use /etc/dbmail.conf; as do the daemons now by >default. Ok, but in maintenance.c you have forget to change in line 56: ReadConfig("DBMAIL", "dbmail.conf", &sysItems); to: ReadConfig("DBMAIL", configFile, &sysItems);

Re: [Dbmail] Last CVS don't compile

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >You can start the imap and pop daemons with the '-f' option; as in >'dbmail-imapd -f /etc/dbmail.conf'; i'll change the default to >/etc/dbmail.conf. Same problem with dbmail-maintenance but the "-f" option don't work. Sam.

Re: [Dbmail] Last CVS don't compile

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >You can start the imap and pop daemons with the '-f' option; as in >'dbmail-imapd -f /etc/dbmail.conf'; i'll change the default to >/etc/dbmail.conf. Thanks ! Sam.

Re: [Dbmail] Last CVS don't compile

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >What says the log? Do you have a valid dbmail.conf file? Remember that >from now on the dbmail config table is no longer used but a config file >instead. I have a valid config file in /etc/dbmail.conf but it seems that dbmail-imapd don't find

Re: [Dbmail] Last CVS don't compile

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >Probably you are using an old makefile - try 'cp Makefile.mysql >Makefile; make all' or 'make -f Makefile.mysql all'. I have no problems >compiling using mysql; the errors indicate that make is searching for >some (now obsolete) non-existing ru

Re: [Dbmail] Last CVS don't compile

Roel Rozendaal - IC&S ([EMAIL PROTECTED]) écrivait: > >Probably you are using an old makefile - try 'cp Makefile.mysql >Makefile; make all' or 'make -f Makefile.mysql all'. I have no problems >compiling using mysql; the errors indicate that make is searching for >some (now obsolete) non-existing ru

[Dbmail] Last CVS don't compile

Hi, My last CVS update (today) don't compile with mysql setup, it seems the config.c, config.o, serverservice.c, serverservice.o rules are missing in the Makefile. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54

Re: [Dbmail] Some patches

has some more >paranoid handling of the use of strncpy so that buffers are more likely to >be terminated with a NULL. I got it but on which version or CVS date is it for ? Thanks. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel:

Re: [Dbmail] Bug with charset ISO-8859-1

Igor Olemskoi ([EMAIL PROTECTED]) écrivait: > >SP> We have found a bug when we use accentued characters in ISO-8859-1 >(Latin-1) on >SP> subject line, the message don't appear in Outlook Express 5 and 6 with >IMAP, the >SP> same message in Cc on Courier-IMAP server work fine. >SP> Thanks in advan

Re: [Dbmail] Bug with charset ISO-8859-1

e found a bug when we use accentued characters in ISO-8859-1 (Latin-1) >on >>subject line, the message don't appear in Outlook Express 5 and 6 with IMAP, >the >>same message in Cc on Courier-IMAP server work fine. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrate

[Dbmail] Bug with charset ISO-8859-1

patch. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

[Dbmail] MIME parse problem

1.2 And the part 1.1 1.2 are empty. Have you any idea to fix it ? Our setup: Lynux Debian 2.2.19 and 2.4 MySQL 3.23.52 PHP 4.1.2 and 4.2 phpGroupware 0.9.14 (Webmail) Same problem with Squirrelmail 1.2.8 (last version) Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36

Re: [Dbmail] DBMAIL 1.0-rc4

s include >imapd speed improvements and a couple of bug fixes. Thanks, but is there a good reason to omit the "&" character into the AcceptedMailboxnameChars[] in imap4.c ? Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 5

RE: [Dbmail] Outlook 2000 bug (Addon)

Sam Przyswa ([EMAIL PROTECTED]) wrote: > >In fact the problem come from a Outlook 2000 bug when it send the STATUS >command. >In french the Inbox is named "Boîte de réception" in UTF-7 "Bo&AO4-te de r&AOk- >ception" and it send the status request as: Y

RE: [Dbmail] Outlook 2000 bug

it won't try >again unless I close Outlook and restart. It's annoying problem as the >smallest network hiccup will require me to restart Outlook so I can >check email. This has happened in both Outlook 2000 and XP running SP1. >I don't seem to have a problem when usi

[Dbmail] Outlook 2000 bug

it will be good to patch it to append the "INBOX/" prefix in case the IMAP client forget it. What do you think about ? Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://ww

Re: [Dbmail] Imapd is slow as hell

Roel Rozendaal ([EMAIL PROTECTED]) écrivait: > >The basic layout for dbmail was based upon pop3 but we are interested in >better schemes for imap. One of the main goals right now is to have the >fastest imap server around. Better table layouts would mean a great >improvement; just don't know how mu

Re: [Dbmail] Imapd is slow as hell

t's possible to use messageblks only to store the body part of the mail, then we don't need to accede to it to fetch the headers fields by putting them into the messages table, what did you think about ? Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue

Re: [Dbmail] Imapd is slow as hell

t the order and number of the fields is what you think might be there. Sure it's easiest to SELECT named fields as SELECT * and use raw[x] to get the value. Our main goal it's to speed up DBmail and any suggestions are welcome ! Sam. -- Sam Przyswa - Chef de projet Arial Concept - In

RE: [Dbmail] Imapd is slow as hell

and/or change the table structure to put the mail header on "messages" >>whith the from:, to:, subject:, field and perhaps the body too, or just >>the body on messageblks. >> >>DBmail is the right way to make an isp mail solution with a lot of >>capabilities as CRM, etc, but we have to improve its speed and discuss >>to find the best way to do. >> -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

RE: [Dbmail] Imapd is slow as hell

apd works fast sometimes and sometimes it slow as hell. I got only 3 > users on that mailserver with dbmail. The server it runs on is strong > so there is no problem with the server. > > The slow part is when I login to the imapd server, it takes up to a > minute before I see any login t

Re: [Dbmail] Again: TODO

scuss >the current structure to see what other optimizations/changes would be >favorable. Ok, I hope this will be done in the next future. Sam. >- Original Message - >From: "Sam Przyswa" <[EMAIL PROTECTED]> >To: >Sent: Wednesday, September 11, 2002 6:26 PM >

Re: [Dbmail] Again: TODO

Philip Warner ([EMAIL PROTECTED]) wrote: > > >A few suggestions... > [...] >4. Nice-to-have: break up mail headers into a table >--- > >ie. parse the mail headers and store (a copy?) in a separate table. eg. > >Create Table message_headers(id, messa

Re: [Dbmail] Company References for DbMail ?

Micah Stevens ([EMAIL PROTECTED]) wrote: > >I'd be embarrassed to give it to you right now, but it's on my project list >to finish debugging it by Friday, so one I get it straightened out a bit >better, I'll send you a copy. Thanks in advance Micah. Sam.

Re: [Dbmail] Company References for DbMail ?

Micah Stevens ([EMAIL PROTECTED]) écrivait: > >I wrote a PHP web administration utility for adding accounts/domains. I'm very interested, is it GPL licence ? - I have to write the same thing perhaps we can share some lines of code... Sam. -- Sam Przyswa - Chef de projet Ar

Re: [Dbmail] Sendmail

rom SQL database and it's easiest to configure virtusers and virtuals domains. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] Company References for DbMail ?

nt factors in your decision ? We have make the DBmail choice because we have plan to develop a CRM solution. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] Company References for DbMail ?

DbMail wit a lot >of virtual domains/mailboxe. With a well configured MySQL+Innodb and the right indexes as explained on this list we got pretty good performances. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 -

Re: [Dbmail] ISO-8859-1 charset support

Roel Rozendaal ([EMAIL PROTECTED]) écrivait: > >Hi, > >i'm not sure what exactly your problem is - what functionality is >missing 8859-1 charset support? When we make a search with Squirrelmail dbmail-imapd return "ISO-8859-1 NO specified charset is not supported" and we use ISO-8859-1 charset (se

[Dbmail] ISO-8859-1 charset support

Hi, We have some problems with Squirrelmail on DBmail about the ISO-8859-1 charset not supported by DBmail, does this will be fixed in a next cvs release ? Thanks in advance. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40

Re: [Dbmail] dbmail-imap extremely slow??

unique_id,deleted_flag), > KEY idx_flagged_flag (mailbox_idnr,status,unique_id,flagged_flag), > KEY idx_recent_flag (mailbox_idnr,status,unique_id,recent_flag), > KEY idx_draft_flag (mailbox_idnr,status,unique_id,draft_flag) >) TYPE=MyISAM; -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] dbmail-imap extremely slow??

MySQL and we study differents way to do that. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] dbmail-imap extremely slow??

QL tuning? >Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] > [...] Thanks a lot ! Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] dbmail-imap extremely slow??

ssages. I got best results with Courier-IMAP... Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

[Dbmail] IMAP folders name in UTF-7 format

"9" and "-" as: "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789&-=/ _"; This permit the encoded UTF-7 sequence begining with a "&" and ended with a "-" character. I tested with the MS-Outlook series, Netscape, Mozilla. Sam. -- Sam Przyswa - Chef de projet Arial Concept

[Dbmail] DBmail and MySQL/Innodb

Hi, Have you tested DBmail on MySQL/Innodb (www.innodb.com) with the COMMIT and ROLLBACK functions ? We plan to switch on MySQL/Innodb to run our messages base. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax

Re: [Dbmail] MySQL limit table size

Eelco van Beek ([EMAIL PROTECTED]) écrivait: > >Hi Sam, > > >You can also convert to postgresql. Just make dumps and use the mysql import >tool. Postgresql can grow to 17 Tbyte table sizes. Ok, thanks but we want to stay with MySQL at this time, we try Innodb to fix this. S

Re: [Dbmail] Outlook 2000 problem

Eelco van Beek ([EMAIL PROTECTED]) écrivait: > >Hi Sam, > > >Since Roel is a very french loving (and fluently french speaking) guy he'll >probably fix this as soon as he gets back from his holiday. He'll be back in >about 2 weeks. He's on holiday in France. Thanks for your reply, but it's poss

[Dbmail] Outlook 2000 problem

ap code. Last request, have you plan to accept french accentued characters utf-7 in folders names ? Thanks in advance. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] MySQL limit table size

sive how-to on the MySQL web site. Well, >actually, it's on the innodb web site, but there are links to it on >the MySQL site. We try that, thanks for your fast reply. Sam Przyswa.

[Dbmail] MySQL limit table size

t, we plan to store more than 100,000 messages. Thanks in advance. Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]

Re: [Dbmail] dbmail-imap and Netscape

Sam Przyswa ([EMAIL PROTECTED]) écrivait: > >Edward Allen ([EMAIL PROTECTED]) écrivait: >> >>CVS as of the 8th works fine with Mozilla (1.0 on linux) and with kmail >>(konqueror). I have had a minor problem with kmail, but it seems to be >>kmail's fault. >

Re: [Dbmail] dbmail-imap and Netscape

Edward Allen ([EMAIL PROTECTED]) écrivait: > >CVS as of the 8th works fine with Mozilla (1.0 on linux) and with kmail >(konqueror). I have had a minor problem with kmail, but it seems to be >kmail's fault. > >So, can you be more specific as to the problem (set TRACE_LEVEL to 5 and >give us the out

RE: [Dbmail] dbmail-imap and Netscape

Shih Ming-Wei ([EMAIL PROTECTED]) écrivait: > >I have just pulled cvs of yesterday, and imapd works, recently do you mean >today? About two weeks, I'll try the last CVS. Thanks for your reply. Sam.

[Dbmail] dbmail-imap and Netscape

Hi, DBmail-imap don't work with Netscape, Mozilla, Konqueror, with recent cvs update. Have you plan to fix it ? Sam. -- Sam Przyswa - Chef de projet Arial Concept - Intégrateur Internet 36, rue de Turin - 75008 - Paris Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01 Web: http://www.arial-concep