<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi Raphaël,</p>
<p><br /></p>
<p>Answering below in blue for instance......</p>
<div>---<br />
<div class="firmasarenet" style="clear: both; text-align: left;">
<div class="imgsarenet" style="margin: 0 0 10px 0;"><img src="https://www.sarenet.es/estaticos/LogoSarenetEmails.png?newlogo" alt="sarenet" /></div>
<div class="titulosarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: bold; font-size: 14px; color: #333333;"><strong>Egoitz Aurrekoetxea</strong></div>
<div class="dptosarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #333333;">Departamento de sistemas</div>
<div class="textosarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #333333;">944 209 470<br />Parque Tecnológico. Edificio 103<br />48170 Zamudio (Bizkaia)</div>
<div class="lnksarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #007ac4; line-height: 1.2;"><a id="mailto" style="font-size: 12px; color: #007ac4; text-decoration: underline;" href="mailto:egoitz@sarenet.es"><label id="label_email">egoitz@sarenet.es</label></a></div>
<div class="lnksarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 12px; color: #007ac4; line-height: 1.2;"><a style="font-size: 12px; color: #007ac4; text-decoration: underline;" href="http://www.sarenet.es">www.sarenet.es</a></div>
<br />
<div class="imprimirsarenet" style="font-family: Helvetica, Arial, sans-serif; font-weight: normal; font-size: 10px; color: #a0c361;">Antes de imprimir este correo electrónico piense si es necesario hacerlo.</div>
</div>
</div>
<p><br /></p>
<p>El 14-02-2019 13:27, Raphaël Halimi escribió:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">Hi,<br /> <br /> I have a small (3 users) Cyrus IMAP server that started as a very old<br /> Debian (Woody or Sarge, I don't remember exactly) and that I upgraded<br /> through the years, and yesterday I upgraded from Jessie to Stretch<br /> (Cyrus 2.4.17 without caldav, to 2.5.10 with caldav).<br /> <br /> As I had some trouble in the past with databases migrations between<br /> BerkeleyDB versions during some upgrades, and although Cyrus started<br /> without any serious problem this time (after minor tuning of some<br /> options in the configuration files), I still wanted to check the state<br /> of the databases.<br /> <br /> So, the contents of /usr/lib/cyrus/cyrus-db-types.txt is:<br /> <br /> ANNOTATION twoskip<br /> DBENGINE BerkeleyDB5.3<br /> DUPLICATE twoskip<br /> MBOX twoskip<br /> PTS twoskip<br /> QUOTA quotalegacy<br /> SEEN twoskip<br /> STATUSCACHE twoskip<br /> SUBS flat<br /> TLS DEFAULT<br /> TLS twoskip<br /> USERDENY flat<br /> ZONEINFO twoskip<br /> <br /> (note that in Debian, no format is forced in /etc/imapd.conf)<br /> <br /> So my first questions is: I thought that Cyrus had abandoned BerkeleyDB<br /> a long time ago for skiplist, and then twoskip. Why is it still listed<br /> in this file ? Is there a part of Cyrus that still uses it ?</div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"> </div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"> </div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><strong><span style="color: #339966;">I suppose it could some Debian standard config?. We run FreeBSD and I have never see that file.</span></strong></div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><br /> <br /> Now for the databases themselves. In /var/lib/cyrus the global databases<br /> were converted on-the-fly:<br /> <br /> # file /var/lib/cyrus/*.db<br /> /var/lib/cyrus/annotations.db: Cyrus twoskip DB<br /> /var/lib/cyrus/deliver.db: Cyrus twoskip DB<br /> /var/lib/cyrus/mailboxes.db: Cyrus twoskip DB<br /> /var/lib/cyrus/statuscache.db: Cyrus twoskip DB<br /> /var/lib/cyrus/tls_sessions.db: Cyrus twoskip DB<br /> /var/lib/cyrus/user_deny.db: empty<br /> <br /> However, the user databases were not converted:<br /> <br /> # file /var/lib/cyrus/user/*/*<br /> /var/lib/cyrus/user/u/user1.seen: Cyrus skiplist DB<br /> /var/lib/cyrus/user/u/user1.sub: ASCII text<br /> /var/lib/cyrus/user/u/user2.seen: Cyrus skiplist DB<br /> /var/lib/cyrus/user/u/user2.sub: ASCII text<br /> /var/lib/cyrus/user/u/user3.seen: Cyrus skiplist DB<br /> /var/lib/cyrus/user/u/user3.sub: ASCII text</div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"> </div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><span style="color: #339966;"><strong>Cyrus 2.4 converted databases on the fly. Cyrus 2.5 and newer don't. You should launch a "reconstruct -r -V max" for that purpose.</strong></span><br /> <br /> So my next questions are: why are the databases still in skiplist<br /> format, whereas according to /usr/lib/cyrus/cyrus-db-types.txt, they<br /> should be twoskip ? Why didn't Cyrus convert them on-the-fly like the<br /> global databases ? Do I have to manually do it myself ? And if I do<br /> convert them, will it change anything (performance, reliability, etc etc) ?</div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"> </div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><strong><span style="color: #339966;">As said perhaps is a Debian derived config for the package. Yes you should with the command above.</span></strong><br /> <br /> Also, what about the various databases in the mail directories<br /> (cyrus.cache, cyrus.header, cyrus.index) ? For most of them, the "file"<br /> command only reports "data". What format are they actually in ? Do I<br /> have to convert them too ?</div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"> </div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><strong><span style="color: #339966;">Sure... Just launch a reconstruct -r -V max...</span></strong><br /> <br /> My last question is about a planned migration of this home server to a<br /> hosted private server. This old server and the new one are now both<br /> Debian Stretch and thus, have the same Cyrus version, but they're not<br /> the same architecture: the old one is i386, and the new one is amd64.<br /> <br /> When I mill migrate, will I have to convert the databases through the<br /> flat format and back, or can I blindly copy the whole contents of<br /> /var/spool/cyrus and /var/lib/cyrus to the new server and expect it to<br /> work out of the box ?</div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"> </div>
<div class="pre" style="margin: 0; padding: 0; font-family: monospace"><strong><span style="color: #339966;">When doing such a migration, it would be better to setup a replication between the 2.4 and the new 2.5 in the hosting. You should encrypt that communication. You could use the own cyrus encription for replication or something like OpenVPN. Although it should work, I wouldn't copy directly (with an rsync or scp) the files.</span></strong><br /> <br /> Thanks a lot in advance for your answers.<br /> <br /> Regards,</div>
<br /><br /><strong><span style="color: #339966;">Cheers!</span></strong><br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">----<br /> Cyrus Home Page: <a href="http://www.cyrusimap.org/" target="_blank" rel="noopener noreferrer">http://www.cyrusimap.org/</a><br /> List Archives/Info: <a href="http://lists.andrew.cmu.edu/pipermail/info-cyrus/" target="_blank" rel="noopener noreferrer">http://lists.andrew.cmu.edu/pipermail/info-cyrus/</a><br /> To Unsubscribe:<br /> <a href="https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus" target="_blank" rel="noopener noreferrer">https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus</a></div>
</blockquote>
</body></html>