<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style>
</head>
<body><div>Hi Sven,<br></div>
<div><br></div>
<div>Are you able to provide a sample mailboxes.db entry (using cyr_dbtool as Bron describes below) for a mailbox which is affected by this?<br></div>
<div><br></div>
<div>I'm trying to determine if the cause is bad data getting into the database, or good data that's being misread for some reason. An example would help a lot!<br></div>
<div><br></div>
<div>Cheers,<br></div>
<div><br></div>
<div>ellie</div>
<div><br></div>
<div>On Tue, May 29, 2018, at 9:34 AM, Bron Gondwana wrote:<br></div>
<blockquote type="cite"><div style="font-family:Arial;"><a href="https://github.com/cyrusimap/cyrus-imapd/issues/2378">https://github.com/cyrusimap/cyrus-imapd/issues/2378</a> to track the issue.<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;">Sorry about the short comment earlier on my phone as I woke up - meant to save it as a draft and add some detail!<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;"># /usr/cyrus/bin/cyr_dbtool <br></div>
<div style="font-family:Arial;">Usage: /usr/cyrus/bin/cyr_dbtool [-C altconfig] <db file> <db backend> <action> [<key>] [<value>]<br></div>
<div style="font-family:Arial;">Usable Backends: flat, skiplist, quotalegacy, twoskip<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;">Actions:<br></div>
<div style="font-family:Arial;">* show [<prefix>]<br></div>
<div style="font-family:Arial;">* get <key><br></div>
<div style="font-family:Arial;">* set <key> <value><br></div>
<div style="font-family:Arial;">* delete <key><br></div>
<div style="font-family:Arial;">* dump - internal format dump<br></div>
<div style="font-family:Arial;">* consistent - check consistency<br></div>
<div style="font-family:Arial;">* repack - repack/checkpoint the DB (if supported)<br></div>
<div style="font-family:Arial;">* damage - start a commit then die during<br></div>
<div style="font-family:Arial;">* batch - read from stdin and execute commands<br></div>
<div style="font-family:Arial;">You may omit key or key/value and specify one per line on stdin<br></div>
<div style="font-family:Arial;">keys are terminated by tab or newline, values are terminated by newline<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;">=====<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;"><db file> will need to be your mailboxes.db (e.g. /var/imap/mailboxes.db on many systems). You'll have to run it as the cyrus user. You can use "show" to dump the whole file and grep for the individual mailbox, or "get" on the mailbox key directly to get the one line. Then "set" to set it with a value with that group name removed.<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;">You'll probably want to do another setacl on that mailbox with something safe afterwards, just so the cyrus.header file gets cleaned up as well. It contains a value which is a cache of the value in mailboxes.db.<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;">Cheers,<br></div>
<div style="font-family:Arial;"><div><br></div>
<div>Bron.<br></div>
</div>
<div><br></div>
<div><br></div>
<div>On Tue, May 29, 2018, at 07:55, Bron Gondwana wrote:<br></div>
<blockquote type="cite"><div style="font-family:Arial;">If you use cyr_dbtool you can edit the offending line in mailboxes db.<br></div>
<div style="font-family:Arial;"><br></div>
<div style="font-family:Arial;">Clearly there's a bug here too, we should be sanitising group names! Or at least storing them in a reversible format<br></div>
<div><br></div>
<div><br></div>
<div>On Tue, May 29, 2018, at 00:33, Sven Schwedas wrote:<br></div>
<blockquote type="cite"><div>After running `setaclmailbox some/mailbox "group:name with spaces" all`,<br></div>
<div>all attempts to access the mailbox in any way either result in an<br></div>
<div>"Invalid identifier" error message, or can't even find the mailbox.<br></div>
<div><br></div>
<div>deleteaclmailbox with exactly the same parameters as set doesn't help<br></div>
<div>(same "invalid identifier" error); cyrreconstruct doesn't even find the<br></div>
<div>mailbox. Deliveries are deferred as well.<br></div>
<div><br></div>
<div>Any ideas how I can recover the mailbox without rolling back the whole<br></div>
<div>server to an older backup?<br></div>
<div><br></div>
<div>(Cyrus 2.5.10 on Debian stretch, if that matters.)<br></div>
<div><br></div>
<div>--<br></div>
<div>Mit freundlichen Grüßen, / Best Regards,<br></div>
<div>Sven Schwedas, Systemadministrator<br></div>
<div>✉ <a href="mailto:sven.schwedas@tao.at">sven.schwedas@tao.at</a> | ☎ +43 680 301 7167<br></div>
<div>TAO Digital | Teil der TAO Beratungs- & Management GmbH<br></div>
<div>Lendplatz 45 | FN 213999f/Klagenfurt, FB-Gericht Villach<br></div>
<div>A8020 Graz | <a href="https://www.tao-digital.at">https://www.tao-digital.at</a><br></div>
<div><br></div>
<div>----<br></div>
<div>Cyrus Home Page: <a href="http://www.cyrusimap.org/">http://www.cyrusimap.org/</a><br></div>
<div>List Archives/Info: <a href="http://lists.andrew.cmu.edu/pipermail/info-cyrus/">http://lists.andrew.cmu.edu/pipermail/info-cyrus/</a><br></div>
<div>To Unsubscribe:<br></div>
<div><a href="https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus">https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus</a><br></div>
<p>Email had 1 attachment:<br></p><ul><li><div style="font-family:Arial;"><code>signature.asc</code><br></div>
<div style="font-family:Arial;"> 1k (application/pgp-signature)<br></div>
</li></ul></blockquote><div style="font-family:Arial;"><br></div>
<div><div>--<br></div>
<div> Bron Gondwana, CEO, FastMail Pty Ltd<br></div>
<div> brong@fastmailteam.com<br></div>
<div><br></div>
</div>
<div>----<br></div>
<div>Cyrus Home Page: <a href="http://www.cyrusimap.org/">http://www.cyrusimap.org/</a><br></div>
<div>List Archives/Info: <a href="http://lists.andrew.cmu.edu/pipermail/info-cyrus/">http://lists.andrew.cmu.edu/pipermail/info-cyrus/</a><br></div>
<div>To Unsubscribe:<br></div>
<div><a href="https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus">https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus</a><br></div>
</blockquote><div style="font-family:Arial;"><br></div>
<div><div>--<br></div>
<div> Bron Gondwana, CEO, FastMail Pty Ltd<br></div>
<div> brong@fastmailteam.com<br></div>
<div><br></div>
</div>
<div style="font-family:Arial;"><br></div>
<div>----<br></div>
<div>Cyrus Home Page: <a href="http://www.cyrusimap.org/">http://www.cyrusimap.org/</a><br></div>
<div>List Archives/Info: <a href="http://lists.andrew.cmu.edu/pipermail/info-cyrus/">http://lists.andrew.cmu.edu/pipermail/info-cyrus/</a><br></div>
<div>To Unsubscribe:<br></div>
<div><a href="https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus">https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus</a><br></div>
</blockquote><div><br></div>
</body>
</html>