sqlite3.OperationalError: unable to open database file

[Filip Chabik]

I'm not an programmer myself, although for me it looks like there's somewhere in the code location of the file locales.db hardcoded:

hadret@r2-d2 ~ % uberwriter
Traceback (most recent call last):
  File "/usr/bin/uberwriter", line 43, in <module>
    import uberwriter
  File "/usr/lib/python2.7/dist-packages/uberwriter/__init__.py", line 25, in <module>
    from uberwriter import UberwriterWindow
  File "/usr/lib/python2.7/dist-packages/uberwriter/UberwriterWindow.py", line 49, in <module>
    from uberwriter_lib.thirdparty.gtkspellcheck import SpellChecker
  File "/usr/lib/python2.7/dist-packages/uberwriter_lib/thirdparty/gtkspellcheck/__init__.py", line 57, in <module>
    from .spellcheck import SpellChecker
  File "/usr/lib/python2.7/dist-packages/uberwriter_lib/thirdparty/gtkspellcheck/spellcheck.py", line 32, in <module>
    from ..pylocales import code_to_name
  File "/usr/lib/python2.7/dist-packages/uberwriter_lib/thirdparty/pylocales/__init__.py", line 55, in <module>
    from locales import *
  File "/usr/lib/python2.7/dist-packages/uberwriter_lib/thirdparty/pylocales/locales.py", line 54, in <module>
    _database = sqlite3.connect(os.path.join(__path__, 'locales.db'))
sqlite3.OperationalError: unable to open database file

I built UberWriter with "default" paths, so it's using /usr/bin /usr/lib etc. If there's anything else I can provide to help track this bug down, please let me know.

Regards,
Hadret

[Wolf Vollprecht (w-vollprecht)]

Hi,

so I guess you are *not* running ubuntu, right?

Because I will target other platforms as soon as possible (I had multiple requests to do so).

Actually, I was asked specifically by the ubuntu app team to install the app into /opt/extras.ubuntu.com/uberwriter/

Will fix soon.

Stay tuned,

Wolf

[Wolf Vollprecht (w-vollprecht)]

Ah, well of course it would be very nice to hear which distro you're using and how you installed the app :)

[Filip Chabik (hadret)]

I'm using Debian, so it's close enough to Ubuntu. I built Debian package using pure dh_python2 (no extra flags, no extra options). It seems, that locales.db (under pylocales) is not included by default -- I found workaround for this, but at the moment it's pretty "hackish" and I'm still searching for cleaner solution. Either way, the issue is more likely due to the installation method and not the application itself, so I guess it can be closed. Unless there's some way to forcefully include locales.db during the installation on applications side? Cause this is the only file, that's not going where it suppose to go...

[Wolf Vollprecht (w-vollprecht)]

Hi Filip,

the method I was using in the beginning was also quite "hackish":

You can add these lines in debian/rules at "override_dh_install:"

 cp -r uberwriter_lib/thirdparty/gtkspellcheck/locale/ debian/uberwriter/opt/extras.ubuntu.com/uberwriter/uberwriter_lib/thirdparty/gtkspellcheck/locale/
 cp -r uberwriter_lib/thirdparty/pylocale/databases/ debian/uberwriter/opt/extras.ubuntu.com/uberwriter/uberwriter_lib/thirdparty/pylocale/databases/
 cp -r uberwriter_lib/thirdparty/pylocale/locales/ debian/uberwriter/opt/extras.ubuntu.com/uberwriter/uberwriter_lib/thirdparty/pylocale/locales/
 cp uberwriter_lib/thirdparty/pylocale/locales.db debian/uberwriter/opt/extras.ubuntu.com/uberwriter/uberwriter_lib/thirdparty/pylocale/locales.db

and modify them to your need / install dir.

[Wolf Vollprecht (w-vollprecht)]

Oh, I guess the foldernames where the files come from might have changed (e.g. «thirdparty» dir is not there anymore, would be cool if you check that before using :)