The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'E-mail Discussions' started by Oliver Etchebarne, Aug 15, 2016.

Tags:
  1. Oliver Etchebarne

    Oliver Etchebarne Registered

    Joined:
    Aug 15, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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','a_user@a_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!
     
  2. Oliver Etchebarne

    Oliver Etchebarne Registered

    Joined:
    Aug 15, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Perú
    cPanel Access Level:
    Root Administrator
    Found the problem: /var/run/dovecot didn't have the write bit active for the group dovecot... mea culpa :-p nevermind.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page