search

DocNow / dnflow-ansible

Ansible playbooks for setting up dnflow
MIT License
1 stars 0 forks source link

missing database #10

Closed shawngraham closed 8 years ago

shawngraham commented 8 years ago

HI,

The search feature wasn't working at all. PUzzling through it with Ed, it seems as if the database wasn't formed correctly (vagrant, on a Mac). There was no data directory created:

vagrant@vagrant-ubuntu-trusty-64:/home/docnow/dnflow$ ls
db.sqlite3           __init__.py  queue_tasks.py    static
dnflow.cfg           LICENSE      README.md         summarize.py
dnflow.cfg.template  luigi.cfg    requirements.txt  templates
docnow.ini           __pycache__  schema.sql        ui.py

I cd /home/docnow/dnflow and then sqlite3 db.sqlite3 with the result: sqlite> SELECT * FROM searches; Error: no such table: searches

so we:

sudo -u docnow -s ; sqlite3 db.sqlite3 < schema.sql

but I had to re-enter the sqlite3 db.sqlite3 < schema.sql to get it to take. And then the search in the webapp performed as expected.

ianmilligan1 commented 8 years ago

Followed above steps (getting into vagrant via vagrant ssh), but while search populates it does nothing and just hangs there.. screen shot 2016-08-31 at 11 48 51 am

kayiwa commented 8 years ago

Hey @ianmilligan1 can you post the contents of /var/log/uwsgi/docnow.log when you have a moment?

Cheers

ianmilligan1 commented 8 years ago

Certainly – I've gist'ed it here. Thanks for your help and hope this is helpful!