<DKIM> OperationalError: unable to open database file

Bjørn Forsman bjorn.forsman at gmail.com
Fri Jan 30 22:50:27 GMT 2015

Hi Nicolas,

Thanks for the reply!

On 26 January 2015 at 05:46, Nicolas Sebrecht <nicolas.s-dev at laposte.net> wrote:
> On Sun, Jan 25, 2015 at 06:34:15PM +0100, Bjørn Forsman wrote:
>> Hi,
> Hi,
>>     self.connection = sqlite.connect(self.filename, check_same_thread = False)
>> OperationalError: unable to open database file
>> I tried to track down the path to the (missing) database file. I used
>> both strace and offlineimap -d ALL but couldn't find it :-/
> sqlite is supposed to create the database file if it doesn't exit. I
> guess it was already there but it couldn't read it. Check what you have
> in your metadata path (configuration option).

You are right, although I still don't know the _exact_ problem yet (read on).

I had pointed offlineimap at my old maildir, which was copied from
another machine. User ownership is correct, but the group ownership is
for a non-existing group (on this new system). I would have expected
it to work, as I'm running offlineimap as my user (but oh well). But,
for testing, I changed "localfolders" away from my old maildir and
over to a new (or non-existing) directory. Now offlineimap works again

I still don't know what's wrong with my old maildir. AFAICS,
offlineimap has all the permissions it needs:

$ find maildir/ -type f \! -perm -600 -exec ls -l '{}' \;   # no files
lack rw perms for user
$ find maildir/ -type d \! -perm -700 -exec ls -l '{}' \;   # no
directories lack rwx perms for user

Feature request: Please make offlineimap print the path to the sqlite
file it fails to access.

UPDATE: I switched "localfolders" back to the old maildir, and
offlineimap works also there! I promise I haven't changed any
permissions. Whaaat...?!

- Bjørn

More information about the OfflineIMAP-project mailing list