RE: Using SQL database to store mailboxes. deliverdb and etc ...

2010-09-20 Thread Michel Sébastien

> - Its possible to convert a exist installation to use SQL ?
> ( How ? How can i create the necessary tables and import from a
> skiplist database ? )

use cyr_dbtool to dump mboxlist and awk to prepare the import. Use mysqlimport 
to load in mysql, don't forget to set an appropriate field separator.

> - Its is compatible with Aggregation ( Murder ) ?
No it isn't. We will provide a patch to rewrite SQL results depending of BEs 
and FEs. May be is it possible to do the job with a mysql proxy ?
> - I can share the same database with frontends, backends and mupdate ?

Sébastien


Ce message et les pièces jointes sont confidentiels et réservés à l'usage 
exclusif de ses destinataires. Il peut également être protégé par le secret 
professionnel. Si vous recevez ce message par erreur, merci d'en avertir 
immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant 
être assurée sur Internet, la responsabilité du groupe Atos Origin ne pourra 
être recherchée quant au contenu de ce message. Bien que les meilleurs efforts 
soient faits pour maintenir cette transmission exempte de tout virus, 
l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne 
saurait être recherchée pour tout dommage résultant d'un virus transmis.

This e-mail and the documents attached are confidential and intended solely for 
the addressee; it may also be privileged. If you receive this e-mail in error, 
please notify the sender immediately and destroy it. As its integrity cannot be 
secured on the Internet, the Atos Origin group liability cannot be triggered 
for the message content. Although the sender endeavours to maintain a computer 
virus-free network, the sender does not warrant that this transmission is 
virus-free and will not be liable for any damages resulting from any virus 
transmitted.


Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/


RE: A beginner question about Murder

2010-09-20 Thread Michel Sébastien
>> So we use about ten common Intel based servers for BEs (sized to
>> support loss of 2/3 servers) and store data on NAS. Users are active
>> and filer is about tens of thousand nfsop/s at the busy hour.
>>
>> About 10% to 20% of the users connect at least one time a day, globally
>> 4 million connections per day.

> These are quite massive figures -- I'm thoroughly impressed. I am
> assuming that your back-ends experience 50,000-100,000 concurrent IMAP
> connections during certain parts of the day. This means that each BE
> takes 5,000-10,000 parallel connections. Can an ordinary Intel server
> handle such loads? What's the CPU and RAM of each?

We don't have to handle such load. Most of end-users connect on pop3d (we 
provide a pop3 optimizer to reduce I/O, see 
http://www.mail-archive.com/cyrus-de...@lists.andrew.cmu.edu/msg01194.html) , 
others connect on the webmail (our webmail uses disconnected imapd sessions and 
is optimized thanks to Cyrus statuscache db).

> Also, how many NAS servers/appliances are being used? I would have
> thought that something like NFS would be too slow for such heavy IO
> loads, but evidently I'm wrong.

One huge is enough and cheaper than a SAN. Also we have very experienced system 
admins to tune the filer !


Ce message et les pièces jointes sont confidentiels et réservés à l'usage 
exclusif de ses destinataires. Il peut également être protégé par le secret 
professionnel. Si vous recevez ce message par erreur, merci d'en avertir 
immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant 
être assurée sur Internet, la responsabilité du groupe Atos Origin ne pourra 
être recherchée quant au contenu de ce message. Bien que les meilleurs efforts 
soient faits pour maintenir cette transmission exempte de tout virus, 
l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne 
saurait être recherchée pour tout dommage résultant d'un virus transmis.

This e-mail and the documents attached are confidential and intended solely for 
the addressee; it may also be privileged. If you receive this e-mail in error, 
please notify the sender immediately and destroy it. As its integrity cannot be 
secured on the Internet, the Atos Origin group liability cannot be triggered 
for the message content. Although the sender endeavours to maintain a computer 
virus-free network, the sender does not warrant that this transmission is 
virus-free and will not be liable for any damages resulting from any virus 
transmitted.


Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/


competition

2010-09-20 Thread Marc Patermann
Hi,

where does Cyrus IMAPd stand today?
When I was starting to think about moving to a open source mail system 
(migrating away from Lotus Domino btw.), there ware Cyrus IMAPd, Courier 
and UW-IMAP I think.
Cyrus was the only "full flavored" IMAP server with active development. 
We were going the 2.2. path, while 2.3 seemed to "fresh". So there was 
development.
On the other side there were still many people complaining about Cyrus 
being too complex and too unstable with all the BDB fiddlings.

