[Bug 1843606] Re: command-not-found unable to open database file (because it is readable only by root)

[Sergio Callegari]

Again! The database files have been again marked as readable by root
only by some system action.

What I get as a result is:

Sorry, command-not-found has crashed! Please file a bug report at:
https://bugs.launchpad.net/command-not-found/+filebug
Please include the following information with the report:

command-not-found version: 0.3
Python version: 3.7.3 final 0
Distributor ID: Ubuntu
Description:    Ubuntu 19.04
Release:        19.04
Codename:       disco
Exception information:

unable to open database file
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/CommandNotFound/util.py", line 23, in crash_guard
    callback()
  File "/usr/lib/command-not-found", line 89, in main
    cnf = CommandNotFound.CommandNotFound(options.data_dir)
  File "/usr/lib/python3/dist-packages/CommandNotFound/CommandNotFound.py", line 81, in __init__
    self.db = SqliteDatabase(dbpath)
  File "/usr/lib/python3/dist-packages/CommandNotFound/db/db.py", line 12, in __init__
    self.con = sqlite3.connect(filename)
sqlite3.OperationalError: unable to open database file

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to command-not-found in Ubuntu.
https://bugs.launchpad.net/bugs/1843606

Title:
  command-not-found unable to open database file (because it is readable
  only by root)

Status in command-not-found package in Ubuntu:
  New

Bug description:
  On Ubuntu 19.04 I repeatedly encounter command-not-found crashing
  because it is unable to open its database.

  Inspection reveals that files in /var/lib/command-not-found are owned
  by root and have permissions set so that they are readable only by the
  owner.

  Deleting these files or changing their permission to be universally
  readable fixes the issue.

  ProblemType: Bug
  DistroRelease: Ubuntu 19.04
  Package: command-not-found 18.10.0~pre2
  ProcVersionSignature: Ubuntu 5.0.0-27.28-generic 5.0.21
  Uname: Linux 5.0.0-27-generic x86_64
  ApportVersion: 2.20.10-0ubuntu27.1
  Architecture: amd64
  CurrentDesktop: KDE
  Date: Wed Sep 11 17:48:29 2019
  EcryptfsInUse: Yes
  InstallationDate: Installed on 2013-12-12 (2098 days ago)
  InstallationMedia: Kubuntu 13.10 "Saucy Salamander" - Release amd64 (20131016.1)
  PackageArchitecture: all
  SourcePackage: command-not-found
  UpgradeStatus: Upgraded to disco on 2019-06-12 (91 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/command-not-found/+bug/1843606/+subscriptions