Re: mailboxes.db disagree between master and replica

2019-12-12 Thread Michael Menge


Quoting Tod Pike :


Hello:
  I am running a 3.X cyrus setup with master/slave replication. I
have discovered that one of my replicas has gotten out of sync with
it's master server, not in the sense that the mailboxes are not
replicated, but that the mailboxes live in different partitions on
the master and the slave.

  As an example, if I do a "ctl_mboxlist -d user." on the master,
I get back that it lives on partition 2. If I do the same thing on
the replica, I get back that it lives on partition 4. What happened
at one time is that the user got moved from partition 4 to partition 2
and it worked correctly on the master, but never happened on the slave.
BTW, the mupdate server agrees with the master, not the replica.


Make sure that the same partitions are configured on master and replica



  As an experiment, I tried to do a "ctl_mboxlist -m -w" on the
replica server, but it returns "couldn't get mupdate server name" since
it doesn't even know about the mupdate server in it's role as a replica.



Cyrus replication is not integrated with the murder setup.
A replica MUST NOT have a mupdate server configured.


  What are my options here - I know that I could just copy the
mailboxes.db file from the master to the replica, then manually move
the mailboxes that are in the "wrong" place to the "right" place, but
this seems a little drastic. Any way I can just tell the replica to
update the location of the mailbox one at a time?



Have you tried calling sync_client on the master with the "-u" option
(See sync_client manpage for details https://linux.die.net/man/8/sync_client)
This should sync all mailboxes, of the user and move the mailboxes to the
correct partition.

If this fails check for errors in the logs.

An other option would be to move the mailboxes to the correct partition with
cyradm using the renamemailbox command

  renamemailbox oldname newname [partition]





M.MengeTel.: (49) 7071/29-70316
Universität Tübingen   Fax.: (49) 7071/29-5912
Zentrum für Datenverarbeitung  mail:  
michael.me...@zdv.uni-tuebingen.de

Wächterstraße 76
72074 Tübingen


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

mailboxes.db disagree between master and replica

2019-12-12 Thread Tod Pike

Hello:
  I am running a 3.X cyrus setup with master/slave replication. I
have discovered that one of my replicas has gotten out of sync with
it's master server, not in the sense that the mailboxes are not
replicated, but that the mailboxes live in different partitions on
the master and the slave.

  As an example, if I do a "ctl_mboxlist -d user." on the master,
I get back that it lives on partition 2. If I do the same thing on
the replica, I get back that it lives on partition 4. What happened
at one time is that the user got moved from partition 4 to partition 2
and it worked correctly on the master, but never happened on the slave.
BTW, the mupdate server agrees with the master, not the replica.

  As an experiment, I tried to do a "ctl_mboxlist -m -w" on the
replica server, but it returns "couldn't get mupdate server name" since
it doesn't even know about the mupdate server in it's role as a replica.

  What are my options here - I know that I could just copy the
mailboxes.db file from the master to the replica, then manually move
the mailboxes that are in the "wrong" place to the "right" place, but
this seems a little drastic. Any way I can just tell the replica to
update the location of the mailbox one at a time?

Thanks!

Tod Pike
--
CMU Computing Services
SGRG 105

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


Re: django-cyradm

2019-12-12 Thread Jesper Schmitz Mouridsen via Info-cyrus



On 12.12.2019 21.26, Niels Dettenbach wrote:

Am Donnerstag, 12. Dezember 2019, 21:06:46 CET schrieb Jesper Schmitz
Mouridsen via Info-cyrus:

It has self service support. The system has 3 roles "admin","domain
admin" and "account user".

If you are interested take a look at

sounds very interesting - i planned to write a similiar open source product
(after the very flexible web-cyradm was very outdated) - but with exim /
pam_mysql (should be similiar) and reserved some spare time over christmas
and january for it...

After planning with django years ago, my current plan was to use flask or
similiar more light, because installation of django (compared to the old LAMP
based web-cyradm) is more difficult for many users / impossible in some typical
mass hosting environments and easier to maintain in regards of security over
longer timespan (django typically needs security updates several times a year
from what i experienced with it in other projects). And with flask it is (at
least by my intention so far...) more easy to use it on i.e. embedded
hardware or "small email servers" with a DevOps like software / "firmware"
management.

I very like the very intelligent (because it allows very flexible email configs
as MTA integrations) database design of web_cyradm. While i've not found a
way to easily "reuse" that existing database structure (or "rebuilt" it with
the django DB subsystem) in flask is has to be done by hand - so "no prob" at
this edge for me.

But will definitely check it - and (if interested) contribute (where it may
makes sense). it may possibly still is a nice base or working solution for
what i'm looking for (saving me time to write something complete byself) and
if flask or so is still an option, the similiar concept should allow to
"reuse" at least the more fiddely python code from a django project.

is there any public "main" repo of the project?

https://github.com/jsm222/django-cyradm/


many thanks for your time and posting,



niels.


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


Re: django-cyradm

2019-12-12 Thread Niels Dettenbach via Info-cyrus
Am Donnerstag, 12. Dezember 2019, 21:06:46 CET schrieb Jesper Schmitz 
Mouridsen via Info-cyrus:
> It has self service support. The system has 3 roles "admin","domain
> admin" and "account user".
> 
> If you are interested take a look at
sounds very interesting - i planned to write a similiar open source product 
(after the very flexible web-cyradm was very outdated) - but with exim / 
pam_mysql (should be similiar) and reserved some spare time over christmas 
and january for it...

After planning with django years ago, my current plan was to use flask or 
similiar more light, because installation of django (compared to the old LAMP 
based web-cyradm) is more difficult for many users / impossible in some typical 
mass hosting environments and easier to maintain in regards of security over 
longer timespan (django typically needs security updates several times a year 
from what i experienced with it in other projects). And with flask it is (at 
least by my intention so far...) more easy to use it on i.e. embedded 
hardware or "small email servers" with a DevOps like software / "firmware" 
management.

I very like the very intelligent (because it allows very flexible email configs 
as MTA integrations) database design of web_cyradm. While i've not found a 
way to easily "reuse" that existing database structure (or "rebuilt" it with 
the django DB subsystem) in flask is has to be done by hand - so "no prob" at 
this edge for me.

But will definitely check it - and (if interested) contribute (where it may 
makes sense). it may possibly still is a nice base or working solution for 
what i'm looking for (saving me time to write something complete byself) and 
if flask or so is still an option, the similiar concept should allow to 
"reuse" at least the more fiddely python code from a django project.

is there any public "main" repo of the project?



many thanks for your time and posting,



niels.
-- 
 ---
 Niels Dettenbach
 Syndicat IT & Internet
 http://www.syndicat.com
 PGP: https://syndicat.com/pub_key.asc
 ---
 





signature.asc
Description: This is a digitally signed message part.

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

django-cyradm

2019-12-12 Thread Jesper Schmitz Mouridsen via Info-cyrus

Hi cyrus list.

(This email contains self promotion of a cyrus/imap related piece of 
software..)


I wrote some years ago (and recently updated) a small django application 
for cyrus and postfix,


with database lookup tables.

It has self service support. The system has 3 roles "admin","domain 
admin" and "account user".


If you are interested take a look at

https://djcyradm.schmitz.computer

Kind regards

Jesper Schmitz Mouridsen



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