[Roundup-users] sqlite error with roundup-demo

[Tonu M. <tm...@um...>]

Hello,

I am trying to install the latest Roundup issue tracker on Red Hat Linux 7.
I installed Python 3 and created a virtual environment according to this
guide
<https://developers.redhat.com/blog/2018/08/13/install-python3-rhel#tl_dr>.

I then ran the roundup-demo to create a demo tracker, but got an error with
sqlite3. I tried downloading and installing the latest version of sqlite,
but that did not work.

Any suggestions?


(py36-venv) [tmikk@drc-roundup-prd-web bin]$ sudo roundup-demo
> Enter directory path to create demo tracker [./demo]:
> /swadm/roundup/trackers/demo-classic
> Enter tracker template to use (one of
> (minimal,jinja2,classic,responsive,devel)) [classic]:
> Nuking directory left from the previous demo instance.
> Trying to set up web server on port 8917 ...
> should be ok.
> Traceback (most recent call last):
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/backends/back_sqlite.py",
> line 202, in open_connection
>     self.load_dbschema()
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/backends/rdbms_common.py",
> line 305, in load_dbschema
>     self.cursor.execute('select schema from schema')
> sqlite3.OperationalError: no such table: schema
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "/home/tmikk/pydev/py36-venv/bin/roundup-demo", line 11, in <module>
>     load_entry_point('roundup==2.3.0', 'console_scripts', 'roundup-demo')()
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/scripts/roundup_demo.py",
> line 173, in run
>     use_port=cli_args.urlport or DEFAULT_PORT)
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/demo.py",
> line 120, in install_demo
>     tracker.init(password.Password('admin', config=config))
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/instance.py",
> line 209, in init
>     db = self.open('admin')
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/instance.py",
> line 115, in open
>     'db': backend.Database(self.config, name)
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/backends/rdbms_common.py",
> line 227, in __init__
>     self.open_connection()
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/backends/back_sqlite.py",
> line 211, in open_connection
>     self._add_fts5_table()
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/backends/back_sqlite.py",
> line 255, in _add_fts5_table
>     self.sql('CREATE virtual TABLE __fts USING fts5(_class, '
>   File
> "/home/tmikk/pydev/py36-venv/lib64/python3.6/site-packages/roundup/backends/rdbms_common.py",
> line 266, in sql
>     cursor.execute(sql)
> sqlite3.OperationalError: no such module: fts5
> (py36-venv) [tmikk@drc-roundup-prd-web bin]$
>
-- 
Tonu Mikk
Developer | Disability Resource Center | disability.umn.edu
University of Minnesota | umn.edu
tm...@um...
Pronouns: He/Him