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

Aug 15, 2016
5
0
1
Perú
cPanel Access Level
Root Administrator
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!
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
Found the problem: /var/run/dovecot didn't have the write bit active for the group dovecot... mea culpa :-p 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.