Then dovecot emerged and quickly evolved. I don't know why, but I seemed 
to become everyone's darling the the favorite IMAP server to many 
people. It came up with SIEVE and ACLs, which before were more or less a 
domain of Cyrus. And yet it is still evolving fast, with "easy" 
replication mechanisms, SIS etc.
And still, if someone asks a mailing list (not here certainly) how to 
start with IMAPd, many people shout, to go with dovecot and not using Cyrus.
I don't know, where this bad karma is coming from - I'm still happy with 
Cyrus. One point may have been from the documentation, that's why I 
really appreciate the new web site. I hope it will help.

But where does Cyrus IMAPd stand today?
It may be Murder/Aggregator - but how to get the people, when on first 
contact, where they just need a simple IMAP server, they are pointed to 
other product, which they then stay with?


Marc

Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/


Re: competition

2010-09-20 Thread Vincent Fox
  On 09/20/2010 06:59 AM, Marc Patermann wrote:
> But where does Cyrus IMAPd stand today?
> It may be Murder/Aggregator - but how to get the people, when on first
> contact, where they just need a simple IMAP server, they are pointed to
> other product, which they then stay with?
Umm, what?  We run Cyrus IMAP server with no Murder
for 20K+ people.  Murder may be a feature but it's not a
deployment requirement.

We used Perdition, originally just thrown up to provide a
transparent bridge as we migrated from Uwash to Cyrus.
But as things moved along, we ended up with Perdition
and multiple Cyrus backends and no good reason to switch
over to a Murder.



Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/


Re: competition

2010-09-20 Thread Andrew Morgan
On Mon, 20 Sep 2010, Vincent Fox wrote:

> Umm, what?  We run Cyrus IMAP server with no Murder
> for 20K+ people.  Murder may be a feature but it's not a
> deployment requirement.
>
> We used Perdition, originally just thrown up to provide a
> transparent bridge as we migrated from Uwash to Cyrus.
> But as things moved along, we ended up with Perdition
> and multiple Cyrus backends and no good reason to switch
> over to a Murder.

I end up granting myself rights to various users' mailboxes to investigate 
when we see one of our users sending out spam.  It usually turns out that 
they have been phished recently.  Once I grant myself rights to their 
mailbox, I see the mailbox in my regular email client (Alpine) in the 
"Other Users" hierarchy.

Does this work without Murder?  How do you investigate users' mailboxes in 
cases like this?

Andy

Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/


Re: competition

2010-09-20 Thread Vincent Fox
  On 09/20/2010 04:23 PM, Andrew Morgan wrote:
> I end up granting myself rights to various users' mailboxes to 
> investigate when we see one of our users sending out spam.  It usually 
> turns out that they have been phished recently.  Once I grant myself 
> rights to their mailbox, I see the mailbox in my regular email client 
> (Alpine) in the "Other Users" hierarchy.
>
> Does this work without Murder?  How do you investigate users' 
> mailboxes in cases like this?
>

I just login to the backend and look at their mailbox directly.  
Admittedly clunkier but the number of times where I've had to poke 
directly is small.





Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/


Re: competition

2010-09-20 Thread David Lang
On Mon, 20 Sep 2010, Andrew Morgan wrote:

> On Mon, 20 Sep 2010, Vincent Fox wrote:
>
>> Umm, what?  We run Cyrus IMAP server with no Murder
>> for 20K+ people.  Murder may be a feature but it's not a
>> deployment requirement.
>>
>> We used Perdition, originally just thrown up to provide a
>> transparent bridge as we migrated from Uwash to Cyrus.
>> But as things moved along, we ended up with Perdition
>> and multiple Cyrus backends and no good reason to switch
>> over to a Murder.
>
> I end up granting myself rights to various users' mailboxes to investigate
> when we see one of our users sending out spam.  It usually turns out that
> they have been phished recently.  Once I grant myself rights to their
> mailbox, I see the mailbox in my regular email client (Alpine) in the
> "Other Users" hierarchy.
>
> Does this work without Murder?

it definantly works with a single back-end. In the case of a multi-server 
setup, 
it depends on if your murder substatute will show you the folders across 
back-ends or not in a listing.

you can always connect directly to the back-end (bypassing murder or it's 
replacement) to see all "other users" for that back-end.

David Lang

>  How do you investigate users' mailboxes in
> cases like this?
>
>   Andy
> 
> Cyrus Home Page: http://www.cyrusimap.org/
> List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/
>

Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/