dovecot: dict(15979): Error: sqlite: [...] failed: unable to open database file

[Oliver Etchebarne]

Hi.

just noticed this error has been repeatly shown for a while in /var/log/mail_log:

Aug 15 16:30:38 snoopy dovecot: dict(18287): Error: sqlite: exec(INSERT INTO lastlogin (login_stamp,username) VALUES ('1471296638','[email protected]_domain.com')) failed: unable to open database file (14)

I checked the file /etc/dovecot/dovecot.conf, and saw this:

dict {

lastlogin = sqlite:/usr/local/cpanel/etc/dovecot/dovecot-dict-lastlogin.conf.ext
}

That seems wrong... that file is not a sqlite file, instead it's a dovecot configuration file with info about a real sqlite database file.

Perhaps this is a bug in some update I've installed? How can I fix this? I'm using WHM 58.0 build 19.

Thanks for all your help!

 

[Oliver Etchebarne]

Found the problem: /var/run/dovecot didn't have the write bit active for the group dovecot... mea culpa nevermind.

 

[cPanelMichael]

Found the problem: /var/run/dovecot didn't have the write bit active for the group dovecot... mea culpa nevermind.

Hello,

Is this a change that was manually made on that directory in the past, or are you unsure of how those permissions were modified? Could you let us know the specific permissions configured on this directory before you updated it?

Thank you.