Project

General

Profile

[Prewikka] prewikka-httpd error when connecting to localhost:8000

Added by yasey omal 11 months ago

I'm running Prelude 4.1.0 on Ubuntu 17.04.
I have installed all the dependencies and all the libraries needed.
I'm getting an errors when I run this command -> /usr/local/bin/prewikka-httpd

Traceback (most recent call last):
File "/usr/lib/python2.7/wsgiref/handlers.py", line 85, in run
self.result = application(self.environ, self.start_response)
File "/usr/local/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/local/lib/python2.7/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/local/lib/python2.7/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/local/lib/python2.7/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/local/lib/python2.7/dist-packages/prewikka/error.py", line 90, in html_respond
from prewikka import baseview
File "/usr/local/lib/python2.7/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/local/lib/python2.7/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N
("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/local/lib/python2.7/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/local/lib/python2.7/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/local/lib/python2.7/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist

Any help regarding this :)


Replies (3)

RE: [Prewikka] prewikka-httpd error when connecting to localhost:8000 - Added by Thomas ANDREJAK 11 months ago

Your database seems not well initialized, can you delete it, recreate it and retry ?

With ubuntu 18.04, all prelude packages are in the ubuntu repo. Can you update your ubuntu and use them ?

Howto : https://www.prelude-siem.org/projects/prelude/wiki/InstallingPackageUbuntu

RE: [Prewikka] prewikka-httpd error when connecting to localhost:8000 - Added by yasey omal 11 months ago

I have deleted the database and recreated it.
Now it saying there is a database error.

All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

I have attached the sql file to build the database.

prewikka.sql View (3.63 KB)

RE: [Prewikka] prewikka-httpd error when connecting to localhost:8000 - Added by yasey omal 11 months ago

This has been solved. Thank you for your support.

    (1-3/3)